Page 257 - Trackpad 402_Class-X_Final
P. 257
b. The steps to make the spreadsheet shareable with the other users are:
Step 1: Open the spreadsheet.
Step 2: Select the Tools → Share Document from the menu bar.
c. Open the original worksheet. Follow the steps:
Step 1: Click on the Edit menu from the Menu bar.
Step 2: Select the Changes → Merge Document option.
d. Open both the original worksheet and the edited worksheet. Follow the steps:
Step 1: Click on the Edit menu from the Menu bar.
Step 2: Select the Edit → Compare Document option.
Unsolved
SECTION A (Objective Type Questions)
A. Choose the correct option.
1. To the comment, hover the mouse pointer over the cell that has the comment.
a. Edit b. View
c. Hide d. None
2. You can save time by saving the repeated commands as .
a. Scenario b. Goal Seek
c. Macros d. Subtotal
3. tab in the Accept or Reject changes dialog box is used to specify the filter criteria.
a. Tools b. Data
c. Filter d. Criteria
4. In spreadsheet, to apply Goal Seek your cell pointer must be in .
a. The Changing cell whose value you need to find b. The Result Cell where formula is entered
c. The cell where your targeted value is entered d. The active cell with no value
5. Which of the following tools deals with multiple unknown values?
a. Goal Seek b. Scenario
c. Solver d. Subtotal
6. Which of the following options is not present in the Hyperlink dialog box?
a. Internet b. Mail & News
c. Document d. Video
7. Which of the following menu contains the Consolidate option?
a. View b. Tools
c. Data d. Insert
8. Data can be consolidated from two sheets only.
a. True b. False
c. Not Sure d. None of these
9. Which of the following is the correct method to make a cell reference using another workbook?
a. =’file.ods’ #sheet1.A3 b. =’file.ods’ @sheet1.A3
c. =’file.ods’ &sheet1.A3 d. =’file.ods’ +sheet1.A3
10. Which of the following options is used to delete a worksheet?
a. Delete Sheet b. Remove Sheet
c. Exit Sheet d. Rename Sheet
Electronic Spreadsheet (Advanced) 257

