MS Excel mcq Questions and Answer | Microsoft Excel-11

1 min read

MS Excel mcq Questions and Answer | Microsoft Excel-11

excel-11

Question 1
. Which types of charts can excel produce?
A
(1) Line graphs and pie charts only
B
(2) Only line graphs
C
(3) Bar charts, line graphs and pie charts
D
(4) Bar charts and line graphs only
Question 2
. How are data organized in a spreadsheet?
A
(1) Lines and spaces
B
(2) Layers and planes
C
(3) Rows and columns
D
(4) Height and width
Question 3
. What does the VLOOKUP function do?
A
1) Looks up text that contain V
B
(2) Checks whether text is the same in one cell as in the next
C
(3) Finds related records
D
(4) All of above
Question 4
. Gridlines
A
(1) May be turned off for display but turned on for printing
B
(2) May be turned on or off for printing
C
(3) The be turned off for display and printing
D
(4) a, b and c
Question 5
..You can print only an embedded chart by
A
(1) Moving the chart to a chart sheet before you print
B
2) Formatting the chart before you print
C
(3) Selecting the chart before you print
D
(4) a and c
Question 6
Which of the following is a cor-rect order of precedence in a formula calculation?
A
Which of the following is a cor-rect order of precedence in a formula calculation?
B
(2) Multiplication and division, positive and negative values, addition and subtraction
C
(3) Addition and subtraction, positive and negative values, exponentiation
D
4) None of above
E
(5) None of these
Question 7
A function incite another function is called a .....function.
A
(1) Nested
B
(2) Round
C
(3) Sum
D
(4) Text
Question 8
How should you print a selected area of a worksheet, if you'll want to print a different area next time?
A
(1) On the file menu, point to print area, and then click set print are
B
(2) On the file menu, click print, j and then click selection | under print what
C
(3) On the view menu, click custom views, then click add
D
(4) All of above
Question 9
Youar German supplier still in-voices for parts in deutsche marks. How can you .have Excel convert those sums to Euros?
A
(1) On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
B
(2) On the tools menu, click Add-lns, and select the Euro Currency Tools check box
C
(3) Apply a selected background color
D
(4) All of above
Question 10
Which function calculates your monthly mortage payment?
A
(1) PMT (payments)
B
(2) NPER (number of periods)
C
(3) PV (present value)
D
(4) All of above
Question 11
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify ac: curacy. How do you activate this feature?
A
(1) Point to speech on the tools menu, and then click show text to speech toolbar
B
(2) Click validation on the data menu
C
(3) Point to speech on the tools menu, and then click speech recognition
D
(4) All of above
Question 12
You can open the Sort dialog box by choosing Sort from the .... menu
A
(1) View
B
(2) Format
C
(3) Tools
D
(4) Data
Question 13
when working in the page break preview, you can
A
(1) view exactly where each page break occurs
B
(2) add or remove page breaks
C
(3) change the print area
D
(4) all of above
Question 14
. A data map is helpful
A
(1) When you have too much data to chart
B
(2) To show a geographic distri-bution of data
C
(3) To compare data points
D
(4) To show changes in data over-time
Question 15
In MS Access-,-a table can have__ primary key /keys.
A
(1) One
B
(2) Two
C
(3) Three
D
(4) Four
Question 16
__ cells involves creating a single cell by combining two or more selected cells.
A
(1) Formatting
B
(2) Merging
C
(3) Embedding
D
(4) Splitting
Question 17
The horizontal and vertical lines on a worksheet are called
A
1) cells
B
(2) sheets
C
(3) blocklines
D
(4) gridlines
Question 18
The horizontal and vertical lines on a worksheet are called
A
1) cells
B
(2) sheets
C
(3) blocklines
D
(4) gridlines
Question 19
To delete an incorrect character in a document, __ to erase to the right of the insertion point.
A
(1) press the left mouse key
B
(2) double click the right mouse key
C
(3) press the BACKSPACE key
D
(4) press DELETE key
Question 20
. The most common subtotal used Subtotals command is the __ function, which causes Excel to display a sum each time the corurol field change.
A
(1) ADD
B
(2) SUM
C
(3) TOTAL
D
(4) LIST
Question 21
. Be default, Excel positions text in a cell ___.
A
(1) left-aligned
B
(2) right-aligned
C
(3) centered
D
(4) justified
Question 22
To centre a paragraph using shortcut keys, press __.
A
(1) CTRL + C
B
(2) CTRL + E
C
(3) CTRL + L
D
(4) CTRL + R
Question 23
Which of the following is the latest version of Excel?
A
(1) Excel 2000
B
(2) Excel 20.02
C
(3) Excel ME
D
(4) Excel XP
Question 24
. Which area in an Excel window allows entering values and formulas
A
(1) Title Bar
B
(2) Menu Bar
C
(3) Formula Bar
D
(4) Standard Tool Bar
Question 25
How are data organised in a spreadsheet?
A
(1) Lines and spaces
B
(2) Layers and planes
C
(3) Height and width
D
(4) Rows and columns
Question 26
. Which of the following types of tables constraints will prevent the entry of duplicate rows?
A
(1) Primary key
B
(2) Unique
C
(3) Null
D
4) Foreign key
Question 27
Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the
A
(1) cell's column label
B
(2) cell's column label and worksheet tab name
C
(3) cell's row label
D
(4) cell's row and column la-bels
There are 27 questions to complete.

Leave a Reply

Your email address will not be published.

Previous Story

MS Excel mcq Questions and Answer | Microsoft Excel-10

Next Story

MS Excel mcq Questions and Answer | Microsoft Excel-12

Latest from Blog

error: Content is protected !!