Inserting, Deleting and Renaming Sheets

Category : 9th Class

*     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.  

 

 

Question.jpg    

 

 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.



LIMITED OFFER HURRY UP! OFFER AVAILABLE ON ALL MATERIAL TILL TODAY ONLY!

You need to login to perform this action.
You will be redirected in 3 sec spinner

Free
Videos