MS Excel mcq Questions and Answer | Microsoft Excel-4

1 min read

MS Excel mcq Questions and Answer | Microsoft Excel-4

ms excell - 4

Question 1
Data can be arranged in a worksheet in a easy to understand manner using
A
(1) auto formatting
B
(2) applying styles
C
(3) changing fonts
D
(4) all of above
Question 2
You can use drag-and-drop to embed excel worksheet data in a word document
A
(1) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
B
(1) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
C
(3) By dragging a range of excel data to the word button on the taskbar while pressing Alt key
D
(4) None of above
Question 3
Excel uniquely identifies cells within a worksheet with a cell name
A
(1) Cell names
B
(2) Column numbers and row letters
C
(3) Column letters and row numbers
D
(4) Cell locator coordinates
Question 4
To view a cell comment
A
(1) click the edit comment command on the insert menu
B
(2) click the display comment command on the window menu
C
(3) position the mouse pointer over the cell
D
4) click the comment command on the view menu
Question 5
When you want to insert a blank imbedded excel object n a word document you can
A
(1) Click the object command on the insert menu
B
(2) Click the office links button on the standard toolbar
C
(3) Click the create worksheet button on the formatting toolbar
D
(4) Click the import excel command on the file menu
Question 6
To save a workbook, you:
A
(1) Click the save button on the standard toolbar from the menu
B
(2) Press Ctrl+F5
C
(3) Click Save on the Windows Start button
D
(4) Select Edit>Save
Question 7
You can edit a cell by
A
(t) Clicking the formula button
B
(2) Double clicking the cell to edit it in-place
C
(3) Selecting Edit > Edit Cell from the menu
D
(4) None of above
Question 8
You can select a single range of cells by
A
(1) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
B
(2) Pressing the Ctrl key while dragging over the desired cells
C
(3) Pressing the Shift key and an arrow key
D
(4) Dragging over the desired cells Correct
Question 9
Which elements of worksheet can be protected from accidental modification
A
(1) Contents
B
(2) Objects
C
(3) Scenarios
D
(4) All of above
Question 10
You can use the drag and drop method to
A
(1) Copy cell contents
B
(2) Move cell contents
C
(3) Add cell contents
D
(4) a and b
Question 11
. lt is acceptable of let long text flow into adjacent cells on a worksheet when
A
1) Data will be entered in the adjacent cells
B
(2) No data will be entered in the adjacent cells
C
(3) There is not suitable abbreviation of the text
D
(4) There is not time to format the next
Question 12
How can you delete a record?
A
(1) Delete the column from the worksheet
B
(2) Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
C
(3) Select Data > Delete Record from the menu
D
(4) Click the Delete button on the Standard toolbar
Question 13
Right clicking something in Excel:
A
(1) Deletes the object
B
(2) Nothing the right mouse button is there for left handed people
C
(3) Opens a shortcut menu listing everything you can do to the object
D
(4) Selects object
Question 14
. Documentation should include
A
(1) Destination and users of the output data
B
(2) Source of input data
C
(3) Information on the purpose of the workbook
D
(4) All the above
Question 15
Files created with Lotus 1-2-3 have an extension
A
(1) DOC
B
(2) XLS
C
(3) 123
D
(4) WK1
Question 16
To delete an embedded objects, first
A
(1) Double click the object
B
(2) Select the object by clicking it
C
3) Press the Shift + Delete ' keys
D
(4) Select it and then press the delete key
Question 17
. Comments can be added to cells using
A
(1) Edit > Comments
B
(2) Insert > Comments
C
(3) File > Comments
D
(4) View > Comments
Question 18
Which of the following is not a worksheet design criterion?
A
(1) Efficiency
B
(2) Aditibility
C
(3) Description
D
(4) Clarity
Question 19
To copy cell contents using drag and drop press the
A
(1) End key
B
(2) Shift key
C
(3) Ctrl key
D
(4) Esc key
Question 20
. Which of the following is the latest version of Excel
A
(1) Excel 2000
B
(2) Excel 2002
C
(3) Excel ME
D
(4) Excel XP
Question 21
. When you copy a formula
A
(1) Excel erases the original copy of the formula
B
2) Excel edits cell references in the newly copied formula
C
(3) Excel adjusts absolute cell references
D
(4) Excel doesn't adjust relative cell references
Question 22
. The autofill feature
A
(1) extends a sequential series of data
B
(2) automatically adds range of cell values
C
(3) applies a boarder around the selected cells
D
(4) none of the above j
Question 23
Which menu option can be used to split windows into two
A
(1) View > window > split
B
(2) Format > window
C
(3) Window > split
D
(4) View > split
Question 24
You can use the formula palette to
A
(1) Format cells containing numbers
B
(2) Create and edit formulas containing functions
C
(3) Enter assumptions data
D
(4) Copy a range of cells
Question 25
You can convert existing excel worksheet data an charts to an HTML document by using
A
(1) Internet assistant wizard
B
(2) FTP wizard
C
(3) Intranet wizard
D
(4) Import wizard
Question 26
A circular reference is
A
(1) Geometric modeling tool
B
(2) A cell that points to a drawing object
C
(3) A formula that either directly or indirectly depends on itself
D
(4) Always erroneous
Question 27
.Which of following is Not one of Excel's what-if function?
A
(1) Goal seek
B
(2) Solver
C
(3) Scenario manager
D
(4) Auto Outline
Question 28
When you insert an excel file into a word document. The data are
A
(1) Hyperlinked placed in a word table
B
2) Linked
C
(3) Embedded
D
(4) Use the word menu bar and toolbars
Question 29
. Which of the following is not information you can specify using the solver?
A
(1) Input cells
B
(2) Constraints
C
(3) Target cell
D
(4) Changing cells
Question 30
Each excel file is called a workbook because
A
(1) It can contain text and data
B
(2) It can be modified
C
(3) It can contain many sheets including worksheets and chart sheets
D
(4) You have to work hard to create it
Question 31
Excel probably considers the cell entry January 1, 2000 to be a
A
(1) Label
B
(2) Value
C
(3) Formula
D
(4) Text string
Question 32
You can enter which types of data into worksheet cells?
A
(1) Labels, values, and formulas
B
(2) Labe31s and values but not formulas
C
(3) Values and formulas but not labels
D
(4) Formulas only
Question 33
All worksheet formula
A
(1) Manipulate values
B
(2) Manipulate labels
C
(3) Return a formula result
D
(4) Use the addition operator
Question 34
Which of the following is a correct order of precedence in formula palcuiation?
A
(1) Multiplication and division exponentiation positive and negative values
B
(2) Multiplication and division, positive and negative values, addition and subtraction
C
(3) Addition and subtraction, positive and negative values, exponentiation
D
(4) All of above
Question 35
. The Paste Special command lets you copy and paste:
A
(1) Multiply the selection by a copied value
B
(2) Cell comments
C
(3) Formatting options
D
(4) The resulting values of a formula instead of the actual formula
Question 36
The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?
A
(1) Click the Currency Style button on the formatting toolbar
B
(2) You have to retype everything and manually add the dollar signs, commas, and decimals.
C
(3) Select Format > Money from the menu
D
4) All the above
Question 37
. Which of the following is not a valid data type in excel
A
(1) Number
B
(2) Character
C
(3) Label
D
(4) Date/time
Question 38
. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
A
(1) Option buttons
B
(2) List boxes
C
(3) Text boxes
D
(4) Combo boxes
Question 39
Which of the following options is not located in the Page Setup dialog box?
A
(1) Page Break Preview.
B
(2) Page Orientation
C
(3) Margins
D
(4) Headers and Footers
Question 40
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
A
(1) Pie chart
B
(2) Row chart
C
(3) Line chart
D
(4) Column chart
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-3

Next Story

MS Excel mcq Questions and Answer | Microsoft Excel-5

Latest from Blog

error: Content is protected !!