Exams › IBPS PO › General Awareness

Which notation represents a cell range starting in cell B1, column G and selecting row 10 in Excel?

1. B1-G10
2. B1.G10
3. B1;G10
4. B1:G10

Correct answer: B1:G10

Solution

Excel cell ranges use the colon (:) syntax: B1:G10 defines the rectangular range from cell B1 to cell G10. Hyphens, dots, and semicolons are not valid range separators in Excel.

Related IBPS PO General Awareness questions

• Which feature of MS Office provides convenient access to most commonly used commands?
• Cache and main memory will not be able to hold their contents when the power is switched off. This type of memory is called:
• What type of program controls the various computer parts and allows users to interact with the computer?
• Ransomware is classified as:
• Which keyboard shortcut is used to switch to the next window/worksheet?
• Specialized programs that help users locate information on the Web are called:

⚔️ Practice IBPS PO General Awareness free + battle 1v1 →