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.
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
Rate this question:
True
False
Rate this question:
?
+
=
Rate this question:
True
False
Rate this question:
Letters
Cell references
Symbols
Operators
Rate this question:
=TODAY()
=[date]
=[system date]
Rate this question:
Alt+~
Ctrl+~
Ctrl+W
Ctrl+¬
Rate this question:
The syntax of writing optional arguments.
An example of a formula.
The general syntax of all functions.
Rate this question:
Nested
Round
Complex
Compound
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.
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:
9 |
Attempts:
1106 |
Last updated:
Mar 21, 2023
|
Microsoft Excel Functions Knowledge Test! Trivia Quiz
Test your expertise in Microsoft Excel with this trivia quiz! Covering key functions like SUM, and concepts such as workbooks, worksheets, and arguments, this quiz is designed to...
Questions:
38 |
Attempts:
164 |
Last updated:
Mar 20, 2023
|
MCQ Quiz: Microsoft Excel Functions! Trivia
Do you have a strong knowledge of Microsoft Excel functions? Microsoft Excel is said to be the most challenging Microsoft tool for people to understand because of its ability to...
Questions:
9 |
Attempts:
269 |
Last updated:
Mar 17, 2023
|
Mathematical Functions (Sum, Sub, Mul, Div, Min, Max)
This quiz assesses knowledge on basic mathematical functions in Excel, including SUM, SUMIF, SUMIFS, multiplication, and rounding. It tests the ability to apply these functions to...
Questions:
10 |
Attempts:
326 |
Last updated:
Mar 21, 2023
|
Excel Quiz 2 On Functions And Graphing
Excel Quiz 2 on Functions and Graphing tests knowledge on selecting data for charts, utilizing functions like Max, understanding chart types for data representation, and mastering...
Questions:
13 |
Attempts:
1098 |
Last updated:
Mar 21, 2023
|
Microsoft Excel Quiz: Test On Functions!
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow...
Questions:
10 |
Attempts:
65589 |
Last updated:
Mar 22, 2023
|
Wait!
Here's an interesting quiz for you.