MISY 5325 Excel Midterm Ultimate Review with Complete Solutions

MISY 5325 Excel Midterm Ultimate Review with Complete Solutions Pressing the Ctrl key is required to select cells or ranges of cells that are not adjacent. To relocate a chart to another worksheet, users should employ the function **move chart**. If entered correctly, the functions SUMIF and DSUM will produce the same result. Which cell reference remains unchanged when formulas are copied and pasted into other cells? $A$1 (Absolute Reference) Which statement regarding the Table function is false? Once applied, the Table function cannot be reverted. To reveal formulas within a worksheet, press **Ctrl + Accent**. The PV function is typically used to calculate the ending balance of a loan in an amortization schedule. The Hide function allows users to hide columns but not rows. Linda deposits $200 into a bank monthly at a 6% annual interest rate for 4 years. Which function calculates the amount she will have at the end of the fourth year? = -FV(6%/12, 4*12, 200) (with a minus sign before the future value) Autosum should not be used to find totals for columns containing percentage data. To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button in the INSERT tab | Charts group. To use the AutoCalculate area, select the cell range with numbers for the calculation, then double-click or press and hold the AutoCalculate area to display the Customize Status Bar shortcut menu. The Microsoft Office Specialist (MOS) program provides proof of Excel 2013 skills required by employers. To clear cell contents and formatting, click Clear Contents on the Clear button menu. An equal sign (=) precedes a formula in Excel. The most common error when entering a formula is referencing the wrong cell. An asterisk (*) following a cell reference in a formula directs Excel to perform the multiplication operation, not division. Brackets in Excel do not override the order of operations as in algebra. Dragging the fill handle left or up in Excel will decrement the series, not increment it. The Increase Indent button in Excel indents cell contents to the right by three spaces each time it's clicked.