Which among the following is used to fill the cells with predefined series of numbers or text?
Autofill
Shift cells up
Shift cells down
None of these
How many ways are there for moving cell contents?
Three
Two
Four
Six
Which of the following is not the correct method of editing the cell content?
Pressing the Alt key
Pressing the Enter key
Clicking the formula bar
Pressing the F2 key
How do you insert a row?
Right-click the rows where you want to insert the new row and select Rows from the Insert menu
Select the row heading where you want to insert the new row and select Edit → Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above.
Which menu has number of commands that can be used to make changes in cell contents?
Insert
Edit
View
Format
What is the default row height of MS Excel worksheet?
12.75
12.30
8.43
8.45
How do you delete a column?
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert → Delete from the menu
Select the row heading you want to delete and select Edit → Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu or Edit menu
When a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
What is fill handle?
Grey boxes along left side of the worksheet numbered sequentially.
Grey boxes on the top of the worksheet labeled by a number.
Black square which appears at the bottom right corner of selected range.
