Question 1

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?

Accepted Answer

A)   Fotor
B)   OpenOffice
C)   G Suite
D)   CanvaE) A) and B)
F) A) and C)

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?

Accepted Answer

A)   TIFF
B)   JPEG
C)   DOC
D)   GIFE) B) and D)
F) All of the above

Question 3

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?

Accepted Answer

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

Question 4

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?

Accepted Answer

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 browserE) A) and B)
F) B) and C)

Question 5

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?

Accepted Answer

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, VenmoE) A) and B)
F) B) and D)

Question 6

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?

Accepted Answer

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.E) B) and C)
F) A) and D)

Question 7

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?

Accepted Answer

A)   VLOOKUP
B)   What-if analysis
C)   Pivot table
D)   Relative referencingE) B) and D)
F) B) and C)

Question 8

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?

Accepted Answer

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

Question 9

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?

Accepted Answer

A)   Presentation
B)   Spreadsheet
C)   Word processor
D)   MessagingE) A) and B)
F) None of the above

Question 10

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?

Accepted Answer

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.E) B) and C)
F) All of the above

Question 11

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?

Accepted Answer

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.E) B) and C)
F) All of the above

Question 12

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

Accepted Answer

A)   Blackberry
B)   Android
C)   iOS
D)   WindowsE) B) and D)
F) B) and C)

Question 13

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?

Accepted Answer

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 calculationsE) A) and B)
F) A) and C)

Question 14

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?

Accepted Answer

A)   OpenOffice Writer
B)   Zoho writer
C)   Prezi app
D)   VenmoE) A) and D)
F) A) and C)

Question 15

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?

Accepted Answer

A)   First slide
B)   Title slide
C)   Slide master
D)   Last slideE) A) and B)
F) A) and C)

Question 16

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?

Accepted Answer

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.E) B) and C)
F) C) and D)

Exam 5: Generating Reports From Multiple Worksheets and Workbooks

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

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

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?

Correct Answer
verified

Exam 5: Generating Reports From Multiple Worksheets and Workbooks

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified