Question

how will you address all cells from cell A5 to G5?
(i) A5, G6
(ii) A5:G6
(iii) G6,A5​

Answer 1

allows us to form connections, influence decisions, and motivate change. Without communication skills, the ability to progress in the working world and in life, itself, would be nearly impossible. Public speaking is one of the most important and most dreaded forms of communication.

Answer 2

The correct option is (ii).

• The colon (:) is used to denote the range of argument of the formula in Excel.
• The colon tells Excel to include all cells between the two reference endpoint cells in the command.
• Hence, in order to adress all the cells from A5 to G6, one uses the formula A5:G6.

SPJ2