Confirming your payment

Skip to content

Competency-Based Questions (CBQ) · Question 40 of 40

A women's self-help group in a village near Nanded saves money every month.

Question 404 marksHard

A women's self-help group in a village near Nanded saves money every month. At each monthly meeting the members check the record together, and the group uses its total savings to decide how much it can lend. Its leader, Kamala, keeps the savings of the 8 members in a spreadsheet: column A has the names, column B the March savings and column C the April savings (in ₹), in rows 2 to 9.

A self-help group of village women sitting in a circle on a mat under a neem tree, with a closed register and a small cash box

Spreadsheet snapshot, columns A to C and rows 1 to 9: Member, March (rupees), April (rupees); Kamala 420, 400; Rukmini 380, 410; Savitri 300, 350; Lata 650, 600; Jaya 450, 480; Sunita 360, 340; Meena 390, 420; Radha 330, 360

(i) Write the range of cells, in the form Start:End, that holds the March savings of the first four members.

(ii) Kamala types =AVERAGE(B2:B9) and the cell shows 410. Without adding the eight values, find what =SUM(B2:B9) will show.

(iii) Lata tells Kamala that her March saving was ₹560, not ₹650: the digits were swapped while typing. After Kamala corrects the cell, what will =AVERAGE(B2:B9) show?