Entering Formulas & Functions
-
When using Excel 2007 what symbol is used to create a formula or function in a cell?
-
?
-
+
-
=
-
This quiz assesses knowledge of entering formulas and functions in Excel 2007, focusing on syntax, function arguments, and the use of cell references. It is ideal for learners looking to enhance their spreadsheet skills and understand function application.
Quiz Preview
- 2.
in "SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
-
Letters
-
Cell references
-
Symbols
-
Operators
Correct Answer
A. Cell referencesExplanation
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.
-
True
-
False
Correct Answer
A. TrueExplanation
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.
-
True
-
False
Correct Answer
A. TrueExplanation
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.
-
True
-
False
Correct Answer
A. TrueExplanation
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 ________.
-
The syntax of writing optional arguments.
-
An example of a formula.
-
The general syntax of all functions.
Correct Answer
A. 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 calculation that describes the relationship between cells
-
Excel automatically knows that you want to add the column of numbers above or add the row of numbers to the left
-
This is what rows are sorted by
Correct Answer
A. A calculation that describes the relationship between cellsExplanation
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.
-
Alt+~
-
Ctrl+~
-
Ctrl+W
-
Ctrl+¬
Correct Answer
A. 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.
-
=TODAY()
-
=[date]
-
=[system date]
Correct Answer
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.
-
Nested
-
Round
-
Complex
-
Compound
Correct Answer
A. CompoundExplanation
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:
-
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 07, 2011Quiz Created by
Nsurani
Back to top