Excel Summative Test

Which of the following is used to create a visual representation of data in Excel?

• Formula

• Chart

• Cell

• Worksheet

What function would you use to find the average of a range of cells in Excel?

• SUM

• AVERAGE

• MEDIAN

• COUNT

Which of the following is NOT a type of chart available in Excel?

• Bar Chart

• Line Chart

• Pie Chart

• Apple Chart

What is the purpose of the VLOOKUP function in Excel?

• To sort data

• To find a value in a table based on a lookup value

• To calculate the sum of a range

• To format cells

Which feature in Excel allows you to automatically fill cells with a series of data?

• AutoSum

• AutoFill

• Flash Fill

• Data Validation

What symbol must a formula in Excel always start with?

• +

• @

• =

• #

Which of the following is the correct formula to add the values in cells A1 and B1?

• =A1+B1

• =A1-B1

• =A1*B1

• =A1/B1

What function would you use to find the maximum value in a range of cells?

• MIN

• MAX

• SUM

• AVERAGE

Which of the following formulas correctly calculates the average of the values in cells A1 through A10?

• =SUM(A1:A10)/10

• =AVERAGE(A1:A10)

• =MEAN(A1:A10)

• =AVG(A1:A10)

What does the formula =IF(A1>10, “Yes”, “No”) do?

• It checks if A1 is greater than 10 and returns “Yes” if true, otherwise “No”.

• It adds 10 to the value in A1.

• It multiplies the value in A1 by 10.

• It subtracts 10 from the value in A1.