Spreadsheet Review

The cells B2 through B45 would be classified as:

• Row

• Column

• Entry

• Cell Address

A spreadsheet formula always begins with the = sign.

• True

• False

A cell range with the sales for the year would be classified as which classification of cells?

• Value

• Label

To find the total of a cell range, which function would you use?

• SUM

• Average

• MIN

• MAX

Which term refers to the column letter and row number in a spreadsheet?

• Cell Address

• Cell Content

• Formula Bar

• Chart Title

Which formula will give you the lowest number in a cell range?

• SUM

• MIN

• MAX

• AVG

Zip code would be which classification of a cell?

• Value

• Label

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

• SUM

• MIN

• MAX

• AVG

The contents in cells A1 through A6 sre 6, 3, 4, 7, 9, and 7. What function would return the answer 6?

• =MAX(A1:A6)

• =MIN(A1:A6)

• =AVERAGE(A1:A6)

• =SUM(A1:A6)

How will the unit price for a product be classified?

• Value

• Label