Spreadsheets

Helpfulness: 0
Set Details Share
created 6 years ago by WoodR
42 views
updated 6 years ago by WoodR
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 by numbers

4

column

Vertical cells across a spreadsheet represented by letters

5

Cell

Where a row and column intersect

6

Active cell

The cell your cursor is in

7

Sheet

one page in a work book

8

Range

A section of the spreadsheet identified by beginning cell and ending cell

9

Auto Fit

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

10

Mathematical operations

used to create formulas and calculations

11

Formula

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

12

Functions
SUM
AVERAGE
MAX
MIN
COUNT

A special formula Excel has created for you
Adds number in a range
finds the highest number in the range
finds the lowest number in the range
Counts the number of cells in a range

13

Relative Address

Cell references change as the formula is coppied

14

Absolute Adress

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

15

Sort
Ascending
Descending

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

16

Chart or graph

A visual representation of data

17

X-axis

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

18

Y-Axis

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

19

Legend

Key for interpreting the charts colors, patterns, etc,