Computer Applications
Study the spreadsheet given below and write the solutions for the specifications that follow. You can write the answers for any four specifications out of the given five.
Specification 1: Write the formula to be entered in cell H4 in order to calculate Rita's total marks out of 500. How can you easily enter the formula for totals in the four cells (H5 to H8) without typing each individually?
Specification 2: The percentage column should contain the percentage of each student. Write the formula to be entered in cell I4 to calculate the percentage for the first student.
Specification 3: Write the formula that will appear in cell I5 when we copy the formula from cell I4 to cell I5.
Specification 4: Write the formula that should be entered in cell C9 to calculate the average marks in English.
Specification 5: If a column chart is to be plotted of students name against the marks in English, write the range of cells that needs to be selected.
Answer
Specification 1 — The formula to be entered in cell H4 in order to calculate Rita's total marks out of 500 is = SUM (C4 : G4).
We can easily enter the formula for totals in the four cells (H5 to H8) without typing each individually by copying the formula of cell H4 in cell range H5 : H8. To copy the formula, we must select it and drag the cell handle to cell H8.
Specification 2 — The formula to be entered in cell I4 to calculate the percentage for the first student is = (H4 / 500) * 100.
Specification 3 — The formula that will appear in cell I5 when we copy the formula from cell I4 to cell I5 is = (H5 / 500) * 100.
Specification 4 — The formula that should be entered in cell C9 to calculate the average marks in English is = AVERAGE (C4 : C8)
Specification 5 — The range of cells that needs to be selected to plot a column chart of students name against the marks in English is B4 : C8.
Related Questions
Karan has created a document in a word processor. Write the features to help him quickly achieve the following:
- Insert a page number at the bottom of each page.
- Give a heading to each page.
- Search for the word 'pink' wherever it occurs and replace it with "green".
Shobha recently got a printer as a gift. She has connected the printer to her computer as well as to the power source. Everything seems to be in order but when she tries to print, the printer does not show up in her list of devices. What could be the problem? Can you suggest what Shobha can do to resolve this issue?
Study the Excel chart shown below and write the solutions for the specifications shown below it. You can write the solutions for any four specifications out of the given five:
Specification 1: Name the type of chart that has been used in the figure. What is the type of analysis that this type is giving?
Specification 2: What is the temperature in Sydney in the month of November?
Specification 3: Which is the hottest city in the month of August?
Specification 4: Which is the country which generally has the lowest temperatures across the year?
Specification 5: What is the use of charts in a spreadsheet? Name one more type of chart.
Case Study 1
Neeta has to create a presentation for a project on sustainable development. She is not very familiar with digital presentation software. Help her understand some of the concepts with reference to a slide presentation.
- Presentation
- Creating a slide
- Workspace Views - any two views
- Animations
- Slide Layout