NEW
Font size
WorksheetsCLASS 6 - CH 4 FORMATTING IN EXCEL
Total questions: 10
Worksheet time: 5mins
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
