Advance Microsoft Advance Excel - Assessment

1 - Which tab in Excel contains options for formatting, inserting, and deleting cells?

• Home

• Insert

• Data

• Review

2 - Which shortcut key is used to open the "Format Cells" dialog box?

• Ctrl + 1

• Ctrl + 2

• Ctrl + F

• Ctrl + S

3 - What is the purpose of Data Validation in Excel?

• To format cells with colors

• To restrict the type of data entered into a cell

• To create charts

• To sort data alphabetically

4 - Which feature allows you to create a dropdown list in a cell?

• Conditional Formatting

• Data Validation

• Pivot Table

• Filter

5 - What does the shortcut "Ctrl + T" do in Excel?

• Insert a table

• Insert a chart

• Insert a pivot table

• Insert a formula

6 - Which Excel feature allows you to create pre-designed layouts for reports?

• Pivot Tables

• Templates

• Macros

• Charts

7 - What is the purpose of the "Subtotal" feature in Excel?

• To create charts

• To calculate totals for grouped data

• To filter data

• To validate data

8 - Which option is used to apply color scales based on cell values?

• Data Validation

• Conditional Formatting

• Sorting

• Sorting

9 - What does the "Custom Sort" feature in Excel allow you to do?

• Sort data by multiple columns

• Sort data by color only

• Sort data randomly

• Sort data by formulas

10 - Which feature is used to display only specific rows that meet certain criteria?

• Sorting

• Filtering

• Subtotals

• Data Validation