Learn with Hafiza Palwasha
OXFORD (Book 5), KEYBOARD
Computer Science With Application Software (Third Edition).
Solution
Chapter No. 7Starting 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. Excel Worksheet:
Excel worksheet facilitates a grid on each page. Grid is made up of rows and columns.
2. Workbook:
A workbook is a collection of a lot of worksheets.
3. Cell:
In worksheet, cell is the smallest unit which is created by intersecting rows and columns.
4. Cell Pointer:
It is a tool which can highlight the boundary of cell. It indicates that which cell is active at that time.
5. Range:
A rectangular block of contiguous cells is called range.
6. Contiguous cells:
Contiguous cells are those cells that touches each other along a line.
ExerciseSolution
Page No. 107
Objective Type Questions
Q No. 1: Choose the correct option.
Solution:
a. Which key should you press to switch on the EXTEND SELECTION mode?
iv. F8 (is correct)
b. Which one of the following is not a Worksheet View option?
iv. Web Layout View (is correct)
c. Which of the following displays the address of the selected cell?
ii. Name Box (is correct)
d. You can save an Excel 2013 file by clicking the
iv. All of the above (is correct)
e. The keyboard shortcut to select the full worksheet is
i. Ctrl + A (is correct)
Page No. 107
Descriptive Type Questions
Q No. 1: Answer the following.
a. How will you select the range of cells B1:F5?
Answer: Lab work (will be discuss in Computer lab. Students do not have to do this question on neat copies).
b. In your opinion, what are three main benefits of using Excel?
Answer: Following are the three main benefits of using Excel:
1. To analyse data
2. For calculations
3. To use formulas
4. To use tables
5. To create graphs
6. To create charts
c. Why is the Quick Access Toolbar useful?
Answer: The Quick Access Toolbar is useful because we can quickly access the commands which we use frequently like:
* Save
* Undo
* Redo
d. What is the difference between worksheets and workbooks in Excel? Why is it important to know this difference?
Answer:
It is important to know the difference because worksheet is a single page whereas workbook is a collection of worksheets.
e. You learned about three different ways of selecting a range of cells. Which seems the simplest way to you? Justify your response.
Answer: Lab work (will be discuss in Computer lab. Students do not have to do this question on neat copies).
f. At the start of the new school year, there are some changes to be made in the school timetable which has been written in Excel. Outline the steps you would take to make these changes in the cells.
Answer: Lab work (will be discuss in Computer lab. Students do not have to do this question on neat copies).
Additional Questions
Q: What is cell in Excel? How a cell creates a spread sheet?
Answer: A cell is made up of row and column. When a lot of rows and columns join together, they form spread sheet.
Q: What do you mean by intersection points in Excel?
Answer: When the lines of rows and columns join together then they are called intersection points.
Q: Consider the below table of MS Excel and find the "Total marks of all subjects" and "Total scored marks of each student"?
Answer: Formula to calculate the total marks of all subjects:
B7 = SUM(B2:B6)
Formulas to calculate the total marks of each student:
Ayesha --> H2 = SUM(C2:G2)
Ali --> H3 = SUM(C3:G3)
Hassan --> H4 = SUM(C4:G4)
Noor --> H5 = SUM(C5:G5)
Hira --> H6 = SUM(C6:C6)
Comments
Post a Comment