GKwizard The name box A. Shows the location of the previously active cell B. Appears to the left of the formula bar C. Appears below the status bar D. Appears below the menu bar Answer: Option B
1 Which Excel function is used to combine text from multiple cells with a delimiter? A. CONCAT B. TEXTJOIN C. JOINSTR D. MERGE View Answer
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 View Answer
3 Which function returns a dynamic array of random numbers between 0 and 1? A. RANDARRAY B. RANDOM C. RNDGEN D. SEQUENCE View Answer
4 Which function helps link to another workbook in Excel? A. HYPERLINK B. INDIRECT C. LINKTO D. VLOOKUP View Answer
5 Which tab in Excel contains the 'Get & Transform Data' tools? A. Home B. Insert C. Data D. Review View Answer
