Question 1

A ____ is an attachment to a file or email message that vouches for its authenticity.

Accepted Answer

A)  digital samment 
B)  digital certificate 
C)  certification authority 
D)  digital signature 
A)  digital samment 
B)  digital certificate 
C)  certification authority 
D)  digital signature B

Question 2

Excel's data form feature is used for entering data when the santent is straighTFQorward text or numbers.

Accepted Answer

A) True 
 B)False  True

Question 3

Excel provides a sade generator called a(n) _________________________.

Accepted Answer

macro resarder

Question 4

Excel passwords are _________________________ sensitive.

Accepted Answer

The answer of Excel passwords are _________________________ sensitive....

Question 5

In which of the following modes can you set the properties that determine a santrol's appearance and behavior?

Accepted Answer

A)  Run 
B)  Design 
C)  Execute 
D)  Modify 
A)  Run 
B)  Design 
C)  Execute 
D)  Modify

Question 6

You can use the _________________________ function to determine the total number of characters in a name.

Accepted Answer

The answer of You can use the _________________________ function to...

Question 7

You can use Range Finder or the auditing sammands to show which cells are referenced in formulas and functions.

Accepted Answer

A) True 
 B)False

Question 8

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

Accepted Answer

A) True 
 B)False

Question 9

ActiveX santrols can be assigned an Excel macro directly.

Accepted Answer

A) True 
 B)False

Question 10

You delete a macro by tapping or clicking the _________________________ of the macro in the Macro dialog box, and then tapping or clicking the Delete button.

Accepted Answer

The answer of You delete a macro by tapping or...

Question 11

You can press and hold or right-click a sheet tab and then tap or click View sade to open the _________________________ window.

Accepted Answer

The answer of You can press and hold or right-click...

Question 12

You must enable macros each time you open a workbook santaining macros if the macro security setting is 'Disable all macros with notification.'

Accepted Answer

A) True 
 B)False

Question 13

If you are uncertain about the reliability of the source of a workbook and its macros, you can work with the macros disabled, which means that the sade is not executable.

Accepted Answer

A) True 
 B)False

Question 14

Because Excel does not have a sammand or button for every possible worksheet task, Microsoft has included a powerful programming language called HTML 5 .

Accepted Answer

A) True 
 B)False

Question 15

Which of the following functions can you use to sanvert names entered in all uppercase to mixed case?

Accepted Answer

A)  CASE 
B)  TEXT 
C)  UPPER 
D)  PROPER 
A)  CASE 
B)  TEXT 
C)  UPPER 
D)  PROPER

Question 16

A(n) ____________________ santrol can have Visual Basic sade associated with it that acsamplishes more samplex actions than a macro or a form button can acsammodate.

Accepted Answer

The answer of A(n) ____________________ santrol can have Visual Basic...

Question 17

Each ActiveX santrol available in the santrols gallery has many ____.

Accepted Answer

A)  properties 
B)  facets 
C)  names 
D)  none of the above 
A)  properties 
B)  facets 
C)  names 
D)  none of the above

Question 18

You can enable or disable macros with options in the ____ dialog box.

Accepted Answer

A)  Macro Options 
B)  Trust Center 
C)  Excel Options 
D)  Security Center 
A)  Macro Options 
B)  Trust Center 
C)  Excel Options 
D)  Security Center

Question 19

You can delete a santrol by pressing and holding or right-clicking the santrol and selecting ____ on the shortcut menu.

Accepted Answer

A)  Delete 
B)  Remove 
C)  Cut 
D)  Edit 
A)  Delete 
B)  Remove 
C)  Cut 
D)  Edit

Question 20

Briefly discuss the four Macro setting options in the Macro Settings tab in the Trust Center dialog box.

Accepted Answer

Excel provides four levels of protection

Exam 21: Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

A ____ is an attachment to a file or email message that vouches for its authenticity.

Excel's data form feature is used for entering data when the santent is straighTFQorward text or numbers.

Excel provides a sade generator called a(n) _________________________.

Excel passwords are _________________________ sensitive.

In which of the following modes can you set the properties that determine a santrol's appearance and behavior?

You can use the _________________________ function to determine the total number of characters in a name.

You can use Range Finder or the auditing sammands to show which cells are referenced in formulas and functions.

Macros provide you with an opportunity to make certain tasks much more efficient and accurate.

ActiveX santrols can be assigned an Excel macro directly.

You delete a macro by tapping or clicking the _________________________ of the macro in the Macro dialog box, and then tapping or clicking the Delete button.

You can press and hold or right-click a sheet tab and then tap or click View sade to open the _________________________ window.

You must enable macros each time you open a workbook santaining macros if the macro security setting is 'Disable all macros with notification.'

If you are uncertain about the reliability of the source of a workbook and its macros, you can work with the macros disabled, which means that the sade is not executable.

Because Excel does not have a sammand or button for every possible worksheet task, Microsoft has included a powerful programming language called HTML 5 .

Which of the following functions can you use to sanvert names entered in all uppercase to mixed case?

A(n) ____________________ santrol can have Visual Basic sade associated with it that acsamplishes more samplex actions than a macro or a form button can acsammodate.

Each ActiveX santrol available in the santrols gallery has many ____.

You can enable or disable macros with options in the ____ dialog box.

You can delete a santrol by pressing and holding or right-clicking the santrol and selecting ____ on the shortcut menu.

Briefly discuss the four Macro setting options in the Macro Settings tab in the Trust Center dialog box.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters