D467 - Exploring Data |122 Questions| With Correct Answers.

A vendor asks a data team at their partner company to share a spreadsheet. The spreadsheet contains three tabs. Tabs 1 and 2 are meant for the vendor to review, but tab 3 contains sensitive internal information. Which of the following tactics will enable the data team to keep tab 3 private? Select all that apply. Rename tab 3 "Sensitive," then share the spreadsheet with the vendor. Hide tab 3, then share the spreadsheet with the vendor. Copy tabs 1 and 2 into a separate spreadsheet, then share the new file with the vendor. Make a copy of the spreadsheet, delete tab 3, then share the new file with the vendor. {Ans: Copy tabs 1 and 2 into a separate spreadsheet, then share the new file with the vendor. Make a copy of the spreadsheet, delete tab 3, then share the new file with the vendor.}A data team at a trade school is sending a text alert to all students who have fewer than 10 credits. What spreadsheet tool will enable them to display only the students who meet that condition? Filter out students who have fewer than 10 credits Filter out students with more than 10 credits Sort