Spreadsheet Basics & Formula

Front

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

Back

Right

Front

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

Back

MAX

Front

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

Back

MIN

Front

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

Back

Function

Front

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

Back

Value

Front

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

Back

Column

Front

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

Back

Label

Front

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

Back

SUM

Front

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

Back

Row

Front

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?

Back

Equal Sign