Excel Functions and Features Assessment

This video tutorial explores five new Excel features: checkboxes, GROUPBY and PIVOTBY functions, Data from Picture tool, inserting images in cells, and the Navigation Pane. Each feature is demonstrated with examples, showing how they enhance Excel's functionality and efficiency. The tutorial provides insights into using these features for tasks like data summarization, importing data from images, and managing workbooks more effectively.

What is the primary advantage of the new checkboxes in Excel?

• They are only available under the Developer tab.

• They allow for easier task management and can be used in formulas.

• They are larger and more colorful than previous checkboxes.

• They can only be used in to-do lists.

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

• By using the AVERAGE function.

• By manually counting each checkbox.

• By using the SUM function.

• By using the COUNTIF function with TRUE as the criteria.

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

• To create charts.

• To summarize data by specific fields.

• To format cells.

• To insert images.

How does the PIVOTBY function differ from the GROUPBY function?

• It is used for formatting text.

• It allows adding fields in the columns for further data breakdown.

• It is used for creating charts.

• It is only available in older versions of Excel.

What does the Data from Picture tool allow you to do?

• Create a picture from data.

• Import data from a picture into Excel.

• Convert pictures into charts.

• Edit pictures within Excel.

How can you insert an image directly into a cell in Excel?

• By using the Place in Cell option under the Insert tab.

• By resizing the image manually.

• By using the Developer tab.

• By copying and pasting the image.

What happens to an image when you resize the cell it is placed in?

• The image automatically resizes with the cell.

• The image remains the same size.

• The image moves to another cell.

• The image disappears.

What is the function of the new Navigation Pane in Excel?

• To insert charts.

• To act as a comprehensive table of contents for easy navigation.

• To create new worksheets.

• To format text.

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

• By using the Developer tab.

• By manually checking each worksheet.

• By using the search bar in the Navigation Pane.

• By scrolling through all the tabs.

How can you add the Navigation Pane to your status bar?

• By right-clicking the status bar and selecting Sheet Number.

• By using the Developer tab.

• By opening the View tab.

• By clicking the Insert tab.