6th Class Computers Getting Started with Spread Sheet Inserting, Deleting and Renaming Sheets

Inserting, Deleting and Renaming Sheets

Category : 6th 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 adding a new sheet

 

Pattern cell.jpg

 

  • Click Insert  Worksheet menu.  

 

To delete a sheet: 

  • Click Edit  Delete sheet  menu option to display message box.
  • Click the Delete button to show the dialog box.  

 

To rename a sheet: 

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

 

 

Question.jpg    

 

 Jack working on Excel sheet. He wants to open Conditional Formatting dialog box. Which one of the following step Jack need to perform to get same output?

(A) Format Conditional Formatting

(B) Format StyleConditional Formatting

(C) Format  Cells Conditional Formatting

(D) Format Sheet Conditional Formatting

(E) None of these

 

Answer: (a)

Explanation

Correct Option:

(A) Select Format Conditional 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:

Rest of the options is incorrect.    

 

 

 An Excel file which contains several worksheets is referred as a workbook. By default Excel enables only ____ sheets.

(A) Two                                                               

(B) Three

(C) Four                                                               

(D) Five

(E) None of these  

 

Answer: (b)

Explanation

Correct Option:

(A) By default Excel enables only three sheets.

Incorrect Options:

Rest of the options is incorrect.  

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

Free
Videos