MS Excel Test: Trivia Quiz! MCQ
(208).jpg "MS Excel Test: Trivia Quiz! MCQ - Quiz")
Check out our MS Excel online quiz that necessitates you to grasp certain concepts like what is the tag given to a value that does not alter when used within a formula, what Chart tool commands are found in these three tabs, what is mixed cell reference with a fixed row address, and with what do formulas in the cell start. This stupendous quiz will tell you all about MS Excel. Give it a shot.
- 1.
Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- A.
Count
- B.
Average
- C.
Sum
- D.
Add
Correct Answer
C. Sum -
- 2.
Is it possible to insert an image from a file into an Excel spreadsheet?
- A.
Yes
- B.
No
Correct Answer
A. Yes -
- 3.
The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
- A.
A1-J15
- B.
A1.J15
- C.
A1;J15
- D.
A1:J15
Correct Answer
D. A1:J15 -
- 4.
“Month 1, Month 2, Month 3” is an example of what?
- A.
Series
- B.
Function
- C.
Formula
- D.
Syntax
Correct Answer
A. Series -
- 5.
What is the name given to a value that does NOT change when used within a formula?
- A.
Reference
- B.
Constant
- C.
Function
- D.
Address
Correct Answer
B. Constant -
- 6.
The Chart Tools commands are found in these three tabs?
- A.
Design, Shape, Layout
- B.
Layout, Format, Type
- C.
Design, Layout, Format
- D.
Styles, Shapes, Effects
Correct Answer
C. Design, Layout, Format -
- 7.
Which of the following is mixed cell reference with a fixed row address?
- A.
P72
- B.
G$9
- C.
$K356
- D.
$F$8
Correct Answer
B. G$9 -
- 8.
Formulas in a cell start with a _______.
- A.
:
- B.
{
- C.
=
- D.
/
Correct Answer
C. = -
- 9.
What is a worksheet tab in Excel 2010?
- A.
A worksheet tab is used to access tools associated with the worksheet
- B.
A worksheet tab is used to move from one cell to the next cell in a worksheet
- C.
A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet
- D.
A worksheet tab is used to get help when working with Microsoft Excel 2010.
Correct Answer
C. A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet -
- 10.
Once data is entered into a cell, can it be edited?
- A.
Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing
- B.
No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet
- C.
No, once a file is saved, cell data cannot be changed
- D.
Yes, but the file must be saved with a different file name
Correct Answer
A. Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing -
- 11.
Which feature in Excel allows you to view two spreadsheets in one window?
- A.
Freeze panes
- B.
Split
- C.
View side by side
- D.
Mirror
Correct Answer
B. Split -
- 12.
Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
- A.
#
- B.
%
- C.
&
- D.
$
Correct Answer
D. $ -
- 13.
When number signs (#####) are displayed in the cell, it means:
- A.
The formula in the cell is wrong
- B.
There are too many characters in the cell to be displayed with the current cell width
- C.
The decimal point placement in the cell is wrong
- D.
All of the above
Correct Answer
B. There are too many characters in the cell to be displayed with the current cell width -
- 14.
When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?
- A.
Seperate the page into two for easier printing
- B.
Use the Fit to Page option
- C.
Highlight all cells to print and print selection
- D.
None of the above
Correct Answer
B. Use the Fit to Page option -
- 15.
What does the following error mean - #REF!?
- A.
The #REF! error value occurs when a cell reference is not valid.
- B.
The #REF! error value occurs when a cell has been formatted as a currency but contains text.
- C.
The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.
- D.
None of the above
Correct Answer
A. The #REF! error value occurs when a cell reference is not valid. -
- 16.
How do you select noncontiguous cells?
- A.
Click a cell, then hold down SHIFT on the keyboard and select the other cells
- B.
Click in a cell, then hold down ALT on the keyboard as you select the other cells
- C.
Click in a cell, hold down CTRL on the keyboard and then select the other cells
- D.
Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard
Correct Answer
C. Click in a cell, hold down CTRL on the keyboard and then select the other cells -
- 17.
Which function would you use to find the largest number of a selected range?
- A.
MAXIMUM
- B.
MAX
- C.
LARGE
- D.
LARGEST
Correct Answer
B. MAX -
- 18.
According to the picture the selected cell in yellow corresponds to:
- A.
Column A, Row A11, Cell 11
- B.
Column 11, Row A, Cell 11A
- C.
Column 11, Row A, Cell A11
- D.
Column A, Row 11, Cell A11
Correct Answer
D. Column A, Row 11, Cell A11 -
- 19.
Inserting Page Number is in Header and Footer.
- A.
True
- B.
False
Correct Answer
A. True -
- 20.
A_________ is a built in mathematical formula included in excel.
- A.
Function
- B.
Cell
- C.
Formula
- D.
Range
Correct Answer
A. Function -
- 21.
What is the keyboard Short Cut to insert the current Time ____
Correct Answer
Ctrl + Shift + ; - 22.
Keyboard Shortcut to Edit the active Cell?
- A.
F2
- B.
Ctrl + E
- C.
Alt + F4
- D.
Alt + E
Correct Answer
A. F2 -
- 23.
If you select a range of cells with Value, (without using any formula) the answer (average, sum etc) will appear at the status bar
- A.
True
- B.
False
Correct Answer
A. True -
- 24.
Where you can find the Sort & Filter option in Excel?
Correct Answer
Home Tab - 25.
Which of following options are not available in Conditional Formatting?
- A.
New table format
- B.
Tab Color
- C.
Data Bars
- D.
Icon Sets
Correct Answer(s)
A. New table format
B. Tab Color -
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, 2022Quiz Edited by
ProProfs Editorial Team -
Nov 19, 2018Quiz Created by
Mashikul Amin
Back to top