Excel II

What function is case sensitive?

• SEARCH

• FIND

• LEFT

• SUM

What function to use to get this ->55555 from the initial value -> 55555-End

• LEFT

• MID

• RIGHT

What function uses delimiter as a parameter in its syntaxis?

• &

• CONCATENATE

• CONCAT

• TEXTJOIN

In this image, which formula could you use to subtract the inventory costs from the monthly budget?

• =B3-B2

• =B3/B2

• =SUM(B2:B3)

• =B2-B3

What formula would you use to find the average of the values in cell range A1 to A10?

• =AVG(A1:A10)

• =AVERAGE(A1:A10)

• =TOTAL/A10

• =MEAN(A1:A10)

Which function would you use to add several numeric values?

• COUNTA

• TOTAL

• SUM

• AVERAGE

Which function can find the highest value in a cell range?

• HIGHEST

• MAX

• MAXVALUE

• TOP

Which function can display a differnece value depending on a condition?

• IF

• AVERAGE

• CONDITION

• TEST

What does the formula =A1&" "&A2 do in Excel?

• Adds the value in A2 to the value in A1

• Combines the values in cells A1 and A2 into a single cell with a space between them

• 
  Multiplies the values in cells A1 and A2

• Subtracts the value in A2 from the value in A1

Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"

• IF(B4>200,"High","Low")

• =IF(B4>200,"High","Low")

• =IF(B4<200,"High","Low")

• =IF(B4>200"High","")