REMOVAL

What is the default file extension for an Excel 365 workbook?

• .xls

• .xlsx

• .docx

• .xlsm

What function is used to find the average in Excel?

• =SUM()

• =MEAN()

• =AVERAGE()

• =AVG()

Which symbol is used to start a formula in Excel?

• =

• +

• @

• #

Which function returns the number of cells with numeric values?

• COUNTIF

• COUNTA

• COUNT

• COUNTBLANK

Which of the following is a relative cell reference?

• A1

• $A$1

• A$1

• $A1

Which feature allows you to copy formulas across a row or column?

• Flash Fill

• Fill Handle

• AutoCorrect

• Filter

What does the CONCATENATE function do?

• Joins text strings

• Adds numbers

• Sorts data

• Splits text

Which chart is best to show trends over time?

• Pie Chart

• Bar Chart

• Line Chart

• Column Chart

What does the IF function do?

• Counts blank cells

• Evaluates a condition

• Filters data

• Formats cells

Which key combination is used to insert a new worksheet?

• Ctrl + W

• Shift + F11

• Alt + F4

• Ctrl + F5