Question 1

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 can help emphasize them throughout the thesis. Headings and hyperlinks may also be useful for organization and navigation, but they do not necessarily emphasize specific words or ideas. Changing margins, size, and orientation may affect the overall layout and appearance of the thesis, but they do not necessarily emphasize keywords.

Question 2

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 provides a range of online tools including Gmail (for sending e-mails), Google Drive (for storing data), Google Sheets (for managing financial records), and Google Slides (for creating designs and presentations). It also offers a customer relationship management tool, Google Contacts, that can help Paul keep a database of all his customers.

Question 3

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 slides and their objects appear and disappear. Hyperlinks allow linking to external sources or slides within the presentation. Applying a new theme will change the overall look of the presentation but won't affect object appearance. SmartArt is a graphic visual representation of information and won't affect object appearance either.

Question 4

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

Accepted Answer

The best option for Anusha to keep a record of her expenses and make calculations is a spreadsheet app. A spreadsheet app like Microsoft Excel or Google Sheets allows her to input her expenses, categorize them, sort them, and make calculations like sum, average, and total expenditure easily.

Question 5

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 set specific rules and criteria for highlighting data in his spreadsheet based on his specifications. He can color code cells, change font styles, and apply other formatting options to make the data more visually organized and easier to read. Sorting and filtering, running macros, and what-if analysis are unrelated features that wouldn't help Pierre achieve his goal of highlighting data according to his specific requirements.

Question 6

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

A drawing app would be the best choice for creating digital artwork that retains its quality in all sizes. Drawing apps allow for more precise and detailed work, and the images created can be easily scaled up or down without losing quality. Paint apps are more basic and have limited tools, photo editing apps are more for enhancing existing images, and video editing apps are for creating and editing video content.

Question 7

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

Accepted Answer

Transitions allow for a visual effect when moving from one slide to another, making the presentation more engaging and keeping the audience's attention. Animations can also enhance the visual appeal but they are specific to individual elements on a slide and may not have the same impact as the overall transition effect. Videos and sounds can be beneficial in some presentations, but they may not be appropriate or necessary for all topics.

Question 8

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.

Accepted Answer

A word processor is ideal for creating and managing lists (step 1), graphics software is suited for designing cards (step 2), and a mail merge combines the list with the design for personalization (step 3).

Question 9

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

Accepted Answer

The answer of Lauren wants to write short articles and...

Question 10

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 allows you to create different scenarios and see how they would affect your profits. Debra can input different price increases and see the resulting profit changes without actually implementing the price hike.

Question 11

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

Header and Footer feature allows adding a document title at the top or bottom of each page.

Question 12

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

Designing the slide master first will ensure consistency throughout the presentation. The slide master controls the overall layout, formatting, and design of the presentation. Once the slide master is created, it will be applied to all subsequent slides, making it easier for Rohan to complete the rest of the presentation.

Question 13

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

Rafael should use a word processor to write a report as it is specifically designed for writing and formatting text. Presentation is for creating slides for a presentation, Spreadsheet is for organizing and analyzing data, and Messaging is for sending short messages to communicate with others.

Question 14

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 database management program called Base, which would allow Sean to become familiar with database software without having to purchase any expensive software. The other options do not come with a database program.

Question 15

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 of company projects, customers, and vendors is the best option to establish a system where any data can be looked up immediately and transparency can be maintained. Spreadsheets and Word documents can be useful, but a database provides a more comprehensive and organized way to store and manage data. Continuing with the old paper-based system will not allow for quick access to data, and transparency can be compromised.

Question 16

Big data is processed using relational databases.

Accepted Answer

While relational databases can be used to process some types of big data, they are not always the most efficient or effective solution. Other technologies such as NoSQL databases, Hadoop, and Spark are often better suited for handling large datasets.

Question 17

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 you can apply to text in a word processing document. It allows you to consistently format and apply design elements such as font, size, color, spacing, and alignment to text throughout a document. Templates are pre-designed documents with placeholders for content, headings refer to a specific level of text formatting, and orientation refers to the landscape or portrait layout of a document.

Question 18

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 extract the data from the database to find instances of failed billing transactions. Therefore, he needs to work with the database. The other options - speech recognition, presentation, and desktop publishing - are not relevant to the task at hand.

Question 19

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

Accepted Answer

Samantha should use a graphics app to design the cover of her book. A graphics app like Adobe Photoshop or Canva will give her the necessary tools to create a visually appealing and professional-looking cover. A video-editing app, word processor, or spreadsheet won't provide the necessary design capabilities.

Question 20

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

Quiz 7: Technology and IT: From CAM to IoT and Digital Citizenship

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?

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?

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?

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?

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?

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?

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?

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

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?

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?

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?

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?

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?

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?

Big data is processed using relational databases.

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

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?

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

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?