Chapter 8 Review Questions 1. a) sequential serial values
b) Select the cell containing the date. Click Home > Number Format > General. 2. a) An arrow for displaying sort and filter commands is added to each column label in a table.
b) In a table that contains a company’s employee data, a filter could be used to display only the employees in a specific department.
c) It may be necessary in order to sort or filter the data by last name. 3. One way to avoid data entry errors is to specify data entry criteria for a cell or range of cells. 4. It would be useful to use a PivotTable if a states school’s performance scores were in a table and you wanted to analyze school performance score by county. 5. A) =CHOOSE(B20, 100, 500, 900, 1200)
b) =CHOOSE (B20, “Excellent”, “Good”, “Fair”, “Poor”) 6. A)Select the cells and type a descriptive name in the box
b) No, a named range does not change when it is copied as part of a formula because a named range is an absolute reference. 7. Calculate shipping fees based on the dollar amount of the order being shipped, to calculate tax rates based on the salary an employee makes, and to calculate discount values based on the number of items purchased. 8. A) Gadgets Discount 100 10% 150 20% 1000 30% 2000 70%
b) = VLOOKUP (C12, $A$2, $B$5, 2) 9. Cell B5 10. Select cell B7 and click Insert>Hyperlink, select place in the dialog box, type cell B7 in the reference box, and select OK 11. Linked objects are automatically updated when the source data is updated, while embedded objects keep the features of the application it was created in 12. A) series of recorded commands and actions that perform a specific task
b) Click Developer>Record Macro, enter a macro name in the box and any other options, select OK, In the active cell type “Date”, click Developer>stop recording
c) Click Developer>Macros, select the name of the macro, select delete, and select Yes