Excel Assessment

What is the shortcut for creating a new workbook?

• Ctrl + P

• Ctrl + O

• Ctrl + N

• Ctrl + S

Which function is used to find the average of a range of numbers?

• AVG

• SUM

• AVERAGE

• MIN

What symbol is used to start a formula in Excel?

• @

• +

• =

• #

How do you create an absolute cell reference?

• &A1

• A1

• #A1

• $A$1

Which of the following is a valid cell reference?

• A1

• 1A

• $1A

• A#1

What does the VLOOKUP function do?

• Calculates the sum of a range of cells

• Searches for a value in a horizontal row

• Looks for a value in a vertical column

• Finds the average of a set of numbers

Which of these formulas will add the values in cells A1 through A5?

• =SUM(A1:A5)

• =SUMMATION(A1:A5)

• =ADD(A1:A5)

• =SUM(A1;A5)

What does the IF function do?

• Counts the number of cells in a range

• Checks a condition and returns one value if true and another if false

• Adds a series of numbers

• Finds the largest number in a range

Answer explanation

Checks a condition and returns one value if true and another if false

Which function is used to count the number of cells that contain numbers?

• COUNTIF

• COUNTIFS

• COUNT

• COUNTA

How do you combine text from two cells into one cell?

• JOIN

• CONCATENATE or &

• LINK

• MERGE