FREE Excel Functions Questions and Answers

Question 1

Excel formulae all start with the same symbol.

Accepted Answer

+

Answer

%

Answer

#

Question 2

A selection of several cells is referred to as a

Accepted Answer

Range

Answer

Group

Answer

Reference

Answer

Package

Question 3

Worksheets are a type of ___.

Accepted Answer

A single page in a workbook

Answer

Piece of graph paper

Answer

Excel file

Answer

All of the above

Question 4

Which of the following formulas will add B2's value to C3's value?

Accepted Answer

=B2+C3

Answer

=6+4

Answer

=C3+B3

Answer

=B+C

Question 5

Which of the following formulations for the IF function is correct?

Accepted Answer

=IF(condition, condition if true, condition if false)

Answer

=IF(condition, condition if false, condition if true)

Answer

=IF(condition:condition if true:condition if false)

Answer

None of these

Question 6

This is an equation.

Accepted Answer

=SUM(A1:A5)

Answer

Subtract the numbers from A1 to A5

Answer

Add A1 - A5

Answer

A1 = A5

Question 7

Which view of a worksheet displays the worksheet's header and footer sections?

Accepted Answer

Page layout view

Answer

Normal view

Answer

Page break preview

Answer

Header/Footer

Question 8

The purpose of the word "=SUM" at the start of an Excel spreadsheet formula is

Accepted Answer

To add all the data together using addition only.

Answer

To tell the person viewing that this is a function and it should be added together.

Answer

To calculate all the data correctly without any mistakes.

Answer

To inform the computer that an arithmetic function will occur.

Question 9

Which of the following calculations uses an Excel spreadsheet the most frequently?

Accepted Answer

All of the above

Answer

Data

Answer

Numbers

Answer

Finances

Question 10

Cell addresses are used in formulas as:

Accepted Answer

Cell referencing

Answer

Formularizing

Answer

Prefixing

Answer

Cell mathematics