MS Excel

What will be the result of the formula =SUM(A1:A5)?

• It will count the number of cells from A1 to A5

• It will add all the numeric values from A1 to A5

• It will find the largest value from A1 to A5

• It will combine the text in cells A1 to A5

Answer explanation

The SUM function adds all numbers in a selected range.

What will be the result of the formula =AVERAGE(B1:B5)?

• It will calculate the average of the numeric values from B1 to B5

• It will find the median value from B1 to B5

• It will return the highest value from B1 to B5

• It will count the number of non-empty cells in B1 to B5

What will be the result of the formula =IF(D1>100, "High", "Low")?

• It will return the value of D1 if it is greater than 100

• It will return "Low" if D1 is greater than 100, otherwise "High"

• It will return "High" if D1 is greater than 100, otherwise "Low"

• It will calculate the sum of D1 and 100

Which formula correctly calculates the average of cells B1 to B10?

(a)  

Answer explanation

Both methods give the average, but =AVERAGE(B1:B10) is quicker and more efficient.

Which function can you use to find the highest value in a list of numbers?

• =MIN()

• =LARGE()

• =MAX()

• =SUM()

Answer explanation

The MAX function returns the highest numeric value in a range.

What is the correct formula to multiply the values in cells A2 and B2?

• =MULTIPLY(A2,B2)

• =A2*B2

• =PRODUCT(A2+B2)

• =A2&B2

Answer explanation

The * operator is used for multiplication in Excel.

What happens if you drag the fill handle from cell C1 containing =A1+B1 down to C5?

• The formula will not change.

• The formula will copy exactly as =A1+B1 in all cells.

• The cells will remain empty.

• The formula will auto-adjust to add A2+B2, A3+B3, etc.

Answer explanation

Excel uses relative referencing when dragging formulas.

What will =IF(A1>10, "High", "Low") return if A1 is 8?

(a)  

Which feature quickly arranges data in ascending or descending order?

(a)  

Answer explanation

The Sort tool arranges data based on selected columns.

Which function counts all non-empty cells in a selected range?

(a)  

Answer explanation

COUNTA counts all non-empty cells, regardless of data type.