GKwizard When you copy a formula A. Excel erases the original copy of the formula B. Excel edits cell references in the newly copied formula C. Excel adjusts absolute cell references D. Excel doesn't adjust relative cell references 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
