Excel 1: Essentials : Module Test Review

Using the correct order of operations, what does this formula equal? =(4-2)*6/2

• 4

• 8

• 6

• 2

A cell has a very long formula that you must edit. What would be the best way to edit the formula.

• Double-click on the cell and edit the formula in the cell

• Select the cell and edit the formula in the Formula Bar

How are a cell's content and format related?

• They are independent and not related

• Changing the format affects the content

• The content and format are the same

Which letter on the image is a Column?

• A

• B

• C

• D

What tab group would you use to change the format of cell A2 to match cell A3?

• Styles

• Numbers

• Cells

• Alignment

• Font

What number would the formula "=COUNT(A2:A7)" return?

• 3

• 4

• 5

• 6

Which keyboard shortcut would you press to copy cells that are selected in a spreadsheet?

• Ctrl+X

• Ctrl+C

• Ctrl+V

• Ctrl+Z

Using the correct order of operations, what does this formula equal? =16/4*2

• 2

• 4

• 8

• 16

What are the pieces of information that describe the appearance of a cell's content?

• Edit attributes

• Paste attributes

• Active attributes

• Format attributes

Define the following operator: /

• Multiplication

• Division

• Addition

• Subtraction