Excel Assessment Prep

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

• 6

• 8

• 2

• 4

Which of the following is a valid formula?

• =E10

• =B5/10

• A2/F2

• (C2-D16)

Which formula contains a cell reference?

• =10+3

• =F6/3

• =21-6

• =G10

How can you force a certain order of operations in a formula?

• By using simple formulas

• They cannot be forced

• By using parentheses

• By positioning the operations from left to right

Which keyboard shortcut would you use to copy cells that are selected?

• Ctrl+C

• Ctrl+Z

• Ctrl+X

• Ctrl+V

What does Ctrl+Z do?

• Paste

• Copy

• Cut

• Undo

A cell has a very long formula that you must edit. What is 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?

• Changing the format affects the content.

• They are independent and not related.

• The content and format are the same.

Clicking on a cell will show its content in the Formula Bar.

• True

• False

Which sequence of shortcuts would you use to MOVE information from one cell to another?

• Ctrl+X then Ctrl+V

• Ctrl+C then Ctrl+V

• Ctrl+V then Ctrl+Z

• Ctrl+X then Ctrl+Z