Excel Review

What is the term used for each box in a spreadsheet?

• Cell

• Box

• Field

• Record

What is the term used for cells which appear going across the spreadsheet?

• Column

• Record

• Field

• Row

What is the term used for cells which appear going up and down the spreadsheet?

• Field

• Row

• Column

• Record

A cell can contain text, values and what else?

• Currency

• Percentages

• Formulae

• Dates

How must a cell containing a formula start?

• SUM

• =

• +

• ( )

What function is used to add more than 2 cells?

• +

• =

• SUM

• ( )

Which formula would you use to multiply cell B4 by cell C4?

• =B4*C4
• =B4xC4
• =(B4:C4)
• B4xC4=

Which of the following is a valid formula?

• =sum(A1:A6)
• sum=(A1:A6)
• =sum[A1:A6]
• =sum(A1,A6)

Which of the following is a valid formula?

• =C7*C8
• =(C7\C8)
• =(C7xC8)
• =AVERAGE(C7*C8)

I can find the lowest number in a range with the ... function

• MIN
• MAX
• AVERAGE
• COUNT