Excel Functions and Features Quiz

In Excel, columns are labeled using:

• Numbers (1, 2, 3, …)

• Letters (A, B, C, …)

• Roman numerals (I, II, III, …)

• Symbols (@, #, $, …)

Rows in Excel are identified using:

• Letters (A, B, C, …)

• Numbers (1, 2, 3, …)

• Both letters and numbers

• Symbols (*, &, %)

Which of the following is NOT a valid way to adjust column width?

• Double-clicking the column boundary

• Dragging the column boundary

• Using Format → Column Width

• Pressing Ctrl + W

What function is used to find the highest value in a range?

• MIN

• MAX

• LARGE

• HIGH

What function is used to find the lowest value in a range?

• LOW

• MIN

• SMALL

• AVERAGE

What does the IF function do?

• Counts the number of cells in a range

• Returns different values based on a condition

• Sorts a list in alphabetical order

• Finds the sum of a range

What will the formula =IF(A1>50, "Pass", "Fail") return if A1 contains 30?

• Pass

• Fail

• Error

• 50

What is the function used to calculate the sum of a range?

• COUNT

• TOTAL

• SUM

• ADD

What will =SUM(A1:A5, B1:B5) do?

• Add all values in A1:A5 and B1:B5

• Multiply A1:A5 by B1:B5

• Count the number of non-empty cells in A1:A5 and B1:B5

• Find the largest value in A1:A5 and B1:B5

What function calculates the average of a range?

• AVG

• SUM

• AVERAGE

• MEAN