Question 1

Menu items can be inserted into a presentation.

Accepted Answer

A) True 
 B)False

Question 2

Martha has been appointed as the Data Security Manager of her organization.The company wants her to have a customized app created that can be used to remove viruses from the infected systems without connecting to the network.What type of app should she focus on getting developed?

Accepted Answer

A)  A device management portable app 
B)  A device management mobile app 
C)  A productivity app that is installed on all the devices 
D)  An educational app accessible through browser 
A)  A device management portable app 
B)  A device management mobile app 
C)  A productivity app that is installed on all the devices 
D)  An educational app accessible through browser

Question 3

Shania has started a new job as an app developer.Her first task was to make an old app designed for Android available on other platforms.Which of the following would make her job easiest and fastest?

Accepted Answer

A)  Develop different versions of the same app for different programs. 
B)  Use cross-platform tools to write code that will translate the existing Android app code into different native formats. 
C)  Feed the existing code into cross-platform tools to develop different versions of the same app. 
D)  Use the same set of codes for different platforms. 
A)  Develop different versions of the same app for different programs. 
B)  Use cross-platform tools to write code that will translate the existing Android app code into different native formats. 
C)  Feed the existing code into cross-platform tools to develop different versions of the same app. 
D)  Use the same set of codes for different platforms.

Question 4

Big data is processed using relational databases.

Accepted Answer

A) True 
 B)False

Question 5

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?

Accepted Answer

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

Question 6

Jamie plans to sell his pottery designs through his website.If he also wants to launch a mobile app to reach more people,which type of app should he launch?

Accepted Answer

A)  M-commerce app 
B)  Banking and finance app 
C)  Photo editing app 
D)  Social media app 
A)  M-commerce app 
B)  Banking and finance app 
C)  Photo editing app 
D)  Social media app

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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?

Accepted Answer

A)  First slide 
B)  Title slide 
C)  Slide master 
D)  Last slide 
A)  First slide 
B)  Title slide 
C)  Slide master 
D)  Last slide

Question 9

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?

Accepted Answer

A)  Sorting and filtering 
B)  Run macros 
C)  Conditional formatting 
D)  What-if analysis 
A)  Sorting and filtering 
B)  Run macros 
C)  Conditional formatting 
D)  What-if analysis

Question 10

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?

Accepted Answer

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

Question 11

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

Accepted Answer

A)  Laser pointer 
B)  Wireless remote control 
C)  Smartphone 
D)  Stylus 
A)  Laser pointer 
B)  Wireless remote control 
C)  Smartphone 
D)  Stylus

Question 12

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?

Accepted Answer

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

Menu items can be inserted into a presentation.

Martha has been appointed as the Data Security Manager of her organization.The company wants her to have a customized app created that can be used to remove viruses from the infected systems without connecting to the network.What type of app should she focus on getting developed?

Shania has started a new job as an app developer.Her first task was to make an old app designed for Android available on other platforms.Which of the following would make her job easiest and fastest?

Big data is processed using relational databases.

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?

Jamie plans to sell his pottery designs through his website.If he also wants to launch a mobile app to reach more people,which type of app should he launch?

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

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?

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?

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?

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

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?

Creating a Worksheet and a Chart

Formulas, functions, and Formatting

Working With Large Worksheets, charting, and What-If Analysis

Financial Functions, data Tables, and Amortization Schedules

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Post-Assessment

Pre-Assessment

Filters

Exam 5: Working With Multiple Worksheets and Workbooks

Menu items can be inserted into a presentation.

Martha has been appointed as the Data Security Manager of her organization.The company wants her to have a customized app created that can be used to remove viruses from the infected systems without connecting to the network.What type of app should she focus on getting developed?

Shania has started a new job as an app developer.Her first task was to make an old app designed for Android available on other platforms.Which of the following would make her job easiest and fastest?

Big data is processed using relational databases.

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?

Jamie plans to sell his pottery designs through his website.If he also wants to launch a mobile app to reach more people,which type of app should he launch?

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

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?

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?

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?

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

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?

Creating a Worksheet and a Chart

Formulas, functions, and Formatting

Working With Large Worksheets, charting, and What-If Analysis

Financial Functions, data Tables, and Amortization Schedules

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Post-Assessment

Pre-Assessment

Filters