Top 50 MS Excel Objective type Questions and Answers

1.    What function displays row data in a column or column data in a row?
a.   Hyperlink
b.   Index
c.   Transpose
d.   Rows
Ans: c

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
Ans: b

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
Ans: a

4.    Macros are “run” or executed from the ….. Menu.
a.   Insert
b.   Format
c.   Tools
d.   Data
Ans: c

5.    You can open the consolidate dialog box byte choosing Consolidate from the ….. Menu.
a.   Insert
b.   Format
c.   Tools
d.   Data
Ans: d

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
Ans: c

7.    Which types of charts can excel produce?
a.   Line graphs and pie charts only
b.   Only line graphs
c.   Bar charts, line graphs and pie charts
d.   Bar charts and line graphs only
Ans: c

8.    How are data organized in a spreadsheet?
a.   Lines and spaces
b.   Layers and planes
c.   Rows and columns
d.   Height and width
Ans: c

9.    What does the VLOOKUP function do?
a.   Looks up text that contain ‘v’
b.   Checks whether text is the same in one cell as in the next
c.   Finds related records
d.   All of above
Ans: c

10.    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
Ans: d

More Questions & Answers:-
Page1 Page2 Page3 Page4 Page5