Module 5 Computer Concepts Exam

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

True

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? A. TIFF B. JPEG C. DOC D. GIF

B. JPEG

Big data is processed using relational databases. True False

False

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

A. M-commerce app

Simone frequently downloads mobile apps from the Amazon App Store. What operating system does she have on her smartphone? A. Blackberry B. Android C. iOS D. Windows

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

D. Apache OpenOffice

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

D. Header and Footer

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

C. Conditional formatting

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? A. Venmo B. Google Calendar C. Drop box D. Words with Friends

C. Drop box

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

D. Logo

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

True

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

B. Native app

A __________ is a named collection of formats you apply to text in a word processing document. A. template B. style C. heading D. orientation

B. style

How can you check data on devices connected through an IoT network? A. Use a desktop B. Use a server C. Use a tablet D. Use a network tracker

C. Use a tablet

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? A. Google photos B. Adobe Premiere Clip C. Audacity D. Adobe Photoshop

B. Adobe Premiere Clip

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.

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

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

A. Create trendlines

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

B. Drawing app

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? A. animations B. transitions C. videos D. sounds

B. transitions

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? A. Presentation B. Spreadsheet C. Word processor D. Messaging

C. Word processor

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. export data from other tables B. create queries to get relevant data C. close the databases D. publish queries and tables

A. export data from other tables

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? A. portable app B. mobile app C. productivity app installed on all devices D. web app

A. portable app

Paul has opened a bespoke tailoring shop. He wants to work online 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 suite should he consider? A. Prezi B. G suite C. OpenOffice D. Apple iWork

B. G suite

An organization has its employees working from home. Which type of software most likely includes collaboration features to help the employees work together online? A. Local apps B. Web apps C. Portable apps D. Device management apps

B. Web apps

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

A. 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? 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.

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

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.

B. Use cross-platform tools to write code that will translate the existing Android app code into different native formats.

Lauren wants to write short articles and post them online. 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

B. Zoho writer

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.

C. Choose specific transition effects and animations to allocate the kind of transition and time to each slide and object.

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.

C. Create a database of company projects, customers and vendors.

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.

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

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.

C. Make the program available as a web 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? A. First slide B. Title slide C. Slide master D. Last slide

C. Slide master

Samantha plans to self-publish her book on her website. Which of the following apps should she use to design the cover? A. video-editing app B. word processor C. graphics app D. spreadsheet

C. graphics app

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

D. A spreadsheet app to keep a record of her expenses, sort data, and make calculations