Exam 2

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 spreadsheet app to keep a record of her expenses, sort data, and make calculations

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

Android

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?

Apache OpenOffice

How can you connect a portable keyboard with a smartphone?

Bluetooth

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?

Change font size, style, and color of the keywords.

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

Communications app

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?

Conditional formatting

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?

Conditional formatting

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?

Create a database of company projects, customers and vendors.

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?

Drawing app

Big data is processed using relational databases.

False

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?

sparklines

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?

Form

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

Google Play Store

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?

Header and Footer

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?

Hyperlink

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

JPEG

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?

M-commerce app

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?

Make sure the app is installed.

Marcie is finishing her research paper for biology class and asks for feedback from her roommate, Robin, on how it looks. Robin says has trouble finding the title of the paper. How can Marcie make the title stand out while maintaining consistency and a professional look to the paper?

Make the title font larger.

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?

Native app

A _____ is a named collection of formats you apply to text in a word processing document.

Style

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?

Suggest that he use less text and stick to the main points.

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?

Swift

_____ are collections of records for a single subject, such as customer records, and store all the data in a database.

Tables

Each slide in a presentation has a layout that includes placeholders for certain types of content.

True

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

Use a tablet

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?

Use a template

Rob is planning his housewarming party. He wants to design an invitation and personalize it for each invitee. He needs to create a list of invitees, design the card, and personalize the card. How should he complete the tasks?

Use a word processor for step 1, graphics software for step 2, and a mail merge for step 3.

Sammy created a new logo for his client to use on the company website and office stationery. However, the logo became a 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 problem in the future?

Use vector images because they retain their clarity even when enlarged or shrunk.

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

Visual Basic

An organization has its employees working from home. Which type of software most likely includes collaboration features to help the employees work together online?

Web apps

Debra tracks her business finances in a spreadsheet. She wants to figure out how much she could increase profits if she raises prices on some products. What feature should she use to find the answer?

What-if analysis

Ruthie needs to buy a new laptop for her college courses. One course requires her to use the full, installed version of Microsoft Office. Which operating systems should she choose for the laptop?

Windows

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

Word processing

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

Word processor

How do you pay for Apache OpenOffice?

You pay nothing—it's free.

Lauren wants to write short articles and post them online. If she has an Internet connection, what software can help her do her work?

Zoho writer

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?

database

Abe is creating a presentation and wants to grab the audience's attention with a visual effect when he moves from one slide to another. What should he add to the presentation?

videos

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?

Adobe Photoshop

Marina is giving a presentation to a client about real estate the client is interested in buying. However, the text on the slides is small, and thumbnails of the slides appear along the side of the screen, which is distracting. How can Marina fix this problem?

Change to slide show view.

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?

Connect to the Internet

Patricia has started a new interior design business, and wants to store designs in the cloud so her clients can review them. Which of the following apps should she use for cloud storage?

Drop box

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?

JPEG

What feature allows you to repeat steps automatically in a worksheet?

Macro

Erin is planning to develop an online app that users can access using any type of Apple device, including iPads and iPhones. Which app development trend should Eric learn about before she starts?

Mobile first design

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?

Native app

Rohan is creating a presentation with at least 50 slides. He wants the slides to use a consistent layout and formatting. Which of the following parts of the presentation should he design first?

Slide master

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

True

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?

Use animations

Samantha plans to self-publish her book on her website. Which of the following apps should she use to design the cover?

graphics app

Martha has been appointed as the Data Security Manager of her organization. The company wants her to develop a customized app to remove viruses from the infected systems without connecting to the network. What type of app should she focus on developing?

portable app

Lucy 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?

Adobe Premiere Clip

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?

Apple iWork

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?

It should have responsive design so that it is easy to use on mobile devices.