Page 122 - 2403_Trackpad_V5.1_C6_Fb
P. 122

Assignments








              Chapter 1: Formulas in Excel 2021

              1.  If you have a cell with a value of 50 in cell D1 and you want to increase this value by 15% in cell D2,
                  what formula would you use in D2?
              2.  Somya is preparing a monthly sales report in Excel, in which she needs to create a formula that
                  calculates the total revenue from sales. The number of units sold is written in cell F2 and the price
                  per unit is written in cell G2. Which formula should she use for this?
              3.  Analyse the given data in Excel.

                        A         B          C          D       E       F        G           H             I       J
                   1 S. No. First Name Last Name Roll No. Maths Science English Social Science Computer Total
                   2      1 Jaspreet     Kaur            701     85       84      93              76         88

                   3      2 Ahmed        Khan           702      66       78      97              95         92
                   4      3 Jasper       Clarke         703      73       65      88              73         84
                   5      4 Priya        Verma          704       91      97      99              93         96
                   6      5 Rajveer      Singh          705      52       48      67              77         99

                  You have to calculate the total marks for all students. Which formula will you use to calculate the

                  total marks?
              4.  Ravi is creating a spreadsheet to track his monthly expenses. He wants to calculate the total
                  expenses for January using the expenses listed in cells B2, B3, and B4. What formula should Ravi
                  enter in cell B5 if he wants to add the values in cells B2, B3, and B4?

              5.  Nitin has entered the formula =A2*B2 in cell C2 to calculate the total price of items by multiplying
                  the quantity in column A by the price in column B. If he copies this formula from cell C2 to cell
                  C3, what will happen to the cell references in the formula? Explain the concept of relative cell
                  referencing using this example.

              6.  In Excel, Raman wants to select a range of cells from B2 to D5 to apply a formula. Describe two
                  different methods he can use to select this range, and explain why it is important to select the
                  correct cell range when performing calculations.

              Chapter 2: Charts in Excel 2021

              1.  Amit has a pie chart showing the market share of different Indian brands: Tata, Reliance, Birla,
                  and Infosys. He wants to change the chart’s background colour to better match the company’s
                  branding. How should Amit accomplish this?
              2.  Vikram wants to create a chart that compares the quarterly profits of “Neha’s Fashion Boutique”
                  and “Vikram’s Furniture” for the year 2023-24. However, after creating the chart, he realises he
                  needs to switch to a different chart type to better visualise the comparison. What steps should
                  Vikram take to change the chart type?


                  120   Premium Edition-VI
   117   118   119   120   121   122   123   124   125   126   127