G11 - CĐ - Mid Term

What does the SUMIF function do?

• None of the above

• Adds the cells in Range or Sum_range specified by a given Criteria

• Returns the arithmetic mean of cells in Range or Average_range that meet a Criteria

• Counts the number of cells within Range that meet the Criteria

When using the COUNTIF function, what does it count?

• The minimum value in a range of cells

• The number of cells within Range that meet the Criteria

• The total of all the cells in a range

• The largest value in a set of values

What is the purpose of the Formulas tab in Excel?

• To apply conditional formatting

• To create and apply advanced formulas

• To format cells and data

• To insert charts and graphs

What is the syntax of the IF function?

• IF(Logical_test, Value_if_true, Value_if_false)

• IF(Value_if_true, Logical_test, Value_if_false)

• IF(Value_if_false, Value_if_true, Logical_test)

• IF(Value_if_true, Value_if_false, Logical_test)

What is the syntax of the SUMIF function?

• SUMIF(Range, Sum_range, Criteria)

• SUMIF(Criteria, Range, Sum_range)

• SUMIF(Sum_range, Criteria, Range)

• SUMIF(Range, Criteria, Sum_range)

Which function is used to format names by capitalizing all letters in of a person's full name?

• UPPER

• RIGHT

• MID

• LOWER

Which function is used to extract the last few digits of a phone number?

• UPPER

• LEFT

• RIGHT

• LOWER

What is the main purpose of the PROPER function in a word processing software?

• Combines text strings into a single text string

• Extracts the left characters from a text string

• Capitalizes the first letter in each word of a text string

• Changes text to lowercase

What does the MID function do in Excel?

• Returns the characters in the middle of a text string

• Capitalizes the first letter in each word of a text string

• Returns the left characters from a text string

• Joins text strings into a single text string

What is the output of formula =SUMIF(F3:F12,"11A2",G3:G12) with the data table: 

• 16

• 8

• 2

• 9