Page 79 - Trackpad_ipro 4.1_Class7
P. 79
4. What are different elements of a formula? Explain them in brief.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
5. List three certain rules of precedence for performing calculations using formulas in Excel.
...................................................................................................................................................................................
...................................................................................................................................................................................
...................................................................................................................................................................................
C. Application-based questions.
1. Sonia is preparing project details in a spreadsheet. Some text in a cell is too long and
gets hidden when she types text in the adjacent cell on the right. How can she change
this?
2. Anaya has prepared a marksheet for her class. She realised that she had
forgotten to enter the marks for one subject. How can she create space in the
marksheet to enter those marks?
Higher Order Thinking Skills (HOTS) #Coding and Computational Thinking
1. Charles had to select row 7 in an Excel file. To do so, he clicked on the first cell of the row
and dragged it to select the entire row. If you were on his place, then how would you have
selected the entire row 7?
2. Analyse the given table of Excel.
a. In the given table, you have to merge cell B1 and C1. How will you do so?
b. You have to calculate the total marks of all the students. Which formula will you use
for each student and in which cell will you type the formulas?
More on Spreadsheets 77

