Deck 8: Excel: Developing an Excel Application

Question 1

By default a macro will select the same cells regardless of which cell is first selected because the macro records a selection using relative cell references.

Answer 1

False

Question 2

You can allow users to insert new rows or columns into a sheet even if the sheet is protected.

Answer 2

True

Question 3

The red triangle in the accompanying figure indicates that a given cell does not have a comment.

Answer 3

False

Question 4

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

Question 5

For cell and range names names of 25 to 50 characters are considered practical although names can be up to 255 characters.

Question 6

You cannot prevent users from changing all of the formulas in a worksheet.

Question 7

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

Question 8

You can keep users from deleting worksheets or inserting new ones.

Question 9

Each cell can have at most three validation rules.

Question 10

Once you protect a worksheet the locked property is enabled and controls whether or not a cell can be edited.

Question 11

Even if a sheet is protected you can limit the user to selecting only unlocked cells or allow the user to select any cell in the worksheet.

Question 12

When you open a file with macros the response you see is based on the security level set on the computer.

Question 13

Data validation can verify data that was entered into a worksheet before the validation criteria were applied.

Question 14

To move the box you would drag the selection handle of the comment in the accompanying figure.

Question 15

Each macro must have a unique name.

Question 16

Even when the worksheet is unprotected the locked property determines whether or not changes can be made to a given cell.

Question 17

If you change the definition of a range name pointing it to a different range the value of any formula using that range name will be updated automatically to reflect the new definition.

Question 18

Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.

Question 19

The frequency of error alert determines what choices the user is presented with when an invalid entry is attempted.

Question 20

Defined names are automatically substituted for the cell addresses in a formula.

Question 21

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

Question 22

If you select the Custom option in the Allow list box in the Data Validation dialog box the validation rule will be based on an Excel logistical formula.

Question 23

To open the Data Validation dialog box click the Data tab on the Ribbon and then click Authentication in the Data Tools group

Question 24

One way to run a macro is to assign it to a(n)button that is placed directly on the worksheet.

Question 25

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

Question 26

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

Question 27

Applications typically include an interface to assist the user in using the system ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

A)commands
B)menus
C)functions
D)all of the above

Question 28

The Name box lists all of the names currently defined in the workbook including Excel table names.

Question 29

After the first character in a range name which of the following is acceptable?

A)hyphen
B)space
C)periods
D)either A or B

Question 30

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

Question 31

Every cell in a workbook has a(n)sealed property that determines whether or not changes can be made to that cell.

Question 32

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

Question 33

By default the locked property is turned off for each cell when you protect a workbook.

Question 34

A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created.

Question 35

Range names must begin with ____.

A)a letter
B)the underscore character
C)a number
D)either A or B

Question 36

Which of the following is a valid function name?

A)FY2010
B)Print_Area
C)Net-Income
D)none of the above

Question 37

Range names can be up to ____ characters.

A)15
B)27
C)56
D)255

Question 38

The default is to protect only the windows used to display a workbook.

Question 39

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code.

Question 40

If you want to return to the Visual Basic Editor you can select one of the macros in the VBE dialog box and click the Edit button again.

Question 41

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept any type of numeric value.

A)Whole Number
B)Any Number
C)Decimal
D)Integer

Question 42

Using the Excel data validation feature you can specify a(n)____ of acceptable values.

A)roster
B)series
C)array
D)range

Question 43

Any blanks or parentheses in a row or column label will be changed to ____ in defined names.

A)ampersands
B)underscore characters
C)hyphens
D)dashes

Question 44

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

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

Question 45

The ____ box displays all of the names in the workbook.

A)Name
B)Ranges
C)Definition
D)Terms

Question 46

If a formula uses a defined name that doesn't exist ____ appears in the cell.

A)#DEF?
B)#NAME?
C)#REF?
D)#CELL?

Question 47

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept only values from a list.

A)List
B)Index
C)Roster
D)Catalog

Question 48

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept only text of a specified number of characters.

A)Custom
B)Text Length
C)Any Value
D)Specified Text

Question 49

One way to ensure that correct data is entered into a cell or range is to use the Excel data ____ feature.

A)validation
B)concatenation
C)security
D)index

Question 50

The most direct way to create defined names like the kind shown in the accompanying figure is to use the ____ box on the formula bar.

A)Definition
B)Name
C)Term
D)Label

Question 51

Using the Excel data validation feature you can specify the ____ of data.

A)aspect
B)type
C)format
D)cast

Question 52

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept only integers.

A)Integer
B)Decimal
C)Numerical
D)Whole Number

Question 53

The current data in the ParkingFee cell according to the accompanying figure is ____.

A)25
B)8
C)2
D)15

Question 54

The active cell in the accompanying figure is ____.

A)B6
B)B25
C)A25
D)C11

Question 55

The Excel data ____ feature restricts data entry to follow a defined set of rules.

A)error-checking
B)rule-based
C)validation
D)contingent

Question 56

In the City_State_Zip field name shown in the accompanying figure the underscores replace ____ in the label name.

A)spaces
B)periods
C)commas
D)numbers

Question 57

In the Allow list box in the Data Validation dialog box the ____ option means that the validation rule will be based on an Excel logical formula.

A)Rule
B)Logical
C)Custom
D)Validation

Question 58

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

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

Question 59

If your data is organized in a tabular format you can quickly create range names for each column or row in the list by using the ____ dialog box.

A)Make from Table
B)Name
C)Create from Selection
D)Assign

Question 60

Using defined names like the kind shown in the accompanying figure makes creating and understanding a(n)____ easier.

A)index
B)log
C)formula
D)All of the above

Question 61

The ____ alert accepts the invalid data but still allows you to cancel the data entry.

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

Question 62

Which of the following are Excel-supported error alert types?

A)Stop Warning and Alert
B)Alert Warning and Information
C)Security Warning and Alert
D)Stop Warning and Information

Question 63

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept only dates.

A)Calendar
B)Schedule
C)Date
D)Timeline

Question 64

One way of reducing the chance of data-entry error is to display a(n)____ message when a user clicks on the cell.

A)value
B)input
C)key
D)user

Question 65

In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept only times.

A)Chronology
B)Clock
C)Time
D)Calendar

Question 66

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

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

Question 67

Sometimes when you build a worksheet for other users you may decide to add a(n)____ message to a cell even if you don't validate the data in that cell.

A)value
B)input
C)key
D)user

Question 68

Every cell in a workbook has a(n)____ property that determines whether or not changes can be made to that cell.

A)ensured
B)locked
C)security
D)changeable

Question 69

Excel supports ____ types of error alerts.

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

Question 70

By default users are only allowed to select ____ cells in a protected worksheet.

A)locked
B)unlocked
C)open
D)both A and B

Question 71

The most serious error alert is the ____ alert.

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

Question 72

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

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

Question 73

Which of the following is a tab in the Data Validation dialog box?

A)Settings
B)Input Message
C)Error Alert
D)All of the above

Question 74

To open the ____ dialog box click the Data tab on the Ribbon and then click Data Validation in the Data Tools group.

A)Data Validation
B)Data Entry
C)Data
D)Validation

Question 75

____ messages appear as ScreenTips next to the active cell.

A)Value
B)Input
C)Key
D)User

Question 76

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

A)ensure
B)protect
C)secure
D)seal

Question 77

The least severe error alert is the ____ alert.

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

Question 78

A(n)____ message provides additional information about the type of data expected for the cell.

A)user
B)key
C)input
D)value

Question 79

When you protect a sheet unless you are concerned the users will turn off protection and make changes to formulas it is probably best not to specify a ____.

A)lock
B)password
C)username
D)any of the above

Question 80

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

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