Excel Skills Challenge

What formula would you use to add numbers in cells A1 and A2?

• =A1 * A2

• =A1 - A2

• =A1 + A2

• =SUM(A1,A2)

How do you sort a list of names in alphabetical order?

• Sort the names by their length.

• Reverse the order of the names.

• Use a sorting function to arrange the names in alphabetical order.

• Group the names by their first letter.

Which chart type is best for showing trends over time?

• Bar chart

• Pie chart

• Line chart

• Scatter plot

What function would you use to find the average of a range of numbers?

• MAX

• AVERAGE

• SUM

• COUNT

How can you highlight cells that are greater than 100?

• Apply a filter to show only cells greater than 100.

• Use Conditional Formatting to highlight cells greater than 100.

• Use Data Validation to restrict input to numbers only.

• Highlight cells that are less than 100.

What is the purpose of data validation in Excel?

• To create complex formulas without user input.

• To enhance the visual appearance of spreadsheets.

• To control and restrict the type of data entered into cells.

• To automatically generate charts from data.

Which formula would you use to subtract B1 from A1?

• A1 / B1

• A1 - B1

• A1 + B1

• A1 * B1

How do you sort data from largest to smallest?

• Sort data using a random order function.

• Use a sorting algorithm or built-in functions with a descending order option.

• Filter data to show only the smallest values.

• Use a sorting algorithm with an ascending order option.

What type of chart would you use to compare different categories?

• Scatter plot

• Line chart

• Bar chart

• Pie chart

Which function can count the number of cells that contain numbers?

• AVERAGE

• COUNT

• MAXIMUM

• SUM