This quiz was made to go along with the Learning Excel website for Cal Poly Pomona. This quiz will test students on how to make calculations in excel.
True
False
Rate this question:
True
False
Rate this question:
=AVERAGE(A1:A10)
=SUM(A1:A11)
=ADDITION(A1:A10)
=SUM(A1:A10)
=ADD(A1:A10)
Rate this question:
False, it is a reference to all cells except B3.
False, it is just a calculation.
False, it refers to all cells before B3.
False, it refers to cells that are equal to B3.
True
Rate this question:
66
32
31
51
N/A
Rate this question:
False, you only have to type in 1 through 50 and then Excel will generate the rest.
True, Excel should really add a feature to handle this tiresome work.
False, you can just write =NUMBERS(1:100)
False, you only have to type in 1 and then use the Auto-Fill feature to get to 100 quickly.
Rate this question:
1.25
2.75
5
2.8
3
Rate this question:
=SUM(B1:B10)
=B1+B2+B3+B4+B5+B6+B7+B8+B9+B10
=SUM(B1:B8)+B9+B10
=SUM(B1:B5)+SUM(B6:B10)
=B1*B10
=SUM(B1-B10)
Rate this question:
=SUM
=MODE
=MOD
=TOTAL
=MAX
=AVG
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.
Charts In MS Excel
Explore the utility of charts in MS Excel through this engaging quiz. Learn to identify different chart types, understand core components, and assess the effectiveness of...
Questions:
7 |
Attempts:
1780 |
Last updated:
Sep 22, 2024
|
Excel Basics Quiz (Level1)
This quiz depicts some of the many different question of Excel Basics
Questions:
10 |
Attempts:
538 |
Last updated:
May 13, 2023
|
The Ultimate Microsoft Excel Trivia Knowledge! Quiz
This is what is known by many as the ultimate excel trivia. A lot of people have a hard time understanding how this feature works when compared to the other Microsoft...
Questions:
20 |
Attempts:
656 |
Last updated:
Mar 21, 2023
|
Microsoft Excel Trivia Quiz Questions!
Test your skills with our Microsoft Excel Trivia Quiz! This quiz covers essential functions such as keyboard shortcuts for copy, cut, and more, understanding interface elements,...
Questions:
40 |
Attempts:
1244 |
Last updated:
Apr 28, 2024
|
Advanced Excel Online Test
Take your Excel skills to the next level with our Advanced Excel Online Test. Designed for seasoned users, this quiz will challenge your proficiency in complex functions,...
Questions:
10 |
Attempts:
12966 |
Last updated:
May 15, 2024
|
Financial And Excel Modelling Quiz
Financial modeling entails building up an abstract representation, aslo known as a model of a real world financial situation. It is a mathematical build representation which has...
Questions:
10 |
Attempts:
817 |
Last updated:
Mar 21, 2023
|
Wait!
Here's an interesting quiz for you.