Entering Formulas & Functions
10 Questions
| Total Attempts: 212
Entering Formulas & Functions for Basic
Questions and Answers
- 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
Questions: 11 | Attempts: 4856 | Last updated: Mar 22, 2022
-
Sample QuestionScreening is:
When it comes to calculus, a limit is described as a number that a function approaches as the independent variable of the function approaches a given value. On the other hand, a continuity is reflected on a graph illustrating a...
Questions: 10 | Attempts: 1827 | Last updated: Mar 22, 2022
-
Sample QuestionIn the function f(x)=3x, what is the limit of f(x) as x approaches 2?
Fill in the missing value:
Questions: 6 | Attempts: 1708 | Last updated: Mar 21, 2022
-
Sample QuestionF(x) = 4x - 3 f(2)
- Algebra Quizzes
- Arithmetic Quizzes
- Calculus Quizzes
- Data Handling Quizzes
- Decimal Quizzes
- Discrete Mathematics Quizzes
- Equation Quizzes
- Multiplication Quizzes
- Number Quizzes
- Percentage Quizzes
- Place Value Quizzes
- Probability Quizzes
- Problem Solving Quizzes
- Ratio Quizzes
- Shape Quizzes
- Statistics Quizzes
- Trigonometry Quizzes
Back to top