Excel Module EIGHT
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| 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
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
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
Normal Size Small Size show me how
Created by:
galvanl
Popular Computers sets