MS Excel mcq Questions and Answer | Microsoft Excel-2

1 min read

MS Excel mcq Questions and Answer | Microsoft Excel-2

Microsoft Excel SET-2

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.
A
(1) Spreadsheet program
B
(2) Database program
C
(3) Word processor program
D
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.
A
(1) Standard
B
(2) Formatting
C
(3) Drawing
D
(4) Picture
There are 40 questions to complete.

 

Leave a Reply

Your email address will not be published.

Previous Story

MS Excel mcq Questions and Answer | Microsoft Excel-1

Next Story

MS Excel mcq Questions and Answer | Microsoft Excel-3

Latest from Blog