- Xupload Blocked We Ran Into A Problem With This File And Can T Save Any New Changes Please Save A Copy To Avoid Losing 1 (157.55 KiB) Viewed 110 times
XUPLOAD BLOCKED We ran into a problem with this file and can't save any new changes. Please save a copy to avoid losing your work. COMP96-K, Assignment 2, Due on Wed. June 8. by 11:59 p.m. EST 1. Conditional formatting provides a visual analysis of data by applying formatting to cells that meet specific criteria (conditions) a. True b. False 2. The Conditional Formatting Rules Manager allows you to do the following a. Delete conditional formatting rules b. Edit conditional formatting rules c. Reorder and control how conditional formatting rules are applied to your worksheet d. All of the above 3. When more than one conditional formatting rule is applied to a group of cells, the rules are applied in the order in which they are created a. True b. False 4. Typically, when you data by a single column, you the Sort A to Z or Sort Z to A commands available from the Home tab a. True b. False 5. If you want to create a multilevel sort so the data are sorted first by one criterion (singular of criteria) and then sorted again within each group, use the: a. Column Dialogue b. Edit Dialogue c. Style Dialog d. Sort dialog 6. Excel's Advanced Filter feature allows you to filter data for criteria in multiple columns using multiple criteria with logical AND and OR operators a. True b. False 7. Before using Advanced Filter, you must set up the criteria range a. True b. False Save a Copy 8. In order to use subtotals, the data range must be arranged in columns with the first row containing column headings a. True b. False 9. One way to subtotal data without formulas and without including the details in an outline format is to use Consolidate a. True b. False 10. Use Consolidate to create subtotals when you want to further manipulate the data or when you do not want or need the details available a. True b. False 11. If your workbook includes a data range organized with summary rows that include formulas, you can use the feature to automatically create groups and subgroups of rows that you can expand and collapse a. Summary O b. Dictate c. Reference d. Auto Outline 12. The displays the formulas and current values of the cells you add to it, and it stays open and on top of the Excel window until you close it a. Search Window b. Layout c. Watch Window d. Outline 13. A scenario is an alternate version of data values that you create and apply through the Scenario Manager a. True b. False 14, Scenarios allow you to analyze the results of changing values in specific cells (inputs) a. True b. False Upload Blocked screen rec