MS Excel mcq Questions and Answer | Microsoft Excel-4

ms excell - 4

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

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