Have an account?
Skip to Content
Business
8th
grade
Excel - Module 1 and 2 - Getting Started - Working with Formulas
Introducing new Paper mode
No student devices needed. Know more
45 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any questions.Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).truefalse
- Multiple ChoicePlease save your changes before editing any questions.According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.truefalse
- Multiple ChoicePlease save your changes before editing any questions.An absolute cell reference changes the cell references when the formula is copied to a new location.truefalse
- Multiple ChoicePlease save your changes before editing any questions.An Excel complex formula uses more than one arithmetic operator.truefalse
- Multiple ChoicePlease save your changes before editing any questions.Arguments are Excel’s built-in formulas.truefalse
- Multiple ChoicePlease save your changes before editing any questions.To print the formulas in a worksheet, click the Formulas tab, then click the Show Formulas button in the Formula Auditing group.truefalse
- Multiple ChoicePlease save your changes before editing any questions.=D8+E8*0.5 is a complex formula.truefalse
- Multiple ChoicePlease save your changes before editing any questions.The cell in which you are working is called the active cell.truefalse
- Multiple ChoicePlease save your changes before editing any questions.You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.truefalse
- Multiple ChoicePlease save your changes before editing any questions.When copying or moving formulas in an Excel worksheet, the default type of cell reference is absolute.truefalse
- Multiple ChoicePlease save your changes before editing any questions.The formula =A4+A8*($B$12) is an example of a(n) _____ formula.complexrelativesimpleabsolute
- Multiple ChoicePlease save your changes before editing any questions.The name Peter is entered in cell B4. This is a ____.labelnumberformulavalue
- Multiple ChoicePlease save your changes before editing any questions.In the formula =D1+C1/F3, which calculation will be performed first?C1/F3D1/F3D1+F3D1+C1
- Multiple ChoicePlease save your changes before editing any questions.Which keyboard shortcut turns on Edit mode?[F1][F2][F3][F4]
- Multiple ChoicePlease save your changes before editing any questions.Once 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.
- Multiple ChoicePlease save your changes before editing any questions.____ below the worksheet grid let you switch from sheet to sheet in a workbook.Sheet tabsCell pointersMode indicatorsScroll bars
- Multiple ChoicePlease save your changes before editing any questions.You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.organize datarepresent values graphicallycreate what-if data scenariosperform calculations
- Multiple ChoicePlease save your changes before editing any questions.Which 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
- Multiple ChoicePlease save your changes before editing any questions.The entry in cell B15 is =SUM(B5:B14) which is a ____.formulalabelvaluecalculation
- Multiple ChoicePlease save your changes before editing any questions.Which 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]
- Multiple ChoicePlease save your changes before editing any questions.How 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
- Multiple ChoicePlease save your changes before editing any questions.Excel’s _____ feature suggests functions depending on the first letters typed by the user.Formula Flash FillFormula AutoCompleteFormula AutoFillFormula AutoCorrect
- Multiple ChoicePlease save your changes before editing any questions.A(n) ____ is a built-in formula that uses arguments to calculate information.labelindicatortemplatefunction
- Multiple ChoicePlease save your changes before editing any questions.In Excel, the electronic spreadsheet you work in is called a ____.databookworksheettabletnumericsheet
- Multiple ChoicePlease save your changes before editing any questions.The default file extension for an Excel 2016 workbook is ____..xlts.xslx.xltx.xlsx
- Multiple ChoicePlease save your changes before editing any questions.In a payroll worksheet, Peter worked 40 hours and actual hours are stored in cell B5. This is a ____.graphicvalueformulalabel
- Multiple ChoicePlease save your changes before editing any questions.If 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
- Multiple ChoicePlease save your changes before editing any questions.You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.%&@$
- Multiple ChoicePlease save your changes before editing any questions.A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.parameterabsoluterelativemixed
- Multiple ChoicePlease save your changes before editing any questions.Case 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
- Multiple ChoicePlease save your changes before editing any questions.Which of the following is a complex formula?=AVERAGE(C6:D6)=(B4/B8)*10=MIN(D5:D7)=SUM(B4:B8)
- Multiple ChoicePlease save your changes before editing any questions.An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.spreadsheetdatabasedataformproject
- Multiple ChoicePlease save your changes before editing any questions.All functions begin with the formula prefix ____.# (number symbol)+ (plus sign)@ (at symbol)= (equals sign)
- Multiple ChoicePlease save your changes before editing any questions.____ operators perform mathematical calculations such as adding and subtracting.ReferenceComparisonArithmeticText concatenation
- Multiple ChoicePlease save your changes before editing any questions.All Excel formulas begin with the ____.plus sign (+)equal sign (=)asterisk (*)slash (/)
- Multiple ChoicePlease save your changes before editing any questions.In 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
- Multiple ChoicePlease save your changes before editing any questions.The cell _____ is a dark rectangle that outlines the cell you are working in.indicatorbartabletpointer
- Multiple ChoicePlease save your changes before editing any questions.In 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.
- Multiple ChoicePlease save your changes before editing any questions.The Excel operator for division is ____.%\^/
- Multiple ChoicePlease save your changes before editing any questions.While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.insert barname boxtaskbarformula bar
- Multiple ChoicePlease save your changes before editing any questions.Possible paper orientations for printing a worksheet are landscape and ____.portraitpreviewpage breaknormal
- Multiple ChoicePlease save your changes before editing any questions.The Undo button allows you to reverse up to ____ previous actions, one at a time.1000101100
- Multiple ChoicePlease save your changes before editing any questions.In Excel, a worksheet is contained in a file called a ____.datapadnotebookworkpadworkbook
- Multiple ChoicePlease save your changes before editing any questions.The Excel operator for exponent is ____.%\/^
- Multiple ChoicePlease save your changes before editing any questions.If 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