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
Great Lakes Institute of Mana...
Apply
Globally Recognized by AACSB (US) & AMBA (UK) | 17.8 LPA Avg. CTC for PGPM 2025
UPES B.Tech Admissions 2026
Apply
Ranked #43 among Engineering colleges in India by NIRF | Highest Package 1.3 CR , 100% Placements
Amity University, Noida | Law...
Apply
Among top 100 Universities Globally in the Times Higher Education (THE) Interdisciplinary Science Rankings 2026
Amity University, Noida : MBA...
Apply
Ranked among top 10 B-Schools in India by multiple publications | Top Recruiters-Google, MicKinsey, Amazon, BCG & many more.
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
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