1.Sarah spends a lot of time cutting and pasting titles and headings and adjusti
ID: 3914528 • Letter: 1
Question
1.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. Truee B. False A filter can be applied to the following list to show only guests whose name starts with J to obtain the result shown. 3. Guest 2 Sarah Mullins 3 Crystal Robinson Finance 4 Austin Farrell 5 John Aikens 6 Jessica MclnnisAuto 7 Atif Khalil 8 Pedro Espinosa Marketing 9 Felecia MurrayRetail Industry Attending Auto Yes Yes No No Yes Yes Yes No Marketing Retail Finance Guest 6 Jessica McInnis 9 John Aikens IndustryAttendin Auto Retail Yes No A. True B. False 4.The lF Function is useful in situations in which there are two, three, or four possible outcomes A. True B. False 5.Data Validation sets out the criteria for a cell or cells, which limits the possible entries in that cell A. Truee B. FalseExplanation / Answer
Answer 1:
True, if she can create template than it would be easier to modify each time
Answer 2:
Flase, we need to use split to view different areas at once
Answre 3:
By using filter we can filter names like starting with something
Answer 4:
True,
IF is used to execute 1 statments out of mulitple statements
Answer 5:
True,
we can write data validations to restrict type of data
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.