# Entering Formulas & Functions

10 Questions | Total Attempts: 212  Settings  Entering Formulas & Functions for Basic

• 1.
When using Excel 2007 what symbol is used to create a formula or function in a cell?
• A.

?

• B.

+

• C.

=

• 2.
in "SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
• A.

Letters

• B.

Cell references

• C.

Symbols

• D.

Operators

• 3.
The Insert Function dialog box tells you how to use functions.
• A.

True

• B.

False

• 4.
The function arguments dialog box tells you how to use functions.
• A.

True

• B.

False

• 5.
All functions have arguments.
• A.

True

• B.

False

• 6.
FUNCTION(argument1,argument2, ...) Is ________.
• A.

The syntax of writing optional arguments.

• B.

An example of a formula.

• C.

The general syntax of all functions.

• 7.
What is a Formula?
• A.

A calculation that describes the relationship between cells

• B.

Excel automatically knows that you want to add the column of numbers above or add the row of numbers to the left

• C.

This is what rows are sorted by

• 8.
You can display a formula by pressing the _____ keys.
• A.

Alt+~

• B.

Ctrl+~

• C.

Ctrl+W

• D.

Ctrl+¬

• 9.
What function would you use to calculate today's date so that tomorrow it updates.
• A.

=TODAY()

• B.

=[date]

• C.

=[system date]

• 10.
A function inside another function is called a _____________ function.
• A.

Nested

• B.

Round

• C.

Complex

• D.

Compound

Related Topics Back to top