Excel Mastery Challenge

You have a list of scores in cells A1 to A10. You need to find the total score. Which formula would you use?

• =SUM(A1:A10)

• =AVERAGE(A1:A10)

• =MAX(A1:A10)

• =COUNT(A1:A10)

You are managing a budget spreadsheet and need to find the highest expense from a range of values in cells B1 to B20. Which function would you use?

• 
  

• =MIN(B1:B20)

• =AVERAGE(B1:B20)

• • =MAX(B1:B20)

• =COUNT(B1:B20)

You are preparing a contact list and need to combine the first name (cell A1) and last name (cell B1) into a single cell. Which formula would you use?

• =COMBINE(A1, B1)

• =MERGE(A1, B1)

• =JOIN(A1, B1)

• =CONCATENATE(A1, B1)

You're putting up a business and need to calculate the total cost by multiplying the quantity in cell A1 with the price in cell B1. Which formula would you use?

• • =SUM(A1*B1)

• =PRODUCT(A1,B1)

• • =AVERAGE(A1*B1)

• =MAX(A1,B1)

You're working with a large dataset and want to sort the data based on multiple criteria (e.g., first by general average, then by gender). What command enables you to do this?

• • Sort by Color

• Custom Sort

• Filter

• Freeze Panes

You're analyzing survey responses and need to categorize responses as "Satisfied" or "Dissatisfied" based on a certain score threshold. Which Excel function would you use?

• =AVERAGE( )

• =IF( )

• =TRIM( )

• =PROPER( )

What symbol is used in Excel to indicate the beginning of a formula?

• +

• --

• *

• =

If you want to multiply the numbers in cell C3 and D3, which formula would you use?

• • =C3 + D3

• =C3 - D3

• • =C3 * D3

• =C3 / D3

The passing grade is 75. If a student's score is equal to or greater than 75, they pass; otherwise, they fail. Which Excel formula would you use to determine if a student passed or failed?

• =IF(B2>=75, "Pass", "Fail")

• =IF(B2<75, "Pass", "Fail")

• =IF(B2=75, "Pass", "Fail")

• =IF(B2>75, "Pass", "Fail")

The performance ratings for each team member are listed in cells B2 to B10. Which Excel formula would you use to calculate the average performance rating?

• • =AVERAGE(B2:B10)

• =SUM(B2:B10)/9

• =AVERAGE(B2:B10)/9

• • =SUM(B2:B10)