ExamVeda
Login
Home
61
To save a workbook, you:
Discuss
Answer & Solution
Answer: Option A
Solution:
Click the save button on the standard toolbar from the menu
62
You can edit a cell by
Discuss
Answer & Solution
Answer: Option B
Solution:
Double clicking the cell to edit it in-place
63
You can select a single range of cells by
Discuss
Answer & Solution
Answer: Option D
Solution:
We can select a single range of cells by dragging cursor over the desired cells.
64
Which elements of worksheet can be protected from accidental modification
Discuss
Answer & Solution
Answer: Option D
Solution:
All elements of a worksheet can be protected from accidental modification.
To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.
Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK.
65
You can use the drag and drop method to
Discuss
Answer & Solution
Answer: Option D
Solution:
Drag-and-drop is a mouse technique that we can use in Excel to pick up a cell selection and drop it into a new place on the worksheet. Although drag and drop is primarily a technique for moving cell entries around a worksheet, we can also adapt it to copy a cell selection.
66
It is acceptable to let long text flow into adjacent cells on a worksheet when
Discuss
Answer & Solution
Answer: Option B
Solution:
When there is no data in in the adjacent cells, long text flows into adjacent cells on a worksheet. As soon as data is entered into in the adjacent cells, text will be visible upto cell length in which data is entered, For full visibility of data either we need to increase the length of cell or wrap text in particular cell.
67
How can you delete a record?
Discuss
Answer & Solution
Answer: Option B
Solution:
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button in Excel 2003 and earlier version.
68
Right clicking something in Excel:
Discuss
Answer & Solution
Answer: Option C
Solution:
Right clicking something in Excel opens a shortcut menu listing everything you can do to the object.
69
Documentation should include
Discuss
Answer & Solution
Answer: Option D
Solution:
Documentation should include
Source of input data
Destination and users of the output data
Information on the purpose of the workbook.
70
Files created with Lotus 1-2-3 have an extension
Discuss
Answer & Solution
Answer: Option C
Solution:
Lotus 1-2-3 have an extension .123