Question:
How are ranges identified within Excel?
How are ranges identified within Excel?
Show Hint
Colon (:) defines a continuous range, while Comma (,) separates multiple ranges or values in Excel formulas.
Updated On: Jul 19, 2025
- Using Hashtag
- Using Vector
- Using Colour
- Using Comma
Hide Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
In Excel, ranges are defined using colon ( : ) between starting and ending cells, such as A1:A10.
However, multiple ranges or distinct cells are separated by a comma, for example: =SUM(A1:A5, C1:C3).
So, when selecting multiple ranges within a formula, commas are used to distinguish them.
Hence, ranges are identified using Comma in Excel.
However, multiple ranges or distinct cells are separated by a comma, for example: =SUM(A1:A5, C1:C3).
So, when selecting multiple ranges within a formula, commas are used to distinguish them.
Hence, ranges are identified using Comma in Excel.
Was this answer helpful?
0
0
Top Questions on Computerised Accounting
- Explain number formatting
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- Develop a code for Nisha, Roll No. 23 who took admission in Section A, Class XI in the year 2024 in School No. 10 run by the ‘Education For All Trust’. Section A is a science stream section and its code is 1.
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- Name the error which occurs when the column is not wide enough or a negative date or time is used. How can it be corrected if:
(i) Error is due to the width of the column, and
(ii) Date or time is negative?- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- State the phases of ‘Accounting Cycle’.
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
- Two important requirements of an accounting report are:
- CBSE CLASS XII - 2025
- Accountancy
- Computerised Accounting
View More Questions
Questions Asked in CBSE CLASS XII exam
- Justify the following statements with valid arguments:
(i) Money supply in an economy is an example of a stock variable.
(ii) The Central Bank provides several Banking services to the government.- CBSE CLASS XII - 2025
- Money and Banking
Simar, Tanvi and Umara were partners in a firm sharing profits and losses in the ratio of 5:6:9. On 31st March, 2024 their Balance Sheet was as follows:
Umara died on 30th June, 2024. The partnership deed provided for the following on the death of a partner:
- CBSE CLASS XII - 2025
- Profit and Loss Account
- The monetary policy is formulated by the ____ in the Indian economy.
- CBSE CLASS XII - 2025
- Money and Banking
- "The government generally levies higher Goods and Services Tax (GST) on socially undesirable products like cigarettes, tobacco, liquor etc." Identify and explain the indicated government budget objective in the above statement.
- CBSE CLASS XII - 2025
- Government Budgeting
- Find the values of \( a \) for which \( f(x) = \sin x - ax + b \) is increasing on \( \mathbb{R} \).
View More Questions