Excel Unit B

Question 1

Is one that uses more than one arithmetic operator.

Answer 1

Complex Formula

Question 2

Rules to determine which operation to perform first.

Answer 2

Order of Precedence

Question 3

Are predefined worksheet formulas that enable you to perform complex calculations easily.

Answer 3

Functions

Question 4

On the formula bar to choose a function from a dialog box.

Answer 4

Insert Function Button

Question 5

Returns the number of cells in a range that contains numeric data, including numbers, dates, and formulas.

Answer 5

COUNT

Question 6

Returns the number of cells in a range that contains any data at all, including numeric data, labels, and even a blank space.

Answer 6

COUNTA

Question 7

Buttons on the home tab on the ribbon.

Answer 7

Cut, Copy, and Paste

Question 8

Because excel is recording the input cells in relation to or relative to the formula cell, it will reflect the new formula location.

Answer 8

Relative Cell Reference

Question 9

Which is a reference that does not change when you copy the formula, it is different cells every time you copy the formula.

Answer 9

Absolute Cell Reference

Question 10

This type of cell referencing combines elements of both absolute and relative referencing.

Answer 10

Mixed Reference

Question 11

Are predesigned workbook files intended to save time when you create common documents such as balance sheets.

Answer 11

Template