Front

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

Back

.xlsx

Front

What function is used to find the average in Excel? Options: =SUM(), =MEAN(), =AVERAGE(), =AVG()

Back

=AVERAGE()

Front

Which symbol is used to start a formula in Excel?

Back

=

Front

Which function returns the number of cells with numeric values? Options: COUNTIF, COUNTA, COUNT, COUNTBLANK

Back

COUNT

Front

Which of the following is a relative cell reference? A1, $A$1, A$1, $A1

Back

A1

Front

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

Back

Fill Handle

Front

What does the CONCATENATE function do?

Back

Joins text strings

Front

Which chart is best to show trends over time? Options: Pie Chart, Bar Chart, Line Chart, Column Chart

Back

Line Chart

Front

What does the IF function do?

Back

Evaluates a condition

Front

Which key combination is used to insert a new worksheet?

Back

Shift + F11