Ajeesh wants to format his Excel table so that every other line is light yellow.He's seen this done on other reports and believes it will make his data easier to follow across rows.Ajeesh begins to apply highlighting to every other line by using the Ctrl key to select the odd rows,but worries that adding and deleting rows will ruin the consistency of his format.What is an alternate solution for Ajeesh?
A) Ajeesh should continue with his current formatting
B) use banded rows
C) Ajeesh should not apply this formatting
D) use Format Painter

Question

Quizplus · Accepted Answer

Using banded rows will automatically format every other row with a different color or shading, making it easier to read and follow across rows. This will also make it easier for Ajeesh to add or delete rows without interrupting the consistency of his format.

Ajeesh Wants to Format His Excel Table So That Every