LS/US Excel Basics

What is a spreadsheet primarily used for?

• Writing essays

• Organizing and analyzing data

• Creating presentations

• Designing graphics

In Microsoft Excel, what is the cell reference for the cell located in the third column and fifth row?

• C5

• 3E

• E3

• 5C

Which of the following is a basic formula in Excel to add the values in cells A1 and A2?

• =A1+A2

• ADD(A1, A2)

• SUM(A1, A2)

• =A1-A2

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

• =SUM()

• =AVERAGE()

• =MEDIAN()

• =MODE()

Which of the following is the correct syntax for the IF function in Excel?

• IF(logical_test, value_if_true, value_if_false)

• IF(value_if_true, logical_test, value_if_false)

• IF(logical_test, value_if_false, value_if_true)

• IF(value_if_false, logical_test, value_if_true)

• 6

• 8

• 9

• 12

Which function would you use to count the number of cells that contain numbers in a range?

• =COUNT()

• =COUNTA()

• =COUNTIF()

• =COUNTBLANK()

What is the purpose of the VLOOKUP function in Excel?

• To look up a value in a vertical column

• To look up a value in a horizontal row

• To calculate the sum of a range

• To find the maximum value in a range

Which of the following is a valid Excel formula to calculate the square root of 16?

• =SQRT(16)

• =ROOT(16)

• =SQUARE(16)

• =POWER(16, 0.5)

• Adds the values in cells A1 and B1

• Subtracts the value in cell B1 from A1

• Multiplies the values in cells A1 and B1

• Divides the value in cell A1 by B1