Excel Final Module 7

For cell and range names, names of 5 to 15 characters are considered practical, although names can be up to 255 characters. True or False

Defined names are automatically substituted for existing range references in a formula. True or False

The Stop alert prevents an entry from being stored in the cell True or False

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

Validation rules come into play only during data entry

Each macro must have a unique name that begins with a letter.

Running a macro means Excel performs a portion of the steps that were recorded.

Cell and range references do not indicate what data is stored in those cells

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

The name dialog box lists all of the names currently defined in the workbook, including Excel table names.

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

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

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

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

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

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

Which of the following is NOT a valid defined name? A) netincome B) Net_Income C) Net-Income D) NetIncome

Range names must begin with _____. A) a letter or an underscore B) a number C) a hash tag D) an asterik

Range names can be up to _____ characters. A) 15 B) 27 C) 56 D) 255

The ____ dialog box displays all of the names in the workbook. A) Name Manager B) Ranges C) Definition D) Terms

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

The Excel data ____ feature restricts data entry to follow a defined set of rules. A) error-checking B) rule-based C) validation D) contingent

An input message appears when the cell becomes active, and can be used to specify the _____ of data the user should enter in that cell. A) aspect B) type C) format D) cast

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

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) Whole Number

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

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

Sometimes when you build a worksheet for other users, you may decide to add a(n) _____ message to a cell even if you do not validate the data in that cell. A) value B) input C) key D) user

Which of the following tabs in the Data Validation dialog box enter the Validation rules for the active cell? A) Criteria B) Input Message C) Error Alert D) Settings

You use the _____ tab in the Data Validation dialog box to enter the validation rules for the active cell. A) Active Cell B) Criteria C) Settings D) Input Message

____ messages appear as ScreenTips next to the active cell. A) Value B) Input C) Key D) User

The following are Excel-supported error alert types: _____. A) Stop, Warning, Alert B) Alert, Warning and Information C) Security, Warning, and Alert D) Stop, Warning, and Information

The ____ alert accepts the invalid data but still allows you to cancel the data entry. A) Information B) Stop C) Security D) Warning

When you _____ a workbook, you control the ability users have to make changes to the file. A) ensure B) protect C) secure D) seal

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

Usually, you will want to protect a worksheet but leave some cells _____. A) opened B) empty C) clear D) unlocked

Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets. A) skeleton B) structure C) format D) location

To remove workbook protection, click the Unprotect Workbook button in the _____ group on the REVIEW tab. A) Format B) Changes C) Sheet D) Options

A ____ can be destructive and can modify or delete files that may not be recoverable. A) digital signature B) macro virus C) comment virus D) micro virus

The ____ Center is a central location for all the security settings in Office. A) Secure B) Security C) Trust D) Protection

If content is blocked, the _____ located under the Ribbon appears, notifying you that some content was disabled. A) Mini toolbar B) Quick Launch toolbar C) Message Bar D) Status Bar

A(n) ____ certificate is another name for a digital ID. A) analog B) signature C) digital D) secure

A digital ____ is like a seal of approval. A) affidavit B) clause C) signature D) salutation

To create a macro, you can enter a series of commands in the ____ programming language. A) HTML B) Java C) VBA D) Perl

The ____ Macro workbook is a hidden workbook opened whenever you start Excel,making its macros available anytime you use Excel. A) Universal B) Personal C) Microsoft D) XP

You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab. A) Insert B) Developer C) Layout D) Macro

If a _____ error appears when you run a macro that has worked in the past, some part of the macro code no longer makes sense to Excel. A) syntax B) run-time C) logic D) baseline

To view the code of a macro, you need to open the Visual Basic A) Manager B) Code Window C) Reader D) Editor

In VBA, macros are called ____ procedures. A) body B) sub C) commented D) modular

Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of _____. A) brackets B) braces C) parentheses D) asterisks

After the comments, in VBA code the next item is the _____ of the macro. A) module B) body C) procedure D) command

To save a workbook with macros, the default Excel Workbook format needs to change to a macro-enabled workbook, which has the _____ file extension. A) xlsm B) xlst C) xlsx D) xls

While just getting his feet wet with Excel, you suggest to Ted that he might want to begin without having his installation of Excel have any macros run at all. Which of the following options would he select in the Trust Center? A) disable all macros without notification B) cancel all macros C) disable a macro with notification D) disable all macros except digitally signed macros

As Ted gets more comfortable with Excel, he thinks that he might be able to decide whether or not to run a macro on a case-by-case basis. What should his option be in the Trust Center? A) disable all macros without notification B) cancel all macros C) disable all macros with notifications D) disable all macros except digitally signed macros

As Ted does even more work in Excel, he has begun to develop a collection of publishers whom he trusts to deliver macros that are problem-free. What should his option be in the Trust Center? A) Enable all trusted macros B) Enable all macros C) Disable all macros except digitally signed macros D) Disable a macro with notification

After a year of work, Ted is taking coursework to become a VBA programmer. He is working on developing an application that contains macros. which should his option be in the Trust Center. a. Enable all trusted macros b. Enable all macros c. Disable all macros except digitally signed macros d. disable a macro with notification

What phrase could Rina use to best describe a digital signature? a. a merit badge b. an indication of value c. an invitation to collaborate d. a seal of approval

Based on what she has learned, which of the following would Rina say is a true statement about digital signatures.? a. adding a digital signature is the first step before you distribute a file. b. A digital signature is often used to identify the author of a workbook that contains macros. c. Before you can add a digital ID to a workbook, you need to obtain a digital signature. d. Digital certificates are usually issued by Microsoft

By digitally signing a workbook that contains macros that she intends to publicly distribute, Rina assures her audience _______. a. of the identity of the user of the macro b. that the macro has not been altered since the digital signature was created. c.that the macro will perform as expected d. that no entry errors will stop the macro from running

Which of the following can Rina tell when she opens a digitally signed file? a. Who the author of the file is b. whether the information in the file is correct c. whether the macros in the workbook will produce accurate results. d. whether the Macro will perform as expected

which of the following is a true statement Juan can make about defined names as he is explaining the rules to you? a. The name can include letters, numbers, periods, and underscores. b. to distinguish multiword names, use a hyphen between the words. c. Defined names are case sensitive d. the name should start with a hash tag.

Which is the following is an example of a valid defined name Juan can provide you? a. .FY2010 b. F-Y2010 c. FY2010 d. FiscalYear2010