Question : What is the correct sequence for creating range names?
Option 1: Select the cell -> Choose the name option -> Choose the define option -> Type in the name -> Click on the Add button -> Click on OK
Option 2: Select the cell -> Choose the define option -> Choose the name option -> Type in the name -> Click on the Add button -> Click on OK
Option 3: Select the cell -> Choose the name option -> Choose the define option -> Click on the Add button -> Type in the name -> Click on OK
Option 4: Select the cell -> Choose the name option -> Choose the define option -> Type in the name -> Click on OK -> Click on the Add button
Correct Answer: Select the cell -> Choose the name option -> Choose the define option -> Type in the name -> Click on the Add button -> Click on OK
Solution : Following is the correct sequence: Select the cell -> Choose the name option -> Choose the define option -> Type in the name -> Click on the Add button -> Click on OK. Hence, the correct option is 1.
Question : What is the procedure for deleting a cell in a spreadsheet?
Option 1: Click on the cell which is to be deleted -> Choose the delete option from the edit menu -> Choose the appropriate option -> Click on OK button
Option 2: Choose the appropriate option -> Click on the cell which is to be deleted -> Choose the delete option from the edit menu -> Click on OK button
Option 3: Click on the cell which is to be deleted -> Choose the appropriate option -> Choose the delete option from the edit menu -> Click on OK button
Option 4: None of these
Question : What is the procedure for inserting a cell?
Option 1: Click on the cell where new cells are to be inserted -> Choose the cells option from the insert menu -> Choose the appropriate option -> Click on OK button
Option 2: Choose the appropriate option -> Click on the cell where new cells are to be inserted -> Choose the cells option from the insert menu -> Click on OK button
Option 3: Click on the cell where new cells are to be inserted -> Choose the appropriate option -> Choose the cells option from the insert menu -> Click on OK button
Question : To select adjacent cells, which of the following methods are used?
Option 1: Click on the name box -> Type the cell reference of the starting cell -> Press enter to select the cells
Option 2: Press enter to select the cells -> Click on the name box -> Type the cell reference of the starting cell
Option 3: Type the cell reference of the starting cell -> Press enter to select the cells -> Click on the name box
Option 4: Type the cell reference of the starting cell -> Click on the name box -> Press enter to select the cells
Question : What is the procedure for aligning cell content using the menu?
Option 1: Click on the cell to be aligned -> Choose the Cell option from the Format menu. The Format cells dialog box appears -> Choose the alignment tab -> Click to open the drop-down box associated with the horizontal field. After the drop-down box is opened, select the desired alignment as Right, Left or Center -> Click OK to close the dialog box
Option 2: Click on the cell to be aligned -> Click OK to close the dialog box -> Choose the Cell option from the Format menu. The Format cells dialog box appears -> Choose the alignment tab -> Click to open the drop-down box associated with the horizontal field. After the drop-down box is opened, select the desired alignment as Right, Left or Center
Option 3: Click to open the drop-down box associated with the horizontal field. After the drop-down box is opened, select the desired alignment as Right, Left or Center -> Click on the cell to be aligned -> Choose the Cell option from the Format menu. The Format cells dialog box appears -> Choose the alignment tab -> Click OK to close the dialog box
Option 4: Choose the Cell option from the Format menu. The Format cells dialog box appears -> Choose the alignment tab -> Click to open the drop-down box associated with the horizontal field. After the drop-down box is opened, select the desired alignment as Right, Left or Center -> Click OK to close the dialog box -> Click on the cell to be aligned
Question : What is the procedure for clearing data?
Option 1: Click on the cell -> Choose the clear option from the Edit menu -> Choose the relevant option from the clear sub-menu
Option 2: Choose the relevant option from the clear sub-menu -> Click on the cell -> Choose the clear option from the Edit menu
Option 3: Choose the clear option from the Edit menu -> Click on the cell -> Choose the relevant option from the clear sub-menu
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile