Question 1

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?
A) Make sure Miguel's credit card didn't expire.
B) Make sure the computer has an antivirus program.
C) Make sure the computer is connected to the Internet.
D) Make sure the app is installed.

Accepted Answer

Since the app's file is found in the Downloads folder, the next logical step would be to check if the app has been installed properly on the computer. Options A, B, and C are irrelevant to the issue at hand.

Question 2

How should you pay for Apache OpenOffice?
A) You pay nothing-it's free.
B) You pay a fee online to purchase the software, download it, and install it.
C) You pay an annual fee.
D) You pay a monthly subscription.

Accepted Answer

Apache OpenOffice is an open-source software, and it is available for free to download and use. There is no need to pay anything for Apache OpenOffice.

Question 3

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?
A) Sorting
B) Conditional formatting
C) Filtering
D) Font formatting

Accepted Answer

Conditional formatting allows for automatic highlighting of cells based on specific criteria, in this case, any week where the grocery expenses exceeded the budget. Sorting, filtering, and font formatting do not provide this functionality.

Question 4

How can you connect a portable keyboard with a smartphone?
A) Wi-Fi
B) Bluetooth
C) Internet
D) USB cable

Accepted Answer

The best way to connect a portable keyboard with a smartphone is through Bluetooth. Most portable keyboards come with Bluetooth compatibility, making it easy to connect them to a smartphone wirelessly. Wi-Fi, internet, and USB cable connections may also work, but they are not as convenient and require additional steps or equipment.

Question 5

Latonya wants to include a website link in her newsletter so readers can click the link and go straight to the website. What kind of formatting does she need to use?
A) Graphic
B) Mail Merge
C) Hyperlink
D) Footer

Accepted Answer

Latonya needs to use a hyperlink to create a clickable link that will take readers directly to the website.

Question 6

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?
A) Microsoft Office Online
B) G Suite
C) Apple iWork
D) Apache OpenOffice

Accepted Answer

Apple iWork is not natively compatible with Windows or ChromeOS, making it the least suitable option for a group with diverse operating systems.

Question 7

Skype is an app that allows you to make video calls to other Skype users. What type of app is Skype?
A) Communications app
B) Productivity app
C) Media app
D) Personal interest app

Accepted Answer

Skype is a communication app because its main purpose is to allow users to converse with each other through video calls.

Question 8

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?
A) HTML5
B) CSS
C) Swift
D) JavaScript

Accepted Answer

Swift is the primary programming language used for developing apps for Apple's App Store.

Question 9

Which of the following is a valid app source for Android users? Choose two.
A) Apple App Store
B) Google Play Store
C) Microsoft Store
D) Amazon App Store

Accepted Answer

The Google Play Store and Amazon App Store are both valid app sources for Android users. The Apple App Store is only for iOS devices and the Microsoft Store is for Windows devices.

Question 10

Lisa is hanging out at a coffee shop with her laptop to work on her research paper using Microsoft Office Online. What must she do before she starts working?
A) Plug her laptop power cord into a wall outlet
B) Install Microsoft Office Online
C) Save her document on a flash drive
D) Connect to the Internet

Accepted Answer

In order to use Microsoft Office Online, Lisa needs to be connected to the Internet. She does not need to plug in her power cord or save the document on a flash drive (although it is always a good idea to save frequently as a backup). Microsoft Office Online does not need to be installed as it is a web-based application.

Question 11

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?
A) Post her resumé online
B) Add clipart and photos
C) Use a template
D) Change the color, size, and fonts of her text

Accepted Answer

Using a template can help ensure that all important information is included and organized in a professional manner. Clipart and photos can come across as unprofessional and distracting. Changing the color, size, and fonts of the text should be done with caution to ensure readability and consistency. Posting the resumé online may be helpful for job applications, but does not necessarily make the resumé itself more professional.

Question 12

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.
A) ChromeOS
B) macOS
C) Windows
D) iOS

Accepted Answer

macOS and Windows both support the full, installed version of Microsoft Office, which is necessary for Ruthie's computer class requirements. ChromeOS and iOS do not support the full desktop version of Microsoft Office; they are more limited to web-based or mobile app versions.

Question 13

What feature will allow you to repeat steps automatically in a worksheet?
A) Formula
B) Pivot table
C) Macro
D) Conditional formatting

Accepted Answer

Macros are a feature in Excel that allow you to record a series of steps and automate them to repeat automatically. This can save time and reduce user error when performing repetitive tasks.

Question 14

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?
A) Make the font size bigger
B) Delete some slides
C) Change to slide show view
D) Use a different template

Accepted Answer

Changing to slide show view will make the text larger and remove the distracting thumbnails along the side of the screen. Marina can also use the arrow keys to navigate through her presentation instead of having the thumbnails visible. Making the font size bigger may help, but it may also make the slides look cluttered if there is too much information on them. Deleting slides is not a solution if all the information is important for the client to see. Using a different template is not necessary to solve this particular issue.

Question 15

Erin just bought a new coffee maker that she can control with Alexa to turn on automatically in the morning. She plugs the coffee maker into the wall outlet, but when she tells Alexa to turn it on, Alexa reports she can't find the coffee maker. What does Erin need to do so Alexa can find the coffee maker?
A) Connect the coffee maker to the Internet
B) Plug the coffee maker into a port on the Alexa device
C) Turn the coffee maker off and back on again
D) Buy a different coffee maker from Amazon

Accepted Answer

For Alexa to be able to control the coffee maker, it needs to be connected to the Internet. Erin can do this by following the coffee maker's instructions to connect it to her home Wi-Fi network.

Question 16

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?
A) Web app
B) App store
C) Native app
D) Portable app

Accepted Answer

The app named for the manufacturer of her phone is most likely a native app, which is designed specifically for the operating system of her phone.

Question 17

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?
A) Add highlighting to the title
B) Make the title font larger
C) Use a more rounded font for the title, such as Comic Sans MS
D) Use a different font color for the title

Accepted Answer

Making the title font larger will make it stand out more without compromising the consistency and professionalism of the paper. Using highlighting or a different font color may make the paper look unprofessional, while using a more rounded font like Comic Sans MS may not be appropriate for a biology paper.

Question 18

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?
A) Copy and paste
B) Themes
C) Animations
D) Slide master

Accepted Answer

The best option is to use the Slide Master feature to add the company logo to all the slides in the presentation. By doing so, Ashleigh can make global changes to the presentation's master slide without having to manually edit each slide. The Slide Master controls the overall layout and design of the presentation, and changes made to it affect all the slides in the presentation.

Question 19

Which kind of chart or graph would be best suited to illustrate how many students in a class made an A on their test?
A) Pie chart
B) Line graph
C) Column chart
D) Bar graph

Accepted Answer

The answer of Which kind of chart or graph would...

Question 20

Skyler needs to print mailing labels for a fundraising campaign her company is hosting. Which type of software should she use?
A) Spreadsheet
B) Email
C) Presentation
D) Word processing

Accepted Answer

Word processing software, such as Microsoft Word, is commonly used for creating mailing labels. It allows users to easily create and format labels with names and addresses, as well as print them on adhesive label paper.

Quiz 5: Generating Reports From Multiple Worksheets and Workbooks

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?

How should you pay for Apache OpenOffice?

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?

How can you connect a portable keyboard with a smartphone?

Latonya wants to include a website link in her newsletter so readers can click the link and go straight to the website. What kind of formatting does she need to use?

Skype is an app that allows you to make video calls to other Skype users. What type of app is Skype?

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?

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

Lisa is hanging out at a coffee shop with her laptop to work on her research paper using Microsoft Office Online. What must she do before she starts working?

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?

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.

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

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?

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?

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?

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

Skyler needs to print mailing labels for a fundraising campaign her company is hosting. Which type of software should she use?