Quiz: Microsoft Excel MCQ Exam!

30 Questions | By Tasha9769 | Last updated: Mar 20, 2022 | Total Attempts: 158

Questions

Settings

Create your own Quiz

Questions and Answers

1.

Microsoft Excel is a?
- A.
  
  Program
- B.
  
  File
- C.
  
  Document
2.

Microsoft excel consists of________________
- A.
  
  Blank documents
- B.
  
  Slides
- C.
  
  Books
3.

Each little box is excel is called a?
- A.
  
  Block
- B.
  
  Table
- C.
  
  Cell
4.

In Excel which direction is a row?
- A.
  
  Horizontal
- B.
  
  Vertical
- C.
  
  Diagonol
5.

In Excel, which direction is a column?
- A.
  
  Horizontal
- B.
  
  Vertical
- C.
  
  Diagonal
6.

What will the FILL COLOR button do in Excel?
- A.
  
  Color the cells
- B.
  
  Color the alphabets and symbols
- C.
  
  Color the numbers
7.

The AutoSum will?
- A.
  
  Add any cell location
- B.
  
  Add or subtract any cell location
- C.
  
  Add any row or column
8.

the Data Sort button will?
- A.
  
  Sort numerical data only
- B.
  
  Sort alphabetically only
- C.
  
  Sort any row or column data
9.

Which statement is true about centering in Excel?
- A.
  
  You can only center a cell at a time
- B.
  
  You can not click the center button before typing
- C.
  
  You can center any range of cells all at one time
10.

The currency key looks like?
- A.
  
  A picture of a dollar bill
- B.
  
  The sigma symbol
- C.
  
  The dollar sign
11.

The currency key will make the number 4469 look like what?
- A.
  
  $4,469
- B.
  
  4469.00
- C.
  
  $4,469.00
12.

What will Auto copy do to the word Monday?
- A.
  
  Copy the word Monday to a selected row or column
- B.
  
  Copy the rest of the week to selected row or column
- C.
  
  Copy the word Monday to the next cell only
13.

In order to have the gridlines of Excel show up when you print, you would need to choose?
- A.
  
  Borders
- B.
  
  Columns
- C.
  
  Format
14.

Which is not a true statement?
- A.
  
  Columns and rows are adjustable
- B.
  
  Only rows can expand
- C.
  
  You can expand a row to your desired setting
15.

You can practically do any kind of math in Excel by using?
- A.
  
  The sigma symbol
- B.
  
  Functions
- C.
  
  Format painter
16.

Which of the following can NOT be deleted?
- A.
  
  An entire row or column
- B.
  
  The font choices
- C.
  
  The contents within the cells
17.

Which statement is true?
- A.
  
  You can have several worksheets within one book
- B.
  
  You are only allowed 3 worksheets within a book
- C.
  
  There is no such thing as having worksheets within a book
18.

How do you name your worksheet tabs?
- A.
  
  Highlight the tab and type in the name
- B.
  
  Click on the tab and go to save as
- C.
  
  Right click on the tab and go to rename
19.

Under which ribbon tab is are the charts located?
- A.
  
  Home
- B.
  
  Insert
- C.
  
  View
20.

What will the "merge and center" button do?
- A.
  
  Merge a range of cells into the center of another worksheet
- B.
  
  Merge all of the worksheets together in the center of the screen
- C.
  
  Merge a range of cells together into one cell and center the contents
21.

What would be the first step in changing a decimal into a fraction in Excel?
- A.
  
  Click on the NUMBER button under the HOME tab In the ribbon
- B.
  
  Click on the PERCENT button in the ribbon
- C.
  
  Click on the INCREASE DECIMAL button in the ribbon
22.

Which tab would you go to in order to set your margins in Excel?
- A.
  
  Page layout
- B.
  
  Home
- C.
  
  Data
23.

Which command reverses the last action taken?
- A.
  
  Redo
- B.
  
  Reverse
- C.
  
  Undo
24.

Which command allows you to reverse an undo command?
- A.
  
  Redo
- B.
  
  Reverse
- C.
  
  Undo
25.

Which cell alignment is assigned to most values by default?
- A.
  
  Left
- B.
  
  General
- C.
  
  Center