Which formula could not have been entered in cell C5?
- =SUBTOTAL(9, C2:C4)
- =C2+C3+C4
- =SUBTOTAL(C2:C4)
- =SUM(C2:C4)
The correct answer is:
- =SUBTOTAL(9, C2:C4)
🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers
- What Excel feature can you use to automatically format cells that are greater than a specified value with designated fill and text colors?
- The last two digits of the Representative ID Number is the Office ID. Which function, when entered into cell B2 and then dragged to cell B6, returns the Office ID for each representative?