*



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

*

*

*

Solved… Inquiry 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… Inquiry 1 Cell Used Distinguish Different Functional Parts Worksheet Ranges B Indices C Q13359317


QUESTION 1 Cell ____ can be used to differentiate the different functionalparts of a worksheet. a. ranges b. indices c. borders d. worths 10 points QUESTION 2 ____ ensures that customers carry out not adjust worths inadvertently thatare crucial to the worksheet. a. Cell defense b. A information table c. The formula checker d. Range Finder 1 points QUESTION 3 ____ examines the formulas in a workbook in a manner equivalent tothe means 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 ____ regularly is developed from column or row titles. a. formula b. information table c. name d. function 1 points QUESTION 5 A inspect note in the ____ inspect box accelerates printing byignoring formatting and also not printing most graphics. a. Gridlines b. Black and white c. Draft top quality d. Print titles 1 points QUESTION 6 A(n) ____ reflects the start and finishing balances and also the amountof payment that is applied to the major and also interest duringeach payment duration. a. information table b. formula checker c. dialog box d. amortization schedule 1 points QUESTION 7 Cell ____ can be provided to differentiate the various functionalparts of a worksheet. a. indices b. boundaries c. ranges d. worths 1 points QUESTION 8 Data tables have to be developed in a(n) ____ location of a worksheet. a. upper-left b. unoffered c. used d. lower-right 1 points QUESTION 9 If you click the ____, Excel screens a menu; the initially item inthe menu identifies the error and also the remainder of the menuincludes commands from which you have the right to pick. a. cell boundary b. Error Checking switch c. Trace Error switch d. fill take care of 1 points QUESTION 10 If you wish to permit an additional worksheet user to be able tomanipulate some cells, leave those cells ____. a. locked b. hybrid c. undefended d. indexed 1 points QUESTION 11 In a process referred to as ____, Excel continually reviews the workbookfor errors in formulas as you produce or manipulate it. a. foreground formula checking b. background attribute checking c. workbook formula checking d. background formula checking 1 points QUESTION 12 In the accompanying number, the Publish area box accepts a name ora ____ to print. a. worksheet b. file c. tab d. variety 1 points QUESTION 13 Names are ____ cell referrals. a. absolute b. mixed c. relative d. formatted 1 points QUESTION 14 Names are ____ to the workbook. a. global b. nationwide c. international d. inclusive 1 points QUESTION 15 Rather than manually setting a print location each time you want toprint a range, you can ____ the selection. a. manipulate b. validate c. name d. lock 1 points QUESTION 16 Similar to the spell checker, Excel has actually a formula checker thatchecks formulas in a worksheet for ascendancy ____. a. repetitiveness b. consistency c. violations d. brevity 1 points QUESTION 17 The ____ feature 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 role areoptional. a. parentheses b. quotation marks c. brackets d. braces 1 points QUESTION 19 To hide a whole workbook on an unattfinished 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 proccasion round-off errors, usage the ____ attribute. a. RADIANS b. RAND c. ROMAN d. ROUND 1 points QUESTION 21 To proccasion sensitive information from being checked out in a worksheet, youdeserve to hide the worksheet by clicking ____ on the shortcut food selection. a. Hide Sheet b. Hide Rows and also Columns c. Hide d. Hide Workbook 1 points QUESTION 22 To select noncontiguous arrays, after choosing the first range,organize down the ____ essential an drag with the extra varieties ofcells to pick them. a. ALT b. F3 c. CTRL d. F10 1 points QUESTION 23 What is the route to the What-If Analysis button? a. (INSERT tab | What-If Tools group) b. (DATA tab | Documents Tools group) c. (INSERT tab | Conditions group) d. (HOME tab | Analysis group) 1 points QUESTION 24 When a formula falls short to pass among the rules and also backgroundformula checking is permitted, Excel display screens a small ____ in theupper-left edge of the cell assigned the formula. a. green triangle b. red circle c. blue square d. green diamond 1 points QUESTION 25 When structure a worksheet for novice customers, you have to ____ thecells in the worksheet that you do not want readjusted, such as cellsthat contain text or formulas. a. delete b. defend c. hide d. code 1 points QUESTION 26 Which of the following is the maximum variety of energetic datatables per worksheet? a. 5 b. 20 c. 50 d. As many type of as you want 1 points QUESTION 27 Which of the complying with is the route 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 adhering to is the route 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 switch 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 route 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 complying with is the course 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 have the right to differ the worth in onecell. a. one-input b. two-input c. three-input d. unlimited-input 1 points QUESTION 34 You have the right to add and also format a range border by right-clicking theselected array and clicking ____ on the resulting shortcutfood selection. a. Insert Comment b. Filter c. Style Cells d. Paste Options 1 points QUESTION 35 You deserve to choose which rules you want Excel to usage by allowing anddisabling them in the ____ location in the Excel Options dialogbox. a. General b. Proofing c. Formulas d. Advanced 1 points QUESTION 36 You have the right to delete a file table by choosing the information table and also then____. a. pressing the OVERTYPE key b. clicking the DELETE DATA TABLE command also on a shortreduced menu c. clicking the Delete command also in the Clipboard group on the Hometab d. pressing the DELETE crucial 1 points QUESTION 37 You have the right to deselect multiple selected sheets start via theSheet1 tab by pushing the ____ vital and clicking the Sheet1tab. a. SHIFT b. TAB c. CTRL d. ALT 1 points QUESTION 38 You deserve to scale a worksheet so that it will certainly fit on one web page withan alternative on the ____ tab in the Page Setup dialog box. a. Header/Footer b. Page c. Margins d. Sheet 1 points QUESTION 39 You have the right to erected a worksheet to print in babsence and white via analternative on the ____ tab in the Page Setup dialog box. a. Sheet b. Header/Footer c. Page d. Margins 1 points QUESTION 40 You must produce a(n) ____ when you want to keep others fromchanging the worksheet from safeguarded to unsafeguarded. a. bureaucratic account b. password c. authorized user d. manager account 1 points QUESTION 41 You use a(n) ____ to automate information analyses. a. formula checker b. amortization schedule c. IF function d. data table Expert Answer