CLASS 6 - CH 4 FORMATTING IN EXCEL

Identify the vertical and horizontal alignment of number 5 in the cell.

• vertical - center

  horizontal - top

• vertical - top

  horizontal - center

• vertical - top

  horizontal - middle

• vertical - middle

  horizontal - top

To give the cells a background colour which of the following buttons will you click on?

• 
• 
• 
• 

To bring the heading 'YEAR' in the center of two cells (as shown in the image) you will select the cells and click on ________________ .

• Center alignment button

• Middle alignment button

• Join and center button

• Merge and center button

#### sign appears in a cell when ______________

• text entered in a cell does not fit in it

• wrong data is entered in a cell

• column width to display date and number is less

• row height to display date and number is less

To make the #### sign disappear from a cell you have to ___________

• Increase the row height of the cell

• Increase column width of the cell

• Delete and retype the data in the cell

• Increase size of the data

On inserting row in a worksheet which of the following happens?

• The total number of rows increases

• Total number of rows remain the same. Data shifts to the row below to make space

• Total number of rows remain the same. Data is deleted to make space

• A new worksheet is inserted

The shortcuts to Copy and Paste content of a cell are

• Ctrl + C and Ctrl +P

• Ctrl +X and Ctrl + P

• Ctrl + C and Ctrl + V

• Ctrl +X and Ctrl + V

which of the following is TRUE related to Autofill option

• Allows filling series of both text and number in worksheet

• Allows filling series of only numbers in worksheet

• Allows filling series of only text in worksheet

• Only fills cells with background colour

Which of the following related to Worksheet tabs can be done in MS Excel?

• You can rename them

• Tabs can be deleted

• You can change the Tab color

• All of the options

The option to remove border from cells is

• Remove Border

• No Border

• Delete Border

• Borderless