Question

Wk Qu. 4-15 An analyst has started... 

An analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and column B analysts name to be used in Excel.

	A	B
1	Price per Unit	Price per Unit
2	Cost per Unit	Cost_Per_Unit
3	Profit per Unit	Profit per Unit
4
5	Fixed Costs	Fixed_Costs
6	Variable Costs	Variable_Costs

Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. 

Proposed Range Name
Price per Unit
Cost_Per_Unit
Profit per Unit
Fixed_Costs
Variable_Costs

Answer 1

While giving a valid range name, the following is the response if the "Proposed Range Name" is "Correct" or "Incorrect" in Excel.

Proposed Range Name	Correct / Incorrect	Reason
Price per Unit	Incorrect	The Range name is not valid (as space is not allowed in range name)
Cost_Per_Unit	Correct	The Range name is valid as it contains underscore
Profit per Unit	Incorrect	The Range name is not valid (as space is not allowed in range name)
Fixed_Costs	Correct	The Range name is valid as it contains underscore
Variable_Costs	Correct	The Range name is valid as it contains underscore

While giving a valid range name, the following is the response if the "Proposed Range Name" is "Correct" or "Incorrect" in Excel.

Answer 2

Blank spaces are not allowed while naming cells and range names Hence instead of space'' is to be used Heading Price per Unit Cost per Unit Profit per Unit Fixed Costs Variable Costs Proposed Name Remarks Price per Unit Incorrect Cost_Per_Unt Correct Profit per unit Incorrect Fixed_Costs Correct Variable_Costs Correct

In case of any doubt, please comment below