ADVITT EXCEL

In Excel, which function is used to count the number of cells in a range that contain numbers?

• sum

• count

• countif

• counta

In Excel, what does the formula =A1&B1 do?

• Adds the values in cells A1 and B1

• Concatenates the values in cells A1 and B1

• Divides the values in cells A1 and B1

• Multiplies the values in cells A1 and B1

What does the NOW() function in Excel do?

• Returns the current time

• Returns the current date and time

• Returns the current date

• Returns the current month

Which Excel feature allows you to automatically fill in a series of data?

• AutoFill

• AutoComplete

• AutoSum

• AutoFormat

What does the VLOOKUP function do?

• Looks up values in a horizontal lookup table

• Looks up values in a vertical lookup table

• Looks up values in a matrix

• Looks up values in a sorted table

Which function would you use to calculate the number of working days between two dates?

• WORKDAY

• NETWORKDAYS

• WORKDAYS

• WORKINGDAYS

What does the formula =IF(A1>B1, "Yes", "No") do?

• Adds the values in cells A1 and B1

• Concatenates the values in cells A1 and B1

• Compares the values in cells A1 and B1

• Compares the values in cells A1 and B1 and returns "Yes" if A1 is greater than B1, otherwise "No"

Which function is used to count how many cells in a range meet a condition?

• COUNTIF

• SUMIF

• AVERAGEIF

• All of the above

What does the Excel function TRIM() do?

• Removes all spaces from text except for single spaces between words

• Reverses the order of characters in text

• Converts text to lowercase

• Converts text to uppercase

What does the COUNTA function do in Excel?

• Counts the number of errors in a range

• Counts the number of non-empty cells in a range

• Counts the number of numeric values in a range

• Counts the number of cells containing text in a range