Mis 180 Tutorial 1 Easton

Front 1

spreadsheet

Back 1

a computer application designed to help organize data, perform calculations, format information, chart results, manage tables and develop reports

Front 2

file tab

Back 2

used to select tasks you can do with your document such as opening, saving, and printing

Front 3

tabs

Back 3

contain task-oriented icons and tools

Front 4

groups

Back 4

icons that have been organized within a tab

Front 5

cell

Back 5

the intersection of a row and column

Front 6

active cell

Back 6

the cell in the worksheet that you are working on

Front 7

formula bar

Back 7

where the contents of the active cell are displayed

Front 8

home tab

Back 8

contains seven different groups of tasks

Front 9

text data

Back 9

any cell entry that contains letters, hyphens, or spaces

Front 10

numeric data

Back 10

contains numbers and special characters such as dollar signs, commas, decimal points, and percent signs

Front 11

formula

Back 11

a mathematical equation used to calculate a value inside your worksheet

Front 12

cell reference

Back 12

the unique address of a cell identified by its column and row location

Front 13

constant

Back 13

a value that doesn't change

Front 14

order of operations

Back 14

the rules that indicate which calculations are done first when evaluation equations (Parentheses, exponentiation, multiplication and division, addition and subtraction)

Front 15

relative cell reference

Back 15

when a formula includes a cell so that when the formula is copied the cell reference will adjust relative to the new cell location of the formula

Front 16

absolute cell reference

Back 16

used when you do not want Excel to adjust the cell reference relative to the new formula's position, indicate an absolute cell reference by including a dollar sign $ in front of both the column and the row of the cell address

Front 17

mixed cell reference

Back 17

holding either the row or the column absolute while leaving the other unchanged

Front 18

functions

Back 18

predefined formulas to use for specific calculations

Front 19

range

Back 19

a group or block of cells in a worksheet

Front 20

fill handle

Back 20

used to allow you to select a cell and then drag the fill handle to copy the cell contents down a column or across a row

Front 21

formula

Back 21

a mathematical equation used to calculate a value inside your worksheet

Front 22

cell reference

Back 22

the unique address of a cell identified by its column and row location

Front 23

constant

Back 23

a value that doesn't change

Front 24

order of operations

Back 24

the rules that indicate which calculations are done first when evaluation equations (Parentheses, exponentiation, multiplication and division, addition and subtraction)

Front 25

relative cell reference

Back 25

when a formula includes a cell so that when the formula is copied the cell reference will adjust relative to the new cell location of the formula

Front 26

absolute cell reference

Back 26

used when you do not want Excel to adjust the cell reference relative to the new formula's position, indicate an absolute cell reference by including a dollar sign $ in front of both the column and the row of the cell address

Front 27

mixed cell reference

Back 27

holding either the row or the column absolute while leaving the other unchanged

Front 28

functions

Back 28

predefined formulas to use for specific calculations

Front 29

range

Back 29

a group or block of cells in a worksheet

Front 30

fill handle

Back 30

used to allow you to select a cell and then drag the fill handle to copy the cell contents down a column or across a row

Front 31

formula

Back 31

a mathematical equation used to calculate a value inside your worksheet

Front 32

cell reference

Back 32

the unique address of a cell identified by its column and row location

Front 33

constant

Back 33

a value that doesn't change

Front 34

order of operations

Back 34

the rules that indicate which calculations are done first when evaluation equations (Parentheses, exponentiation, multiplication and division, addition and subtraction)

Front 35

relative cell reference

Back 35

when a formula includes a cell so that when the formula is copied the cell reference will adjust relative to the new cell location of the formula

Front 36

absolute cell reference

Back 36

used when you do not want Excel to adjust the cell reference relative to the new formula's position, indicate an absolute cell reference by including a dollar sign $ in front of both the column and the row of the cell address

Front 37

mixed cell reference

Back 37

holding either the row or the column absolute while leaving the other unchanged

Front 38

functions

Back 38

predefined formulas to use for specific calculations

Front 39

range

Back 39

a group or block of cells in a worksheet

Front 40

fill handle

Back 40

used to allow you to select a cell and then drag the fill handle to copy the cell contents down a column or across a row

Front 41

page setup group

Back 41

used to adjust many common settings including selecting the paper orientation and setting the margins