Excel Final Module 7
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
A
Range names must begin with _____. A) a letter or an underscore B) a number C) a hash tag D) an asterik
A
The ____ alert accepts the invalid data but still allows you to cancel the data entry. A) Information B) Stop C) Security D) Warning
A
The ____ dialog box displays all of the names in the workbook. A) Name Manager B) Ranges C) Definition D) Terms
A
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
A
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
A
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
B
After the comments, in VBA code the next item is the _____ of the macro. A) module B) body C) procedure D) command
B
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
B
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
B
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
B
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
B
In VBA, macros are called ____ procedures. A) body B) sub C) commented D) modular
B
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
B
Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets. A) skeleton B) structure C) format D) location
B
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
B
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
B
To remove workbook protection, click the Unprotect Workbook button in the _____ group on the REVIEW tab. A) Format B) Changes C) Sheet D) Options
B
When you _____ a workbook, you control the ability users have to make changes to the file. A) ensure B) protect C) secure D) seal
B
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
B
____ messages appear as ScreenTips next to the active cell. A) Value B) Input C) Key D) User
B
A digital ____ is like a seal of approval. A) affidavit B) clause C) signature D) salutation
C
A(n) ____ certificate is another name for a digital ID. A) analog B) signature C) digital D) secure
C
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
C
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
C
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
C
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
C
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
C
The Excel data ____ feature restricts data entry to follow a defined set of rules. A) error-checking B) rule-based C) validation D) contingent
C
The ____ Center is a central location for all the security settings in Office. A) Secure B) Security C) Trust D) Protection
C
To create a macro, you can enter a series of commands in the ____ programming language. A) HTML B) Java C) VBA D) Perl
C
Which of the following is NOT a valid defined name? A) netincome B) Net_Income C) Net-Income D) NetIncome
C
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
C
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
D
Range names can be up to _____ characters. A) 15 B) 27 C) 56 D) 255
D
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
D
To view the code of a macro, you need to open the Visual Basic A) Manager B) Code Window C) Reader D) Editor
D
Usually, you will want to protect a worksheet but leave some cells _____. A) opened B) empty C) clear D) unlocked
D
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
D
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
D
A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created.
False
Defined names are automatically substituted for existing range references in a formula. True or False
False
Even when the worksheet is unprotected, the locked property determines whether or not changes can be made to a given cell.
False
Running a macro means Excel performs a portion of the steps that were recorded.
False
The name dialog box lists all of the names currently defined in the workbook, including Excel table names.
False
To open the Data Validation dialog box, click the Data tab on the Ribbon, and then click Authentication in the Data Tools group.
False
Any BLANKS or parentheses in row or column labels are changed to underscore characters in defined names.
True
Cell and range references do not indicate what data is stored in those cells
True
Each macro must have a unique name that begins with a letter.
True
Every cell in a workbook has a(n) locked property that determines whether or not changes can be made to that cell.
True
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
True
One way to run a macro is to assign it to a(n) button that is placed directly on the worksheet.
True
The Stop alert prevents an entry from being stored in the cell True or False
True
The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code.
True
When Excel creates a macro button, the Assign Macro dialog box opens with the button's default name showing. T/F
True
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
a
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.
a
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
b
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
b
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
b
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
d
Validation rules come into play only during data entry
true