Page 33 - Trackpad_V2.1_Class6
P. 33
3. Think and answer.
a. What are formulas in Excel?
______________________________________________________________________________________
b. Find the result using correct order of operations.
= 8 + 3 * 2 ^ 2 - 5 / 5
______________________________________________________________________________________
c. What are the three types of operators in Excel? Give an example of each.
______________________________________________________________________________________
______________________________________________________________________________________
d. What is cell range? How can you select a cell range by using the mouse?
______________________________________________________________________________________
______________________________________________________________________________________
e. Explain the meaning of #NAME?, #REF! and #NUM! errors in Excel. Also, write a tip to
resolve them.
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
4. Define the following functions:
a. MAX() ______________________________________________________________________________
b. TODAY() ______________________________________________________________________________
c. LEN() ______________________________________________________________________________
5. Differentiate between the following:
Relative Cell Referencing Absolute Cell Referencing
__________________________________ __________________________________
__________________________________ __________________________________
21 st
Century #Information Literacy
6. Application-based questions. Skills
a. Alisha was using Excel and encountered an error that displayed ‘#Div/0!’. She doesn’t
know about this error. Tell her the meaning of this error and also give a tip to resolve this.
b. Siya has made a spreadsheet of the marks obtained in different subjects by the students in her class.
She has made some changes to the marks of some students. Now she wants that the total number
of marks of those students be automatically updated. Which function should she use to do so?
Formulas and Functions in Excel 2016 31

