Quickly Displaying and Hiding Formulas in Excel Spreadsheets

Quickly Displaying and Hiding Formulas in Excel Spreadsheets

Assessment

Interactive Video

Other, Social Studies, Information Technology (IT), Architecture

KG - University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial explains how to distinguish between entered numbers and formulas in a spreadsheet. It covers two methods to display formulas: using the ribbon and keyboard shortcuts. The tutorial also provides guidance on adjusting column widths when formulas are displayed and how to revert to the normal view with calculated results. The keyboard shortcut for toggling formula display is highlighted, along with its location on the keyboard.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain how to revert back to the normal view of the spreadsheet after displaying formulas.

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the keyboard shortcut for displaying formulas in a spreadsheet?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the significance of the 'graph sign' on the keyboard in relation to displaying formulas?

Evaluate responses using AI:

OFF