NP Excel 2016
Module 07
Quick Check Answers
Session 7.1
1. An Excel application is a spreadsheet written or tailored to meet specific needs. It
3. Defined names make interpreting formulas easier. If you move a cell or range with a
4. any three of the following—Name box, Define Name dialog box, Create from Selection
dialog box, Name Manager dialog box
6. Click the Name box arrow, and then click the defined name.
7. =SUM(Expenses)
8. On the Formulas tab, in the Defined Names group, click the Define Name button arrow, and then
click Apply Names (if the cell reference and defined name are in the same worksheet). In the Apply
1. You validate data to eliminate invalid data from being entered into the workbook
2. The input message in the Data Validation command informs the person doing the data
3. The Stop alert prevents the user from storing the data in the cell. The Warning alert
4. A locked cell prohibits data entry when the worksheet is protected. Unlocked cells allow
users to enter data into a cell when a worksheet is protected.
5. Worksheet protection controls the user’s ability to edit cells within the worksheet.
6. Yes, you can rename a protected worksheet as long as the workbook is not protected.
7. Comments are used to explain the contents of a particular cell, provide instruction to a
Session 7.3
2. repetitive tasks
3 Use the macro recorder to record the exact keystrokes and commands you want the macro
5. Any two of the following: Click the Macros button on the Developer tab, select a macro,
and click the Run button. Press the shortcut key that is assigned to the macro. Assign a macro to
a macro button.
8. The macros are not stored in the workbook and are lost.