Deck 5: Generating Reports From Multiple Worksheets and Workbooks

Question 1

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?

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

Answer 1

B

Question 2

Aaron has started a food blog on which he wants to post his recipes. He wants to place a good quality image that corresponds to each cooking step. Which file format should he use so that users do not experience a lag in loading of the website because of high-quality images?

A) TIFF
B) JPEG
C) DOC
D) GIF

Answer 2

B

Question 3

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?

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.

Answer 3

C

Question 4

Anusha wants to use her computer, rather than handwriting the information on her notepad, to analyze her monthly expenses to make the job easier. Which of the following apps should she use?

A) A word processor app to keep a record of her expenses and make calculations
B) A personal interest app to keep a track of all the expenses based on her personal interests
C) A device management app to track all the expenses she makes using her credit and debit cards
D) A spreadsheet app to keep a record of her expenses, sort data, and make calculations

Question 5

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

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

Question 6

Jamie plans to sell his pottery designs through his website. If he also wants to launch a mobile app to reach more people, which type of app should he launch?

A) M-commerce app
B) Banking and finance app
C) Photo editing app
D) Social media app

Question 7

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?

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

Question 8

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?

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

Question 9

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

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

Question 10

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?

A) Use a word processor for step 1, graphics software for step 2, and a mail merge for step 3.
B) Use a graphics software for step 1, mail merge for step 2, and a word processor for step 3.
C) Use a word processor for steps 1 and 2 and a graphics software for step 3.
D) Use mail merge for steps 1 and 2 and a word processor for step 3.

Question 11

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?

A) Fotor, Amazon, PowerPoint, Priceline, Chrome
B) Canva, Dropbox, PayPal, GoogleDocs, Instagram, Facebook
C) Google Calendar, OneDrive, Yelp, Venmo, Twitter
D) Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Facebook, Venmo

Question 12

Lauren wants to be a blogger but uses a Chromebook for writing posts and uploading them to the website. If she has an Internet connection, what software can help her do her work?

A) OpenOffice Writer
B) Zoho writer
C) Prezi app
D) Venmo

Question 13

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?

A) A device management portable app
B) A device management mobile app
C) A productivity app that is installed on all the devices
D) An educational app accessible through browser

Question 14

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?

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 15

Menu items can be inserted into a presentation.

Question 16

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?

A) Develop different versions of the same app for different programs.
B) Use cross-platform tools to write code that will translate the existing Android app code into different native formats.
C) Feed the existing code into cross-platform tools to develop different versions of the same app.
D) Use the same set of codes for different platforms.

Question 17

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

Question 18

An organization has its employees working from home. Which of the following productivity apps should the employees use so they are able to collaborate easily with each other?

A) Fotor
B) OpenOffice
C) G Suite
D) Canva

Question 19

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

A) Blackberry
B) Android
C) iOS
D) Windows

Question 20

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?

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 21

Rohan has to create a presentation out of his thesis summary. He expects the presentation to have at least 50 slides. Which of the following parts of the presentation should he design first?

A) First slide
B) Title slide
C) Slide master
D) Last slide

Question 22

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?

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 23

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?

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

Question 24

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

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

Question 25

Raina is putting finishing touches on her Ph.D. thesis report. She feels she should emphasize the keywords throughout the thesis. How can she do this in the word processor she is using?

A) Change font size, style, and color of the keywords.
B) Define a heading style.
C) Change page margins, size and orientation.
D) Add hyperlinks for each keyword.

Question 26

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?

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

Question 27

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?

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

Question 28

Debra launched her start-up in 2016. After 2 continuous years of losses, she needs to now downsize. She has salary details of all employees in a spreadsheet report. Which of the following features should she use to decide how many people to layoff, and who?

A) VLOOKUP
B) What-if analysis
C) Pivot table
D) Relative referencing

Question 29

Big data is processed using relational databases.

Question 30

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?

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 31

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?

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 32

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?

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

Question 33

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?

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

Question 34

When Florence joins her father's construction business, she realizes all the transactions are still done and maintained on paper. What should she do to establish a system where any data can be looked up immediately and transparency can be maintained?

A) Transfer all financial record to spreadsheet.
B) Convert all paper files to word documents.
C) Create a database of company projects, customers and vendors.
D) Continue with the old system.

Question 35

Fiona is responsible for presenting data at the monthly team meeting so that it can be understood at a glance and is visually appealing way. The data is available in spreadsheet. Which of the following can Fiona do?

A) Create trendlines
B) Create and run macros
C) Move the data to a PowerPoint presentation
D) Format the sheets containing important data

Question 36

Rafael has to type a report about class trip to the museum. Which of the following types of apps should he use to type the report?

A) Presentation
B) Spreadsheet
C) Word processor
D) Messaging