Q&A Hero

Computer Science

Q: 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. xlsm b. xlst c. xlsx d. xls
Q: Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets. a. skeleton b. structure c. format d. location
Q: To remove workbook protection, click the Unprotect Workbook button in the _____ group on the Review tab. a. Format b. Changes c. Sheet d. Options
Q: A _____ can be destructive and can modify or delete files that may not be recoverable. a. digital signature b. macro virus c. comment virus d. micro virus
Q: The _____ Center is a central location for all the security settings in Office. a. Secure b. Security c. Trust d. Protection
Q: If content is blocked, the _____ located under the Ribbon appears, notifying you that some content was disabled. a. Mini toolbar b. Quick Launch toolbar c. Message Bar d. Status Bar
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: 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: 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: 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: 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: 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: 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
Q: To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink. a. Delete b. Erase c. Archive d. Remove
Q: If the destination file is closed when you make a change in the ____ file, you can choose whether to update the link to display the current values when you open the destination file. a. target b. origin c. source d. key
Q: The default template contains the default formatting you start out with in every new workbook, including ____ 11-point font. a. Calibri b. Helvetica c. Geneva d. Times New Roman
Q: A ____ is a workbook that you can open with the text, formats, and formulas already built into it. a. boiler b. summary sheet c. template d. range master
Q: When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____. a. braces b. brackets c. parentheses d. single quotation marks
Q: Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site? a. Family Budget b. Inventory List c. Team Roster d. Fax Cover Sheet
Q: The worksheet range ____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4." a. Sheet1_Sheet4 b. Sheet1-Sheet4 c. Sheet1:Sheet4 d. Sheet1/Sheet4
Q: The ____ template in Excel creates an online time card to track employees work hours. a. Payroll b. Personnel Statement c. Time Sheet d. Employment Calculator
Q: Which of the following is NOT an option for arranging your workbooks? a. tiled b. cascade c. horizontal d. lateral
Q: The default template places the formula results aligned to the ____ of a cell. a. right side b. left side c. top d. bottom
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
1 2 3 … 99

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts