Deck 5: Generating Reports From Multiple Worksheets and Workbooks

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.

Answer 1

D

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.

Answer 2

A

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

Answer 3

B

Question 4

How can you connect a portable keyboard with a smartphone?

A) Wi-Fi
B) Bluetooth
C) Internet
D) USB cable

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

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

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

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

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

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

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

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

Question 13

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

A) Formula
B) Pivot table
C) Macro
D) Conditional formatting

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

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

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

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

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

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

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

Question 21

Shelle wants to design her database so it's easy for the receptionist or another assistant to enter client information. What object should she create to accomplish this goal?

A) Report
B) Form
C) Query
D) Table

Question 22

Lucas is looking for a photo from a recent beach trip to add to his presentation. The photo is saved in a folder with many other kinds of graphics and images. What file format should Lucas look for to find his photo?

A) Bitmap
B) PNG
C) JPEG
D) GIF

Question 23

Nicholas is complaining there's not enough space on his slides to include all the text he needs. What advice should you give him to solve this problem?

A) Show him how to change the orientation of his slides.
B) Help him find a smaller font size that fits.
C) Show him how to add transitions so the text can flow to the next slide.
D) Suggest that he use less text and stick to the main points.

Question 24

What kind of data is appropriate for a field containing street addresses?

A) Text
B) Number
C) Attachment
D) Hyperlink

Question 25

Jasmine needs to crop a group photo to show only her face so she can use it as a headshot for a job application. Which of these programs is the best fit for this task?

A) Microsoft Paint
B) Audacity
C) Adobe Photoshop
D) FilmoraGo