Spreadsheet Review

Another name for a spreadsheet is....

• worksheet
• paper
• workbook
• tablet

When you key a formula in a spreadsheet what do you key in first?

• Subtraction sign
• Equal Sign
• Addition sign
• Division sign

If you need to compute the total sales which function will you use?

• MIN
• Max
• Avg
• SUM

A corporation lists all of its sales information for one product in a cell range of A1 to L1. Where is this information?

• column
• row
• cell address
• entry

How would you find the lowest sale for a quarter of the year?

• SUM
• MIN
• MAX
• AVG

When you enter sales figures for the first quarter, where will they align?

• Left
• Right
• Centered
• Justified

Which function should be used to find the highest value in a range of cells?

• max
• sum
• min
• avg

This instructs the software to perform a calculation

• label
• function
• formula
• value

Which is an example of a cell reference?

• A1
• CD
• 7D
• 77

What is a label?

• cells that contain numbers used in calculations
• cells that contain numbers used in formulas
• cells that contain text and numbers used in calculations
• cells that contain numbers not used in caulculations