Have an account?
Skip to Content
Build your own quiz
Suggestions for you
10 questions
Show Answers
See Preview
- 1. Multiple Choice
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
- 2. Multiple Choice
To give the cells a background colour which of the following buttons will you click on?
- 3. Multiple Choice
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
- 4. Multiple Choice
#### 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
- 5. Multiple Choice
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
- 6. Multiple Choice
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
- 7. Multiple Choice
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
- 8. Multiple Choice
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
- 9. Multiple Choice
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
- 10. Multiple Choice
The option to remove border from cells is
Remove Border
No Border
Delete Border
Borderless
- Answer choicesTagsAnswer choicesTags