Question 1

Big data is processed using relational databases.

Accepted Answer

While relational databases can handle certain aspects of big data, such as structured data, big data often requires specialized processing tools such as Hadoop or NoSQL databases.

Question 2

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

Accepted Answer

The Header and Footer feature allows the user to insert a title or document name at the top of each page. The other options (Heading style, Page margin, References) do not directly relate to adding a document title at the top of each page.

Question 3

To protect your information and help you to remember passwords, use your social media account login information to log into another site.

Accepted Answer

It is not recommended to use your social media account login information to log into other sites, as this can make your information more vulnerable to hacking or data breaches. It is generally safer to create unique, complex passwords for each individual site or app that you use. Additionally, using a password manager or other secure means of storing and managing passwords can help you to remember them without compromising your security.

Question 4

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

Accepted Answer

The slide master is where the overall layout and formatting for the presentation is set. Designing the slide master first will ensure consistency throughout the entire presentation.

Question 5

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

Accepted Answer

Remus should use a drawing app as it will allow him to create vector images that can retain their quality in all sizes. Paint and photo editing apps are better suited for editing images, while video editing apps are for creating and editing videos, not still images.

Question 6

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.

Accepted Answer

Changing the font size, style, and color of the keywords is the best way to emphasize them in the thesis report. This will make the keywords stand out and catch the reader's attention. Option B defines a heading style, which is not necessarily relevant to emphasizing keywords. Option C changes page formatting, which is not directly related to emphasizing specific words. Option D involves adding hyperlinks, which is not necessary for emphasizing keywords in a thesis report.

Question 7

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

Accepted Answer

Adobe Premiere Clip is a mobile video editing app that allows users to mix and match video clips, add music and transitions, and fine-tune their edits. It's a great choice for creating and editing videos on the go.

Question 8

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.

Accepted Answer

Vector images use mathematical equations to create images, so they can be enlarged or shrunk without losing their clarity. This is the best option to avoid blurring when enlarging logos or other graphics.

Question 9

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

Accepted Answer

A word processor is the best choice for writing a report, as it is specifically designed for creating and editing text documents. Presentation and spreadsheet apps are better suited for creating presentations or organizing data, while messaging apps are not suitable for creating a report.

Question 10

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

Accepted Answer

A style is a named collection of formats that can be applied to text in a word processing document, such as font size, font color, and paragraph spacing. A template is a pre-designed document that includes formatting and placeholders for text and images. Headings are pre-defined text styles that are used to create hierarchical organization within a document. Orientation refers to the orientation of the page layout, such as landscape or portrait.

Question 11

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

Accepted Answer

Conditional formatting allows Pierre to apply specific formatting to cells based on their contents. He can set rules for highlighting data that meet certain criteria, such as marking all students who scored below a certain grade in red. Sorting and filtering would only rearrange the data and not highlight it, while running macros and what-if analysis are not relevant to Pierre's specifications in this scenario.

Question 12

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

Accepted Answer

G suite is the most suitable productivity suite for Paul's requirements as it includes email, cloud storage, and collaboration tools to maintain a database of customers. It also has Google Sheets which can be used to maintain financial records and Google Forms which can be used to create designs. Additionally, it allows integration with third-party apps for more tailored solutions.

Question 13

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) Use animations
B) Insert hyperlinks
C) Apply a new theme
D) Add SmartArt

Accepted Answer

Using animations can make the presentation more interactive and visually appealing by making objects appear and disappear. This can help to keep the audience engaged and focused on the content.

Question 14

How can you protect personal information gathered by legitimate organizations?
A) Link your credit or debit card to your online accounts.
B) Use the same password and username for all your online accounts.
C) Sign up for many online mailing lists.
D) Create a separate email account for receiving information from websites.

Accepted Answer

Creating a separate email account for receiving information from websites can help protect personal information by keeping it separate from personal and work emails. This can reduce the amount of spam and phishing attempts that could lead to a breach of personal information. It is important to have unique and strong passwords for each account and to avoid linking credit or debit cards to online accounts. Signing up for many online mailing lists can also increase the likelihood of spam and phishing attempts.

Question 15

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

Accepted Answer

Apache OpenOffice includes a program called Base, which is a database management system. It is available for free download and can be used to familiarize oneself with database software.

Question 16

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?
A) VLOOKUP
B) What-if analysis
C) Pivot table
D) Relative referencing

Accepted Answer

What-If Analysis is a feature in Excel that helps to answer hypothetical questions about the data by changing one or more inputs, and observing the impact on the results. In this case, Debra can use the Goal Seek function in What-If Analysis to determine the ideal price increase that would maximize profits.

Question 17

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) sparklines
B) filters
C) pivot tables
D) conditional formatting

Accepted Answer

The answer of Fiona is responsible for presenting data at...

Question 18

How does discarding computers in a landfill affect the environment?
A) Data miners are digging up landfills looking for gold and platinum.
B) Lead and mercury in computer parts are seeping into the ground and water supply.
C) Copper on circuit boards is creating fire hazards.
D) The computer parts quickly decay and become organic material

Accepted Answer

Discarding computers in a landfill can release toxic materials such as lead and mercury into the environment, which can seep into the ground and water supply. This can have negative impacts on both human health and the environment.

Question 19

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.

Accepted Answer

Creating a database that includes information on company projects, customers, and vendors would be the best choice because it would allow for easy access to all data and would promote transparency. This system could also potentially streamline the business's operations and increase efficiency. Transferring records to spreadsheets or converting files to Word documents could be helpful, but database software specifically designed for business management would offer the most comprehensive and user-friendly system. Continuing with the old system would not promote transparency and could potentially hinder the business's growth and success.

Question 20

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) speech recognition
B) database
C) presentation
D) desktop publishing

Accepted Answer

Sean needs to access the database to retrieve the necessary information on failed billing transactions.

Quiz 7: Computer History and Components

Big data is processed using relational databases.

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?

To protect your information and help you to remember passwords, use your social media account login information to log into another site.

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?

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?

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?

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?

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?

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 _____ is a named collection of formats you apply to text in a word processing document.

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?

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?

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?

How can you protect personal information gathered by legitimate organizations?

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?

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?

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?

How does discarding computers in a landfill affect the environment?

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?

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?