Excel HR 2019 Module 5 Review # 3

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

• 5

• 3

• 15

• -30

Match the following Excel terms to their correct definitions:

• Formula

• A mathematical equation that performs calculations on values in a worksheet.

• Constant

• A pre-built command in Excel that performs mathematical operations such as automatically adding up a range of cells, or reviewing values to be used in calculations.

• Function

• A number or text value that is entered directly into a cell.

• Operator

• A representation in Excel that can be a number, a cell address, a date, text, or range of cells.

• Value

• An indicator used to specify the type of calculation to take place, such as add (+), subtract (-), multiply (*), or divide (/).

Which of following operators is used to multiply in Excel?

• *

• /

• +

• X

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

• " "

• @

• ( )

• *

Which following operator is used to divide in Excel?

• *

• /

• @

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

• A2

• A2:B5

• A$2

Which of the following symbols specifies an absolute reference?

• %

• &

• $

• @

Which of the following is a valid named range?

• A7

• Sales_Data

• Sales Data

• Sales\Data

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

• F1

• F4

• F6

• F8

Review the following formula: =Sales!C10+A7. This formula uses which of the following reference types?

• Absolute

• Relative

• Named

• Worksheet