UNIT B EXCEL

Question 1

Complex formula

Answer 1

one that uses more than 1 arithmetic operator. (addition and multiplication). =(4+2)*5

Question 2

standard order of precedence

Answer 2

use these rules in doing complex formulas

Question 3

functions

Answer 3

predefined worksheet formulas that enable you to perform complex calculations-use insert function

Question 4

Auto complete

Answer 4

feature suggest functions depending on the first letters you type, - displays list in ABC order

Question 5

To copy & move cells use

Answer 5

cut, copy, and paste, and fill handles

Question 6

Office clipboard

Answer 6

temporary holds stuff you cut or copy till you paste it

Question 7

Relative cell reference

Answer 7

charges cells as you copy and paste them to new locations

Question 8

Absolute cell reference

Answer 8

formulas that do not change when copied - =$c$12+$d$12

Question 9

Mixed cell references

Answer 9

part of the formula changes when copied and pasted

Question 10

fill button list arrow

Answer 10

can be used to fill cells containing formulas going left, right, up, down and in series

Question 11

round function

Answer 11

rounds your result - to eliminate many decimals

Question 12

Launcher

Answer 12

item on ribbon that opens dialog box

Question 13

Fill handle

Answer 13

lets you copy excel contents or continue a series of data in to a range of selected cells

Question 14

F4

Answer 14

converts a relative cell reference to an absolute cell reference

Question 15

To enter a function

Answer 15

insert function. Button, use sum list arrow or use auto complete practice examples