MS Excel mcq Questions and Answer | Microsoft Excel-2

Microsoft Excel SET-2

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

What function Displays row data in a column or column data in a row?

A	Hyperlink
B	Index
C	Transpose
D	Rows

Question 2

When you insert an Excel file into a Word document, the data are

A	Hyperlinked Placed in a word table
B	Linked
C	Embedded
D	None of these

Question 3

Except for the ...... function, a formula with a logical the function shows the word "TRUE" or "FALSE" as a result

A	IF
B	AND
C	OR
D	NOT

Question 4

Macros are "run" or executed from the..... menu.

A	Insert
B	Format
C	Tools
D	Data

Question 5

You can open the consolidate dialog box byt choosing Consolidate from the..... menu.

A	Insert
B	Format
C	Tools
D	Data

Question 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

Question 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

Question 8

How are data organized in a spreadsheet?

A	Lines and spaces
B	Layers and planes
C	Rows and columns
D	Height and width

Question 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

Question 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

Question 11

You can print only an embedded chart by

A	Moving the chart to a chart sheet before you print.
B	Formatting the chart before you print
C	Selecting the chart before you print
D	a and c

Question 12

Which of the following is a correct order of precedence in a formula calculation?

A	Multiplication and division, exponential positive and negative value
B	Multiplication and division, positive and negative values, addition and subtraction
C	Addition and subtraction, positive and negative values, exponentiation
D	All of above
E	None of these

Question 13

A function inside another function is called a.....function.

A	Nested
B	Round
C	Sum
D	Text

Question 14

How should you print a selected area of a worksheet, if you'll want to print a different area next time?

A	On the file menu, point to print area, and then click set print area.
B	On the file menu, click print, and then click selection under print what
C	On the view menu, click custom views, then click add
D	All of above

Question 15

Youar German supplier still invoices for parts in deutsche marks. How does Excel convert those sums to Euros?

A	On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign,
B	On the tools menu, click Add-lns, and select the Euro Currency Tools check box
C	Apply a selected background color
D	All of above

Question 16

Which function calculates your monthly mortage payment?

A	PMT (payments)
B	NPER (number of periods)
C	PV (present value)
D	All of above

Question 17

If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

A	Point to speech on the tools menu, and then click show text to speech toolbar.
B	Click validation on the data menu
C	Point to speech on the tools menu, and then click speech recognition
D	All of above

Question 18

Which of the following methods can not 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

Question 19

Which of the following will not set text in selected cells to italics?

A	Pressing Ctrl + I on the keyboard
B	Using the Tools - Wizard -Web Form menu item
C	Using the Format - Cells -Font menu item
D	All of the above

Question 20

Which of the following methods cannot be used to edit the content of cell?

A	Pressing the Alt key
B	Clicking the formula bar
C	Pressing F2
D	Double clicking the cell

Question 21

You can activate a cell by

A	Pressing the Tab key
B	Clicking the cell
C	Pressing an arrow key
D	All of above

Question 22

Which of the following setup options can not be set in the page setup dialog box?

A	Printer selection
B	Vertical or horizontal placement
C	Orientation
D	Row and column titles

Question 23

What term refers to a specific set of values saved with the workbook?

A	Range
B	Scenario
C	Trend line
D	What-if analysis

Question 24

Got functions? No? You need the insert function dialog box. How do you get it?

A	Right click a cell and then click insert
B	Click the insert menu and then click function
C	Type - in a cell
D	All of the above

Question 25

Which of the following describes how to select all the cells in a single column?

A	Right click on column and select Pick from list
B	Use data - text to columns menu item
C	Left click on the gray column title button
D	Pressing Ctrl + A on the keyboard

Question 26

When you use the fill effects in the format data series dialog box, you can not

A	rotate text on the chart
B	select a fore ground color
C	select a pattern
D	select a background color

Question 27

Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

A	Rows and columns
B	Headings
C	Speed
D	All of above

Question 28

Which of the following is not a basic step in creating a worksheet?

A	(1) Save the workbook
B	(2) Modify the worksheet
C	(3) Enter text and data
D	(4) Copy the worksheet

Question 29

. What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

A	(1) Select both cells, and then drag the fill handle over the
B	(2) Select the range you want, include both cells, point tofill on the Edit menu, and then click down.
C	3) Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
D	(4) All of above

Question 30

To insert three columns between columns D and E you would

A	(1) Select column D
B	2) Select column E
C	3) Select columns E, F and G
D	(4) Select columns D, E, and F

Question 31

To center worksheet titles across a range of cell, you must

A	1) Select the cells containing the title text and use the fill handle to center the text across a range of cells
B	(2) Widen the columns
C	(3) Select the cells containing the title text and use the fill handle to center the text across a range of cells
D	(4) Widen the column

Question 32

.When integrating Ms-Word and Excel, Word is usually the

A	1) Server
B	(2) Source
C	(3) Client
D	4) None

Question 33

Charts tips can

A	(1) Show the formatting of a data label
B	(1) Show the formatting of a data label
C	(3) Show the value of data point
D	(4) b and c

Question 34

The Name box

A	(1) Shows the location of the previously active cell
B	(2) Appears t the left of the formula bar
C	(3) Appears below the status bar
D	(4) Appears below the menu bar

Question 35

How do you change column width to fit the contents?

A	(1) Single-click the boundary to the left to the column heading
B	(2) Double click the boundary to the right of the column heading
C	(3) Press Alt and single click anywhere in the column
D	(4) All of above

Question 36

When you work with large worksheets, you may need to

A	(1) size the worksheet to fit on the specific number of pages
B	(2) add and remove page breaks
C	(3) specify only certain print areas
D	(4) all of above

Question 37

Hyperlinks cannot be

A	(1) Special shapes like stars and banners
B	(2) Drawing objects like rectangles ovals
C	(3) Pictures
D	(4) All can be hyperlinks

Question 38

You can use the horizontal and vertical scroll bars to

A	(1) Split a worksheet into two panes
B	(2) View different rows and columns
C	(3) Edit the contents of a cell
D	(4) View different worksheets

Question 39

What do we call a computer pro gram that orga-nizes data in rows and columns of cells? You might use this type of rogram to keep a record of the money you earned moving lawns over the summer.