Computer Science
Class-VI
Chapter-5 Editing Cell Contents in MS-Excel
A. Fill in the blanks:
1. You can select the cell by clicking over it or using the ____ keys.
Answer: Arrows
2. Commands in the _____ drop-down menu can be used to make changes in cell contents.
Answer: Edit
3. The _______ command is activated only after you have undoe a data entry.
Answer: Redo
4. One can select the entire row by clicking on its________.
Answer: Number Header
5. You can select the entire column by clicking on its_________.
Answer: Letter Heading
B. Write whether true or false:
1. In MS- Excel, you can copy data by drag and drop.
Answer: T
2. It is not necessary to select the cell to do editing.
Answer: F
3. The Redo command in the Edit menu allows you to redo an action.
Answer: T
4. You can use the Cut and Paste method to move data.
Answer: T
5. MS-Excel does not adjust row height if you enter taller characters.
Answer: F
C. Tick the correct option:
1. This command is used to reverse the last action.
a. Redo command b. Undo command
Answer: Undo command
2. You can delete a block of cells, by choosing the
a. Delete option from Edit menu
b. Undo option
Answer: Delete option from edit menu
D. Answer the following questions:
1. What do you mean by overwriting and Partial Modification? Explain using examples.
Answer: Overwriting and Partial Modification are used to change the cell's contents. For overwriting and Partial Modification select the cell and type new entry.
2. What are the two ways of copying data?
Answer: There are two ways of copyig data.
1. Drag and drop method: Select the data, hold down the left mouse button and drag the mouse where you want to drop. Release the left mouse button.
2. Copy and paste method: Copy the data and paste where you want.
3. What are the two ways of moving data?
Answer: There are two ways of moving data:
1. Drag and drop method: Select the data, hold down the left mouse button and drag the mouse where you want to drop. Release the left mouse button.
2. Cut and paste method: Cut the data using shortcut key Ctrl+X, paste where you want using shortcut key Ctrl+V.
4. How do you select an entire row or column?
Answer: You can select the entire row by clicking on its number header.
You can select the entire column by clicking on its letter heading.
5. Can you differentiate between copying and moving a cell range?
Answer: Copy means make a duplicate copy of the data and moving means shift the data from one place to another place.
6. Can you change the column width in Excel? Explain.
Answer: For changing the column width of a single column, click on the right hand border of a column heading and drag it to the left or the right until the column is as wide as you need.
7. How will you change the row height?
Answer: For change the row height of a single row, click on the bottom border of the row heading, and drag it up or down.
No comments:
Post a Comment