Navigating the ribbon and menus in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select the tab where you find the 'Bold' button.

Excel

Click on the [1] tab to find the 'Bold' button.

Drag options to blanks, or click blank then click option'

AHome

BInsert

CView

DData

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing the 'Insert' tab which is for adding objects.

Selecting 'View' which controls how the sheet looks.

Picking 'Data' which is for managing data tools.

The 'Bold' button is located in the Home tab of the ribbon.

2fill in blank

medium

Complete the code to open the menu for inserting a new chart.

Excel

Go to the [1] tab and click on the 'Insert Chart' button.

Drag options to blanks, or click blank then click option'

AFormulas

BPage Layout

CReview

DInsert

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Formulas' which is for functions.

Selecting 'Review' which is for comments and proofing.

Picking 'Page Layout' which is for page setup.

The 'Insert' tab contains the options to add charts, tables, and other objects.

3fill in blank

hard

Fix the error in the instruction to find the spell check tool.

Excel

Click on the [1] tab to find the spell check tool.

Drag options to blanks, or click blank then click option'

AReview

BView

CData

DInsert

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Data' which is for data tools.

Selecting 'View' which changes how the sheet looks.

Picking 'Insert' which adds objects.

The spell check tool is located in the Review tab.

4fill in blank

hard

Fill both blanks to describe how to change the page orientation.

Excel

Go to the [1] tab, then click on [2] to change page orientation.

Drag options to blanks, or click blank then click option'

APage Layout

BFormulas

COrientation

DData

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Formulas' tab which is unrelated.

Selecting 'Data' tab which is for data management.

Page orientation settings are found under the Page Layout tab in the Orientation button.

5fill in blank

hard

Fill all three blanks to describe how to add a filter to a data table.

Excel

Click on the [1] tab, then select the [2] group, and click [3] to add a filter.

Drag options to blanks, or click blank then click option'

AData

BSort & Filter

CFilter

DHome

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Home' tab which does not have filter tools.

Selecting wrong groups or buttons that do not add filters.

Filters are added from the Data tab, inside the Sort & Filter group, by clicking the Filter button.