Excel Mastery Quiz

Which option is used to import data from a text file in Excel?

• Home > Import > From Text > Select "RentalAccessories.csv"

• Data > Import Data > From Text > Select "RentalAccessories.csv"

• File > Open > Select "RentalAccessories.csv"

• Insert > Object > Create from File > Select "RentalAccessories.csv"

Where can you find the option to apply the theme 'Blue, Accent 1, 25%' in Excel?

• Home > Cell Styles > Blue, Accent 1, 25%

• Home > Format Painter > Blue, Accent 1, 25%

• Home > tab color > Blue, Accent 1, Darker25%

• Home > Fill Color > Blue, Accent 1, 25%

How can you copy content from the worksheet 'Inv' and paste it to the worksheet 'Boat' starting at cell A6?

• Select 'Inv' > Copy > Paste to 'Boat' starting at A6

• Copy content of 'Inv' > Select 'Boat' > Paste at A6

• Home > Paste Special > Linked Picture

• Insert > Table > 'Inv' data

Which option allows you to move the 'Boat' worksheet to be the first tab in Excel?

• Select 'Boat' tab > Move with the mouse to the first position

• Drag 'Boat' tab to the left of 'Sheet1'

• Home > Arrange > Rearrange Sheets > Move 'Boat' to Beginning

• Home > Sort > Sort by Sheet Name

How can you hide the 'Inv' worksheet in Excel?

• View > Hide > 'Inv'

• Home > Format > Hide Sheet > 'Inv'

• Right-click on 'Inv' tab > Hide

• Format > Visibility > Hide > 'Inv'

Where can you find the option to add document properties like 'Team Proposals' in Excel?

• File > Properties > Add 'Team Proposals'

• Home > Document Properties > Add 'Team Proposals'

• Insert > Properties > Add 'Team Proposals'

• File > Info > Properties > Advanced Properties > Add 'Team Proposals'

How can you set the print area to 'A1:F17' in Excel?

• Page Layout > Print Area > Set Print Area 'A1:F17'

• File > Print > Print Area 'A1:F17'

• Home > Print > Set Print Area 'A1:F17'

• Page Layout > Set Print Area 'A1:F17'

In Excel, what is the correct formula to calculate the sum of sales in cells G2 to G26?

• In cell G27, type =SUM(G2:G26)

• Home > AutoSum > Total Sales

• Insert > Function > SUM > Select range G2:G26

• Formula > AutoSum > Sales > Total

How can you apply the table style 'White, Table Style Medium 18' to cells A9:E14 in Excel?

• Home > Format as Table > Apply 'White, Table Style Medium 18' to A9:E14

• Home > Table Styles > Apply 'White, Table Style Medium 18' to A9:E14

• Home > Format > Apply 'White, Table Style Medium 18' to A9:E14

• Format > Styles > Apply 'White, Table Style Medium 18' to A9:E14

Where can you find the option to freeze rows 1 to 3 in Excel?

• View > Freeze Panes > Rows 4

• Home > Freeze Panes > Rows 1 to 3

• Page Layout > Freeze Panes > Rows 1 to 3

• Data > Freeze Panes > Rows 1 to 3