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?

Skyler needs to print mailing labels for a fundraising campaign her company is hosting. Which type of software should she 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?

Ruthie needs to buy a new laptop for her college courses she's beginning in the fall. One course is a computer class that requires her to use the full, installed version of Microsoft Office. Which operating systems will work for her? Choose two.

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?

Which kind of chart or graph would be best suited to illustrate how many students in a class made an A on their test?

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

How can you connect a portable keyboard with a smartphone?

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?

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?

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?

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?

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?

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?

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

How should you pay for Apache OpenOffice?

Lexie just bought a new smartphone and is looking through the pre-installed apps. She sees several apps she recognizes and some that are new to her. One of the apps is named for the manufacturer of her phone. What kind of app is this?

What feature will allow you to repeat steps automatically in a worksheet?