Unit B

Question 1

one that uses more than 1 arithmetic operator

Answer 1

complex formula

Question 2

use these rules in doing complex formulas

Answer 2

standard order of precedence

Question 3

predefined worksheet formulas that enable you to preform complex calculations use insert function button FX

Question 4

suggests functions depending of the first letter you type displays list in alphabetical order

Answer 4

auto complete feature

Question 5

cut copy and paste and fill handles

Answer 5

to copy and move cells use

Question 6

temporary storage that holds things that you can cut or copy

Answer 6

office clipboard

Question 7

changes the cells as you copy and paste

Answer 7

relative cell reference

Question 8

formulas that don’t change after you copy

Answer 8

absolute cell reference

Question 9

part of the formula changes when copied and part does not

Answer 9

mixed cell reference

Question 10

can be used to fill cells going up down left right and in a series

Answer 10

fill button list arrow

Question 11

rounds your results to eliminate many decimals

Answer 11

round function

Question 12

item on ribbon that opens a dialog box

Answer 12

launcher

Question 13

lets you copy cell contents or continue a series of data into a range of selected cells

Answer 13

fill handle

Question 14

converts a relative cell reference to an absolute

Answer 14

f4

Question 15

insert function button use sum list arrow or auto complete

Answer 15

to insert a function