Spreadsheet Basics & Formula

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

A sales manager has requested the highest sale for the first quarter. Which function will be used? Options: SUM, MIN, MAX, AVG

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

Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer? Options: Label, Value, Formula, Function

Paul has to enter a unit price for a product. How will this data be classified? Options: Label, Value, Formula, Function

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

Paul has to enter the zip code for a client. How will this data be classified? Options: 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?

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

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?