Software and Apps

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

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

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.

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 is used to highlight cells that meet the specified criteria.

Local applications are installed on hard drives and they cannot be accessed on other computers.

Create a database of company projects, customers and vendors.

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

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

Local applications are installed on hard drives and they cannot be accessed on other computers.

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

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

True, embedded objects like menu commands and content placeholders can be added to presentation slides

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

Use a Tablet

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

Visual Basic

big data is processed using relational databases

false, big data is a large collection of data, usually unstructured, which cannot be processed using relational database model.

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?

make the program available as a web app

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

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

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

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

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?

Trendlines, also known as sparklines, are charts that simply and visually summarize changes in values over time with small graphs that appear in cells of the worksheet.

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

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