MS Excel Test: Trivia Quiz! MCQ

25 Questions | By MashikulBappy | Last updated: Mar 21, 2022 | Total Attempts: 70

Questions

Settings

Create your own 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.

Questions and Answers

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
2.

Is it possible to insert an image from a file into an Excel spreadsheet?
- A.
  
  Yes
- B.
  
  No
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
4.

“Month 1, Month 2, Month 3” is an example of what?
- A.
  
  Series
- B.
  
  Function
- C.
  
  Formula
- D.
  
  Syntax
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
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
7.

Which of the following is mixed cell reference with a fixed row address?
- A.
  
  P72
- B.
  
  G$9
- C.
  
  $K356
- D.
  
  $F$8
8.

Formulas in a cell start with a _______.
- A.
  
  :
- B.
  
  {
- C.
  
  =
- D.
  
  /
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.
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
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
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.
  
  $
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
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
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
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
17.

Which function would you use to find the largest number of a selected range?
- A.
  
  MAXIMUM
- B.
  
  MAX
- C.
  
  LARGE
- D.
  
  LARGEST
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
19.

Inserting Page Number is in Header and Footer.
- A.
  
  True
- B.
  
  False
20.

A_________ is a built in mathematical formula included in excel.
- A.
  
  Function
- B.
  
  Cell
- C.
  
  Formula
- D.
  
  Range
21.

What is the keyboard Short Cut to insert the current Time ____
22.

Keyboard Shortcut to Edit the active Cell?
- A.
  
  F2
- B.
  
  Ctrl + E
- C.
  
  Alt + F4
- D.
  
  Alt + E
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
24.

Where you can find the Sort & Filter option in Excel?
25.

Which of following options are not available in Conditional Formatting?
- A.
  
  New table format
- B.
  
  Tab Color
- C.
  
  Data Bars
- D.
  
  Icon Sets