Question 1

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?

Accepted Answer

A)   A word processor app, which would allow him to use different font sizes, styles and colors
B)   Graphics software, which would allow him to create and edit graphics and text
C)   A presentation app, which would allow him to use basic animation functions, and add graphics and videos
D)   A video editing app, which will allow him to modify videos to use in his presentation B, C, D

Question 2

Logan is considering web app development as a career option. Which of the following languages does he not need to master?

Accepted Answer

A)   CSS
B)   JavaScript
C)   HTML5
D)   Logo D

Question 3

Jim wants to develop an app for a specific purpose that would run even when his computer is not connected to the Internet. What type of app should he develop?

Accepted Answer

A)   Mobile app
B)   Native app
C)   Web-based app
D)   Cloud-based app B

Question 4

Menu items can be inserted into a presentation.

Accepted Answer

A) True 
 B)False

Question 5

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?

Accepted Answer

A)   Have a mobile app developed.
B)   Use a generic e-mail software like Gmail.
C)   Make the program available as a web app.
D)   Design a new e-mail program.

Question 6

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?

Accepted Answer

A)   Google photos
B)   Adobe Premiere Clip
C)   Audacity
D)   FilmoraGo

Question 7

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?

Accepted Answer

A)   Use vector images because they retain their clarity even when enlarged or shrunk.
B)   Use GIFs because they are a combination of images and provide alternatives in case a portion appears blurred.
C)   Use raster images because they retain their clarity even when enlarged or shrunk.
D)   Use cropped screenshots of paused video clips because video clips are a combination of images and provide alternatives in case images appear blurred.

Question 8

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?

Accepted Answer

A)   It should be a web app so that it runs on all devices.
B)   It should be native app so that the device camera can be used by the app.
C)   It should have responsive design so that it is easy to use on mobile devices.
D)   It should be a portable app so that it is quick to use.

Question 9

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?

Accepted Answer

A)   Prezi, G suite
B)   G suite, Zoho
C)   OpenOffice, G suite
D)   Zoho, Apple iWork

Question 10

Remus is an art student who wants to start creating digital artwork on his computer. He wants to be able to create images that retain their quality in all sizes. Which type of app should he use?

Accepted Answer

A)   Paint app
B)   Drawing app
C)   Photo editing app
D)   Video editing app

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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?

Accepted Answer

A)   A presentation app to design graphics and a video editing app to insert snippets of videos
B)   A word processor app to write the text that would appear on the cover page
C)   A graphics app to design the cover page and place the desired text where needed
D)   A spreadsheet app to create graphics and text, and the inbuilt grid to arrange it

Question 13

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?

Accepted Answer

A)   Heading style
B)   Page margin
C)   References
D)   Header and Footer

Question 14

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

Accepted Answer

A)   Use a desktop
B)   Use a server
C)   Use a tablet
D)   Use a network tracker

Question 15

Big data is processed using relational databases.

Accepted Answer

A) True 
 B)False

Question 16

For an interview, Sean needs to familiarize himself with database software but cannot afford to purchase any software. Which of these app suites should he download?

Accepted Answer

A)   Microsoft Office
B)   G suite
C)   Apple iWork
D)   Apache OpenOffice

Question 17

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?

Accepted Answer

A)   Sorting and filtering
B)   Run macros
C)   Conditional formatting
D)   What-if analysis

Question 18

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?

Accepted Answer

A)   Assign specific instructions in slide master formatting to make slides and objects appear and disappear as required.
B)   Use hyperlinks to go to random slides to make it look like they are appearing and disappearing.
C)   Choose specific transition effects and animations to allocate the kind of transition and time to each slide and object.
D)   Use sound effects to create the illusion of appearance and disappearance of objects and slides.

Question 19

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?

Accepted Answer

A)   Create queries to get relevant data
B)   Specify layout and format
C)   Establish relationship between data
D)   Add data to the report by running it

Question 20

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

Accepted Answer

A)   Laser pointer
B)   Wireless remote control
C)   Smartphone
D)   Stylus

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?

Logan is considering web app development as a career option. Which of the following languages does he not need to master?

Jim wants to develop an app for a specific purpose that would run even when his computer is not connected to the Internet. What type of app should he develop?

Menu items can be inserted into a presentation.

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?

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?

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?

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?

Remus is an art student who wants to start creating digital artwork on his computer. He wants to be able to create images that retain their quality in all sizes. Which type of app should he use?

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

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?

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?

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

Big data is processed using relational databases.

For an interview, Sean needs to familiarize himself with database software but cannot afford to purchase any software. Which of these app suites should he download?

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?

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?

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?

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