MS Excel mcq Questions and Answer | Microsoft Excel-3

1 min read

MS Excel mcq Questions and Answer | Microsoft Excel-3

ms excell- 3

Question 1
To drag a selected range of data to another worksheet in the same workbook, use the
A
(1) Tab key
B
(2) Alt key
C
(3) Shift key
D
(4) Ctrl key
Question 2
When creating a vertical page break
A
(1) The active cell must be Al
B
(2) The active cell can be anywhere in the worksheet
C
(3) The active cell must be in row 1
D
(4) The active cell must be in column A
Question 3
.To activate the previous cell in a pre-selected range press
A
(1) the Alt key
B
(2) the Tab key
C
(3) the Enter key
D
(4) none of above
Question 4
When the formula bar is activated, you can see
A
(1) The Edit Formula button
B
(2) The Cancel button
C
(3) The Enter button
D
(4) All of above
Question 5
. In a worksheet you can select
A
(1) Entire worksheet
B
(2) Rows
C
3) Columns
D
(4) a, b, and c
Question 6
. When you print preview a worksheet
A
(1) the entire worksheet is displayed
B
(2) the selected range is displayed
C
(3) the active portion of the worksheet is displayed
D
(4) a, b and c
Question 7
. You can group noncontiguous worksheets with
A
(1) The group button on the standard toolbar
B
2) The shift key and the mouse
C
(3) The Ctrl key and mouse
D
(4) The alt+enter key
Question 8
Weight refers to
A
(1) The print density of characters
B
(2) The height of the printed character
C
(3) Upright or Santed shape
D
(4) The sign and appearance f characters
Question 9
. When you link data maintained in Excel workbook to a Word document
A
(1) The Word document cannot be edited
B
(2) The Word document contains a reference to the original source application
C
(3) The word document must contain a hyperlink
D
(4) The word document contains a copy of the actual data
Question 10
When you see a cell with a red triangle in the top right corner, what does this signify?
A
(1) There is an error in the cell .
B
2) There is a comment associated with the cell
C
(3) The font color for text in the cell is red
D
(4) A formula cannot be entered into the cell
Question 11
To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
A
(1) Unfreeze panes command on the window menu
B
(2) Freeze panes command on the window menu
C
(3) Hold titles command on the edit menu
D
4) Split command on the window menu
Question 12
. To edit data in an embedded Excel worksheet object in a Word document
A
(1) Use the Excel menu bar and toolbars insjde the word application
B
(2) Edit the hyperlink
C
(3) Edit the data in a Excel source application
D
(4) Use the Word menu bar and toolbars
Question 13
. Status indicators are located on the
A
(1) Vertical scroll bar
B
(2). Horizontal scroll bar
C
(3) Formula bar
D
(4).Formatting toolbar
Question 14
. You can open the scenario Manager dialog box by choosing scenarios from the ..... menu.
A
(1) View
B
(2) Insert
C
(3) Format
D
(4) Tools
Question 15
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 16
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 17
A data map is helpful
A
(1) When you have too much data to chart
B
(2) To show a geographic distribution of data
C
(3) To compare data points
D
(4) To show changes in data over time
Question 18
Hounding errors can occur
A
(1) When you use multiplication, division or exponentiation in a formula
B
2) When you use addition and subtraction in a formula
C
(3) Because Excel uses hidden decimal places in computation
D
(4) When you show the results of formulas with different decimal places' than the calculated results
Question 19
You can copy data or formulas
A
(1) With the copy, paste and cut commands on the edit menu
B
(2) With commands on a shortcut menu
C
(3) With buttons on the standard toolbar
D
(4) All of the above
Question 20
You can zoom a worksheet
A
(1) With the mouse pointer in Print Preview
B
(2) With the zoom button on the Print Preview toolbar
C
(3) With the Zoom command on the view menu
D
(4) All of the above
Question 21
This type of software is similar to an accountant's worksheet
A
1) Word processing
B
(2) Database
C
(3) Spreadsheets
D
4) Graphics
Question 22
which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
A
(1) Workday
B
(2) Date
C
(3) Networkdays
D
4) All of the above
Question 23
. Data marker on a chart are linked to data points in a . worksheet therefore,
A
(1) You can automatically apply formatting to a data series
B
(2) You can change the position of a data marker andautomatically change the data point value in the worksheet
C
(3) You can change a data print value and automatically are
D
(4) a and b
Question 24
When you group worksheets
A
(1) You can enter variable data on multiple worksheets at one time
B
2) You can print more than*one worksheet at a time
C
(3) You can enter common data, formats, and formulas on multiple worksheets at one time
D
(4) b, and c
Question 25
You can use the format painter , multiple times before you turn it offby
A
(1) You can use the format painter button only one time when you click it
B
(2) Double clicking the format painter button
C
(3) Pressing the Ctrl key and clicking the format painter button
D
(4) Pressing Alt key and clicking the format painter button
Question 26
The default header for a worksheet is
A
(1) Your name
B
(2) The date and time
C
(3) None
D
(4) The sheet tab name
Question 27
. Which of the following is an absolute cell reference?
A
(1) !A!1
B
(2) SA$1
C
(3) #a#l
D
(4) Al
Question 28
What symbol is used before a number to make it a label?
A
(1) "(quote)
B
(2) = (equal)
C
(3) _ (underscore)
D
(4) * (apostrophe)
Question 29
Which symbol must ail formula begin with?
A
(1) =
B
(2) +
C
(3) (
D
(4) e
Question 30
Which of the following formulas is not entered correctly?
A
(1) =10+50
B
(2) =B7*B1
C
(3) =B7+14
D
(4) 10+50
Question 31
Which of the following formulas will Excel Not be able to calculate?
A
(1) =SUM(Sales)-A3
B
(2) =SUM(A1:A5)*.5
C
(3) =SUM(A1:A5)/(10-10)
D
(4) =SUM(A1:A5)-10
Question 32
A typical worksheet has .... Number of columns
A
(1) 128
B
(2) 256
C
(3) 512
D
4) 1024
Question 33
How many characters can be typed in a single cell in Excel?
A
(1) 256
B
(2) 1024
C
(3) 32,000
D
(4) 65,535
Question 34
A worksheet can have a maximum of.... Number ofrows
A
(1) 256
B
(2) 1024
C
(3) 32,000
D
(4) 65,535
Question 35
. Which of the following is not an example of a value?
A
(1) 350
B
(2) May 10,2001
C
(3) 57%
D
(4) Serial Number 50771
Question 36
The chart wizard term data series refers to
A
(1) A chart legend
B
(2) A collection of chart data markers
C
(3) A set of values you plot in a chart
D
(4) A data label
Question 37
The Chart wizard term data categories refers to;
A
(1) A chart plot area
B
(2) A horizontal axis
C
(3) The organization of individual values with a chart's data series
D
(4) The data range that supply chart data
Question 38
A worksheet range is a
A
(1) A command used for data modeling
B
(2) A range of values such as from 23 to 234
C
(3) A group of cells
D
(4) A group of worksheets
Question 39
Getting data from a cell located in a different sheet is called
A
(1) Accessing
B
(2) Referencing
C
(3) Updating
D
4) Functioning
Question 40
. Tab scrolling button
A
(1) Allow you to view a different worksheet
B
(2) Allow you to view additional worksheet rows down
C
(3) Allow you to view additional worksheet columns to the right
D
(4) Allow you to view additional sheets tabs
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-2

Next Story

MS Excel mcq Questions and Answer | Microsoft Excel-4

Latest from Blog

error: Content is protected !!