Learn with Hafiza Palwasha
OXFORD (Book 7), KEYBOARD
Computer Science With Application Software (Third Edition).
Solution
Chapter No. 1Formulas 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. Formula:
It is defined by the sequence of:
* Operators
* Values
* Functions
* Variables
* Cell reference
2. Concatenation:
It means joining together. The process by which Text values are joined together in series.
3. Function:
A function is a pre-defined formula that can perform calculations.
4. Text String:
It is the combination of characters that are used as data in MS Excel. Addition, Subtraction, Multiplication and Division are not performed on these characters.
5. AutoSum:
It is a function in MS Excel in which all the selected cells are add up and gives output on new cell.
6. Insert Function:
This option provides us the facility to add different functions in MS Excel like Addition, Subtraction, AutoSum etc.
7. Circular Reference:
When the formula is referring to its own value, it is called a circular reference.
8. Mathematical Operators:
Those operators that can perform mathematical calculations are called mathematical operators. For example:
* Exponent ^
* Multiplication *
* Division /
* Addition +
* Subtraction -
9. AutoFill:
It is the function in MS Excel that can automatically fill the cells by observing the sequence of previous cells.
10. Max Function:
It is a function that can find out the maximum value from the selected cells.
Objective Type Questions
Q No. 1: Fill in the blanks with the correct words.
Solution:
a. A formula in Excel is a sequence of values, cell references, functions, and/or operators in a cell that produces a new value from existing values.
b. A circular reference occurs when a formula refers to it's own value.
c. The text string or a text value is a sequence of characters on which you cannot perform operations like subtraction, multiplication, or division. However you can join strings together. This is called concatenation.
d. Mathematical operators used in Excel and their order of evaluation in formulas from first to last.
e. Functions in Excel are pre-defined formulas that perform specific calculations.
ExerciseSolution
Page No. 16 & 17
Descriptive Type Questions
Q No. 1: Answer the following.
a. What is a circular reference? Explain with an example.
Answer: When the formula is referring to its own value, it is called a circular reference. Its effect is like a loop, which calculates its own value and then updates with a new value, for example: If we have a formula for the A1 cell that is A1+A2+A3+A4, then every time it calculates A1, it updates the value of A1. So A1 changes every time, and it goes forever.
b. Write the steps to find the LCM of three numbers.
Answer: Lab work (will be discuss in Computer lab. Students do not have to do this question on neat copies).
c. The way of entering a cell reference in a formula are (a) by typing and (b) by pointing. Explain the difference between the two methods.
Answer: By typing: In this method, we enter the formula in the formula bar and then press enter to get the results of this formula.
By pointing: In this method, we type '=' in the formula bar and then click on the cell with which the reference has to be made.
d. When you enter a formula and click Enter, it displays the calculated value. What will you do to display the formula?
Answer: To display the formula, we have to select the cell in which the formula was entered before, and then the formula is displayed in the formula bar.
e. Name the arithmetic operators you can use in an Excel formula.
Answer: Following are the arithmetic operators I can use in an Excel formula:
* Addition
* Subtraction
* Multiplication
* Division
* Exponent
f. Your teacher has asked you to use an Excel sheet to record the marks of your class in the following subjects: English, Science, Mathematics, and Computer Science. With this information you can then calculate the average marks of each student and the names of the students who scored the highest and lowest marks in each subject.
* Compare the different methods of creating this sheet.
* Give reasons as to why you would select one method over the other.
Answer: Following are the two different methods of creating this sheet:
1. Using Formula Bar
2. Using Autosum
I would prefer Autosum because:
1. It's an automatic feature to do the calculation.
2. It saves time to do the same task by using Formula bar.
3. It gives quick results for large calculations.
g. Access the advantages of relative, mixed, and absolute reference cells in Excel 2013.
Answer: Advantages of Relative Reference Cell: Relative Reference Cell makes the calculation easier because it replaces the references. It is very useful when we have to do the same calculation for the number of cells.
Advantages of Mixed Reference Cell: Mixed Reference Cell helps to define the reference for the user for column and row.
Advantages of an Absolute Reference Cell: An Absolute Reference Cell can fix the reference as a row or column; because of this, if a number is used again and again, it will consider that number an absolute reference. Hence, we don't need to type the same number repeatedly.
h. Create a table showing your own overall average marks in all subjects. Make separate columns or rows showing the subjects in which you gained the highest and lowest marks.
Answer: Lab work (will be discuss in Computer lab. Students do not have to do this question on neat copies).
Additional Questions
Q: Solve the following expressions:
1. 2 ^ 4
2. 8 * 5
3. 10 / 3
4. 24 + 58
5. 46 - 19
Answer: 1. 2 ^ 4 = 2 * 2 * 2 * 2 = 16
2. 8 * 5 = 40
3. 10 / 3 = 3.33
4. 24 + 58 = 82
5. 46 - 19 = 27
Q: Write the results of the following formulas:
1. = (8 + 3) * 2
2. = 8 * 2 + 3
3. = 2 + 3 ^ 4
4. = 4 + 5 * 4 - 2
5. = 6 + 10 / 2 * 3 - 6
Answer: 1. = (8 + 3) * 2 = 11 * 2 = 22
2. = 8 * 2 + 3 = 16 + 3 = 19
3. = 2 + 3 ^ 4 = 2 + 81 = 83
4. = 4 + 5 * 4 - 2 = 4 + 20 - 2 = 24 - 2 = 22
5. = 6 + 10 / 2 * 3 - 6 = 6 + 5 * 3 - 6 = 6 + 15 - 6 = 15
Q: Define the ##### error.
Answer: ##### error means the width of the column is small, so the value is not displaying properly.
Q: Define the #DIV/0! error.
Answer: #DIV/0! means the formula has some invalid operation; for example, a number divided by zero gives an invalid answer.
Q: Define the #N/A error.
Answer: #N/A error indicates that a specific value is not available in that cell.
Q: Define the #NUM! error.
Answer: #NUM! error indicates that there is a problem with the value; for example, the cell requires q positive number and the user is entering a negative number.
Q: Define the #REF! error.
Answer: #REF! error means that the entered value does not exist in the worksheet. It happens when the cell is deleted.
Q: Define the #VALUE! error.
Answer: #VALUE! error means that the user entered an invalid argument. It may happen when the user enters text but a numeric value is required by the cell.
Comments
Post a Comment