The Name box on to the left of formula bar

A. shows the name of workbook currently working on

B. shows the name of worksheet currently working on

C. shows theÂ name of cell or range currently working on

D. None of above

Answer: Option C

1

Which Excel function is used to combine text from multiple cells with a delimiter?

A. CONCAT

B. TEXTJOIN

C. JOINSTR

D. MERGE

2

What does the SORTBY function do?

A. Sorts data based on specified order

B. Sorts by a related range

C. Sorts by default ascending order

D. None of the above

3

Which function returns a dynamic array of random numbers between 0 and 1?

A. RANDARRAY

B. RANDOM

C. RNDGEN

D. SEQUENCE

4

Which function helps link to another workbook in Excel?

A. HYPERLINK

B. INDIRECT

C. LINKTO

D. VLOOKUP

5

Which tab in Excel contains the 'Get & Transform Data' tools?

A. Home

B. Insert

C. Data

D. Review

The Name box on to the left of formula bar

1

Which Excel function is used to combine text from multiple cells with a delimiter?

2

What does the SORTBY function do?

3

Which function returns a dynamic array of random numbers between 0 and 1?

4

Which function helps link to another workbook in Excel?

5

Which tab in Excel contains the 'Get & Transform Data' tools?

Categories

Random Posts

About

Important Link

Company

Others

Social Media

The Name box on to the left of formula bar

1 Which Excel function is used to combine text from multiple cells with a delimiter?

2 What does the SORTBY function do?

3 Which function returns a dynamic array of random numbers between 0 and 1?

4 Which function helps link to another workbook in Excel?

5 Which tab in Excel contains the 'Get & Transform Data' tools?

Categories

Random Posts

Social Media

1

Which Excel function is used to combine text from multiple cells with a delimiter?

2

What does the SORTBY function do?

3

Which function returns a dynamic array of random numbers between 0 and 1?

4

Which function helps link to another workbook in Excel?

5

Which tab in Excel contains the 'Get & Transform Data' tools?