Part 2

What happens when you insert a new column in Excel?

• The worksheet is duplicated

• The new column appears to the left of the selected column, shifting the rest to the right

• A column appears to the right of the selected column

• All rows are deleted

Which of the following is not a cell formatting option?

• Number

• Alignment

• Worksheet

• Font

Which function would you use to find the total of the total number of non-empty cells?

• IF

• SUM

• COUNT

• MIN

What does the COUNTIF function do?

• Counts the total number of rows

• Adds a range of cells

• Counts cells based on a specific condition

• Multiplies values in cells

What’s the main difference between a formula and a function in Excel?

• There is no difference

• B) A function is built-in and simplifies formulas, whereas a formula can be any calculation created by the user

• A formula is built-in while a function is user-created

• A formula can’t handle large data sets while a function can

Which function would you use to find the largest number in a range?

• AVERAGE

• MIN

• SUMIF

• MAX