85 terms

BUS 150 Part 1

STUDY
PLAY

Terms in this set (...)

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
T
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
F
You can use the Name Manager dialog box, shown in the accompanying figure, to create a defined name. T/F
T
Defined names are automatically substituted for existing range references in a formula. T/F
F
The Stop alert prevents an entry from being stored in the cell. T/F
T
Even when the worksheet is unprotected, the locked property determines whether or not changes can be made to a given cell. T/F
F
Validation rules come into play only during data entry. T/F
T
Each macro must have a unique name that begins with a letter. t/f
T
Running a macro means Excel performs a portion of the steps that were recorded. T/F
F
Cell and range references do not indicate what data is stored in those cells. T/F
T
Any blanks or parentheses in row or column labels are changed to underscore characters in defined names. T/F
T
The ____ dialog box lists all of the names currently defined in the workbook, including Excel table names.
Name manager
To open the Data Validation dialog box, click the DATA tab on the Ribbon, and then click _____ in the Data Tools group.
Data validation
When you ___ a workbook, you control the ability users have to make changes to the file
protect
Every cell in a workbook has a(n) locked property that determines whether or not changes can be made to that cell. T/F
T
A digital ______ confirms that the macro created by the signer has not been altered since the digital certificate was created.
signature
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
T
One way to run a macro is to assign it to a(n) button that is placed directly on the worksheet. T/F
T
When Excel creates a macro button, the Assign Macro dialog box opens with the button's default name showing. T/F
T
___ is an error alert that rejects invalid data but allows you to override the rejection
warning
____ is a series of stored commands
macro
____ appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell
input message
_____ is programming language that allows you to create macros
VBA
A _____ is needed before you can add a digital signature to a workbook
digital certificate
A(n) ___ is an error alert that accepts the invalid data but still allows you to cancel the data entry
information
____ defines the criteria for storing data in a cell or range
validation rule
____ is a property that determines whether or not changes can be made to a cell
locked
___ is an error alert that prevents you from storing the data in the cell
stop
___ is a word or string of characters associated with a single cell or a range
defined name
Which of the following is NOT a valid defined name?
a.
netincome
c.
Net-Income
b.
Net_Income
d.
NetIncome
c
Range names must begin with _____.
a letter or an underscore
Range names can be up to _____ characters.
255
In the accompanying figure, clicking the New button opens the New _____ dialog box.
name
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.
formula
The _____ dialog box displays all of the names in the workbook.
name manager
Any blanks or parentheses in a row or column label will be changed to _____ in defined names.
underscore characters
The Excel data _____ feature restricts data entry to follow a defined set of rules.
validation
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.
type
In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only integers.
whole number
One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature.
validation
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.
text length
In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only times.
time
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.
input
Which of the following tabs in the Data Validation dialog box allows you to set validation criteria?
a.
Criteria
c.
Error Alert
b.
Input Message
d.
Settings
d
You use the _____ tab in the Data Validation dialog box to enter the validation rules for the active cell.
settings
_____ messages appear as ScreenTips next to the active cell.
input
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.
information
When you _____ a workbook, you control the ability users have to make changes to the file.
protect
Every cell in a workbook has a(n) _____ property that determines whether or not changes can be made to that cell.
locked
Usually, you will want to protect a worksheet but leave some cells _____.
unlocked
Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets.
structure
To remove workbook protection, click the Unprotect Workbook button in the _____ group on the REVIEW tab.
changes
Comments like those in the accompanying figure are often used to _____.
skip
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.
REVIEW
A _____ can be destructive and can modify or delete files that may not be recoverable.
macro virus
The _____ Center is a central location for all the security settings in Office.
trust
If content is blocked, the _____ located under the Ribbon appears, notifying you that some content was disabled.
message bar
A(n) _____ certificate is another name for a digital ID.
digital
A digital _____ is like a seal of approval.
signature
To create a macro, you can enter a series of commands in the _____ programming language.
VBA
The _____ Macro workbook is a hidden workbook opened whenever you start Excel, making its macros available anytime you use Excel.
personal
You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab.
developer
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.
run-time
To view the code of a macro, you need to open the Visual Basic _____.
editor
In VBA, macros are called _____ procedures.
sub
Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of _____.
parenthesis
After the comments, in VBA code the next item is the _____ of the macro.
body
To save a workbook with macros, the default Excel Workbook format needs to change to a macro-enabled workbook, which has the _____ file extension.
xlsm
A(n)___________________ is a spreadsheet written or tailored to meet the user's specific needs.
excel application
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.
name
One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature.
validation
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.
any value
Input messages appear as ____________________ next to the active cell.
screen tips
The ____________________ alert, by default, rejects the invalid data, but allows you to override the rejection.
warning
When you ____________________ a workbook, you control the ability users have to make changes to the file.
protect
A protected sheet can always be unprotected, but you can also require users to enter a(n) ____________________ before the protection is removed.
password
Protecting the ____________________ of a workbook prohibits users from moving, resizing, closing, or hiding parts of the Excel window.
windows
A(n) ____________________ is a text box that is attached to a specific cell in a worksheet.
comment
A(n) ____________________ is a series of stored commands that can be run whenever you need to perform a task.
macro
A macro ____________________ uses a program's own macro programming language for distribution
virus
You control how Excel handles suspect macros by setting Excel's ____________________.
security level
A digital ____________________ is often used to identify the author of a workbook that contains macros.
signature
A digital ____________________ is typically issued by a certificate authority
certificate