MCQ’s About MS Excel 01

Posted by

The "Answers" given with the Question is "not verified". To view Verified answers click on the button below.

MCQ’s About MS Excel (Part-01)

1. In Excel default header for a worksheet is
(A) Your name
(B) The date and time
(C) None
(D) The sheet tab name

2. In Excel which of the following is not an option in the spelling dialog box
(A) Edit
(B) Ignore
(C) Ignore all
(D) Change

3. Excel uses the …. Function when creating a data table
(A) Average
(B) Count
(C) Sum
(D) Table

4. In Excel you can copy cell formats from one cell to another by using the
(A) Backspace key
(B) Default font
(C) Format painter
(D) Formatting toolbar

5. In Excel accounting style shows negative numbers in
(A) Bold
(B) Brackets
(C) Parentheses
(D) Quotes

6. In Excel you can use drag and drop to embed excel worksheet data in a word document
(A) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
(B) By dragging a range of excel data to the Word button on the taskbar while pressing Shift key
(C) By displaying both applications side-byside and dragging a selected range of Excel data into the word application window while pressing the Ctrl key
(D) (A) and (C)

7. In Excel the chart wizard
(A) Can place a chart on a new chart sheet or on any sheet in the workbook
(B) Can only place a chart on new chart sheet
(C) Can only place a chart on a new blank worksheet
(D) Can only be used to create embedded charts

8. In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004
(A) Workday
(B) Date
(C) Networkdays
(D) All of the above

9. In Excel data marker on a chart are linked to data points in a worksheet, therefore,
(A) You can automatically apply formatting to a data series
(B) You can change the position of a data marker and automatically change the data point value in the worksheet
(C) You can change a data print value and automatically are draw the chart
(D) (A) and (B)

10. In Excel when you group worksheets
(A) You can enter variable data on multiple worksheets at one time
(B) You can print more than one worksheet at a time
(C) You can enter common data, formats, and formulas on multiple worksheets at one time
(D) (B) and (C)

11. In Excel you can zoom a worksheet
(A) With the mouse pointer in Print Preview
(B) With the zoom button on the Print Preview toolbar
(C) With the Zoom command on the view menu
(D) All of the above

12. You cannot link Excel worksheet data to a Word document
(A) With the right drag method
(B) With a hyperlink
(C) With the copy and paste special commands
(D) With the copy and paste buttons on the standard toolbar

13. In Excel this type of software is similar to an accountant’s worksheet
(A) Word processing
(B) Database
(C) Spreadsheets
(D) Graphics

14. In Excel you can use the format painter multiple times before you turn it off by
(A) You can use the format painter button only one time when you click it
(B) Double clicking the format painter button
(C) Pressing the Ctrl key and clicking the format painter button
(D) Pressing Alt key and clicking the format painter button

15. In Excel default header for a worksheet is
(A) Your name
(B) The date and time
(C) None
(D) The sheet tab name

16. In Excel which of the following is not an option in the spelling dialog box
(A) Edit
(B) Ignore
(C) Ignore all
(D) Change

17. In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu
(A) Edit
(B) View
(C) Format
(D) Tools

18. In Excel….. is a group of cells that form a rectangle on the screen.
(A) Calculation
(B) Formula
(C) Range
(D) Range address

19. In Excel following term describes explanatory text attached to a cell
(A) Callout
(B) Comment
(C) Dialog
(D) Extension

20. In Excel the drag and drop method of copying or moving
(A) Can be used between worksheets but not workbooks
(B) Can be used between workbooks but not worksheets
(C) Can be used between workbooks but not worksheets
(D) None

21. In Excel 3-D reference in a formula
(A) Cannot be modified
(B) Only appears on summary worksheets
(C) Limits the formatting options
(D) Spans worksheets

22. In Excel the auto calculate feature
(A) Can only add values in a range of cells
(B) Provides a quick way to view the results of an arithmetic operation on a range of cells
(C) Automatically creates formulas and adds them to a worksheet
(D) None of the above

23. In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu
(A) Edit
(B) Format
(C) Tools
(D) Data

24. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
(A) Edit
(B) Insert
(C) Format
(D) Tools

25. In Excel which of the following is not a worksheet design criterion
(A) Efficiency
(B) Auditability
(C) Description
(D) Clarity Correct Answer:

26. In Excel to copy cell contents using drag and drop, press the
(A) End key
(B) Shift key
(C) Esc key
(D) None of above

27. In Excel if you press …….., the cell accepts your typing as its contents.
(A) Enter
(B) Ctrl + Enter
(C) TAB
(D) Insert

28. In Excel the auto fill feature
(A) Extends a sequential series of data
(B) Automatically adds a range of cell values
(C) Applies a boarder around selected cells
(D) None of above

29. In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells
(A) F3
(B) F5
(C) F7
(D) F11

30. In Excel you can use the formula palette to
(A) Format cells containing numbers
(B) Create and edit formulas containing functions
(C) Entered assumptions data
(D) Copy a range of cells