Navigating the ribbon and menus in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

🎯 Scenario

intermediate

Finding the command to insert a new worksheet

You want to add a new worksheet to your Excel workbook. Which ribbon tab and button should you use?

A Go to the Review tab and click the Add Worksheet button

B Go to the Data tab and click the New Sheet button

C Go to the Home tab and click the Insert button, then choose Insert Sheet

D Go to the View tab and click the New Worksheet button

💡 Hint

Think about where you usually find options to add or insert things in Excel.

The Home tab contains the Insert button, which lets you add new sheets. The other tabs do not have this option.

📊 Formula Result

intermediate

Result of using the AutoSum button

You select cells A1 to A5 with numbers and then click the AutoSum button on the ribbon. What will Excel do?

A Excel will delete the selected cells

B Excel will insert a SUM formula below the selected cells adding A1 to A5

C Excel will highlight the cells with a border but not change values

D Excel will open the Formula tab

💡 Hint

AutoSum is used to quickly add numbers.

AutoSum inserts a SUM formula below the selected cells to add their values automatically.

❓ Function Choice

advanced

Choosing the correct ribbon tab for sorting data

You want to sort a list of names alphabetically in Excel. Which ribbon tab contains the sorting commands?

A Data tab

B Home tab

C Insert tab

D Formulas tab

💡 Hint

Sorting and filtering are usually found where you manage data.

The Data tab contains sorting and filtering commands to organize your data.

📊 Formula Result

advanced

Effect of clicking the Wrap Text button

You have a long text in cell B2 that is cut off. What happens if you click the Wrap Text button on the Home tab?

A The text will be deleted

B The cell will merge with the cell below

C The font size will increase automatically

D The text will display on multiple lines within the same cell

💡 Hint

Wrap Text helps you see all text without changing column width.

Wrap Text makes the text appear on multiple lines inside the same cell so you can read it all.

🧠 Conceptual

expert

Identifying the ribbon tab for conditional formatting

You want to highlight cells that meet certain conditions, like values greater than 100. Which ribbon tab and group contains Conditional Formatting?

A Home tab, Styles group

B Insert tab, Charts group

C Data tab, Sort & Filter group

D Review tab, Comments group

💡 Hint

Conditional Formatting changes how cells look based on their values.

Conditional Formatting is found on the Home tab inside the Styles group.