GKwizard You can set Page Border in Excel from A. From Border tab in Format Cells dialog box B. From Border tool in Formatting toolbar C. From Line Style tool in Drawing toolbar D. You cannot set page border in Excel 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