Question 1

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 2

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 is the most appropriate way to make objects and slides appear and disappear. This will allow Lauren to allocate the kind of transition and time to each slide and object, which can keep the audience engaged and interested in the presentation. Assigning specific instructions in slide master formatting or using hyperlinks may not look as smooth as using appropriate transition effects and animations, and using sound effects may be distracting and unnecessary.

Question 3

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

Pierre should use conditional formatting to highlight specific data according to his specifications. For example, he could highlight all marks below a certain threshold or all top-performing students. This feature allows him to easily see and analyze the data he needs. Sorting and filtering, run macros, and what-if analysis may also be helpful in certain situations, but they do not specifically address Pierre's need to highlight data.

Question 4

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 designed specifically to advance slides without having to click a button on the laptop. Laser pointers, smartphones, and styluses do not provide this function.

Question 5

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 and emphasize their importance in the thesis. However, defining a heading style could also be helpful in organizing and highlighting important sections of the thesis. Changing page margins, size, and orientation or adding hyperlinks to each keyword are not effective ways to emphasize keywords throughout the thesis.

Question 6

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 7

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

Headers and Footers can be used to add document titles at the top of each page.

Question 8

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 input different scenarios and see how they would affect her company's financials. She can test out different layoff scenarios and determine the optimal number of employees to let go based on her financial goals. VLOOKUP and pivot tables may be useful for analyzing employee salaries, but they do not directly address Debra's need to downsize. Relative referencing is a basic Excel feature for copying formulas and not applicable in this situation.

Question 9

Big data is processed using relational databases.

Accepted Answer

Big data is often too large and complex to be processed efficiently using traditional relational databases. Instead, specialized tools such as Hadoop, Spark, and NoSQL databases are used.

Question 10

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 use mathematical equations to define the shapes, lines, and curves that make up the image. This means that they can be scaled up or down without losing any quality or becoming blurry.

Question 11

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 12

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 as it allows for the creation of vector graphics which retain their quality at any size. Paint apps and photo editing apps are better suited for editing or manipulating existing images, while video editing apps are focused on creating videos rather than still images.

Question 13

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

Question 14

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 would allow for quick access to data and transparency in the transactions. It is a more advanced option than transferring records to spreadsheets or converting paper files to word documents, and it would be a more efficient solution than continuing with the old system.

Question 15

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 16

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 to type a report because it is designed for creating and editing documents, such as essays or reports. The other options are not suitable for this purpose: Presentation is for creating slideshows, Spreadsheet is for organizing and calculating data, and Messaging is for sending short messages between individuals.

Quiz 5: Generating Reports From Multiple Worksheets and Workbooks

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?

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?

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?

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

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?