Free Excel Formulas Questions and Answers

Question 1

A _______ is a collection of cells.

Accepted Answer

cell range

Answer

chart

Answer

cell cluster

Answer

multicell

Question 2

True or False: Excel will always let you know if a formula you've constructed has a flaw.

Accepted Answer

FALSE

Answer

TRUE

Question 3

Which formula might you apply to the following graphic to deduct the inventory expenses from the monthly budget?

Accepted Answer

=B2-B3

Answer

=B3/B2

Answer

=SUM(B2:B3)

Answer

=B3=B2

Question 4

Which of the following is a reference to an absolute cell?

Accepted Answer

$B$2

Answer

$B2$

Answer

B2

Answer

B$2$

Question 5

Which of the following formulas is true? Please check all that apply.

Accepted Answer

=J5+C21/D21

Answer

C8+C7

Answer

=A+B+C

Question 6

Which of the following comes first in the order of events?

Accepted Answer

Operations enclosed in parentheses

Answer

Operations involving large numbers

Answer

Exponential calculations

Answer

Multiplication

Question 7

What does an Excel number format mean?

Accepted Answer

A format that tells Excel how to display data in a cell

Answer

A feature that automatically adds numbers in Excel

Answer

A formula that performs mathematical calculations in Excel

Answer

A function that rounds numbers up or down in Excel

Question 8

What does Excel's "Custom" number format mean?

Accepted Answer

A number format that you create to fit your specific needs

Answer

A number format that only displays negative numbers

Answer

A number format that is automatically applied to every cell in a worksheet

Answer

A number format that rounds numbers up or down

Question 9

What is the purpose of Excel's "General" number format?

Accepted Answer

It applies the default number format to a cell.

Answer

It displays numbers as text.

Answer

It displays numbers as dates.

Answer

It displays numbers with no decimal places.

Question 10

How would you calculate the average of the data in cells A1 through A10?

Accepted Answer

=AVERAGE(A1:A10)

Answer

=AVG(A1:A10)

Answer

=MEAN(A1:A10)

Answer

=TOTAL/A10