MS Excel mcq Questions and Answer | Microsoft Excel-2
Microsoft Excel SET-2
MS Excel mcq Questions and Answer | Microsoft Excel-2
Question 1
What function Displays row data in a column or column data in a row?
Hyperlink
Index
Transpose
Rows
Question 2
When you insert an Excel file into a Word document, the data are
Hyperlinked Placed in a word table
Linked
Embedded
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
IF
AND
OR
NOT
Question 4
Macros are "run" or executed from the..... menu.
Insert
Format
Tools
Data
Question 5
You can open the consolidate dialog box byt choosing Consolidate from the..... menu.
Insert
Format
Tools
Data
Question 6
Each excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and
chart sheets
You have to work hard to create it
Question 7
Which types of charts can excel produce?
Line graphs and pie charts only
Only line graphs
Bar charts, line graphs and pie charts
Bar charts and line graphs only
Question 8
How are data organized in a spreadsheet?
Lines and spaces
Layers and planes
Rows and columns
Height and width
Question 9
What does the VLOOKUP function do?
Looks up text that contain V
Checks whether text is the same in one cell as in the
next
Finds related records
All of above
Question 10
Gridlines
May be turned off for display but turned on for printing
May be turned on or off for printing
The be turned off for display and printing
a, b and c
Question 11
You can print only an embedded chart by
Moving the chart to a chart sheet before you print.
Formatting the chart before you print
Selecting the chart before you print
a and c
Question 12
Which of the following is a correct order of precedence in a formula calculation?
Multiplication and division, exponential positive and
negative value
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values,
exponentiation
All of above
None of these
Question 13
A function inside another function is called a.....function.
Nested
Round
Sum
Text
Question 14
How should you print a selected area of a worksheet, if you'll want to print a different area next time?
On the file menu, point to print area, and then click set
print area.
On the file menu, click print, and then click selection
under print what
On the view menu, click custom views, then click add
All of above
Question 15
Youar German supplier still invoices for parts in deutsche marks. How does Excel convert those sums to Euros?
On the Insert menu, click Symbol and from the currency
symbols subset, select the Euro sign,
On the tools menu, click Add-lns, and select the Euro
Currency Tools check box
Apply a selected background color
All of above
Question 16
Which function calculates your monthly mortage payment?
PMT (payments)
NPER (number of periods)
PV (present value)
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?
Point to speech on the tools menu, and then click show
text to speech toolbar.
Click validation on the data menu
Point to speech on the tools menu, and then click
speech recognition
All of above
Question 18
Which of the following methods can not be used to enter data in a cell?
Pressing an arrow key
Pressing the tab key
Pressing the Esc key
Clicking the enter button to the formula bar
Question 19
Which of the following will not set text in selected cells to italics?
Pressing Ctrl + I on the keyboard
Using the Tools - Wizard -Web Form menu item
Using the Format - Cells -Font menu item
All of the above
Question 20
Which of the following methods cannot be used to edit the content of cell?
Pressing the Alt key
Clicking the formula bar
Pressing F2
Double clicking the cell
Question 21
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of above
Question 22
Which of the following setup options can not be set in the page setup dialog box?
Printer selection
Vertical or horizontal placement
Orientation
Row and column titles
Question 23
What term refers to a specific set of values saved with the workbook?
Range
Scenario
Trend line
What-if analysis
Question 24
Got functions? No? You need the insert function dialog box. How do you get it?
Right click a cell and then click insert
Click the insert menu and then click function
Type - in a cell
All of the above
Question 25
Which of the following describes how to select all the cells in a single column?
Right click on column and select Pick from list
Use data - text to columns menu item
Left click on the gray column title button
Pressing Ctrl + A on the keyboard
Question 26
When you use the fill effects in the format data series dialog box, you can not
rotate text on the chart
select a fore ground color
select a pattern
select a background color
Question 27
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Rows and columns
Headings
Speed
All of above
Question 28
Which of the following is not a basic step in creating a worksheet?
(1) Save the workbook
(2) Modify the worksheet
(3) Enter text and data
(4) Copy the worksheet
Question 29
. What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
(1) Select both cells, and then drag the fill handle over the
(2) Select the range you want, include both cells, point tofill on the Edit menu, and then click down.
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
(4) All of above
Question 30
To insert three columns between columns D and E you would
(1) Select column D
2) Select column E
3) Select columns E, F and G
(4) Select columns D, E, and F
Question 31
To center worksheet titles across a range of cell, you must
1) Select the cells containing the title text and use the fill
handle to center the text across a range of cells
(2) Widen the columns
(3) Select the cells containing the title text and use the fill
handle to center the text across a range of cells
(4) Widen the column
Question 32
.When integrating Ms-Word and Excel, Word is usually the
1) Server
(2) Source
(3) Client
4) None
Question 33
Charts tips can
(1) Show the formatting of a data label
(1) Show the formatting of a data label
(3) Show the value of data point
(4) b and c
Question 34
The Name box
(1) Shows the location of the previously active cell
(2) Appears t the left of the formula bar
(3) Appears below the status bar
(4) Appears below the menu bar
Question 35
How do you change column width to fit the contents?
(1) Single-click the boundary to the left to the column
heading
(2) Double click the boundary to the right of the column
heading
(3) Press Alt and single click anywhere in the column
(4) All of above
Question 36
When you work with large worksheets, you may need to
(1) size the worksheet to fit on the specific number of pages
(2) add and remove page breaks
(3) specify only certain print areas
(4) all of above
Question 37
Hyperlinks cannot be
(1) Special shapes like stars and banners
(2) Drawing objects like rectangles ovals
(3) Pictures
(4) All can be hyperlinks
Question 38
You can use the horizontal and vertical scroll bars to
(1) Split a worksheet into two panes
(2) View different rows and columns
(3) Edit the contents of a cell
(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.
(1) Spreadsheet program
(2) Database program
(3) Word processor program
4) Desktop publisher program
Question 40
. You can add an image to a template by clicking the Insert Picture From File button on the .... Toolbar.
(1) Standard
(2) Formatting
(3) Drawing
(4) Picture
There are 40 questions to complete.
