Skip to Content

## Business

## Business

## 8th

## grade

# Excel - Module 1 and 2 - Getting Started - Working with Formulas

# Introducing new Paper mode

Back

Build your own quiz

Browse from millions of quizzes

QUIZ

8th

grade

85%

accuracy

12

plays

Kal Robbins

5 years

No student devices needed. Know more

45 questions

Show Answers

See Preview

- 1. Multiple Choice20 seconds1 ptUsing the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).truefalse
- 2. Multiple Choice20 seconds1 ptAccording to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.truefalse
- 3. Multiple Choice20 seconds1 ptAn absolute cell reference changes the cell references when the formula is copied to a new location.truefalse
- 4. Multiple Choice20 seconds1 ptAn Excel complex formula uses more than one arithmetic operator.truefalse
- 5. Multiple Choice20 seconds1 ptArguments are Excel’s built-in formulas.truefalse
- 6. Multiple Choice20 seconds1 ptTo print the formulas in a worksheet, click the Formulas tab, then click the Show Formulas button in the Formula Auditing group.truefalse
- 7. Multiple Choice20 seconds1 pt=D8+E8*0.5 is a complex formula.truefalse
- 8. Multiple Choice20 seconds1 ptThe cell in which you are working is called the active cell.truefalse
- 9. Multiple Choice20 seconds1 ptYou use formulas in Excel to perform calculations such as adding, multiplying, and averaging.truefalse
- 10. Multiple Choice20 seconds1 ptWhen copying or moving formulas in an Excel worksheet, the default type of cell reference is absolute.truefalse
- 11. Multiple Choice20 seconds1 ptThe formula =A4+A8*($B$12) is an example of a(n) _____ formula.complexrelativesimpleabsolute
- 12. Multiple Choice20 seconds1 ptThe name Peter is entered in cell B4. This is a ____.labelnumberformulavalue
- 13. Multiple Choice20 seconds1 ptIn the formula =D1+C1/F3, which calculation will be performed first?C1/F3D1/F3D1+F3D1+C1
- 14. Multiple Choice20 seconds1 ptWhich keyboard shortcut turns on Edit mode?[F1][F2][F3][F4]
- 15. Multiple Choice20 seconds1 ptOnce 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 Choice20 seconds1 pt____ below the worksheet grid let you switch from sheet to sheet in a workbook.Sheet tabsCell pointersMode indicatorsScroll bars
- 17. Multiple Choice20 seconds1 ptYou 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 Choice20 seconds1 ptWhich 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 Choice20 seconds1 ptThe entry in cell B15 is =SUM(B5:B14) which is a ____.formulalabelvaluecalculation
- 20. Multiple Choice20 seconds1 ptWhich 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 Choice20 seconds1 ptHow 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 Choice20 seconds1 ptExcel’s _____ feature suggests functions depending on the first letters typed by the user.Formula Flash FillFormula AutoCompleteFormula AutoFillFormula AutoCorrect
- 23. Multiple Choice20 seconds1 ptA(n) ____ is a built-in formula that uses arguments to calculate information.labelindicatortemplatefunction
- 24. Multiple Choice20 seconds1 ptIn Excel, the electronic spreadsheet you work in is called a ____.databookworksheettabletnumericsheet
- 25. Multiple Choice20 seconds1 ptThe default file extension for an Excel 2016 workbook is ____..xlts.xslx.xltx.xlsx
- 26. Multiple Choice20 seconds1 ptIn a payroll worksheet, Peter worked 40 hours and actual hours are stored in cell B5. This is a ____.graphicvalueformulalabel
- 27. Multiple Choice20 seconds1 ptIf 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 Choice20 seconds1 ptYou 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 Choice20 seconds1 ptA(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.parameterabsoluterelativemixed
- 30. Multiple Choice20 seconds1 ptCase 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 Choice20 seconds1 ptWhich of the following is a complex formula?=AVERAGE(C6:D6)=(B4/B8)*10=MIN(D5:D7)=SUM(B4:B8)
- 32. Multiple Choice20 seconds1 ptAn electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.spreadsheetdatabasedataformproject
- 33. Multiple Choice20 seconds1 ptAll functions begin with the formula prefix ____.# (number symbol)+ (plus sign)@ (at symbol)= (equals sign)
- 34. Multiple Choice20 seconds1 pt____ operators perform mathematical calculations such as adding and subtracting.ReferenceComparisonArithmeticText concatenation
- 35. Multiple Choice20 seconds1 ptAll Excel formulas begin with the ____.plus sign (+)equal sign (=)asterisk (*)slash (/)
- 36. Multiple Choice20 seconds1 ptIn 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 Choice20 seconds1 ptThe cell _____ is a dark rectangle that outlines the cell you are working in.indicatorbartabletpointer
- 38. Multiple Choice20 seconds1 ptIn 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 Choice20 seconds1 ptThe Excel operator for division is ____.%\^/
- 40. Multiple Choice20 seconds1 ptWhile you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.insert barname boxtaskbarformula bar
- 41. Multiple Choice20 seconds1 ptPossible paper orientations for printing a worksheet are landscape and ____.portraitpreviewpage breaknormal
- 42. Multiple Choice20 seconds1 ptThe Undo button allows you to reverse up to ____ previous actions, one at a time.1000101100
- 43. Multiple Choice20 seconds1 ptIn Excel, a worksheet is contained in a file called a ____.datapadnotebookworkpadworkbook
- 44. Multiple Choice20 seconds1 ptThe Excel operator for exponent is ____.%\/^
- 45. Multiple Choice20 seconds1 ptIf 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
Explore all questions with a free account

Already have an account?