1.
When using Excel 2007 what symbol is used to create a formula or function in a cell?
Correct Answer
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.
2.
in "SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
Correct Answer
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.
3.
The Insert Function dialog box tells you how to use functions.
Correct Answer
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.
4.
The function arguments dialog box tells you how to use functions.
Correct Answer
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.
5.
All functions have arguments.
Correct Answer
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.
6.
FUNCTION(argument1,argument2, ...) Is ________.
Correct Answer
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.
7.
What is a Formula?
Correct Answer
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.
8.
You can display a formula by pressing the _____ keys.
Correct Answer
B. Ctrl+~
Explanation
To display a formula, you can press the Ctrl+~ keys.
9.
What function would you use to calculate today's date so that tomorrow it updates.
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.
10.
A function inside another function is called a _____________ function.
Correct Answer
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.