You Scored:
Ranking:
Past Papers MS Word Questions Answers
1. In Excel which of the following is not a worksheet design criterion
Clarity
Description (Answer)
Efficiency
Auditability
2. In Excel you can use the drag and drop method to
Add cell contents
Move cell contents
Copy cell contents
(A) and (B) (Answer)
3. In Excel how can you delete a record?
Delete the column from the worksheet
Select Data > Delete Record from the menu
Click the Delete button on the Standard toolbar
Select Data > Form from the menu to open the Data dialog box, find record and Click the Delete button (Answer)
4. In Excel the auto calculate feature
None of the above
Provides a quick way to view the results of an arithmetic operation on a range of cells (Answer)
Can only add values in a range of cells
Automatically creates formulas and adds them to a worksheet
5. Right clicking something in Excel
Selects the object
Deletes the object
Opens a shortcut menu listing everything you can do to the object (Answer)
Nothing the right mouse button is there for left handed people
6. In Excel to copy cell contents using drag and drop, press the
Esc key
None of above (Answer)
Shift key
End key
7. Files created with Lotus 1-2-3 have an extension
XLS
WK1
123 (Answer)
DOC
8. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
Format
Tools (Answer)
Edit
Insert
9. In Excel Documentation should include
Source of input data
Destination and users of the output data
Information on the purpose of the workbook
All of the above (Answer)
10. In Excel you can use the formula palette to
Create and edit formulas containing functions (Answer)
Copy a range of cells
Format cells containing numbers
Entered assumptions data
11. In Excel the auto fill feature
Extends a sequential series of data
None of above (Answer)
Automatically adds a range of cell values
Applies a boarder around selected cells
12. In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when
Data will be entered in the adjacent cells
No data will be entered in the adjacent cells (Answer)
There is not time to format the next
There is nt suitable abbreviation of the text
13. In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu
Edit
Tools (Answer)
Format
Data
14. In Excel 3-D reference in a formula
Limits the formatting options
Cannot be modified
Spans worksheets (Answer)
Only appears on summary worksheets
15. In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells
F11 (Answer)
F7
F5
F3
16. In Excel if you press …….., the cell accepts your typing as its contents.
Enter (Answer)
Insert
Ctrl + Enter
TAB
17. What excel feature can you use if you want to work with one record at a time?
Sub Totals
Auto Filter
Data Form (Answer)
Auto Complete
18. In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?
Category axis
Data point
Gridline (Answer)
Data marker
19. In Excel value used in a formula that does not change is called a
Function (Answer)
Range
Cell address
Constant
20. In Excel which elements of worksheet can be protected from accidental modification ?
Contents
Scenarios
All of above (Answer)
Objects