Exam 5: Generating Reports From Multiple Worksheets and Workbooks

Abe has to design a presentation about the progress of his research team over the previous year.He wants to add small video snippets to show the actual work his team carried out during the research.Which of the following apps should he use?

dLucy is planning to launch her podcast on career guidance for college students and has already recorded a few videos for marketing purposes.Which of the following apps can she use to mix and match the clips?

Sean works for an organization that offers SaaS to a chain of boutiques.By getting data from the database,he has to prepare a list of instances when the billing transaction failed.Which of the following tasks does he need to do to prepare the report?

Simone frequently downloads mobile apps from Amazon Appstore.What operating system does she have on her smartphone?

Menu items can be inserted into a presentation.

Lauren is preparing a presentation for her class.She wants to make the slides and their objects appear and disappear to make it more interesting.What should she do?

Martha has been appointed as the Data Security Manager of her organization.The company wants her to have a customized app created that can be used to remove viruses from the infected systems without connecting to the network.What type of app should she focus on getting developed?

Samantha plans to self-publish her book on her website.She had asked a friend to design the cover of her book but he backed out at the last moment.Samantha now needs to design it herself.Which of the following apps should she use to complete this project?

Andrew's company uses a special email program for communicating within the organization.What should the company do to ensure that its employees are able to access the inbox even when they are away from office?

How can you check data on devices connected through IoT network?

Rob is planning his housewarming party.He wants to design an invitation and personalize it for each invitee.These are the things he needs to do: Create a list of invitees; Design the card; and Personalize the card. How should he go about the task?

Sammy created a new logo for his client to be used on the company website as well as office stationary.However,it became an almost invisible blur when it was enlarged to use on a billboard ad.Now Sammy needs to redo the logo.What should he do to avoid this in future?

LensForAll is a company that sells affordable contact lenses on its website.The CEO of the company realizes that an app must be developed that would allow customers to virtually try on colored lenses to find out what best suits them.Which of these features should the app have?

Shania has started a new job as an app developer.Her first task was to make an old app designed for Android available on other platforms.Which of the following would make her job easiest and fastest?

Pierre has entered marks obtained by the students in all the classes he teaches in a spreadsheet.Now he wants to highlight some data according to his specifications.Which spreadsheet feature should he use?

Sophia is putting together a training manual for her new batch of employees.Which of the following features can she use to add a document title at the top of each page?

Which of the following devices can be used to advance slides without having to click a button on the laptop?

Local applications can be accessed only on the computers on which they are installed.

Paul has opened a bespoke tailoring shop.He wants to keep a database of all his customers,send e-mails when garments are ready,create designs,and maintain financial records using software.Which productivity suites should he consider?

Patricia has started a new interior designing business.Her top five tasks are creating designs,sharing them with her team and potential clients,making presentations for potential clients,sending and receiving payments,and carrying out marketing on social media.Which of the following sets of apps should she use?