GKwizard

Which area in an excel window allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

Answer: Option C

Discussion

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