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

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.

What is the primary purpose of adding a checkbox to the HR report?

• To change the color of the report

• To toggle the visibility of employee salaries

• To add new employee data

• To calculate total salaries

Which key combination allows you to copy a formula without its formatting?

• Ctrl + C

• F2 then Ctrl + Enter

• Alt + Enter

• Ctrl + V

Where can you find the option to insert a checkbox in Excel?

• Home tab

• Insert tab

• Developer tab

• View tab

What is the role of the cell link in the checkbox setup?

• To add a new column

• To change the checkbox color

• To delete the checkbox

• To store the checkbox state (true or false)

Which formula is used to assign meaning to TRUE and FALSE values in this report?

• SUM

• AVERAGE

• VLOOKUP

• IF

What formatting is applied to the salary column when it is visible?

• Blue background with white font

• No formatting

• Green background with yellow font

• Red background with black font

What can be done to hide the data preparation in the report?

• Increase the font size

• Move it to another tab

• Change the font color

• Delete the data