You Scored:
Ranking:
Past Papers MS Excel Test Questions Answers
1. In Excel default header for a worksheet is
Your name
The sheet tab name
None (Answer)
The date and time
2. In Excel you can use drag and drop to embed excel worksheet data in a word document
By dragging a range of excel data to the Word button on the taskbar while pressing Shift key
By displaying both applications side-byside and dragging a selected range of Excel data into the word application window while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
(A) and (C) (Answer)
3. In Excel data marker on a chart are linked to data points in a worksheet, therefore,
You can automatically apply formatting to a data series
You can change a data print value and automatically are draw the chart
You can change the position of a data marker and automatically change the data point value in the worksheet (Answer)
(A) and (B)
4. You cannot link Excel worksheet data to a Word document
With the copy and paste buttons on the standard toolbar (Answer)
With the right drag method
With a hyperlink
With the copy and paste special commands
5. In Excel which of the following is not an option in the spelling dialog box
Change
Ignore
Edit (Answer)
Ignore All
6. In Excel which of the following is not an option in the spelling dialog box
Ignore all
Change
Edit (Answer)
Ignore
7. In Excel following term describes explanatory text attached to a cell
Comment (Answer)
Callout
Dialog
Extension
8. In Excel this type of software is similar to an accountant’s worksheet
Spreadsheets (Answer)
Database
Graphics
Word processing
9. In Excel the chart wizard
Can only place a chart on a new blank worksheet
Can place a chart on a new chart sheet or on any sheet in the workbook
Can only place a chart on new chart sheet (Answer)
Can only be used to create embedded charts
10. In Excel ----------- is a group of cells that form a rectangle on the screen.
Formula
Calculation
Range (Answer)
Range address
11. In Excel you can use the format painter multiple times before you turn it off by
Pressing the Ctrl key and clicking the format painter button
You can use the format painter button only one time when you click it
Double clicking the format painter button (Answer)
Pressing Alt key and clicking the format painter button
12. In Excel you can zoom a worksheet
With the zoom button on the Print Preview toolbar
With the Zoom command on the view menu
With the mouse pointer in Print Preview
All of the above (Answer)
13. In Excel the drag and drop method of copying or moving
None
Can be used between workbooks but not worksheets (Answer)
Can be used between worksheets but not workbooks
Can be used between workbooks but not worksheets
14. In Excel accounting style shows negative numbers in
Bold
Brackets
Parentheses (Answer)
Quotes
15. In Excel you can copy cell formats from one cell to another by using the
Default font
Formatting toolbar
Backspace key
Format painter (Answer)
16. In Excel when you group worksheets
You can enter variable data on multiple worksheets at one time
None of these (Answer)
You can print more than one worksheet at a time
You can enter common data, formats, and formulas on multiple worksheets at one time
17. Excel uses the --------- Function when creating a data table
Sum
Table (Answer)
Average
Count
18. In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004
Networkdays
All of the above (Answer)
Date
Workday
19. In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu
View
Tools
Format (Answer)
Edit
20. In Excel default header for a worksheet is
Your name
The date and time
None (Answer)
The sheet tab name