9th Class Computers Science Microsoft Excel Inserting, Deleting and Renaming Sheets

     Inserting, Deleting and Renaming Sheets

By default Excel enables only three sheets. You can insert, add and delete sheet in existing worksheet according to your requirements.  

 To add a new sheet: 

Click Insert -> Worksheet menu.  

 To delete a sheet: 

• Click Edit Delete sheet -> menu option to display message box.
• Click Delete to delete the sheet permanently.  

  To rename a sheet: 

• Click Format Sheet -> Rename menu.
• Specify a name such as my sheet at the base of the sheet.
• Click OK to accept the changed name.  

 Joseph is working on Excel sheet. He wants to open Conditional Formatting dialog box. Which one of the following steps he should perform?

(A) Format -> Conditional Formatting

(B) Format -> Style -> Conditional Formatting

(C) Format -> Cells -> Conditional Formatting

(D) Format -> Sheet -> Conditional Formatting

(E) None of these  

Answer: (A)

Explanation

Correct Option:

(A) Select FormatConditional Formatting to display the Conditioning Formatting dialog box.

Incorrect Options:

Rest of the options is incorrect.  

  Editing the style of text, numbers and the pages based on conditions are performed under ................option.

(A) Formatting                                                 

(B) Alignment

(C) Customize                                                   

(D) All of these

(E) None of these

Answer: (A)

Explanation

Correct Option:

(A) Formatting option allows you to edit style of text and numbers.

Incorrect Options:

(B) Alignment option allows you to align whole worksheet.

(C) Customization option allows you to customize excel interface.    

 Which one of the following statements is true?

Statement A: In 1984, Excel was invented for Apple Macintosh computer.

Statement B: By default Excel enables only two sheets

(A) Statement A is correct (B) Statement B is correct

(C) Both statement A and B are correct

(D) Neither statement A nor statement B is correct

(E) None of these  

Answer: (A)

Explanation

Correct Option:

(A) Only statement A is true.

Incorrect Options:

Rest of the options is incorrect.