Excel Lesson 4: Using Basic Formulas

Which of the following is not an arithmetic operator?   

• +

• −

• *

• ]

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

  

• 2

•   3

• 4

• 6

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

.   

• Addition (+) and subtraction (−) (left to right)

• Exponentiation (ˆ)

• Percent (%)

•   Negative number (−)

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

   

• =SUM(C2:E12)

• =Q3Expenses!A19

• =[Media.xlsx]MasterList!$D$10

• =SUM(budget.summary)

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

•   =SUM(C2:E12)

• =Q3Expenses!A19

• =[Media.xlsx]MasterList!$D$10

• =SUM(budget.summary)

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

• =SUM(C2:E12)

• =Q3Expenses!A19

• =[Media.xlsx]MasterList!$D$10

•   =SUM(budget.summary)

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

• C7

•   subtotal_west

• subtotal west

•    subtotal/west

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

• A9

• A$9

• $A$9

• A9:E9

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

• A9

• A$9

• $A$9

• A9:E9

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

• Enter values into a range

• Change a range name

• Delete a named range

• Verify the scope of a range