Question 1 of 5 Share Facebook Twitter LinkedIn WhatsApp Email Copy Link An analyst is arranging all data in a dataset by ranking it based on a specific metric to make it easier to understand, analyze, and visualize. Which task is the analyst performing? A. Updating the data B. Sorting the data C. Restricting access to the data D. Filtering the data Submit Answer
Question 2 of 5 Share Facebook Twitter LinkedIn WhatsApp Email Copy Link An analyst wants to sort all columns in a table in Microsoft Excel using Structured Query Language (SQL). Which SQL command can the analyst use to sort all columns? A. CAST B. SELECT * C. WHERE = D. JOIN Submit Answer
Question 3 of 5 Share Facebook Twitter LinkedIn WhatsApp Email Copy Link Which tool does an analyst use to organize similar kinds of data into categories and subject areas? A. Tables B. Reports C. Charts D. Maps Submit Answer
Question 4 of 5 Share Facebook Twitter LinkedIn WhatsApp Email Copy Link How does an analyst type a SORT function in Microsoft Excel to organize data by a certain category? A. {=-SORT] B. [=+SORT} C. {=SORT] D. SORT * Submit Answer
Question 5 of 5 Share Facebook Twitter LinkedIn WhatsApp Email Copy Link How would an analyst specify a descending order of data in a Structured Query Language (SQL) query? A. ORDER BY followed by DESC B. FROM followed by database C. SORT followed by TRUE D. FILTER followed by ASC Submit Answer