Spreadsheets

Helpfulness: 0
Set Details Share
created 7 years ago by ReznikMhjhs
6 views
updated 7 years ago by ReznikMhjhs
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 (1,2,3)

4

Column

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

AutoFit

Adjusts 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 one cell to several others

11

Mathematical Operators (+-*/)

Used to create formulas and calculations

12

Formula

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

13

Functions

A special formula Excel has craeted for you
SUM: Adds numbers in a range
AVERAGE: Averages numbers in a range
MAX: Finds the highest(max) number in a range
MIN: Finds the lowest(minimum) number in a range
COUNT: Counts the number of cells in a range that contain a number

14

Relative Address

Cell references (addresses) change as the formula is copied (A4 or C)

15

Absolute Address

Cell references (addresses) do not change as he formaula is copied. Use the $ in front of a cell, row, and/or column address to make it absolute ($A$4 or $A4 or A$A)

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-shows the topics of the values

19

Y-Axis

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

20

Legend

Key for interpreting the chart's colors, patterns, etc.