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
Amity University-Noida B.Tech...
Apply
Among top 100 Universities Globally in the Times Higher Education (THE) Interdisciplinary Science Rankings 2026
BML Munjal University | B.Tec...
Apply
A Hero Group Initiative | Up to 100% Scholarships | Highest CTC 32.99 LPA | Average CTC 8.45 LPA | Accepts JEE Score | Applications Closing Soon!
SRM University A.P UG Admissi...
Apply
UG Admissions Open 2026 | Highest CTC 52 LPA | Average CTC 9.09 LPA | 60+ Collaborations with the world's best Universities
Amity University-Noida MBA Ad...
Apply
Ranked among top 10 B-Schools in India by multiple publications | Top Recruiters-Google, MicKinsey, Amazon, BCG & many more.
Amity University-Noida BBA Ad...
Apply
Among top 100 Universities Globally in the Times Higher Education (THE) Interdisciplinary Science Rankings 2026
Poddar Business School PGDM A...
Apply
Highest CTC 24 LPA | Average CTC 8.5 LPA | 1600+ Recruiters | 165+ Corporates Linkages
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