Learn with Hafiza Palwasha
OXFORD (Book 5), KEYBOARD
Computer Science With Application Software (Third Edition).
Solution
Chapter No. 8Editing Cell Contents in Excel 2013
NEW WORDS
Students should extract new words by themselves from chapter No. 1 and write them on neat copies as vocabulary words. There is no need to memorize these words but students should be able to read and understand these words as I explained and discussed in class.
NEW TERMS AND ABBREVIATIONS
Students should learn these terms and abbreviation. It will be the part of exam.
1. Row Headings:
It's the light blue boxes appears along the left side of the worksheet. These worksheets are sequentially numbered.
2. Column Headings:
It's the light blue boxes appears on the top of the worksheet. These worksheets are in alphabetical order. It helps to select and to identify columns.
3. Formula Bar:
It is used to edit or modify the text of any cell.
4. Undo and Redo Command:
Undo command is used to reverse the last action performed whereas Redo command is used to recover the last action performed.
5. Clipboard group:
This option is available in HOME tab. It can perform following functions:
* Commands in the context menu
* Keyboard shortcuts
* Drag and drop
ExerciseSolution
Page No. 122
Objective Type Questions
Q No. 1: Choose the correct option.
Solution:
a. Which of the following commands are part of the Cells group on the HOME tab?
iv. all of these (is correct)
b. Which one is not an option in the Delete dialog box?
iv. Shift cells right (is correct)
c. The key used to select more than one column / row, consecutively is
i. Ctrl (is correct)
d. The Insert menu option used to insert multiple rows is
ii. Insert Sheet Rows (is correct)
e. You can edit the data in a cell in the
iv. both i. and ii. (is correct)
Page No. 123
Descriptive Type Questions
Q No. 1: Answer the following.
a. What is the difference between copying and moving a cell range?
Answer: Copying a cell range: To copy a cell range means to duplicate all values from one place of the document to another place.
Moving a cell range: To move a cell range means to shift all values from one place of the document to another place.
b. Your teacher has accidently put the wrong names of students on her Excel Science results sheet. What method can be used to change the names to the correct names? Why is it better to do these result sheets on the computer rather than on paper?
Answer: Lab work (will be discuss in Computer lab. Students do not have to do this question on neat copies).
c. Which of the four options displayed in the Insert Dialog Box in Excel 2013 would you choose to use in order to add a column to a school newsletter? Why?
Answer: Following are the four options displayed in the Insert Dialog Box in Excel 2013:
1. Shift cells right
2. Shift cells down
3. Entire row
4. Entire column
So, I will select the option 'Entire column' because I have to put up a complete column in the school newsletter.
d. Compare the undo and redo buttons. Why are they very useful tools?
Answer:
They both are useful because these are shortcut commands to perform quick operation on last action.
e. List the steps to use the drag-and-drop method in Excel. Why is it important to follow these steps carefully and logically?
Answer: Lab work (will be discuss in Computer lab. Students do not have to do this question on neat copies).
f. What is the similarity between the Insert and Delete Dialog boxes? Can changing the row height and the column width both be used when including a long sentence? Explain your answer.
Answer: All the options available in the drop down menu of both 'Insert Dialog box' and 'Delete Dialog box' are exactly same.
Yes, we can change the row height and the column width when including a long sentence. It is because the size of the cell increases from all sides.
Additional Questions
Q: What is the Action performed by choosing the option 'Shift cells right' from the 'Insert dialog box'?
Answer: A new cell is inserted and other cells will be shift in right direction.
Q: What is the Action performed by choosing the option 'Shift cells down' from the 'Insert dialog box'?
Answer: A new cell is inserted and other cells will be shift downwards.
Q: What is the Action performed by choosing the option 'Entire row' from the 'Insert dialog box'?
Answer: A new row or the range of the cells in horizontal direction is inserted and other row or range of horizontal cells are inserted downwards.
Q: What is the Action performed by choosing the option 'Entire column' from the 'Insert dialog box'?
Answer: A new column or the range of cells in vertical direction is inserted and other row or range of vertical cells are inserted towards the right side.
Comments
Post a Comment