spreadsheet functions

Refer to your practice spreadsheet. This image here has an error in Column A. Which cell has the error? Remember cells are written this way A1 .... A9 etc.

=A1*B1

• 2
• 3
• 4
• Error

Refer to your practice spreadsheet. Same one as in this image. What was the lowest you spent on an item in Cost #2.

• $5

• $3

• $4

• $15

What is the active cell in excel

• The bottom cell in a worksheet

• The top cell in a worksheet

• The Past cell in a worksheet

• The current cell in a worksheet

Which of the statement is NOT TRUE about the spreadsheet?

• The user bought three different items

• The average cost for Cost#1 is in B6

• The total for Cost#1 is less than Cost#2

• $15 is the total for Cost#2

Which key should be used to move to the left of the cell

• Tab key

• Enter key

• Shift+ Enter key

• Shift+ Tab key

Name of the workbook is displayed in the

• Menu bar

• Title bar

• Tool bar

• Option bar

9. This function returns the sum of the products of corresponding ranges or arrays.

• A. SUMIF

• B. MOD

• C. SUMPRODUCT

• D. SUMSQ

Which career(s) or places of employment involve the use of a spreadsheet at work?

• Accountant
• Hospital
• All Choices
• Shop Keeper

Refer to your practice spreadsheet. Same one as in this image. Which of the following would you use to calculate answer in C8?

• =MIN(B2:C4)

• =MIN(D2:C4)

• =MIN(C2:C4)

• =MAX(B2:B4)