Excel - Home & Insert Tab Test

Which Tool Box in the Home tab contains the Bold, Italic, and Underline options?

• Styles
• Font
• Paragraph
• Editing

What does the 'Format Painter' tool in the Home tab do?

• Changes font color
• Copies formatting from one place and applies it to another
• Paints clipart
• Inserts shapes

Shortcut for all Borders

• Alt + H + G + U
• Alt + H + B + A
• Alt + I + H + A
• Alt + H + B

Which option is NOT found in the Home tab?

• Bullets
• Font Size
• SmartArt
• Line Spacing

The 'Table' option is found in the Insert tab under which group?

• Pages
• Illustrations
• Tables
• Links

What can you insert using the 'Illustrations' group on the Insert tab?

• Footnotes
• ClipArt, Pictures, Shapes, and SmartArt
• Comments
• Page Breaks

To insert Pivot Table which shortcut will be used?

• Alt + H +G + I
• Alt + H + U + O
• Alt + N + V
• Alt + N + I + O

Explain about uses of Slicers?

• Used to Assign the data in a work sheet
• Used to insert pictures
• Used to insert a color
• Used to filter data visually

Sparklines Tool Box Contains?

• Line
• Column
• Win/Loss
• All The Above

When will be slicer works

• After Inserting Pivot Table
• After entering the data in the workbook
• After inserting sort & Filters
• After Inserting charts