47. Please refer to the following screenshot. In Column A, the largest three numbers are highlighted in yellow. In. Column B, the duplicate numbers are highlighted in blue. What function in Excel can automate this? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 A 131 248 537 435 634 324 276 453 237 764 333 428 534 641 B 5403 5506 5405 5392 4334 4334 5497 5486 5445 5357 5429 5453 5485 5424 Data tab - Data Analysis Data tab - Formatting Home tab Conditional Formatting Home tab Table Formatting 48. Greg is using a template to construct a spreadsheet for bookkeeping. After working on it, he needs to save the spreadsheet into a new file so that the template remains unchanged. Where can he find the "Save As" command? A B C D INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEV OBS FILE HOME X Cut copy D Calib - 16 NA AP Wrap The File tab The Save icon The Home tab The Data tab 49. To wrap the text in a cell, one needs to select the cell first, then right-click and choose Format Cells in the pop-up menu. Under which tab on the Format Cells dialogue box can we find the setting for wrapping text? Number Alignment Font Border