7.3 Spreadsheet Diagnostic Test

• Total Sales =SUM(C2:C6)

• Total Sales =MAX(C2:C6)

• Total Sales =MIN(C2:C6)

• Total Sales =AVERAGE(C2:C6)

• Average Sales =AVERAGE C2:C6

• Average Sales =AVERAGE C2-C6

• Average Sales =AVERAGE(C2:C5)

• Average Sales =AVERAGE(C2:C6)

• Highest Sales =MAX(C2-C6)

• Highest Sales =SUM(C2:C6)

• Highest Sales =HIGH(C2:C6)

• Highest Sales =MAX(C2:C6)

• Total No. of Products =SUM(C2:C6)

• Total No. of Products =C2+C3+C4+c5+C6

• Both of these answers

• Neither of these answers

What is the cell reference of the Yellow cell?

• A1

• C4

• B3

• C3

The yellow strip refers to a

• Row

• Column

What do all formulas begin with?

• %
• [ ]
• =
• :

Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?

• A4-A3=
• A3-A4=
• =A4-A3
• =A3-A4

Which of the following is a formula that will add cells C9 and C10?

• =C9+C10
• C9+C10
• =C9:C10
• =C9*C10

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

• C
• 9
• B4
• =A1+A2