Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 122 - 2607_Trackpad_Pro_5.1_flipbook_C6
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 |