Introduction to Business & Technology

Which formula would you enter to return the number 45.1?

• =MIN(A2:B5)

• =SUM(A2:B5)

• =MAX(A2:B5)

• =AVERAGE(A2:B5)

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

• Ctrl+V

• Ctrl+X

• Ctrl+Z

• Ctrl+C

Which letter on the image is a Column?

• A

• B

• C

• D

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

• Paste attributes

• Format attributes

• Active attributes

• Edit attributes

Define the following operator: /

• Subtraction

• Division

• Multiplication

• Addition

Which letter on the image is a Cell?

• A

• B

• C

• D

Which formula contains a cell reference?

• =10+13

• =21-6

• =G10

• =F6/3

Which of these statements about cell references is NOT true?

• You can enter a cell reference in a formula by typing in the reference.

• Cell references can only be entered in a formula by using the Formula Bar.

• Cell references make it easy to use values from other cells in a formula.

• You can enter a cell reference in a formula by clicking the cell location on the spreadsheet.

Where is the Formula Bar?

• A

• B

• C

• D

• E

Which command would you use if you wanted to move row 6 in between rows 3 and 4 without overwriting any data.

• Paste

• Merge

• Insert

• Insert copied cells