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 Law A...
Apply
700+ Campus placements at top national and global law firms, corporates and judiciaries
Amity University, Noida BBA A...
Apply
Ranked amongst top 3% universities globally (QS Rankings)
VIT Bhopal University | M.Tec...
Apply
M.Tech admissions open @ VIT Bhopal University | Highest CTC 52 LPA | Apply now
Amity University | M.Tech Adm...
Apply
Ranked amongst top 3% universities globally (QS Rankings).
Graphic Era (Deemed to be Uni...
Apply
NAAC A+ Grade | Among top 100 universities of India (NIRF 2024) | 40 crore+ scholarships distributed
IBSAT 2025-ICFAI Business Sch...
Apply
IBSAT 2025-Your gateway to MBA/PGPM @ IBS Hyderabad and 8 other IBS campuses | Scholarships worth 10 CR
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