Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

. Sarah spends a lot of time cutting and pasting titles and headings and adjusti

ID: 3747647 • Letter: #

Question

. Sarah spends a lot of time cutting and pasting titles and headings and adjusting the formatting each month to create a report for her boss; Sarah would be better off creating a template for herself A True B False 2. Freezing Panes allows you to view four different areas of your worksheet at once. A True B False 3. Afilter can be applied to the following list to show only guests whose name starts with Jto obtain the result shown. Crystal Robinson Finance Austin Fael Marketing No Jessica Mcienis Auto Pedro Eipinosa Maktin sJohn Akens Jessice Mcns Awb A True B. False 4. The IF Function is useful in situations in which there are two, three, or four possible outcomes. A True B. False S. Data Validation sets out the criteria for a cell or cells, which limits the possible entries in that cell. A True B. False Page 1 6 4 6 you have a large list of employees sorted by department, and you want each department to print on a separate page, you should go to Page Break Preview and insert Page Breaks between the departments A True B. False 7. Once you insert a table, you cannot convert the table back to a range because you will lose all of your data. A True B. False 8 What is a character such as a comma, space, or tab that is used to specify a boundary between fields in a data file called? A Parameter B. Delimiter Unlimited D. Decliner

Explanation / Answer

1. True. Creating a template saves Sarah on reworking.
2. False. Freezing panes helps the user to keeps rows or columns visible while scrolling through rest of the worksheet.
3. True.
4. True.
5. True.
6. True.
7. True
8. Delimiter.