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