24 Views

Question : What is the correct sequence for creating range names?

Option 1: Select the cell -> Choose the name option -> Choose the define option -> Type in the name -> Click on the Add button -> Click on OK

Option 2: Select the cell -> Choose the define option -> Choose the name option -> Type in the name -> Click on the Add button -> Click on OK

Option 3: Select the cell -> Choose the name option -> Choose the define option -> Click on the Add button -> Type in the name -> Click on OK

Option 4: Select the cell -> Choose the name option -> Choose the define option -> Type in the name -> Click on OK -> Click on the Add button


Team Careers360 14th Jan, 2024
Answer (1)
Team Careers360 22nd Jan, 2024

Correct Answer: Select the cell -> Choose the name option -> Choose the define option -> Type in the name -> Click on the Add button -> Click on OK


Solution : Following is the correct sequence:
Select the cell -> Choose the name option -> Choose the define option -> Type in the name -> Click on the Add button -> Click on OK. Hence, the correct option is 1.

Related Questions

Question : What is the procedure for aligning cell content using the menu?

Option 1: Click on the cell to be aligned -> Choose the Cell option from the Format menu. The Format cells dialog box appears -> Choose the alignment tab -> Click to open the drop-down box associated with the horizontal field. After the drop-down box is opened, select the desired alignment as Right, Left or Center -> Click OK to close the dialog box

Option 2: Click on the cell to be aligned -> Click OK to close the dialog box -> Choose the Cell option from the Format menu. The Format cells dialog box appears -> Choose the alignment tab -> Click to open the drop-down box associated with the horizontal field. After the drop-down box is opened, select the desired alignment as Right, Left or Center

Option 3: Click to open the drop-down box associated with the horizontal field. After the drop-down box is opened, select the desired alignment as Right, Left or Center -> Click on the cell to be aligned -> Choose the Cell option from the Format menu. The Format cells dialog box appears -> Choose the alignment tab -> Click OK to close the dialog box

Option 4: Choose the Cell option from the Format menu. The Format cells dialog box appears -> Choose the alignment tab -> Click to open the drop-down box associated with the horizontal field. After the drop-down box is opened, select the desired alignment as Right, Left or Center -> Click OK to close the dialog box -> Click on the cell to be aligned

15 Views
UPES B.Tech Admissions 2026
Apply
Ranked #43 among Engineering colleges in India by NIRF | Highest Package 1.3 CR , 100% Placements
UPES Integrated LLB Admission...
Apply
Ranked #18 amongst Institutions in India by NIRF | Ranked #1 in India for Academic Reputation by QS Rankings | 16 LPA Highest CTC
Presidency University MBA Adm...
Apply
NAAC A+ Accredited | Highest CTC 10 LPA | Top Recruiters : Amazon, Accenture, KPMG, EY, Capgemini & many more
Nirma University Law Admissio...
Apply
Grade 'A+' accredited by NAAC | Ranked 33rd by NIRF 2025
UPES M.Tech Admissions 2026
Apply
Ranked #45 Among Universities in India by NIRF | 1950+ Students Placed 91% Placement, 800+ Recruiters
UPES | BBA Admissions 2026
Apply
#36 in NIRF, NAAC ‘A’ Grade | 100% Placement, up to 30% meritorious scholarships
View All Application Forms

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books