LO5 - Spreadsheets (1)

A sales manager has requested the highest sale for the first quarter. Which function will be used?

• SUM

• MAX

• MIN

• AVERAGE

A sales manager has requested the lowest sale for the first quarter. Which function will be used?

• SUM

• MIN

• MAX

• AVERAGE

Bob needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?

• Label

• Value

• Formula

• Function

A sales manager has requested the total sale for the first quarter. Which function will be used?

• SUM

• MIN

• MAX

• AVERAGE

In spreadsheets, columns are marked with _________

• Letters

• Numbers

• = sign

• Both a letter and a number

In spreadsheets, rows are marked with _____

• Letters

• Numbers

• = sign

• Both a letter and a number

All spreadsheet formulas begin with which symbol?

• =

• ^

• $

• #

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

• C

• 9

• B4

• =A1+A2

Which symbol on the computer represents the multiplication sign?

• /

• -

• +

• *

Which symbol on the computer represents the division sign?

• /

• -

• +

• *