Excel Checkboxes Tutorial Quiz

What is the first step to insert a checkbox in Excel?

• Select 'File' and then 'Options'

• Click on the 'Insert' tab

• Right-click on any tab and select 'Customize the Ribbon'

• Go to the 'Home' tab

How can you select a checkbox to reposition it?

• Use the 'Shift' key and click

• Press the 'Alt' key and click

• Right-click on the checkbox

• Double-click on the checkbox

What is the quickest way to link a checkbox to a cell?

• Drag the checkbox to the desired cell

• Press 'Control' and click the checkbox, then use the formula bar

• Right-click and select 'Format Control'

• Use the 'Insert' tab

Which function is used to count the number of checked items?

• VLOOKUP

• AVERAGE

• COUNTIF

• SUM

Which key combination opens the 'Format Control' dialog quickly?

• Alt + F

• Control + F

• Control + 1

• Shift + F10

What is the default state of a newly inserted checkbox?

• Disabled

• Unchecked

• Checked

• Mixed

How can you display the progress of completed items using checkboxes?

• By changing the font color

• Using conditional formatting with data bars

• Using the 'Sort' function

• By inserting a pie chart

What is the purpose of using the FILTER function with checkboxes?

• To sort the items alphabetically

• To generate a list of completed items

• To create a list of remaining items

• To calculate the total number of items

How can you hide the true/false values linked to checkboxes?

• Delete the linked cells

• Change the font color to white or use custom formatting

• Use conditional formatting to hide them

• Change the font size to zero

What optional argument can be used in the FILTER function to handle empty results?

• IFERROR

• IFEMPTY

• IFBLANK

• IFNULL