Exploring New Excel Features

What happens to the cell value when a new checkbox is checked?

• It changes to 'TRUE'

• It changes to 'FALSE'

• It becomes empty

• It remains unchanged

How can you count the number of completed tasks using checkboxes?

• Using the AVERAGE function

• Using the MAX function

• Using the SUMIF function

• Using the COUNTIF function

What does the COUNTIF function do with checkboxes?

• Counts unchecked boxes

• Deletes unchecked boxes

• Counts all boxes

• Counts checked boxes

What is the primary purpose of the GROUPBY function in Excel?

• To sort data

• To merge data

• To summarize data

• To filter data

What additional feature does the PIVOTBY function offer over the GROUPBY function?

• It allows adding a field in the columns of your summary table

• It allows for faster data processing

• It automatically updates data

• It supports more complex formulas

Which function allows you to summarize data by adding a field in the columns?

• AVERAGE

• PIVOTBY

• GROUPBY

• SUM

How do you import data from a picture into Excel?

• Using the Import Data command

• Using the Insert Data function

• Using the Data from Picture tool

• Using the Scan & Upload feature

What happens when you insert an image directly into a cell?

• The image floats over cells

• The image becomes a background

• The image cannot be resized

• The image resizes with the cell

What can you do with the Navigation Pane in Excel?

• Navigate and manage workbook elements

• Create new worksheets

• Automatically sort data

• Change the theme of the workbook

How can you find a specific worksheet quickly using the Navigation Pane?

• By scrolling through all tabs

• By using the search bar

• By rearranging the tabs

• By creating a new tab