Have an account?
Skip to Content
Build your own quiz
14 questions
Show Answers
See Preview
- 1. Multiple ChoiceAfter entering the number of sales for the first quarter, where will they align?RightLeftCenteredJustified
- 2. Multiple ChoiceA sales manager has requested the highest sale for the first quarter. Which function will be used?SUMMINMAXAVG
- 3. Multiple ChoiceA sales manager has requested the lowest sale for the first quarter. Which function will be used?SUMMINMAXAVG
- 4. Multiple ChoiceSamantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?LabelValueFormulaFunction
- 5. Multiple ChoicePaul has to enter a unit price for a product. How will this data be classified?LabelValueFormulaFunction
- 6. Multiple ChoiceABC Corporation has listed all of its products in the cell range A1 to A45. Where are the products displayed?A. RowB. ColumnC. EntryD. Cell address
- 7. Multiple ChoicePaul has to enter the zip code for a client. How will this data be classified?A. LabelB. ValueC. FormulaD. Function
- 8. Multiple ChoiceA sales manager has requested the total sale for the first quarter. Which function will be used?SUMMINMAXAVG
- 9. Multiple ChoiceABC Corporation has listed all of its products in the cell range A1 to K1. Where is this sales information displayed?RowColumnEntryCell address
- 10. Multiple ChoiceWhen 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 OperatorDivision OperatorEqual SignSubtraction Sign
- 11. Multiple ChoiceThe column letter and row number make up what?Cell addressCell contentFormula bar titleChart
- 12. Multiple ChoiceWhen entering the client’s names, what is the default alignment?RightLeftCenteredJustified
- 13. Multiple ChoiceJohn needs to total the cell range A1 to A3. What is the MOST efficient method to find the answer?A. LabelsB. ValuesC. FormulaD. MAX
- 14. Multiple ChoiceThe contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?=MAX(A1:A6) )=MIN(A1:A6. =AVG(A1:A6) )=SUM(A1:A6
- Answer choicesTagsAnswer choicesTags