Spread Sheets ,

Helpfulness: 0
Set Details Share
created 7 years ago by CierraS
8 views
updated 7 years ago by CierraS
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:
1

Spreadsheet/Workbook

A grid of rows and columns containing numbers, text, formulas and calculations

2

Microsoft Excel

Application program used to create spreadsheets

3

Row

Horizontal cells up and down a spreadsheet - Represented my #'s (1,2,3)

4

Colmn

Vertical cells across a spreadsheet - represented by letters (A,B,C)

5

Cell

Where a row and column intersect (A1,C3,D10)

6

Active Cell

The cell your cursor is in

7

Sheet

One page in a workbook

8

Range

A section of the spreadsheet identified by beginning cell and ending cell (C1:G10)

9

Auto Fit

Adjust the size of rows or columns to fit the data within those rows or columns

10

Auto fill

Click and drag the AutoFill button to automatically copy from cell to several others

11

Mathematical Operators (+ - */)

Used to create formulas and calculations

12

Formula

Used cell addresses and mathematical operators to create a formula - start with =

13

Functions

A special formula Excel has created for you
SUM - Adds #'s in a range
AVERAGE - Averages #'s in a range
MAX - Finds highest (max) #'s in range
MIN - Finds lowest (minimum) #'s in a range
COUNT - Counts the # of cells in a range that contains a #

14

Relative Address

Cell reference change as the formula is copied (A4 or C6)

15

Absolute Address

Cell reference do not change as the formula is copied. Use the $ in front of a cell, row, and/or column address to make it absolute

16

Sort

Changing the order of information
Ascending - from A to Z, 0 to 1, or low to high
Descending - From Z to A, 9 to 1, or high to low

17

Chart or Graph

A visual representation of data

18

X-axis

Usually the horizontal axis, usually left to right - usually shows the topics of the values

19

Y-axis

Usually the vertical axis, usually top to bottom - usually shows the range of values

20

Legend

Usually the vertical axis, usually top to bottom - usually shows the range of values