Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

CTS 230 EM08

Excel Module EIGHT

QuestionAnswer
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
A macro ____________________ uses a program’s own macro programming language for distribution. virus
A protected sheet can always be unprotected, but you can also require users to enter a(n) ____________________ before the protection is removed. password
A(n) ____________________ is a series of stored commands that can be run whenever you need to perform a task. macro
A(n) ____________________ is a spreadsheet written or tailored to meet the user’s specific needs. Excel application
A(n) ____________________ is a text box that is attached to a specific cell in a worksheet. comment
In addition to referring to cells by their cell references, it is easier to remember where different data is stored by assigning a descriptive ____________________, to each cell or range. name
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
In the Allow list box in the Data Validation dialog box, the ____________________ option means that the cell will accept only dates. date
In the Allow list box in the Data Validation dialog box, the ____________________ option means that the cell will accept only times. time
Input messages appear as ____________________ next to the active cell. screen tips
One way to ensure that correct data is entered into a cell or range is to use the Excel data ____________________ feature. validation
Protecting the ____________________ of a workbook prohibits users from moving, resizing, closing, or hiding parts of the Excel window. windows
The ____________________ alert by default rejects the invalid data, but allows you to override the rejection. warning
The ____________________ alert prevents you from storing the data in the cell. stop
To open the Protect Sheet dialog box, click the Review tab on the Ribbon, and then click the Protect Sheet button in the ____________________ group. changes
When you ____________________ a workbook, you control the ability users have to make changes to the file. protect
You can create a(n) ____________________ key that will run a macro directly from the keyboard. shortcut
You control how Excel handles suspect macros by setting Excel's ____________________. security level.
____ messages appear as ScreenTips next to the active cell. input
You use the ____ tab in the Data Validation dialog box to enter the validation rules for the active cell. settings
You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the ____ tab. developer
Which of the following is a tab in the Data Validation dialog box? settings, input message, error alert
When you set up worksheet protection, you can allow users to ____. insert new rows or columns, delete rows and columns, select any cell in the worksheet.
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 ____. password
When you find an error in a macro, all of the following are options EXCEPT ____. recopy the macro from the macro library
When you ____ a workbook, you control the ability users have to make changes to the file. protect
When a workbook is protected such that options to modify the worksheet are no longer available, what do the corresponding commands on the shortcut menu look like? They are grayed out.
Usually, you will want to protect a worksheet but leave some cells ____. unlocked
Using the Excel data validation feature, you can specify a(n) ____ of acceptable values. range
To view the code of a macro, you need to open the Visual Basic ____. editor
To remove workbook protection, click the Unprotect Workbook button in the ____ group on the Review tab. changes
To open the ____ dialog box, click the Data tab on the Ribbon, and then click Data Validation in the Data Tools group. data validation.
To create a macro, you can write one by entering a series of commands in the ____ programming language. vba
The most serious error alert is the ____ alert. stop
The least severe error alert is the ____ alert. information.
The following are Excel-supported error alert types: ____. Stop, Warning, and Information
The ____ box displays all of the names in the workbook. name
The ____ alert accepts the invalid data but still allows you to cancel the data entry. information
The ____ Reference button controls how Excel records the act of selecting a range in the Worksheet. relative
The ____ Macro workbook is a hidden workbook opened whenever you start Excel, making its macros available anytime you use Excel. personal
The ____ Center is a central location for all the security settings in Office 2007. trust
The Excel data ____ feature restricts data entry to follow a defined set of rules. validation
Sub procedures are organized into ____. modules
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. input
Range names must begin with ____. a letter or a number.
Range names can be up to ____ characters. 255
Protecting the ____ prohibits users from renaming, deleting, hiding, or inserting worksheets. structure
Protecting the ____ prohibits users from moving, resizing, closing, or hiding parts of the Excel window. windows
One way to ensure that correct data is entered into a cell or range is to use the Excel data ____ feature. validation
One way of reducing the chance of data-entry error is to display a(n) ____ message when a user clicks on the cell. input
Most ____ are not harmful and do not affect data in any way. macros viruses
In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept only integers. whole number.
In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept any type of numeric value. decimal
In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept only values from a list. list
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. custom text
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. custom
In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept only times. time
In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept only dates. date
In VBA, macros are called ____ procedures. sub
In VBA procedures, the ____ are used if you want to include any arguments in the procedure. parentheses
In Office 2010, you can define a set of locations (file paths) where you can place files you consider trustworthy. This feature is known as ____ Locations. trusted
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. create from selection
If content is blocked, the ____ located under the Ribbon appears, notifying you that some content was disabled. Message Bar
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
For simple macros, it is easier to create a macro using the macro ____. recorder
Excel supports ____ types of error alerts. three
Excel 2010 enables you to change the Ribbon to fit your work style. Among many other customization features, you can do all of the following EXCEPT ____. eliminate the ribbon
Every cell in a workbook has a(n) ____ property that determines whether or not changes can be made to that cell. locked
Each sub procedure in VBA begins with the keyword "Sub" followed by the name of the sub procedure and a set of ____. parentheses
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 ____. commands, menus and toolbars.
Any blanks or parentheses in a row or column label will be changed to ____ in defined names. underscore character (_)
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
After the first character in a range name, the following is acceptable: ____. periods
After the comments in VBA code is the ____ of the macro. body
After the Stop alert, the next alert in severity is the ____ alert. warning
A(n) ____ message provides additional information about the type of data allowed for the cell. input
A(n) ____ certificate is another name for a digital ID. digital
A macro can be stored in ____. the current workbook, a Personal Macro workbook, a new workbook
A digital ____ is like a seal of approval. signature
Using defined names figure makes creating and understanding a(n) ____ easier. formula
The most direct way to create defined names is to use the ____ box on the formula bar. name
Created by: galvanl
Popular Computers sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards