GKwizard to view a cell comment A. click the edit comment command on the insert menu B. click the display comment command on the window menu C. position the mouse pointer over the cell D. click the comment command on the view menu 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 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
