MS Excel mcq Questions and Answer | Microsoft Excel-11

excel-11

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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.

MS Excel mcq Questions and Answer | Microsoft Excel-11

MS Excel mcq Questions and Answer | Microsoft Excel-11

excel-11

Leave a Reply Cancel reply

Recent Posts

Categories

Latest Posts

MS Excel mcq Questions and Answer | Microsoft Excel-10

MS Excel mcq Questions and Answer | Microsoft Excel-12

Latest from Blog