Excel Functions Quiz
This is a review about lesson 3, the topics contained are this: excel formulas, functions( sum,max,min,average,round,if)
Questions and Answers
- 1.
To start a formula you must use:
- A.
Parentheses ()
- B.
Equals =
- C.
Just type your formula
Correct Answer
B. Equals =Explanation
The correct answer is "Equals =". In order to start a formula, you must use the equals sign (=). This is because the equals sign is used to indicate that you are entering a formula and want the spreadsheet software to perform calculations based on that formula. Without the equals sign, the software will treat the entry as a regular text or number. The parentheses () are used to group certain parts of the formula together, while "Just type your formula" is not a valid way to start a formula.Rate this question:
-
- 2.
Which of the following is invalid?
- A.
=MAX(B5:B15)
- B.
=MAX(B1,B2,B3,B4,B5,B6,B7)=MAX(B8,B9)
- C.
=MAX(B1:B10,B11:B20)
Correct Answer
B. =MAX(B1,B2,B3,B4,B5,B6,B7)=MAX(B8,B9)Explanation
The given answer "=MAX(B1,B2,B3,B4,B5,B6,B7)=MAX(B8,B9)" is invalid because the MAX function can only accept a range of cells or individual cell references as arguments, not multiple separate arguments. Therefore, it is not possible to compare two separate MAX functions using the "=" operator.Rate this question:
-
- 3.
List which standart math operators Excel uses and what is their order of precedence.
- 4.
Explain how works the function if ?
- 5.
Write an example of an if function
- 6.
Explain how average function works and provide an example of it
- 7.
You can refer data in worksheet from another?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Yes, you can refer data in a worksheet from another worksheet in Excel. This can be done by using formulas or functions that reference the cell or range of cells in the other worksheet. By linking the data between worksheets, any changes made in the referenced cells will automatically update in the referring worksheet.Rate this question:
-
- 8.
SUM() is a function that allow to make additions ?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given answer is true because the SUM() function in programming languages, such as SQL or Excel, allows for the addition of numbers. It takes a set of values and returns the sum of those values. This function is commonly used to calculate the total of a series of numbers or to perform mathematical operations that involve adding values together. Therefore, the statement that SUM() allows for additions is correct.Rate this question:
-
Quiz Review Timeline +
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 -
Jan 29, 2013Quiz Created by
Calderon_jorge