Question 1

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.

Accepted Answer

Choosing specific transition effects and animations can help allocate the kind of transition and time for each slide and object, creating the appearance and disappearance effect that Lauren wants to achieve. This option is also easier to control and customize compared to assigning specific instructions in slide master formatting or using hyperlinks. Sound effects can also enhance the presentation, but it is not necessary for making objects and slides appear and disappear.

Question 2

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 3

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 will make them stand out in the thesis without disturbing the overall flow and structure of the document. Defining a heading style is useful for creating a table of contents, but it does not emphasize specific keywords throughout the text. Changing page margins, size, and orientation would not effectively emphasize the keywords. Adding hyperlinks for each keyword is unnecessary and would not be relevant to a printed report.

Question 4

Rafael has to type a report about class trip to the museum.Which of the following types of apps should he use to type the report?
A) Presentation
B) Spreadsheet
C) Word processor
D) Messaging

Accepted Answer

Rafael should use a word processor app to type the report as it is specifically designed for creating written documents.

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

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

Accepted Answer

The answer of Paul has opened a bespoke tailoring shop.He...

Question 7

dLucy 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) FilmoraGo

Accepted Answer

Adobe Premiere Clip and FilmoraGo are both video editing apps that allow users to mix and match video clips, making them suitable for Lucy's needs to edit her marketing videos for her podcast.

Question 8

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

Accepted Answer

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

Question 9

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 10

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) Create queries to get relevant data
B) Specify layout and format
C) Establish relationship between data
D) Add data to the report by running it

Accepted Answer

The answer of Sean works for an organization that offers...

Question 11

Which of the following devices can be used to advance slides without having to click a button on the laptop?
A) Laser pointer
B) Wireless remote control
C) Smartphone
D) Stylus

Accepted Answer

A wireless remote control is specifically designed to advance slides without having to click a button on the laptop, making it the best choice for this scenario. A laser pointer, smartphone, and stylus do not typically have this feature.

Question 12

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 13

Sammy created a new logo for his client to be used on the company website as well as office stationary.However,it became an almost invisible 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 in 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 are created using mathematical formulas to create shapes and lines rather than pixels. This makes them infinitely scalable without any loss in quality. Therefore, using vector images will prevent the logo from becoming an almost invisible blur when enlarged for use on a billboard ad.

Question 14

Rohan has to create a presentation out of his thesis summary.He expects the presentation to have at least 50 slides.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 in presentation software like PowerPoint allows for the uniform design of all slides, including fonts, colors, layouts, and backgrounds. Starting with the Slide Master ensures consistency throughout the presentation, making it a logical first step before individual slides like the title or first slide are designed.

Question 15

Debra launched her start-up in 2016.After 2 continuous years of losses,she needs to now downsize.She has salary details of all employees in a spreadsheet report.Which of the following features should she use to decide how many people to layoff,and who?
A) VLOOKUP
B) What-if analysis
C) Pivot table
D) Relative referencing

Accepted Answer

What-if analysis allows Debra to create different scenario models to see how layoffs will affect the financials of the company. She can adjust variables such as number of employees, salaries and benefits to come up with the best possible solution. VLOOKUP and Pivot table will not provide information on how downsizing affects the financials of the company. Relative referencing is a basic feature used to copy formulas and will not help in this scenario.

Question 16

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.

Quiz 5: Generating Reports From Multiple Worksheets and Workbooks

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?

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?

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

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 keep a database of all his customers,send e-mails when garments are ready,create designs,and maintain financial records using software.Which productivity suites should he consider?

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

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?

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?

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?

Which of the following devices can be used to advance slides without having to click a button on the laptop?

Big data is processed using relational databases.

Sammy created a new logo for his client to be used on the company website as well as office stationary.However,it became an almost invisible 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 in future?

Rohan has to create a presentation out of his thesis summary.He expects the presentation to have at least 50 slides.Which of the following parts of the presentation should he design first?

Debra launched her start-up in 2016.After 2 continuous years of losses,she needs to now downsize.She has salary details of all employees in a spreadsheet report.Which of the following features should she use to decide how many people to layoff,and who?

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?