Question 16: Which statement regarding Quick Analysis is accurate? Answer: A. O It cannot be used to apply formatting to tables B. O It only contains options that cannot be found on the Ribbon C. O It does not afford the opportunity to preview the impact of potential changes D. O It can be used to convert standard worksheet data into a table. 43 54 0 C Dill 75 % 84 5 Copyright 2022-Labyrinth Leaming-All Rights 66 N ab P Presen Ho 17 &7 E R T Y U 8 Question 17: Why sort table data? Answer: A. B. O You want to display only the table rows that meet certain criteria, such as after a certain date. O You want to analyze table data in different ways, such as from largest to smallest amounts C. You can filter by two criteria, such as region and salesperson. D. You need to convert the worksheet data to table data 3 3' 54 Copyright 2022-Labyrinth Leaning-Al Rights Reserved . e ab 411 15 O 15 85 E R T 66 100 Presc Home 1 28 7 U B Question 18: Which statement is incorrect regarding filters? O When a filter is applied, the AutoFilter button in the associated column heading displays a filter icon. A. O Records not meeting the criteria of a filter are hidden. Answer: B. C. OA filter can apply a single criterion only. D. O The AutoFilter button Screen Tip indicates the current filter setting. 4 #3 LLI E C Copyright 2022-Labyrinth Learning-All Rights Reserved 2 Dill 4 0 % 55 N e 16 49F M * Prtscn Home End 17 2 R T Y 7 88 & D F G H U