Excel Formula Helper

1. What is the purpose of the Vertical Grow Data feature in Excel?

• To expand the data vertically by adding new rows.

• To delete existing rows

• To change the font style of the data

• To calculate the average of the data

2. Which option is used to lock cells in Excel?

• Format Cells

• Protect Sheet

• Merge Cells

• Freeze Panes

3. How can you sort data in Excel?

• By using the Delete function in the Review tab

• By using the Paint function in the Home tab

• By using the Sort function in the Data tab

• By using the Filter function in the Insert tab

4. What is the function of the filter feature in Excel?

• To change the font style of the data

• To calculate the sum of all the data

• To create a new worksheet in the Excel file

• To selectively display data that meets certain criteria and hide the data that does not meet the criteria.

5. How do you group data in Excel?

• By selecting the data range and using the 'Group' function in the 'Data' tab.

• By applying conditional formatting to the data

• By using the 'Sort' function in the 'Home' tab

• By changing the font color of the data

6. What is the benefit of ungrouping data in Excel?

• Easier manipulation and analysis of individual data points

• Improved data visualization

• More accurate calculations

• Faster data entry

7. Which tab in Excel contains the group and ungroup feature?

• Data

• Home

• Insert

• Review

8. How can you expand data vertically in Excel?

• Deleting existing rows

• Inserting new rows above or below the existing data

• Copying and pasting data horizontally

• Changing the font size of the data

9. What is the shortcut key to group data in Excel?

• Shift + G

• Alt + G

• Alt + Shift + Right Arrow

• Ctrl + G

10. How can you ungroup data in Excel?

• Go to the 'Format' tab and choose 'Ungroup Data'

• Right-click on the data and select 'Ungroup'

• Click on the 'Ungroup' button in the 'Data' tab

• Press the 'Ctrl + U' shortcut key