Excel Unit B

Question 1

A formula that uses more than one arithmetic operator

Answer 1

Complex Formula

Question 2

A button that inserts a function from a drop down list

Answer 2

Insert Functions Button

Question 3

A function that returns the number of cells in a range that contain numerical data

Answer 3

COUNT

Question 4

A function that returns the number of cells in a range that hold any data at all

Answer 4

COUNTA

Question 5

Recorded input of cells in relation to the formula cell (=SUM (B5:E5))

Answer 5

Relative Cell Reference

Question 6

Recoded input that does not change when you move the formula to a new cell (=SUM($B$5:$E$5))

Answer 6

Absolute Cell Reference

Question 7

Recorded input that is both relative and absolute (=SUM($B5:$E5))

Answer 7

Mixed Reference

Question 8

Predesigned excel workbooks that are used to save time

Answer 8

Template