Introduction to Spreadsheets (Microsoft Excel)



Yüklə 356,5 Kb.
tarix08.04.2023
ölçüsü356,5 Kb.
#94973
Lesson6 (1)

Understanding Spreadsheets NOTES 4

  • Chapter 7
  • By: Ms Pryor

What is a spreadsheet?

Uses of Spreadsheet

  • Prepare budgets
  • Financial statements
  • Inventory management
  • Create charts

What is a worksheet?

  • A grid with columns & rows; the term worksheet is used interchangeably with spreadsheet

What is a cell?

What 3 things can you type into a cell?

  • Label = words or letters
  • Value = numbers
  • Formula – statement that performs a calculation

What is a cell range?

  • A group of cells that are closely together

What are columns?

What are rows?

  • Horizontal arrangement of cells; identified by numbers

What is a worksheet tab?

Excel 2003 vs. Excel 2007

  • 256 Columns 16,384 Columns
  • 65,536 Rows 1,048,576 Rows

What is a Cell Address (Reference)?

  • This is a column letter & row number combination, such as A1, B2

What is a name box?

  • Displays the name of the active cell or range

What is a formula bar?

What is an active cell?

  • The cell in which you are currently working (normally the cell is surrounded by a black border)

What is a function?

  • A built-in formula that is a shortcut for common calculations such as addition and average.

What are Operation Symbols?

  • Instruct the computer as to what mathematical operations to perform

Operation Symbols

  • Addition (+)
  • Subtraction (-)
  • Multiplication (*)
  • Division (/)

How do you key a formula?

  • You combine numbers,
  • cell addresses (references),
  • Operation symbols
  • and/or functions
  • Ex: =4 + 5; =B1 * B2

Order of Operations

  • Completes formulas in this order:
    • Parentheses
    • Exponents
    • Multiplication
    • Division
    • Addition
    • Subtraction
  • Example:
  • Formula: 5+2*7 Result: 19
  • Formula: (5+2)*7 Result: 49

What is a column width tool?

  • Tool that changes the width of the columns on a spreadsheet

What is a row height tool?

  • Tool that changes the height of rows on a spreadsheet

What is the Fill Handle Tool?

  • Used to copy data & formulas to another cell; and create a series

What is Auto Sum Tool?

  • Automatically creates a formula to add a series of numbers in a spreadsheet

What is a Chart?

What is sorting?

  • Organizing or rearranging data in either ascending or descending order

Definitions….

  • Sort Ascending – arranges records from A to Z or smallest to largest
  • Sort Descending – arranges records from Z to A or largest to smallest

Yüklə 356,5 Kb.

Dostları ilə paylaş:




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©azkurs.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin