Excel Quiz

What does a cell in Excel represent?

• A file

• A worksheet

• The intersection of a row and a column

• A chart

Which of the following is a correct basic formula in Excel?

• A1 + B1

• SUM = A1:A5

• =A1 + B1

• Add(A1, B1)

What is the purpose of formatting data in Excel?

• To hide errors

• To make data easier to read and understand

• To delete cells

• To calculate numbers

Which Excel function is used to find the average of a range of numbers?

• =SUM()

• =COUNT()

• =AVERAGE()

• =MAX()

What does the IF() function do?

• Finds text in a document

• Filters rows

• Makes a decision based on a condition

• Sorts data alphabetically

You can have multiple sheets in one Excel workbook.

• True

• False — Filtering only hides rows temporarily.

Filtering allows you to remove data permanently.

• True

• False — Filtering only hides rows temporarily.

=PMT() is used to perform financial calculations in Excel.

• True

• False

Excel formulas must always start with an equal sign (=).

• True

• False

The COUNT function is used to add numbers together.

• True

• False — =COUNT() counts numeric entries, not sums them.