Get Stronger: Microsoft Intermediate Skills

1. What is the first step to sorting data in Excel?

A) Click on the “Data” tab
B) Select the data range
C) Use the “Sort” dialog box
D) Apply a filter

2. Which function would you use to add up all the numbers in a range of cells?

A) SUM
B) AVERAGE
C) COUNT
D) MEDIAN

3. Flash Fill can be used to:

A) Automatically fill data in columns based on patterns
B) Create charts
C) Filter data
D) Sort data

4. To filter data, which of the following actions should you perform?

A) Apply the “Sort” function
B) Click on the “Data” tab and then “Filter”
C) Use Flash Fill
D) Enter data in a new column

5. Which function would you use to perform simple math operations such as addition or

subtraction in Excel?
A) CONCATENATE
B) IF
C) Basic arithmetic operators (+, -, *, /)
D) COUNTIF

6. What type of chart is useful for showing trends over time?

A) Pie Chart
B) Column Chart
C) Line Chart
D) Scatter Plot

7. The SUM function in Excel is used to:

A) Count the number of cells
B) Find the maximum value
C) Add the values in a range of cells
D) Calculate the average of a range of cells

8. Which type of chart is best for comparing values across categories?

A) Line Chart
B) Pie Chart
C) Clustered Column Chart
D) Area Chart

9. What does Flash Fill use to predict and automatically fill in data?

A) Predefined functions
B) Patterns detected in the data
C) User inputs
D) Filter criteria

10. Which Excel feature allows you to remove certain data from view without deleting it?

A) Sorting
B) Filtering
C) Flash Fill
D) Conditional Formatting

11. Which function would you use to count the number of cells that contain numbers?

A) COUNT
B) COUNTA
C) COUNTIF
D) COUNTBLANK

12. When creating a pie chart, what does each slice represent?

A) A different category of data
B) The total value
C) A data trend over time
D) A different series

13. What is the purpose of using the IF function in Excel?

A) To perform logical tests and return different values based on the results
B) To count the number of non-empty cells
C) To find the maximum value in a range
D) To sort data

14. Which of the following is the correct function to find the difference in values between two neighboring cells?

A) =”A1″-“B1″
B) =”A1-B1”
C) =A1-B1
D) A1-B1