Question

Which of the following is an alternative to using a space in a named range?

A) Use a hyphen
B) Use an equal sign
C) Use an underscore
D) Capitalize the first letter of each word

Answer 1

In spreadsheets like Microsoft Excel, use an underscore as an alternative to spaces in named ranges because spaces are not allowed in range names.

Step-by-step explanation:

An alternative to using a space in a named range in spreadsheet software like Microsoft Excel is C) Use an underscore. When creating named ranges, spaces are not allowed. A common practice is to use underscores to replace spaces, as they help to maintain readability while adhering to the requirements of the software. For instance, for a named range indicating 'monthly sales', one would use 'monthly_sales' instead of 'monthly sales'. Hyphens can be used as well, but equal signs are reserved for formulas and calculations, and capitalizing the first letter of each word without spaces (PascalCase or CamelCase) may be done but it does not substitute for the space character.