Microsoft Excel Quiz

 



Microsoft Excel Quiz contain set of 10 MCQ questions for Microsoft Excel MCQ which will help you to clear beginner level quiz.



1.  What function displays row data in a column or column data in a row?
a.   Hyperlink
b.   Index
c.   Transpose
d.   Rows
 
2.  When you insert an Excel file into a Word document, the data are
a.   Hyperlinked
b.   Placed in a word table
c.   Linked
d.   Embedded
 
3.  Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
a.   IF
b.   AND
c.   OR
d.   NOT
 
4.  Macros are “run” or executed from the ….. menu.
a.   Insert
b.   Format
c.   Tools
d.   Data
 
5.  You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
a.   Insert
b.   Format
c.   Tools
d.   Data
 
6.  Each excel file is called a workbook because
a.   It can contain text and data
b.   It can be modified
c.   It can contain many sheets including worksheets and chart sheets
d.   You have to work hard to create it
 
7.  How are data organized in a spreadsheet?
a.   Lines and spaces
b.   Layers and planes
c.   Rows and columns
d.   Height and width
 
8.  Gridlines
a.   May be turned off for display but turned on for printing
b.   May be turned on or off for printing
c.   The be turned off for display and printing
d.   a, b and c
 
9.  A function inside another function is called a ….. function.
a.   Nested
b.   Round
c.   Sum
d.   Text
 
10.  Which of the following methods cannot be used to enter data in a cell?
a.   Pressing an arrow key
b.   Pressing the tab key
c.   Pressing the Esc key
d.   Clicking the enter button to the formula bar