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

