Test Bank Create and Use Cell Styles 6. What is affected by a custom or modified cell style? A. The current worksheet B. The current workbook C. All current and future workbooks D. All current and existing workbooks 7. Identify the accurate statement about cell styles. A. A modified cell style does not change when you change the theme. B. You modify cell styles in the Format Cells dialog box. C. You can create a new style based on formatting applied to a single cell. D. Cell style changes apply only to the selected cell. 8. Which option applies to cell styles but NOT themes? A. Alignment B. Fonts C. Colors D. Fill themes, cell styles, document properties, and number formats 9. What is this? 20% - Accent1 20% - Accent2 20% - Accent3 20% - Accent4 20% - Accents 20% - Accent6 40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 40% - Accents 40% - Accent6 60% - Accent1 60% - Accent2 60% - Accent3 60% - Accent4 60% - Accent5 60% - Accent6 Accentl Accent2 Accenta Accents Accent5 Accento A. Cell style options B. Themes C. Document properties D. Number formats Apply Cell Borders and Fill 10. Which statement related to the Format Cells dialog box is FALSE? A. The active tab depends on the method used to open the dialog box. B. You can't see cell borders while the cell is selected, so remember to deselect after formatting to see the effect. C. The dialog box options change according to the theme applied and stay in effect for future workbooks until the theme is changed again. D. Use the dialog box to access formatting options not available from the Ribbon. Excel 2019 & 365 Page 2 of 4