Displaying and Hiding Formulas in Excel

This video tutorial explains how to display formulas in an Excel spreadsheet. It covers three methods: using File Options, the Formulas Tab, and a keyboard shortcut. The tutorial also demonstrates how to adjust column widths and revert to the original view. By the end, viewers will know how to display and hide formulas efficiently.

What is the formula shown in cell D3?

• B3 - C3

• B3 + C3

• B3 / C3

• B3 * C3

Which menu path allows you to display all formulas using File Options?

• File > View > Show Formulas

• File > Options > Advanced > Show Formulas

• File > Data > Show Formulas

• File > Account > Show Formulas

What happens to the column widths when you display all formulas using the Formulas tab?

• They remain the same

• They automatically adjust

• They become narrower

• They may need manual adjustment

Where can you find the 'Show Formulas' option in the Excel ribbon?

• Under the Data tab

• Under the Formulas tab

• Under the Insert tab

• Under the Home tab

What is the purpose of the triangle button at the top left of the worksheet?

• To select all cells in the worksheet

• To open the File menu

• To adjust column widths

• To hide all formulas

What is the keyboard shortcut to toggle the display of formulas?

• Ctrl + Shift + F

• Ctrl + Alt + T

• Ctrl + Tilde (~)

• Ctrl + F

Where is the tilde (~) key typically located on a keyboard?

• To the left of the number 1 key

• Above the number 1 key

• To the right of the number 1 key

• Below the number 1 key

What is the fastest method to display all formulas on a spreadsheet?

• Using File Options

• Using the keyboard shortcut Ctrl + Tilde

• Using the View tab

• Using the Formulas tab

How can you revert to the original spreadsheet view after displaying formulas?

• Refresh the spreadsheet

• Press Ctrl + Tilde again

• Click 'Hide Formulas' in the Formulas tab

• Uncheck the 'Show Formulas' option in File Options

What is the main topic of this video tutorial?

• Formatting cells in Excel

• Displaying and hiding formulas in Excel

• Creating charts in Excel

• Using Excel for data analysis