Excel Module 5

1. What is the answer to the following calculation: (4+6)*2-10/2

• a. 5
• b. 3
• c. 15
• d. -30

1. Which of the following operators is used to start a formula in Excel?

• a. *
• b. /
• c. =
• d. $

1. Which of following operators is used to multiply in Excel?

• a. *
• b. /
• c. ^
• d. X

1. The formula =6*2/3 produces the same result as =6*(2/3). Select the correct option.

• a. True
• b. False

1. Which of the following symbols can you use to override the order of operations?

• a. " "
• b. @
• c. ( )
• d. *

1. Which following operator is used to divide in Excel?

• a. *
• b. /
• c. ^
• d. @

1. Which of the following is the best example of a mixed cell reference?

• a. A2
• b. $A$2
• c. A2:B5
• d. A$2

1. Which of the following symbols specifies an absolute reference?

• a. %
• b. &
• c. $
• d. @

1. Which of the following is a valid named range?

• a. A7
• b. Sales_Data
• c. Sales Data
• d. Sales\Data

1. Which keyboard shortcut can you use to toggle relative, absolute, and mixed references?

• a. F1
• b. F4
• c. F6
• d. F8