7th Grade Excel for Testing

ABC Corporation has listed all of its sales information for one product in the cell range A1 to A45. Where is this sales information displayed?

• Row 
• Column
• Entry
• Cell address

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

• Cell address
• Cell content
• Formula bar
• Chart title

Paul has to enter a unit price for a product. How will this data be classified?

• Label 
• Value
• Formula
• Function

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

• SUM
• MIN
• MAX
• AVG

A spreadsheet formula always begins with the = sign.

• True
• False

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

• SUM
• MIN
• MAX
• AVG

After entering the number of sales for the first quarter, where will they align in a spreadsheet?

• Right
• Left
• Centered
• Justified

Which of the following is the correct way to write a function in a spreadsheet?

• =SUM(A1-A5)
• =SUM A1+A5
• SUM (A1:A5)=
• =SUM(A1:A5)

When keying a formula in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text?

• Addition operator
• Division operator
• Equal sign
• Subtraction sign

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

• SUM
• MIN
• MAX
• AVG