MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide

Index

• A
• absolute cell references, 134–137
• accessibility, adding alt text to charts for, 196–198
• Accessibility section, 192
• Accounting Number Format icon, 83
• Add Trendline dialog box, 184
• Add View dialog box, 43
• adding
  • alt text to charts, 196–198
  • built‐in footer elements, 32–35
  • built‐in header elements, 32–35
  • cells, 72–74
  • columns, 72–73
  • columns to tables, 114, 117–118
  • from Customize Quick Access Toolbar menu, 38–39
  • data series to charts, 178–181
  • dates to Sparklines, 98–99
  • footers, 31–32
  • headers, 31–32
  • line breaks, 81–82
  • rows to tables, 114, 117–118
  • ScreenTips, 14
  • Sparklines, 95–96

• aligning
  • charts in worksheets, 193–194
  • columns, 76–77
  • rows, 76–77

• alt text, in charts, 196–198
• applying
  • built‐in conditional formatting, 99–101
  • cell ...