Computer Science · Spreadsheet Formulas
Suppose that the class grade for a six-week period is based on three tests (T1, T2, T3), each of which counts for 15%, four quizzes (Q1, Q2, Q3, Q4), each of which counts for 10%, and a homework notebook (HW), which counts for 15%. The grades are recorded in a spreadsheet similar to the one below: ABCDEFGHIJ1NameT1T2T3Q1Q2Q3Q4HWAVG2Jatin8792807679877490 3Amit9185777888969092 4Anil6572708081747780 5Anita96889176911007498 Which of the following formulae would NOT be a correct calculation of the six-week weighted average for Jatin (Row 2)?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1=(B2 + C2 + D2 + I2)/15 + (E2 + F2 + G2 + H2)/10✓
- 2=(B2 * 0.15 + C2 * 0.15 + D2 * 0.15 + I2 * 0.15) + (E2 + F2 + G2 + H2)/10
- 3=(B2 + C2 + D2 + I2)*0.15 + (E2 + F2 + G2 + H2)*0.1
- 4= B2 * 0.15 + C2 * 0.15 + D2 * 0.15 + E2 * 0.1 + F2 * 0.1 + G2 * 0.1 + H2 * 0.1 + I2 * 0.15
Correct answer
=(B2 + C2 + D2 + I2)/15 + (E2 + F2 + G2 + H2)/10
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice Spreadsheet Formulas MCQs →Want more practice questions on Spreadsheet Formulas?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Spreadsheet Formulas