Apply and Customize Themes

1. Where are changes to themes applied?
   1. The current worksheet
   2. The entire workbook
   3. The selected cells
   4. All current and future workbooks
2. What happens when you change the theme on a worksheet that already has a theme applied?
   1. The default theme for new workbooks switches to the chosen theme.
   2. All content in the current workbook takes on the font and color of the new theme.
   3. Any content in the current workbook formatted with a theme font or color updates to the newly chosen theme.
   4. The selected data updates to match the new theme.
3. What is NOT affected when you change the theme?
   1. Colors
   2. Margins
   3. Fonts
   4. Effects
4. Martha tracks her album sales in Excel and has modified an existing theme with her preferred colors, fonts, and effects. Shes starting a new workbook to track her tour schedules and wants to use her customized theme choices. What should she do?
   1. Nothing; Excel doesnt allow you to modify the built-in themes.
   2. Write down the customizations used and manually edit the theme in the new workbook.
   3. Search for an online theme with attributes similar to her customizations and use that.
   4. Save her customizations as a new theme and apply it to the new workbook.
5. To what can you NOT apply a custom theme color?
   1. Text/Background
   2. Hyperlinks
   3. Highlighting
   4. Accents

Create and Use Cell Styles

6. What is affected by a custom or modified cell style?
   1. The current worksheet
   2. The current workbook
   3. All current and future workbooks
   4. All current and existing workbooks
7. Identify the accurate statement about cell styles.

1. A modified cell style does not change when you change the theme.
2. You modify cell styles in the Format Cells dialog box.
3. You can create a new style based on formatting applied to a single cell.
4. Cell style changes apply only to the selected cell.