Tuesday, 25 February 2014

Microsoft Excel 4

31. Documentation should include
a. Destination and users of the output data
b. Source of input data
c. Information on the purpose of the workbook
d. All of the above

32. Files created with Lotus 1-2-3 have an extension
a. DOC                                                                      b. XLS
c. 123                                                                       d. WK1

33. To delete an embedded objects, first
a. Double click the object
b. Select the object by clicking it
c. Press the Shift + Delete keys
d. Select it and then press the delete key

34. Comments can be added to cells using
a. Edit>Comments                                              b. Insert>Comments
c. File>Comments                                               d. View>Comments

35. Which of the following is not a worksheet design criterion?
a. Efficiency                                           b. Aditibility
c. Description                                      d. Clarity

36. To copy cell contents using drag and drop press the
a. End key                                                              b. Shift key
c. Ctrl key                                                               d. Esc key

37. Which of the following is the latest version of Excel
a. Excel 2000                                        b. Excel 2002
c. Excel ME                                                             d. Excel XP

38. When you copy a formula
a. Excel erases the original copy of the formula
b. Excel edits cell references in the newly copied formula
c. Excel adjusts absolute cell references
d. Excel doesn’t adjust relative cell references

39. The autofill feature
a. extends a sequential series of data
b. automatically adds range of cell values
c. applies a boarder around the selected cells
d. none of the above

40. Which menu option can be sued to split windows into two
a. Format>window                                            b. View>window>split

c. Window>split                                  d. View>split

No comments:

Post a Comment