You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

A. Custom List

B. Auto Fill Options

C. Fill across Worksheet

D. Fill Series

Answer: Option A

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

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

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

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

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?