Quiz: Microsoft Excel MCQ Exam!
Settings
- 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
Back to top