Dive into the essentials of MS Excel with this trivia quiz! Explore key concepts like cell addresses, columns, rows, sheet tabs, and built-in functions. Perfect for enhancing your Excel skills and understanding, this quiz is tailored for learners aiming to master workbook operations and formula usage.
$
\
*
Rate this question:
* (asterisk)
\ (forward slash)
= (equal sign)
Rate this question:
Formula
Operator
Cell address
Rate this question:
(D4:D9)
(D4,D9)
(D4+D9)
Rate this question:
The formula is missing the math operator.
The column width is not wide enough to display the results.
You entered an invalid cell reference.
Rate this question:
True
False
Rate this question:
Column
Row
Absolute reference
Rate this question:
=
(A10:A15)
SUM
Rate this question:
True
False
Rate this question:
1
3
5
Rate this question:
Active cell
Formula bar
Worksheet name
Rate this question:
=C5*$D$9
=C4*$D$9
=C5*D9
Rate this question:
True
False
Rate this question:
A vertical range of cells referred to by a number.
A horizontal range of cells referred to by a number.
A vertical range of cells referred to by a letter.
Rate this question:
Ctrl + ~
Ctrl + F5
Ctrl + $
Rate this question:
Function
Value
Sort
Rate this question:
True
False
Rate this question:
True
False
Rate this question:
The cell reference automatically changes when the formula is copied down a column or across a row.
The cell uses the A1 reference style.
The cell reference is fixed or locked.
Rate this question:
Quiz Review Timeline (Updated): Mar 17, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Spreadsheet Formulas And Functions Quiz #3
Spreadsheet Formulas and Functions Quiz #3 assesses knowledge on Excel's formula creation, including the use of Auto Calculate and function wizard. It validates understanding of...
Questions:
15 |
Attempts:
1820 |
Last updated:
Mar 22, 2023
|
Microsoft Excel 2007- Formulas And Function
This Microsoft Excel 2007 quiz assesses understanding of formulas and functions, focusing on common errors like #VALUE! and #REF!, and nuances in function syntax. It enhances...
Questions:
25 |
Attempts:
539 |
Last updated:
Mar 20, 2023
|
11KAZEN QUIZ - EXCEL MATH FORMULAS
This quiz is a measurement of your knowledge of the software called Excel. Please use the software to answer any of the questions that are on this quiz.
Questions:
7 |
Attempts:
293 |
Last updated:
Mar 22, 2023
|
Excel Formulas And Functions Trivia Quiz
Get ready for this 'excel formulas and functions trivia quiz'. Have you ever worked on a spreadsheet application or MS Excel? Do you know all the functions and formulas?...
Questions:
10 |
Attempts:
15417 |
Last updated:
Feb 07, 2024
|
Microsoft Excel 2007 Quiz: Formulas And Functions!
Microsoft Excel, often called MS Excel, is a spreadsheet application for data processing and financial presentation. Do you know all the functions and formulas of excel? Are you...
Questions:
28 |
Attempts:
1646 |
Last updated:
Mar 21, 2023
|
Test Your Knowledge About Microsoft Excel Formulas!
Microsoft Excel is a spreadsheet software which was developed by Microsoft.
To become an expert one needs to master the basic formulas and functions used in the excel...
Questions:
20 |
Attempts:
1529 |
Last updated:
Mar 18, 2023
|
Wait!
Here's an interesting quiz for you.