BUS 150 Part 1
For cell and range names, names of 5 to 15 characters are considered practical, although names can be up to 255 characters. T or F
Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name. T/F
You can use the Name Manager dialog box, shown in the accompanying figure, to create a defined name. T/F
Defined names are automatically substituted for existing range references in a formula. T/F
The Stop alert prevents an entry from being stored in the cell. T/F
Even when the worksheet is unprotected, the locked property determines whether or not changes can be made to a given cell. T/F
Validation rules come into play only during data entry. T/F
Each macro must have a unique name that begins with a letter. t/f
Running a macro means Excel performs a portion of the steps that were recorded. T/F
Cell and range references do not indicate what data is stored in those cells. T/F
Any blanks or parentheses in row or column labels are changed to underscore characters in defined names. T/F
The ____ 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 _____ in the Data Tools group.
When you ___ a workbook, you control the ability users have to make changes to the file
Every cell in a workbook has a(n) locked property that determines whether or not changes can be made to that cell. T/F
A digital ______ 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. T/F
One way to run a macro is to assign it to a(n) button that is placed directly on the worksheet. T/F
When Excel creates a macro button, the Assign Macro dialog box opens with the button's default name showing. T/F
___ is an error alert that rejects invalid data but allows you to override the rejection
____ is a series of stored commands
____ appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell
_____ is programming language that allows you to create macros
A _____ is needed before you can add a digital signature to a workbook
A(n) ___ is an error alert that accepts the invalid data but still allows you to cancel the data entry
____ defines the criteria for storing data in a cell or range
____ is a property that determines whether or not changes can be made to a cell
___ is an error alert that prevents you from storing the data in the cell
___ is a word or string of characters associated with a single cell or a range
Which of the following is NOT a valid defined name?
Range names must begin with _____.
a letter or an underscore
Range names can be up to _____ characters.
In the accompanying figure, clicking the New button opens the New _____ dialog box.
In the accompanying figure, the column labeled "Refers To" is the range's _____ (location in the work book)
location in the workbook
Using defined names like those shown in the accompanying figure makes creating and understanding a(n) _____ easier.
The _____ dialog box displays all of the names in the workbook.
Any blanks or parentheses in a row or column label will be changed to _____ in defined names.
The Excel data _____ feature restricts data entry to follow a defined set of rules.
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.
In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only integers.
One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature.
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.
In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only times.
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.
Which of the following tabs in the Data Validation dialog box allows you to set validation criteria?
You use the _____ tab in the Data Validation dialog box to enter the validation rules for the active cell.
_____ messages appear as ScreenTips next to the active cell.
The following are Excel-supported error alert types: _____.
stop, warning, alert
The _____ alert accepts the invalid data but still allows you to cancel the data entry.
When you _____ a workbook, you control the ability users have to make changes to the file.
Every cell in a workbook has a(n) _____ property that determines whether or not changes can be made to that cell.
Usually, you will want to protect a worksheet but leave some cells _____.
Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets.
To remove workbook protection, click the Unprotect Workbook button in the _____ group on the REVIEW tab.
Comments like those in the accompanying figure are often used to _____.
To keep a comment like the one in the accompanying figure on the screen, in the Comments group on the _____ tab, click the Show/Hide Comment button.
A _____ can be destructive and can modify or delete files that may not be recoverable.
The _____ Center is a central location for all the security settings in Office.
If content is blocked, the _____ located under the Ribbon appears, notifying you that some content was disabled.
A(n) _____ certificate is another name for a digital ID.
A digital _____ is like a seal of approval.
To create a macro, you can enter a series of commands in the _____ programming language.
The _____ Macro workbook is a hidden workbook opened whenever you start Excel, making its macros available anytime you use Excel.
You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab.
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.
To view the code of a macro, you need to open the Visual Basic _____.
In VBA, macros are called _____ procedures.
Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of _____.
After the comments, in VBA code the next item is the _____ of the macro.
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(n)___________________ is a spreadsheet written or tailored to meet the user's specific needs.
In addition to referring to cells by their cell references, it is easier to remember where different data is stored by assigning a meaningful, descriptive ____________________ to each cell or range.
One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature.
In the Allow list box in the Data Validation dialog box, the ____________________ option means that the cell will accept any value entered into the cell.
Input messages appear as ____________________ next to the active cell.
The ____________________ alert, by default, rejects the invalid data, but allows you to override the rejection.
When you ____________________ a workbook, you control the ability users have to make changes to the file.
A protected sheet can always be unprotected, but you can also require users to enter a(n) ____________________ before the protection is removed.
Protecting the ____________________ of a workbook prohibits users from moving, resizing, closing, or hiding parts of the Excel window.
A(n) ____________________ is a text box that is attached to a specific cell in a worksheet.
A(n) ____________________ is a series of stored commands that can be run whenever you need to perform a task.
A macro ____________________ uses a program's own macro programming language for distribution
You control how Excel handles suspect macros by setting Excel's ____________________.
A digital ____________________ is often used to identify the author of a workbook that contains macros.
A digital ____________________ is typically issued by a certificate authority
YOU MIGHT ALSO LIKE...
CGS 2518 Chapter 8
IS 200 chapter 8
Excel Test 3
OTHER SETS BY THIS CREATOR
THIS SET IS OFTEN IN FOLDERS WITH...
CIS 150 5
CIS 150 4
NET 100 Ch. 6