GKwizard You cannot link excel worksheet data to a word document A. With the right drag method B. With a hyperlink C. With the copy and paste special commands D. With the copy and paste buttons on the standard toolbar. Answer: Option D
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