# Entering Formulas & Functions

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Nsurani
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 14,619
Questions: 10 | Attempts: 262  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.

=

C. =
Explanation
In Excel 2007, the symbol "=" is used to create a formula or function in a cell. This symbol indicates that the content of the cell is a formula and Excel will calculate the result based on the formula entered. By using the "=" symbol, users can perform various calculations and operations within cells to manipulate data and obtain desired results.

Rate this question:

• 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

B. Cell references
Explanation
In the "SUM(number1 [,number2 ,number3 ...])" function, the numbers inside the parentheses can be either numbers or cell references. Cell references refer to specific cells in a spreadsheet and allow you to perform calculations using the values in those cells. So, in addition to using actual numbers, you can also use cell references as arguments in the SUM function to calculate the sum of the values in those cells.

Rate this question:

• 3.

### The Insert Function dialog box tells you how to use functions.

• A.

True

• B.

False

A. True
Explanation
The statement is true because the Insert Function dialog box is a tool in various software applications, such as Microsoft Excel, that helps users understand and utilize different functions available in the software. It provides information about the purpose, syntax, and arguments of each function, making it easier for users to input and apply functions correctly in their calculations or data analysis.

Rate this question:

• 4.

### The function arguments dialog box tells you how to use functions.

• A.

True

• B.

False

A. True
Explanation
The function arguments dialog box provides information on how to use functions. It likely includes details such as the number and type of arguments the function expects, as well as any additional options or parameters that can be specified. This information helps users understand how to correctly call and utilize functions in their code. Therefore, the statement "The function arguments dialog box tells you how to use functions" is true.

Rate this question:

• 5.

### All functions have arguments.

• A.

True

• B.

False

A. True
Explanation
The statement is true because in programming, a function is a block of code that performs a specific task and it can take inputs called arguments. These arguments allow the function to receive data or information that it needs to perform its task. Without arguments, a function would not be able to receive any input and therefore would not be able to perform its intended task. So, it can be concluded that all functions have arguments.

Rate this question:

• 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.

C. The general syntax of all functions.
Explanation
The given correct answer states that the function "FUNCTION(argument1,argument2, ...)" represents the general syntax of all functions. This means that the syntax provided is a template that can be used to define any function, regardless of the specific arguments or functionality it may have. It does not refer to optional arguments or a specific formula, but rather serves as a general representation of how functions are written in programming or mathematical contexts.

Rate this question:

• 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

A. A calculation that describes the relationship between cells
Explanation
A formula is a calculation that describes the relationship between cells in a spreadsheet. It is used in programs like Excel to perform mathematical operations or manipulate data. With formulas, Excel can automatically determine if you want to add the column of numbers above or add the row of numbers to the left. Formulas are essential for performing calculations and analyzing data in spreadsheets.

Rate this question:

• 8.

### You can display a formula by pressing the _____ keys.

• A.

Alt+~

• B.

Ctrl+~

• C.

Ctrl+W

• D.

Ctrl+¬

B. Ctrl+~
Explanation
To display a formula, you can press the Ctrl+~ keys.

Rate this question:

• 9.

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

• A.

=TODAY()

• B.

=[date]

• C.

=[system date]

A. =TODAY()
Explanation
The correct answer is "=TODAY()". This function is used in Excel to calculate the current date. When this formula is used, it will automatically update to the current date every time the spreadsheet is opened or recalculated. This ensures that the date displayed is always accurate and reflects the current day.

Rate this question:

• 10.

### A function inside another function is called a _____________ function.

• A.

Nested

• B.

Round

• C.

Complex

• D.

Compound

D. Compound
Explanation
A function inside another function is called a compound function because it is a combination of multiple functions working together to achieve a specific task. The outer function acts as a container or wrapper for the inner function, allowing them to interact and share data. This nesting of functions can help organize code, improve modularity, and make it easier to understand and maintain.

Rate this question:

Related Topics Back to top