TSI Excel Certs Part 1 Exam Questions with Correct Answers

TSI Excel Certs Part 1 Exam Questions with Correct Answers In the Source Data worksheet use Fine & Select to find the cell that contains Data Validation and clear the validations - ANSWER Home Tab-Editing group- Find & Select dropdown-click Data Validation- click B2 In the source data WS use Find & Select to find the cell that contains Data Validation and clear the validation - ANSWER Home tab-Editing group- Find & Select dropdown- Click Data Validation- Click B2- Data tab- Data Tools group- select Data Validation- and click Clear all and then ok Source Data WS unhide any hidden rows - ANSWER Crtl+A- Select All Button- Home tab- Cells Group- Click Format- Under Hide & unhide click Unhide rows Change the Margins to Narrow - ANSWER Page layout- Margins- Narrow In the annual Sales WS, in cell B17 use the COUNTIF formula function to count the number of times that the values in cell range B6:B15 exceed 5000 - ANSWER Formulas tab- Click insert Formula- Type COUNTIF- press okay- In range feild type B6:B15- Type 5000 In the Basic Process Smart Art graphic below the data in the worksheet - ANSWER Click the bottom of the WS- Insert tab- Illustrations group- Smart Art- select Basic Process from the Process section- Click okay and enter Inspect the current workbook for hidden properties such as author. Remove any of the properties that are found and return to the document - ANSWER File- Info tab- Check for issue- click Inspect document button- Check document properties and personal info and click inspect- click remove all from document propertiees and personal info section- click close In the June WS define the name Fiction 12 for the cell range B4:B33 - ANSWER Formulas- Define name In the Totals worksheet enter a formula in the cell B2 that displays the SUM of the Fiction 12 range - ANSWER Click totals worksheet- click B2- Formulas- Auto sum- Type Fiction 12- press Enter In the Source Data worksheet Sort the Data alphabetically by Customer ID and then by product - ANSWER Click on the Source Data worksheet- Home- Click Sort and Filter- click "Sort A-Z"- click "Custom Sort"- click sort by Customer ID- Click "Copy level" and click on the drop down and put "Product"