1. >Accountancy
Found 4  QuestionsSET DEFAULT
Selected Filters
    Accountancy MS Excel
Exams
Subjects
Topics

List of top Accountancy Questions on MS Excel

The monthly sales of a company for the first six months are given below in Rupees (₹). 

  • PSEB XII - 2025
  • PSEB XII
  • Accountancy
  • MS Excel
Marks sheet of students is given below:
Complete the table by writing formulas in Row 6 and Column E.

\[ \begin{array}{|c|c|c|c|c|} \hline A & B & C & D & E \\ \hline \text{Name of Students} & \text{Marks Scored in July, 2022} & \text{Marks Scored in December, 2022} & \text{Marks Scored in March, 2023} & \text{Total Marks} \\ \hline \text{Mohan} & 300 & 400 & 425 & \text{=B2+C2+D2} \\ \text{Ram} & 250 & 291 & 300 & \text{=B3+C3+D3} \\ \text{Gobind} & 350 & 300 & 295 & \text{=B4+C4+D4} \\ \text{Kamal} & 410 & 390 & 415 & \text{=B5+C5+D5} \\ \hline \text{Total Marks} & \text{=SUM(B2:B5)} & \text{=SUM(C2:C5)} & \text{=SUM(D2:D5)} & \text{=SUM(E2:E5)} \\ \hline \end{array} \]
  • PSEB XII - 2025
  • PSEB XII
  • Accountancy
  • MS Excel
Write the formula to calculate the depreciation by using SLN (Straight Line) method in MS Excel.
  • PSEB XII - 2025
  • PSEB XII
  • Accountancy
  • MS Excel

Complete the following table: 

  • PSEB XII - 2025
  • PSEB XII
  • Accountancy
  • MS Excel