Q. The most common subtotal used Subtotals command is the function, which causes Excel to display a sum each time the control field change ?

  • (A) ADD
  • (B) SUM
  • (C) TOTAL
  • (D) LIST
💬 Discuss
✅ Correct Answer: (B) SUM
Explanation: The most common subtotal function used with the Subtotals command in Excel is the SUM function. It causes Excel to display the sum each time the control field changes. Therefore, the correct answer is (2) SUM.

Published by Ritu Singhal ⭐ 4.43K Points at 19-Sep-2024 07:13 am in Microsoft Excel

Explanation by: Ritu Singhal
The most common subtotal function used with the Subtotals command in Excel is the SUM function. It causes Excel to display the sum each time the control field changes. Therefore, the correct answer is (2) SUM.

💬 Discussion

📊 Question Analytics

👁️
133
Total Visits
📽️
2 y ago
Published
🎖️
Ritu Singhal
Publisher
📈
87%
Success Rate