*



You are watching: With a(n) ____ data table you can vary the value in one cell.

*

*

*

Solved… Question 1 Cell Used Distinguish Different Functional Parts Worksheet Ranges B Indices C Q13359317




See more: Explain Why T Distributions Tend To Be Flatter, Answered: Explain Why T Distributions Tend To Be…

Solved… Question 1 Cell Used Distinguish Different Functional Parts Worksheet Ranges B Indices C Q13359317


QUESTION 1 Cell ____ can be used to distinguish the different functionalparts of a worksheet. a. ranges b. indices c. borders d. values 10 points QUESTION 2 ____ ensures that users do not change values inadvertently thatare critical to the worksheet. a. Cell protection b. A data table c. The formula checker d. Range Finder 1 points QUESTION 3 ____ examines the formulas in a workbook in a manner similar tothe way the spell checker examines a workbook for misspelledwords. a. The formula checker b. The Range Finder c. An amortization schedule d. A data table 1 points QUESTION 4 A cell ____ often is created from column or row titles. a. formula b. data table c. name d. function 1 points QUESTION 5 A check mark in the ____ check box speeds up printing byignoring formatting and not printing most graphics. a. Gridlines b. Black and white c. Draft quality d. Print titles 1 points QUESTION 6 A(n) ____ shows the beginning and ending balances and the amountof payment that is applied to the principal and interest duringeach payment period. a. data table b. formula checker c. dialog box d. amortization schedule 1 points QUESTION 7 Cell ____ can be used to distinguish the different functionalparts of a worksheet. a. indices b. borders c. ranges d. values 1 points QUESTION 8 Data tables must be built in a(n) ____ area of a worksheet. a. upper-left b. unused c. used d. lower-right 1 points QUESTION 9 If you click the ____, Excel displays a menu; the first item inthe menu identifies the error and the remainder of the menucontains commands from which you can choose. a. cell boundary b. Error Checking button c. Trace Error button d. fill handle 1 points QUESTION 10 If you wish to allow another worksheet user to be able tomanipulate some cells, leave those cells ____. a. locked b. hybrid c. unprotected d. indexed 1 points QUESTION 11 In a process called ____, Excel continually reviews the workbookfor errors in formulas as you create or manipulate it. a. foreground formula checking b. background function checking c. workbook formula checking d. background formula checking 1 points QUESTION 12 In the accompanying figure, the Print area box accepts a name ora ____ to print. a. worksheet b. file c. tab d. range 1 points QUESTION 13 Names are ____ cell references. a. absolute b. mixed c. relative d. formatted 1 points QUESTION 14 Names are ____ to the workbook. a. international b. national c. global d. inclusive 1 points QUESTION 15 Rather than manually setting a print area each time you want toprint a range, you can ____ the range. a. manipulate b. validate c. name d. lock 1 points QUESTION 16 Similar to the spell checker, Excel has a formula checker thatchecks formulas in a worksheet for rule ____. a. repetitiveness b. consistency c. violations d. brevity 1 points QUESTION 17 The ____ function returns the present value of an annuity. a. PMT b. VDB c. FV d. PV 1 points QUESTION 18 The arguments in ____ in the ScreenTip for a function areoptional. a. parentheses b. quotation marks c. brackets d. braces 1 points QUESTION 19 To hide an entire workbook on an unattended computer, click theHide button on the ____. a. (VIEW tab | Workbook Views group) b. (HOME tab | View group) c. (VIEW tab | Window group) d. (HOME tab | Display group) 1 points QUESTION 20 To prevent round-off errors, use the ____ function. a. RADIANS b. RAND c. ROMAN d. ROUND 1 points QUESTION 21 To prevent sensitive data from being seen in a worksheet, youcan hide the worksheet by clicking ____ on the shortcut menu. a. Hide Sheet b. Hide Rows and Columns c. Hide d. Hide Workbook 1 points QUESTION 22 To select noncontiguous ranges, after selecting the first range,hold down the ____ key an drag through the additional ranges ofcells to select them. a. ALT b. F3 c. CTRL d. F10 1 points QUESTION 23 What is the path to the What-If Analysis button? a. (INSERT tab | What-If Tools group) b. (DATA tab | Data Tools group) c. (INSERT tab | Conditions group) d. (HOME tab | Analysis group) 1 points QUESTION 24 When a formula fails to pass one of the rules and backgroundformula checking is enabled, Excel displays a small ____ in theupper-left corner of the cell assigned the formula. a. green triangle b. red circle c. blue square d. green diamond 1 points QUESTION 25 When building a worksheet for novice users, you should ____ thecells in the worksheet that you do not want changed, such as cellsthat contain text or formulas. a. delete b. protect c. hide d. code 1 points QUESTION 26 Which of the following is the maximum number of active datatables per worksheet? a. 5 b. 20 c. 50 d. As many as you want 1 points QUESTION 27 Which of the following is the path to the Borders button? a. (HOME tab | Editing group) b. (HOME tab | Clipboard group) c. (HOME tab | Alignment group) d. (HOME tab | Font group) 1 points QUESTION 28 Which of the following is the path to the Cell Stylesbutton? a. (FORMAT tab | Cells group) b. (FORMAT tab | Styles group) c. (HOME tab | Cells group) d. (HOME tab | Styles group) 1 points QUESTION 29 Which of the following is the path to the Fill button? a. (HOME tab | Alignment group) b. (HOME tab | Styles group) c. (HOME tab | Clipboard group) d. (HOME tab | Editing group) 1 points QUESTION 30 Which of the following is the path to the Financial button andthe PMT function? a. (HOME tab | Formulas group) b. (DATA tab | Function Library group) c. (FORMULAS tab | Function Library group) d. (FORMULAS tab | Defined Names group) 1 points QUESTION 31 Which of the following is the path to the Name Managerbutton? a. (FORMULAS tab | Names group) b. (FORMULAS tab | Calculation group) c. (FORMULAS tab | Function Library group) d. (FORMULAS tab | Defined Names group) 1 points QUESTION 32 Which of the following is the path to the Protect Sheetbutton? a. (VIEW tab | Protect Sheet group) b. (REVIEW tab | Changes group) c. (HOME tab | Protection group) d. (VIEW tab | Protect group) 1 points QUESTION 33 With a(n) ____ data table you can vary the value in onecell. a. one-input b. two-input c. three-input d. unlimited-input 1 points QUESTION 34 You can add and format a range border by right-clicking theselected range and clicking ____ on the resulting shortcutmenu. a. Insert Comment b. Filter c. Format Cells d. Paste Options 1 points QUESTION 35 You can choose which rules you want Excel to use by enabling anddisabling them in the ____ area in the Excel Options dialogbox. a. General b. Proofing c. Formulas d. Advanced 1 points QUESTION 36 You can delete a data table by selecting the data table and then____. a. pressing the OVERTYPE key b. clicking the DELETE DATA TABLE command on a shortcut menu c. clicking the Delete command in the Clipboard group on the Hometab d. pressing the DELETE key 1 points QUESTION 37 You can deselect multiple selected sheets beginning with theSheet1 tab by pressing the ____ key and clicking the Sheet1tab. a. SHIFT b. TAB c. CTRL d. ALT 1 points QUESTION 38 You can scale a worksheet so that it will fit on one page withan option on the ____ tab in the Page Setup dialog box. a. Header/Footer b. Page c. Margins d. Sheet 1 points QUESTION 39 You can set up a worksheet to print in black and white with anoption on the ____ tab in the Page Setup dialog box. a. Sheet b. Header/Footer c. Page d. Margins 1 points QUESTION 40 You should create a(n) ____ when you want to keep others fromchanging the worksheet from protected to unprotected. a. administrative account b. password c. authorized user d. manager account 1 points QUESTION 41 You use a(n) ____ to automate data analyses. a. formula checker b. amortization schedule c. IF function d. data table Expert Answer