Microsoft Excel 2021365 - Beginner to Advanced - Check Box - Check/Uncheck Option

Microsoft Excel 2021365 - Beginner to Advanced - Check Box - Check/Uncheck Option

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial demonstrates how to add interactivity to an HR report in Excel by using checkboxes to show or hide employee salary information. It covers linking employee names to cells, inserting and configuring checkboxes, using the IF formula for conditional display, and applying conditional formatting to match column styles.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain how the IF formula is used in the context of showing or hiding the salary column.

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What formatting changes are applied to the salary header when it is displayed?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you hide the preparation data in the report?

Evaluate responses using AI:

OFF