Have an account?
Skip to Content
Build your own quiz
Business
8th
grade
Excel - Module 1 and 2 - Getting Started - Working with Formulas
45 questions
Show Answers
See Preview
- 1. Multiple ChoiceUsing the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).truefalse
- 2. Multiple ChoiceAccording to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.truefalse
- 3. Multiple ChoiceAn absolute cell reference changes the cell references when the formula is copied to a new location.truefalse
- 4. Multiple ChoiceAn Excel complex formula uses more than one arithmetic operator.truefalse
- 5. Multiple ChoiceArguments are Excel’s built-in formulas.truefalse
- 6. Multiple ChoiceTo print the formulas in a worksheet, click the Formulas tab, then click the Show Formulas button in the Formula Auditing group.truefalse
- 7. Multiple Choice=D8+E8*0.5 is a complex formula.truefalse
- 8. Multiple ChoiceThe cell in which you are working is called the active cell.truefalse
- 9. Multiple ChoiceYou use formulas in Excel to perform calculations such as adding, multiplying, and averaging.truefalse
- 10. Multiple ChoiceWhen copying or moving formulas in an Excel worksheet, the default type of cell reference is absolute.truefalse
- 11. Multiple ChoiceThe formula =A4+A8*($B$12) is an example of a(n) _____ formula.complexrelativesimpleabsolute
- 12. Multiple ChoiceThe name Peter is entered in cell B4. This is a ____.labelnumberformulavalue
- 13. Multiple ChoiceIn the formula =D1+C1/F3, which calculation will be performed first?C1/F3D1/F3D1+F3D1+C1
- 14. Multiple ChoiceWhich keyboard shortcut turns on Edit mode?[F1][F2][F3][F4]
- 15. Multiple ChoiceOnce the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?The user sees a “clipboard full” message.The clipboard automatically deletes the oldest item on the clipboard.The clipboard automatically deletes all items and starts over with the new item.The clipboard prompts the user to delete items.
- 16. Multiple Choice____ below the worksheet grid let you switch from sheet to sheet in a workbook.Sheet tabsCell pointersMode indicatorsScroll bars
- 17. Multiple ChoiceYou can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.organize datarepresent values graphicallycreate what-if data scenariosperform calculations
- 18. Multiple ChoiceWhich formula contains a mixed cell reference?=(A6+A7)*0.20=($A$6+A7)*0.20=($A$6+$A$7)*0.20=($A6+$A$7)*0.20
- 19. Multiple ChoiceThe entry in cell B15 is =SUM(B5:B14) which is a ____.formulalabelvaluecalculation
- 20. Multiple ChoiceWhich function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?[F1][F10][F12][F4]
- 21. Multiple ChoiceHow can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?=C12*F4+C13=(C12+C13)*F4=C12+(C13*F4)=$C12+$C13*F4
- 22. Multiple ChoiceExcel’s _____ feature suggests functions depending on the first letters typed by the user.Formula Flash FillFormula AutoCompleteFormula AutoFillFormula AutoCorrect
- 23. Multiple ChoiceA(n) ____ is a built-in formula that uses arguments to calculate information.labelindicatortemplatefunction
- 24. Multiple ChoiceIn Excel, the electronic spreadsheet you work in is called a ____.databookworksheettabletnumericsheet
- 25. Multiple ChoiceThe default file extension for an Excel 2016 workbook is ____..xlts.xslx.xltx.xlsx
- 26. Multiple ChoiceIn a payroll worksheet, Peter worked 40 hours and actual hours are stored in cell B5. This is a ____.graphicvalueformulalabel
- 27. Multiple ChoiceIf cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?10020=A1^A210^2
- 28. Multiple ChoiceYou can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.%&@$
- 29. Multiple ChoiceA(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.parameterabsoluterelativemixed
- 30. Multiple ChoiceCase 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. You have a monthly income of 2000 that is stored in cell B3. Your rent expense is 450 that is stored in cell B6. Write a formula using an absolute cell reference that would return a value of 1550 in cell C6.=B$3-B6=$B$9-B6=$B$4-B6=$B$3-B6
- 31. Multiple ChoiceWhich of the following is a complex formula?=AVERAGE(C6:D6)=(B4/B8)*10=MIN(D5:D7)=SUM(B4:B8)
- 32. Multiple ChoiceAn electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.spreadsheetdatabasedataformproject
- 33. Multiple ChoiceAll functions begin with the formula prefix ____.# (number symbol)+ (plus sign)@ (at symbol)= (equals sign)
- 34. Multiple Choice____ operators perform mathematical calculations such as adding and subtracting.ReferenceComparisonArithmeticText concatenation
- 35. Multiple ChoiceAll Excel formulas begin with the ____.plus sign (+)equal sign (=)asterisk (*)slash (/)
- 36. Multiple ChoiceIn the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?(G15-G14)$M$3/4(G15-G14)*$M$3(G15-G14)/4
- 37. Multiple ChoiceThe cell _____ is a dark rectangle that outlines the cell you are working in.indicatorbartabletpointer
- 38. Multiple ChoiceIn the formula =ROUND(D4:F4,0), what does the zero indicate?A null value.The number of times the formula should be repeated.The value for cell F4.The number of decimal places in the rounded number.
- 39. Multiple ChoiceThe Excel operator for division is ____.%\^/
- 40. Multiple ChoiceWhile you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.insert barname boxtaskbarformula bar
- 41. Multiple ChoicePossible paper orientations for printing a worksheet are landscape and ____.portraitpreviewpage breaknormal
- 42. Multiple ChoiceThe Undo button allows you to reverse up to ____ previous actions, one at a time.1000101100
- 43. Multiple ChoiceIn Excel, a worksheet is contained in a file called a ____.datapadnotebookworkpadworkbook
- 44. Multiple ChoiceThe Excel operator for exponent is ____.%\/^
- 45. Multiple ChoiceIf cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?=55=10/2=A1/A2
- Answer choicesTagsAnswer choicesTags