Unit B Excel

Question 1

Complex formula: one that uses more than 1 arithmetic operator.

Question 2

Standard order of precedence: use these rules in doing complex formula.

Question 3

Functions: Predefined worksheet formulas that enable you to preform complex calculations.

Question 4

Auto complete: Suggest functions depending on the first letter you type.

Question 5

To copy & move cells: use cut, copy, paste, fill handles.

Question 6

Office clipboard: temporary storage area that holds the selections you copy and cut

Question 7

relative cell reference: changes the cell

Question 8

Absolute cell reference: formulas do not change when copied.

Question 9

mixed cell reference: part of the formula changes when copied and part does not

Question 10

Fill button list arrow can be used to fill cells containing formulas going everywhere.

Question 11

Round function: round your results to estimate a decimal.

Question 12

Launcher: item on ribbon that opens a dialog box.

Question 13

Fill handle: lets you copy cell contents or continue a series of data.

Question 14

F4: converts a relative cell reference

Question 15

to enter a function insert function,button, sum list.