Analyzing Data

Which function is used to add a range of numbers in Excel?

• AVERAGE

• MIN

• SUM

• CONCATENATE

What is the correct syntax for the SUM function?

• =SUM(A1:A10)

• =SUM A1:A10

• SUM(A1:A10)

• =SUM(A1;A10)

What does AVERAGE function do in Excel?

• Finds the minimum value.

• Finds the maximum value.

• Calculates the sum of all values.

• Calculates the mean (average) of a range.

Which function is used to find the smallest value in a range?

• MIN

• MAX

• AVERAGE

• SUM

What is the correct formula to find the highest value in the range A1:A10?

• =MIN(A1:A10)

• =MAX(A1:A10)

• =SUM(A1:A10)

• =AVERAGE(A1:A10)

Which function is used to combine text form multiple cells into one?

• SUM

• CONCATENATE

• IF

• AVERAGE

What will be the result of

=CONCATENATE("HELLO", " ", "World")?

• HelloWorld

• Hello World

• "Hello World"

• Error

What is does the formula =IF(A1>10,"High", "Low") do?

• Checks if A1 is greater than 10 and returns "High" or "Low" accordingly.

• Adds 10 to A1

• Finds the AVERAGE of A1 and 10

• Finds the maximum between A1 and 10

What will =IF(5>3,"Yes","No") return?

• 5

• 3

• Yes

• No

Which of the following is not valid Excel function?

• SUM

• ADD

• MIN

• CONCATENATE