Q&A Hero

Q: 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

Q: Which of the following tabs in the Data Validation dialog box allows you to set validation criteria? a. Criteria b. Input Message c. Error Alert d. Settings

Q: 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

Q: When you _____ a workbook, you control the ability users have to make changes to the file. a. ensure b. protect c. secure d. seal

Q: 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

Q: 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

Q: _____ messages appear as ScreenTips next to the active cell. a. Value b. Input c. Key d. User

Q: To view the code of a macro, you need to open the Visual Basic _____. a. Manager b. Code Window c. Reader d. Editor

Q: The following are Excel-supported error alert types: _____. a. Stop, Warning, and Alert b. Alert, Warning, and Information c. Security, Warning, and Alert d. Stop, Warning, and Information

Q: In VBA, macros are called _____ procedures. a. body b. sub c. commented d. modular

Q: The _____ alert accepts the invalid data but still allows you to cancel the data entry. a. Information b. Stop c. Security d. Warning

Q: 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

Q: 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

Q: After the comments, in VBA code the next item is the _____ of the macro. a. module b. body c. procedure d. command

Q: When Excel creates a macro button, the Assign Macro dialog box opens with the buttons default name showing. _________________________

Q: Which of the following is NOT a valid defined name? a. netincome b. Net_Income c. Net-Income d. NetIncome

Q: Range names must begin with _____. a. a letter or an underscore b. a number c. a hash tag d. an asterisk

Q: Range names can be up to _____ characters. a. 15 b. 27 c. 56 d. 255

Q: The _____ dialog box displays all of the names in the workbook. a. Name Manager b. Ranges c. Definition d. Terms

Q: 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

Q: 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

Q: The Excel data _____ feature restricts data entry to follow a defined set of rules. a. error-checking b. rule-based c. validation d. contingent

Q: 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

Q: 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

Q: A macro ____________________ uses a programs own macro programming language for distribution.

Q: One way to run a macro is to assign it to a(n) button that is placed directly on the worksheet. _________________________

Q: A digital ____________________ is often used to identify the author of a workbook that contains macros.

Q: For cell and range names, names of 5 to 15 characters are considered practical, although names can be up to 255 characters. a. True b. False

Q: Defined names are automatically substituted for existing range references in a formula. a. True b. False

Q: The Stop alert prevents an entry from being stored in the cell. a. True b. False

Q: A(n) ____________________ is a spreadsheet written or tailored to meet the users specific needs.

Q: Even when the worksheet is unprotected, the locked property determines whether or not changes can be made to a given cell. a. True b. False

Q: 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.

Q: Validation rules come into play only during data entry. a. True b. False

Q: Each macro must have a unique name that begins with a letter. a. True b. False

Q: Running a macro means Excel performs a portion of the steps that were recorded. a. True b. False

Q: Input messages appear as ____________________ next to the active cell.

Q: Cell and range references do not indicate what data is stored in those cells. _________________________

Q: The ____________________ alert, by default, rejects the invalid data, but allows you to override the rejection.

Q: Any blanks or parentheses in row or column labels are changed to underscore characters in defined names. _________________________

Q: The Name dialog box lists all of the names currently defined in the workbook, including Excel table names. _________________________

Q: A protected sheet can always be unprotected, but you can also require users to enter a(n) ____________________ before the protection is removed.

Q: To open the Data Validation dialog box, click the Data tab on the Ribbon, and then click Authentication in the Data Tools group. _________________________

Q: Protecting the ____________________ of a workbook prohibits users from moving, resizing, closing, or hiding parts of the Excel window.

Q: Every cell in a workbook has a(n) locked property that determines whether or not changes can be made to that cell. _________________________

Q: A(n) ____________________ is a text box that is attached to a specific cell in a worksheet.

Q: A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created. _________________________

Q: A(n) ____________________ is a series of stored commands that can be run whenever you need to perform a task.

Q: The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code. _________________________

Q: To manually ____________________ a link and see the new data values, click the Update Values button.

Q: After you have saved a template, you can access the template from the New screen in ____________________ view.

Q: Using multiple worksheets makes it easier to group and summarize data. Describe features that can be applied by forming a worksheet group.

Q: What are the steps to inserting a hyperlink and linking to: a file or Web page, a location in the current workbook, a new document, and an e-mail address.

Q: Case 6-2 Ryder has discovered the power of creating and viewing multiple workbooks. When Ryder goes to save the workbooks, what is the required file extension? a. .wxls b. .xlww c. .xlsx d. .xlwx

Q: Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. What is an example of when you would use a template? Name at least three benefits of using a workbook template.

Q: A(n) ____________________ group is a collection of two or more selected worksheets.

Q: A 3-D cell ____________________ specifies not only the rows and columns of a cell range, but also the range of worksheet names that the cells appear on.

Q: A(n) ____________________ is a connection between two files allowing information to be transferred from one file to the other.

Q: Identify the letter of the choice that best matches the phrase or definition.a. 3-Db. ​hyperlinkc. ​worksheet groupd. sourcee. destinationf. linkA collection of two or more selected worksheets

Q: When two files are linked together, the workbook that contains the information is the ____________________ file.

Q: When two files are linked together, the ____________________ file receives the information.

Q: When the destination file is ____________________, and the source files are closed, the complete file path is included as part of the external reference formula that appears in the formula bar.

Q: ____________________ a worksheet duplicates all the values, formulas, and formats into the new worksheet, leaving the original worksheet intact.

Q: A(n) ____________________ is a link in a file, such as a workbook, to information within that file or another file.

Q: In the Links group, click the Hyperlink button and the _______ Hyperlink dialog box opens.

Q: ____________________ appear whenever you place the pointer over a hyperlink.

Q: The ____ arrangement option layers the open workbooks on the screen. a. Cascade b. Horizontal c. Tiled d. Lateral

Q: All template files have a(n) ____ extension. a. .xlsx b. .xltx c. .xldx d. .xtpl

Q: A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks. a. internal b. external c. import d. export

Q: Simon tells Brooke that when he attempts to open a workbook, the Edit Links dialog box appears with the message "This workbook contains one or more links that cannot be updated." Brooke suggests several possible causes of this error message. Which of the following is a possible cause? a. one of the workbook's source files was edited c. one of the workbook's source files was replaced with an updated file of the same name d. the workbook was sent to him without links ANSWER: d

Q: You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6. a. mixed b. absolute c. relative d. indexed

Q: Case 6-1 Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. Finally, Simon asks Brooke what steps (if any) need to be taken to keep a destination file up-to-date if he updates a value in one of the source files. Which of the following statements by Brooke would be correct? a. If a destination file is open when a source file is changed, the destination file will be updated automatically. b. Source files cannot be updated unless the corresponding destination file is open. c. It is not possible to choose whether a destination file should reflect changes made to the source files. d. If a destination file is open when a source file is changed, you need to update the destination file manually so that it reflects the changes.

Q: Formulas created using the point-and-click method contain ____ references. a. absolute b. mixed c. relative d. relational

Q: Case 6-2 Ryder has discovered the power of creating and viewing multiple workbooks. Ryder wants to use a layout in which the workbooks overlap each other with all the title bars visible. Ryder opens all of the workbooks, and then he clicks the View tab on the Ribbon and clicks the Arrange All button. What should he do next to obtain the desired layout? a. Click the Tile Horizontally option button b. Click the Tile Vertically option button c. Click the Overlap option button d. Click the Cascade option button

Q: If you receive a destination workbook but the source files are not included, click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values. a. Fix b. Break c. Update d. Check

Q: When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file. a. source b. destination c. both a. and b. d. neither a. nor b.

Q: If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____. a. Done b. Completed c. OK d. Good

Q: ____ are usually represented by words with colored letters and underlines or images. a. Indices b. Hyperlinks c. Templates d. Icons

Q: When you click a(n) ____, the computer switches to the file or portion of the file that it references. a. index b. hyperlink c. template d. icon

Q: The default ____ for a hyperlink is the folder location and the name of the file to which you will link. a. title b. alt text c. description d. ScreenTip