Excel Part-5 1 / 50 Add chart element (title, legend)?  Home → Format → Add Element  Layout → Chart → Add Element  Chart Tools → Design → Add Chart Element  Right-click → Add Element 2 / 50 Delete chart?  Select chart → Delete  Alt + D → Chart  Ctrl + D  Right-click → Delete 3 / 50 Format chart area? Chart Tools → Format → Format Selection Right-click → Format Chart Area Home → Format → Chart Area Layout → Chart → Format 4 / 50 Move chart to new sheet?  Right-click → Move Chart  Layout → Chart → Move  Home → Format → Move Chart  Chart Tools → Design → Move Chart 5 / 50 Insert text box in sheet? Insert → Text Box Home → Insert → Text Box Layout → Insert → Text Box Tools → Insert → Text Box 6 / 50 Change chart type?  Right-click → Change Chart Type  Home → Format → Chart Type  Layout → Chart → Type  Chart Tools → Design → Change Chart Type 7 / 50 Insert header/footer? Insert → Header & Footer Page Layout → Header & Footer Layout → Insert → Header/Footer Home → Insert → Header/Footer 8 / 50 Insert chart in new sheet?  Ctrl + Shift + C  F11  Alt + N → Chart  Alt + F1 9 / 50 Insert chart shortcut?  Ctrl + C  Alt + N → Chart  Alt + F1  F11 10 / 50 Edit header/footer? Page Layout → Edit Header/Footer Right-click → Edit Header/Footer Click → Header/Footer → Edit Home → Format → Header/Footer 11 / 50 Auto sum?  Ctrl + =  Alt + =  Alt + S  Ctrl + Shift + = 12 / 50 Insert page number? Layout → Insert → Page Number Insert → Header & Footer → Page Number Home → Insert → Page Number Tools → Page → Number 13 / 50 Insert function?  Shift + F3  Ctrl + Shift + F3  Alt + I → F  Ctrl + F3 14 / 50 Freeze panes? Home → View → Freeze Layout → Freeze View → Freeze Panes Data → Freeze 15 / 50 Clear conditional formatting?  Layout → Format → Clear Rules  Right-click → Clear Conditional Formatting  Tools → Format → Clear Rules  Home → Conditional Formatting → Clear Rules 16 / 50 Insert conditional formatting rule?  Tools → Format → Conditional Formatting  Home → Conditional Formatting → New Rule  Right-click → Conditional Formatting → New  Layout → Format → Conditional Formatting 17 / 50 Unfreeze panes? Home → Format → Unfreeze Layout → View → Unfreeze Right-click → Unfreeze View → Freeze Panes → Unfreeze 18 / 50 Remove table formatting?  Layout → Table → Remove  Home → Format → Remove Table  Table Design → Convert to Range  Right-click → Clear Table 19 / 50 Split window? View → Split Layout → Split Home → View → Split Data → Split 20 / 50 Convert range to table?  Home → Format as Table  Right-click → Convert to Table  Layout → Format → Table  Insert → Table → Convert 21 / 50 Remove split window? Home → Format → Split Right-click → Remove Split View → Split → Click again Layout → Split → Remove 22 / 50 Insert table?  Home → Format → Table  Data → Table  Layout → Insert → Table  Insert → Table 23 / 50 Protect sheet? Layout → Review → Protect Tools → Protect → Sheet Home → Protect → Sheet Review → Protect Sheet 24 / 50 Ungroup worksheets?  Ctrl + Shift + Click  Shift + Click  Alt + W → Ungroup  Right-click → Ungroup 25 / 50 Unprotect sheet? Tools → Protect → Unprotect Right-click → Unprotect Review → Unprotect Sheet Home → Protect → Unprotect 26 / 50 Group worksheets?  Ctrl + Click worksheets  Alt + W → Group  Ctrl + G  Shift + Click worksheets 27 / 50 Protect workbook? Review → Protect Workbook Tools → Protect → Workbook Home → Protect → Workbook Layout → Review → Protect 28 / 50 Show/hide sparkline markers?  Home → Format → Markers  Layout → Sparkline → Markers  Sparkline Tools → Design → Show → Markers  Right-click → Show Markers 29 / 50 Change sparkline color?  Tools → Sparkline → Style  Sparkline Tools → Design → Style  Home → Format → Sparkline Color  Layout → Sparkline → Color 30 / 50 Unprotect workbook? Tools → Protect → Unprotect Right-click → Unprotect Review → Unprotect Workbook Home → Protect → Unprotect 31 / 50 Change sparkline type?  Home → Format → Sparkline Type  Layout → Sparkline → Type  Sparkline Tools → Design → Type  Right-click → Change Type 32 / 50 Hide rows? Right-click → Hide Home → Format → Hide → Rows Layout → Hide → Rows Data → Hide → Rows 33 / 50 Delete sparkline?  Ctrl + D  Select sparkline → Design → Clear  Home → Delete → Sparkline  Right-click → Delete 34 / 50 Insert sparkline?  Tools → Sparkline → Insert  Layout → Insert → Sparklines  Home → Insert → Sparklines  Insert → Sparklines 35 / 50 Unhide rows? Right-click → Unhide Home → Format → Unhide → Rows Layout → Unhide → Rows Data → Unhide → Rows 36 / 50 Delete pivot chart?  PivotChart Tools → Design → Delete  Ctrl + D  Select chart → Delete  Right-click → Delete 37 / 50 Move pivot chart to new sheet?  Layout → PivotChart → Move Chart  PivotChart Tools → Design → Move Chart  Home → Format → Move Chart  Right-click → Move Chart 38 / 50 Change pivot chart type?  Right-click → Change Chart Type  Layout → PivotChart → Change Type  PivotChart Tools → Design → Change Chart Type  Home → Format → Chart Type 39 / 50 Insert pivot chart?  PivotTable Tools → Analyze → PivotChart  Home → Insert → PivotChart  Right-click → PivotChart  Insert → PivotChart 40 / 50 Ungroup pivot table items?  PivotTable Tools → Analyze → Ungroup  Layout → Pivot → Ungroup  Home → Format → Ungroup  Right-click → Ungroup 41 / 50 Group pivot table items manually?  Layout → Pivot → Group  Home → Format → Group  Right-click → Group  PivotTable Tools → Analyze → Group 42 / 50 Filter timeline?  PivotTable Tools → Analyze → Filter  Home → Format → Timeline Filter  Click timeline buttons  Right-click → Filter → Timeline 43 / 50 Insert timeline?  Layout → Pivot → Timeline  Home → Insert → Timeline  PivotTable Tools → Analyze → Insert Timeline  Right-click → Insert Timeline 44 / 50 Connect slicer to multiple pivot tables?  Layout → Pivot → Connect Slicer  Home → Format → Connect Slicer  Right-click → Connect Pivot Tables  Slicer → Slicer Settings → Report Connections 45 / 50 Insert slicer?  Layout → Pivot → Slicer  Home → Insert → Slicer  PivotTable Tools → Analyze → Insert Slicer  Right-click → Insert Slicer 46 / 50 Show/hide grand totals?  Layout → Pivot → Grand Totals  PivotTable Tools → Design → Grand Totals  Right-click → Grand Totals → Show/Hide  Home → Format → Grand Totals 47 / 50 Show/hide subtotals?  Right-click → Subtotals → Show/Hide  Home → Format → Subtotals  Layout → Pivot → Subtotals  PivotTable Tools → Design → Subtotals 48 / 50 Change pivot table layout?  PivotTable Tools → Design → Report Layout  Right-click → Layout → Change  Home → Format → Pivot Layout  Layout → Pivot → Report Layout 49 / 50 Refresh pivot table?  Shift + F5  Alt + F5  Ctrl + R  F5 50 / 50 Insert pivot table?  Tools → Pivot → Insert  Layout → PivotTable  Insert → PivotTable  Home → PivotTable Your score isThe average score is 71% 0% Restart quiz
