Spreadsheet Basics & Formula

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

•   Right 
•   Left  
•   Centered
•   Justified

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

•   SUM 
•   MIN
•   MAX
•   AVG

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

•  SUM  
•   MIN
•  MAX
•   AVG

Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer? 

•  Label
•  Value
•  Formula 
•  Function

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

•  Label 
•  Value 
•   Formula 
•  Function

 ABC Corporation has listed all of its products in the cell range A1 to A45. Where are the products displayed?   

• A.  Row
• B.  Column
• C.  Entry
• D.  Cell address

 Paul has to enter the zip code for a client. How will this data be classified?   

• A.  Label
• B.  Value
• C.  Formula 
• D.  Function

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

•  SUM 
•  MIN
•   MAX
•  AVG

 ABC Corporation has listed all of its products in the cell range A1 to K1. Where is this sales information displayed?  

•  Row
•  Column
•   Entry 
•  Cell address

 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