Exam 5: Generating Reports From Multiple Worksheets and Workbooks

Adrian has made a list of his family's grocery expenses over the past year.He wants to highlight all the weeks where expenses exceeded the grocery budget so he can budget more accurately for the coming year.Which spreadsheet tool will allow him to do this automatically?

Shelle wants to design her database so it's easy for the receptionist or another assistant to enter client information.What object should she create to accomplish this goal?

Skype is an app that allows you to make video calls to other Skype users.What type of app is Skype?

Latonya wants to include a website link in her newsletter so readers can click the link and go straight to the website.What kind of formatting does she need to use?

Marsha is working on a group project and needs to start putting together a slide presentation for the group.Two of her group members use Windows laptops,and she has a macOS computer.One group member is using a Chromebook running ChromeOS.Which productivity suite would not work for the whole group?

Skyler needs to print mailing labels for a fundraising campaign her company is hosting.Which type of software should she use?

Erin just bought a new coffee maker that she can control with Alexa to turn on automatically in the morning.She plugs the coffee maker into the wall outlet,but when she tells Alexa to turn it on,Alexa reports she can't find the coffee maker.What does Erin need to do so Alexa can find the coffee maker?

Which of the following is a valid app source for Android users? Choose two.

Emma is working on a new resumé so she can apply for her first full-time job after college.She thinks her design is looking plain,though,and is worried she's missing important information.What advice can you give Emma to help her spruce up her resumé and make it look more professional?

What kind of data is appropriate for a field containing street addresses?

Lisa is hanging out at a coffee shop with her laptop to work on her research paper using Microsoft Office Online.What must she do before she starts working?

Lucas is looking for a photo from a recent beach trip to add to his presentation.The photo is saved in a folder with many other kinds of graphics and images.What file format should Lucas look for to find his photo?

Jasmine needs to crop a group photo to show only her face so she can use it as a headshot for a job application.Which of these programs is the best fit for this task?

Marcie is finishing up her research paper for biology class and asks for feedback from her roommate,Robin,on how it looks.Robin says she initially didn't even see the title of the paper.How can Marcie make the title stand out more while maintaining consistency and a professional look to the paper?

Marina is giving a presentation to a client about some real estate the client is interested in buying.However,the text on the slides is a bit small,and there are thumbnails of all the slides showing along the side of the screen,which is distracting.How can Marina fix this problem?

Miguel just purchased a photo editing app he's been saving up for.However,now he can't find it on his computer.He asks you for help.You open the Downloads folder and see the app's file.What should you check next?

Ashleigh wants to add her company's logo to all of the slides in her presentation.Which software feature should she use to do this most efficiently?

How should you pay for Apache OpenOffice?

Nicholas is complaining there's not enough space on his slides to include all the text he needs.What advice should you give him to solve this problem?

Andy is designing an app that he plans to post only in Apple's App Store.He doesn't plan on posting the app to any other app store.What development tool will he most likely use?