Unit 5 Excel Lesson 4 Basic Formulas

Which of the following is not an arithmetic operator?

• a. +
• b. −
• c. *
• d. ]

 Which of the following shows a formula for a reference to another workbook?

• a. =SUM(C2:E12)
• b. =Q3Expenses!A19
• c. =[Media.xlsx]MasterList!$D$10
• d. =SUM(budget.summary)

Which of the following shows a formula for a reference to another worksheet in the same workbook?

• a. =SUM(C2:E12)
• b. =Q3Expenses!A19
• c. =[Media.xlsx]MasterList!$D$10
• d. =SUM(budget.summary)

 In Excel, what is the result of =1 + 3 * 2 / 2 - 1?

• a. 2
• b. 3
• c. 4
• d. 6

Per the order of operations, which of the following is calculated first?

• a. Addition (+) and subtraction (−) (left to right)
• b. Exponentiation (ˆ)
• c. Percent (%)
• d. Negative number (−)

Which of the following can you not do using the Name Manager?

• a. Enter values into a range
• b. Change a range name
• c. Delete a named range
• d. Verify the scope of a range

Which of the following is an example of a mixed cell reference?

• a. A9
• b. A$9
• c. $A$9
• d. A9:E9

 Which of the following is an example of an absolute cell reference?

• a. A9
• b. A$9
• c. $A$9
• d. A9:E9

Which of the following is an acceptable name for a named range?

• a. C7
• b. subtotal_west
• c. subtotal west
• d. subtotal/west

Which of the following refers to an unnamed range in the current worksheet?

• a. =SUM(C2:E12)
• b. =Q3Expenses!A19
• c. =[Media.xlsx]MasterList!$D$10
• d. =SUM(budget.summary)