Excel Review

Which command on the Home Ribbon is used to remove cells, rows, or

columns from a worksheet or table?

• Delete

• Remove

• Format

• Format as Table

Which command on the Home Ribbon is used to format row height and

column width, organize sheets, and protect or hide cells in a worksheet?

• Insert

• Form

• Sort & Filter

• Format

Where is the spell checker feature located in Microsoft Excel?

• Home Ribbon

• Page Layout Ribbon

• Review Ribbon

• View Ribbon

Lisa has added WordArt to her spreadsheet. Which tab is now available

for her to edit the WordArt?

• Data

• Design

• Style

• Format

Which command on the Home Ribbon do you use to temporarily hide

specific values on a worksheet based on a criterion?

• Find & Select

• Format Cell

• Sort & Filter

• Organize

Ken has inserted a picture into his spreadsheet and would like it to

standout with a frame or 3D effect. Which tool would he use to achieve

this?

• Picture Styles

• Artistic Effects

• Corrections

• WordArt Styles

What is the process of bringing data containing text fields separated by

commas into Excel called?

• Importing data

• Data collection

• Data integration

• Data migration

How can a table style be quickly modified to meet user preferences?

• Right-click on a style and choose Modify

• Right-click on a style and choose Duplicate

• Double-click a style from the Table Quick Styles Gallery

• Choose Modify from the Styles Group on the Home Ribbon

John’s spreadsheet includes multiple pages of records. If John wants to

view his headings while scrolling through his spreadsheet what should he

do?

• Freeze Panes

• Split

• Hide

• Unhide

Which command is used to format a cell or selected cells quickly by

choosing from a defined list of styles?

• Format as Table

• Cell Style

• Conditional Formatting

• Form