Question 1

In VBA procedures the ____ are used if you want to include any arguments in the procedure.

Accepted Answer

A) underscores 
B) brackets 
C) braces 
D) parentheses 
A) underscores 
B) brackets 
C) braces 
D) parentheses

Question 2

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names.

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: Needed before you can add a digital signature to a workbook

Accepted Answer

The Answer of input message and Information and Excel application is...

Question 4

Excel supports ____ types of error alerts.

Accepted Answer

A) two 
B) three 
C) six 
D) eleven 
A) two 
B) three 
C) six 
D) eleven

Question 5

You can use the Name Manager dialog box to create a defined name like the one shown in the accompanying figure.

Accepted Answer

A) True 
 B)False

Question 6

Usually you will want to protect a worksheet but leave some cells ____.

Accepted Answer

A) open 
B) empty 
C) clear 
D) unlocked 
A) open 
B) empty 
C) clear 
D) unlocked

Question 7

After the comments in VBA code is the ____ of the macro.

Accepted Answer

A) module 
B) body 
C) procedure 
D) command 
A) module 
B) body 
C) procedure 
D) command

Question 8

Match between columns
                        Premises: Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell

Accepted Answer

The Answer of defined name and Excel application and VBA is...

Question 9

A range name is more descriptive than a(n)cell reference .

Accepted Answer

A) True 
 B)False

Question 10

When you ____________________ a workbook you control the ability users have to make changes to the file.

Accepted Answer

The answer of When you ____________________ a workbook you control...

Question 11

You drag the comment s border to resize a comment box like the one shown in the accompanying figure.

Accepted Answer

A) True 
 B)False

Question 12

Protecting the structure of a workbook prohibits users from ____ worksheets.

Accepted Answer

A) inserting 
B) hiding 
C) deleting 
D) all of the above 
A) inserting 
B) hiding 
C) deleting 
D) all of the above

Question 13

Click the New button in the accompanying figure to open the ____ dialog box.

Accepted Answer

A) Name 
B) New Name 
C) Edit Name 
D) Define Name 
A) Name 
B) New Name 
C) Edit Name 
D) Define Name

Question 14

You use the ____ tab in the Data Validation dialog box to enter the validation rules for the active cell.

Accepted Answer

A) Active Cell 
B) Rules 
C) Settings 
D) Input Message 
A) Active Cell 
B) Rules 
C) Settings 
D) Input Message

Question 15

When Excel creates a macro button the Assign Macro dialog box opens with the button's default name showing.

Accepted Answer

A) True 
 B)False

Question 16

The name of the active cell in the accompanying figure is ____.

Accepted Answer

A) ParkingFee 
B) HandlingCost 
C) Series 
D) Donation 
A) ParkingFee 
B) HandlingCost 
C) Series 
D) Donation

Question 17

After the Stop alert the next alert in severity is the ____ alert.

Accepted Answer

A) Information 
B) Security 
C) Validation 
D) Warning 
A) Information 
B) Security 
C) Validation 
D) Warning

In VBA procedures the ____ are used if you want to include any arguments in the procedure.

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names.

Excel supports ____ types of error alerts.

You can use the Name Manager dialog box to create a defined name like the one shown in the accompanying figure.

Usually you will want to protect a worksheet but leave some cells ____.

After the comments in VBA code is the ____ of the macro.

A range name is more descriptive than a(n)cell reference .

When you ____________________ a workbook you control the ability users have to make changes to the file.

You drag the comment s border to resize a comment box like the one shown in the accompanying figure.

Protecting the structure of a workbook prohibits users from ____ worksheets.

Click the New button in the accompanying figure to open the ____ dialog box.

You use the ____ tab in the Data Validation dialog box to enter the validation rules for the active cell.

When Excel creates a macro button the Assign Macro dialog box opens with the button's default name showing.

The name of the active cell in the accompanying figure is ____.

After the Stop alert the next alert in severity is the ____ alert.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing Integrating and Analyzing Data

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters

Exam 8: Excel: Developing an Excel Application

In VBA procedures the ____ are used if you want to include any arguments in the procedure.

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names.

Excel supports ____ types of error alerts.

You can use the Name Manager dialog box to create a defined name like the one shown in the accompanying figure.

Usually you will want to protect a worksheet but leave some cells ____.

After the comments in VBA code is the ____ of the macro.

A range name is more descriptive than a(n)cell reference .

When you ____________________ a workbook you control the ability users have to make changes to the file.

You drag the comment s border to resize a comment box like the one shown in the accompanying figure.

Protecting the structure of a workbook prohibits users from ____ worksheets.

Click the New button in the accompanying figure to open the ____ dialog box.

You use the ____ tab in the Data Validation dialog box to enter the validation rules for the active cell.

When Excel creates a macro button the Assign Macro dialog box opens with the button's default name showing.

The name of the active cell in the accompanying figure is ____.

After the Stop alert the next alert in severity is the ____ alert.

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing Integrating and Analyzing Data

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters