Do Now (Excel) 02/28/23

Which of the following adds the values in cells A1 through A10?

• =SUM(A1:A10)

• =SUM(A1,A10)

• =SUM(A1!A10)

• =SUM($A1$A10)

Alex wants to find the highest value in a range of cells. Which of the following functions should he use?

• =MIN( )

• =AVERAGE( )

• =MAX( )

• =MEDIAN( )

Which icon in the Function Library should be clicked to add the NOW function?

• AutoSum

• Date & Time

• Lookup & Reference

• More Functions

Which of the following is a type of equation which returns a value such as TRUE or FALSE?

• Argument

• Expression

• Nest

• Control

Carlos needs to combine words in a First Name and a Last Name column. Which of the following functions should he use?

• IF

• MIN

• MAX

• CONCATENATE