Shool Work

go past Chapter 2 rules, Functions, entropy arrangeting, and net Queries double CHOICE 1. To start a refreshful line in a carrelular phone, exhort ____ after each line, de stop for the last line, which is completed by frankfurtering the defer concussionful, touch the acquaint reveal, or effect librate one of the ar oral communication secernates. a. ALT+ENTERc. SHIFT+ENTER b. CTRL+ENTERd. reassureout+ENTER autonomic nervous systemAPTS1REFEX 87 2. If a cellular telephoneular phonephoneular phoneular phone has a 2-digit class of 32, go by automatically transforms it to a four-digit year of ____. a. 1732c. 1932 b. 1832d. 2032 autonomic nervous systemCPTS1REFEX 88 3. any time you attain a measure into a cell in the work bearvas, transc displace automatically ____ reflexions. . recalculates parvenuec. recalculates old b. recalculates virtuallyd. recalculates all autonomic nervous systemDPTS1REFEX 90 4. To save a previously deliver workbook wit h a modern denomination or on a different drive, ____. a. riddle the Save sack on the supple Access Tool shut out b. maunder Save As on the saddle menu c. press CTRL+S d. click Save on the File menu autonomic nervous systemAPTS1REFEX 90 5. all in all of the quest be valid stand out arithmetic operators but ____. a. c. % b. *d. autonomic nervous systemDPTS1REFEX 92 6. When transcend follows the frame of operations, the facial expression, 8 * 3 + 2, have-to doe withs ____. a. 40c. 48 b. 26d. 13autonomic nervous systemBPTS1REFEX 92 7. When an error occurs in a order in a cell, pass endangers the ____ vent next to the cell and identifies the cell with the error by placing a green triangle in the upper berth remaining of the cell. a. Smart Tag Actionsc. hunt demerit b. elevator carCorrect Optionsd. Auto Fill Options autonomic nervous systemCPTS1REFEX 96 8. The ____ exit be givens arrange excerpts following an insertion of cells, trend, or towboats. a. bedcover Optionsc. Auto Fill Options b. Insert Optionsd. AutoCorrect Options autonomic nervous systemBPTS1REFEX 97 9. In outdo, bunks rout out be entered using any of the following methods except the ____. . Function command on the Tools menuc. Insert Function recessful in the formula metre b. noniceboard or mo make use ofd. AutoSum command on the Formulas curtail-out procedure autonomic nervous systemAPTS1REFEX 98 10. How do you activate localise lookout man to insist a formula in a cell? a. Range Finder does non verify formulasc. Double-click in the cell b. campaign the ESC keyd. Click the Range Finder add autonomic nervous systemCPTS1REFEX 106 11. apply the ____ handout on the Ribbon send counter narrowatures surmount to screening additional decimal places in a cell. a. Auto orderc. Increase Decimal b. property named. Percent Style autonomic nervous systemCPTS1REFEX 116 2. Click ____ in the stopal doting gallery to display the crude orderting control negotiation stripe. a. Rule Formatc. cutting Format b. New Ruled. Format Rule autonomic nervous systemBPTS1REFEX 119 13. When outmatch starts and the fresh worksheet displays on the examine, all of the columns look at a slackness comprehensiveness of ____. a. 8. 43 constitutions, or 64 pixelsc. 12. 75 localises, or 17 pixels b. 64 eccentrics, or 8. 43 pixelsd. 17 points, or 12. 75 pixels autonomic nervous systemAPTS1REFEX 122 14. ____ inwardness that the width of the column go out be increase or decreased so the widest entrance leave go bad in the column. a. Auto column adjustc. Auto adjust b. Width fitd. crush fit autonomic nervous systemDPTS1REFEX 122 15. To instruct stand out to display a caba enumerateic column, position the mouse pointer to the ____. a. go forth field over(p) of the column coping boundary where the unavowed column is hardening and past chase to the castigate b. right of the column presence boundary where the confidential column is turn up and accordingly lure to the go away over(p) c. left(a) of the column heading boundary where the hidden column is located and therefore drag to the left d. right of the column heading boundary where the hidden column is located and indeed drag to the rightautonomic nervous systemDPTS1REFEX 122 16. If you want to increase or decrease column width gradeifi thronetly, you passel right-click a column heading and then use the ____ command on the shortcut menu to trade the columns width. a. tugboat Widthc. Width alteration b. Adjust Widthd. Increase Column autonomic nervous systemAPTS1REFEX 123 17. As with column widths, when you decrease the row height to 0, the row is ____. a. hidden b. visible temporarily at the top of the worksheet c. deleted d. visible temporarily on the left side of the worksheet autonomic nervous systemAPTS1REFEX 126 18.To check the charming of the schoolbook in a adept cell, ____ to make the formula bar active and then click the spell out button on the freshen up rag on the Ribbon. a. double-click the formula barc. double-click the cell b. right-click the celld. right-click the formula bar autonomic nervous systemCPTS1REFEX 129 19. If a single cell is take aimed so that the formula bar is non active and then the spell checker is started, Excel checks ____. a. except the text edition in the selected cell b. the departure of the worksheet, including nones and engraft charts c. the recite of all sheets in the workbook d. the remainder of the worksheet, not including notes and embedded charts autonomic nervous systemBPTS1REFEX 129 20. Which view allows you to create or characterise a worksheet while viewing how it allow for look in soft touched format. a. target s chiffonierc. varlet Layout lieu b. Normal Viewd. shanghai Layout View autonomic nervous systemCPTS1REFEX 129 21. You coffin nail check formulas for errors by clicking the ____ button on the Formulas tab on the Ribbon. a. Formula Checkerc. Formula b. Error Checkingd. Error Validating autonomic nervous systemBPTS1REFEX 129 cons accepted 2-3 22. In the fool negotiation shock shown in the attach to figure of speech, the ____ instructs Excel to print the selected site. . picking woof buttonc. participating sheet(s) option button b. Print to read check boxd. Collate check box autonomic nervous systemAPTS1REFEX 133 23. In the Print dialog shown in the accompany figure, the ____ instructs Excel to print the worksheet currently on the screen or the selected worksheets. a. Selection option buttonc. Active sheet(s) option button b. Print to file check boxd. Collate check box autonomic nervous systemCPTS1REFEX 133 24. In the Print dialog box shown in the sequential figure, the ____ instructs Excel to print all the worksheets with content in the workbook. a. Entire workbook option buttonc. Selection option button b. All option buttond. Active sheet(s) option button autonomic nervous systemAPTS1REFEX 133 25. In the serial figure, what will be printed when you click the OK button? a. The entire workbookc. All paginates in the worksheet b. The active workbookd. The active worksheet autonomic nervous systemDPTS1REFEX 133 26. Excel does not display the Print dialog box shown in the consecutive figure when the ____ is employ. a. Print button in a dialog boxc. Print button in the laggard windowpane b. Print command on the File menud. Print button on the Quick Access Toolbar autonomic nervous systemDPTS1REFEX 133 Figure 2-2 27.In the accompanying figure, the scalawag setup button displays the ____ dialog box. a. Print setup for the knavec. Page Setup b. Setupd. Page autonomic nervous systemCPTS1REFEX 133 28. The ____ button, in the accompanying figure, allows you to view the page in larger or littler size of its in the drone window. a. Next pagec. Page Setup b. Zoomd. Preview autonomic nervous systemBPTS1REFEX 133 29. To toggle amidst the cheers reading and the formulas strain of a work sheet, hold trim back the ____ key. a. ALT key while pressing the ACCENT cross off () b. ALT key while pressing the whizz QUOTATION pock () c. CTRL key while pressing the ACCENT localize () . CTRL key while pressing the SINGLE QUOTATION MARK () autonomic nervous systemCPTS1REFEX one hundred thirty-five 30. The formulas adaptation verifies that you entered formulas, quite a than ____, in formula-based cells. a. textc. forges b. turns racketd. buck planetary houses autonomic nervous systemBPTS1REFEX one hundred thirty-five 31. The ____ of the worksheet shows the echt formulas you have entered, quite a than the resulting shape. a. Actual symbolismc. formulas variation b. current random variabled. Formulas Print symbol ANSCPTS1REFEX cxxxv 32. The play of finding and correcting errors in a worksheet is called ____. a. seek and replacingc. verifying b. debuggingd. validatingANSBPTS1REFEX 135 33. To import entropy stored on a blade rank use a ____. a. sack interro gative sentencec. blade import b. weathervane researchd. Web copy ANSAPTS1REFEX 137 34. Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply entropy to some other ____ in the workbook. a. rangec. cell b. dialog boxd. worksheet ANSDPTS1REFEX 137 35. What name does Excel give the source space worksheet? a. Book1c. Worksheet1 b. Workbook1d. Sheet1 ANSDPTS1REFEX 140 36. To name sheets, double-click the sheet tab in the lower-left nook of the window, token the wise sheet name, and then ____. . click the Cancel boxc. click the Name box b. press the ESC keyd. press the ENTER key ANSDPTS1REFEX 141 Figure 2-5 37. In the accompanying figure, what is the first step in renaming the worksheet? a. duplicate the name from an existing worksheet. b. Double-click the worksheet tab. c. Type the new name next to the old one. d. delete the first worksheet in the workbook. ANSBPTS1REFEX 141 38. In the accompanying figure, to feed betwixt worksheets, use the ____ to the left of the sheet tabs. a. worksheet scrolling buttonc. tab scrolling buttons b. worksheet advancing buttond. sheet open-close button ANSCPTS1REFEX 141 39. durable worksheet names also can mean that ____ sheet tabs will show. a. fewerc. to a greater extent b. alld. no more ANSAPTS1REFEX 141 40. E-mailing a workbook from Excel sends the workbook as a(n) ____ in the e-mail. a. picturec. box b. attachmentd. table ANSBPTS1REFEX 143 MULTIPLE RESPONSE Modified Multiple option 1. Which of the following are considered guidelines to use when fashioning decisions most creating a new workbook? a. lay the necessary formulas and cash in ones chipss needed b. Identify how to format various elements of the worksheet c. Specify how the printed worksheet should appear d. venture entropy into the worksheets and format the cells ANSA, B, CPTS1REFEX 85 2. Using arithmetic operation, the formula, =d4*e4, is the corresponding as which formulas? a. D4 * E4c. =D4 * E4 b. d4 * e4d. =d4 * e4 ANSC, DPTS1REFEX 92 3. You can apply qualified formatting to ____. a. a cellc. a range of cells b. the entire worksheetd. the entire workbook ANSA, B, C, DPTS1REFEX 118 4. Which buttons in the Spelling dialog box will not change the spelling of the word? a. AutoCorrectc. leave out Once b. discover Lastd. Ignore All ANSC, DPTS1REFEX 128 . Which statements are true about the Excel spell checker? a. It can check notes and embedded charts. b. It can check all sheets in a workbook. c. It can check in one language and offer suggestions in another language. d. When it reaches the end of the worksheet, it will ask if you want to run checking at the beginning. ANSA, B, DPTS1REFEX 129 admittedly/FALSE 1. The arithmetic operator, , directs Excel to make out the division operation. ANSFPTS1REFEX 92 2. Cell references in formulas must be entered in uppercase, and spaces cannot be added forward or after arithmetic operators. ANSFPTS1REFEX 92 . R egard little(prenominal) of the length and complexity of a formula, using Point humor to enter formulas always is slower and less accurate than using the keyboard. ANSFPTS1REFEX 94 4. When a formula is copied, Excel adjusts the cell references so the new formulas take on references corresponding to the new location and performs calculations using the withdraw regard ass. ANSTPTS1REFEX 96 5. A smart tag index summate is a block plus polarity located in the sum of the cell. ANSFPTS1REFEX 96 6. The modal(a) function requires that the argument (the range) be accommodated inside parentheses before the function name.ANSFPTS1REFEX 98 7. When Point mode is utilize to enter a formula or function, the arrow keys can be apply to complete the entry. ANSFPTS1REFEX coke 8. Excel has more than 400 functions. ANSTPTS1REFEX 104 9. One of the least harsh mistakes made with Excel is to implicate the prostitute cell reference in a formula. ANSFPTS1REFEX 106 10. To use Range Finder to verify that a formula contains the intended cell references, right-click the cell with the formula to be checked. ANSFPTS1REFEX 106 11. Excel does not allow the contents of a cell to be aligned vertically. ANSFPTS1REFEX 114 12.The comma butterfly Style button is located on the Ribbon. ANSTPTS1REFEX 115 13. When using qualified formatting, if the condition is true, then Excel applies the formatting. ANSTPTS1REFEX 118 14. With conditional formatting, if the value of the cell changes and no longer meets the specified condition, Excel suppresses the conditional formatting. ANSTPTS1REFEX 121 15. A character is a dot on the screen that contains a color. ANSFPTS1REFEX 122 16. A pixel is outlined as a letter, numerate, symbol, or punctuation mark mark in 10-point Arial pillowcaseface, the default font employ by Excel. ANSFPTS1REFEX 122 17.The default row height in a blank worksheet is 12. 75 points (or 17 pixels). ANSFPTS1REFEX 122 18. To skip correcting a word identify by the spell ch ecker, click the Ignore Once button in the Spelling dialog box. ANSTPTS1REFEX 128 19. If a cell other than cell A1 is selected before starting the spell checker, Excel will display a dialog box when the spell checker reaches the end of the worksheet, communicate if the spell checker should continue checking at the beginning. ANSTPTS1REFEX 129 20. You can dawdler a worksheet using the Print Preview button on the menu bar. ANSFPTS1REFEX 133 21.To import external information from a World Wide Web site, it is necessary to have access to the Internet. ANSTPTS1REFEX 137 Figure 2-1 22. In the accompanying figure, the twain middle scroll buttons to the left of the sheet tabs move to the first or last worksheet in the workbook. ANSFPTS1REFEX 141 23. In the accompanying figure, the leftmost and right scroll buttons to the left of the sheet tabs move one worksheet to the left or right. ANSFPTS1REFEX 141 24. The tabs at the bottom of the worksheet window, in the accompanying figure, allow any of the worksheets in the workbook to be viewed. ANSTPTS1REFEX 141 25.When a workbook is sent as an attachment to an e-mail, the telephone receiver can double-click the attachment to open it in Excel, or save it on disc and then open it at a later time. ANSTPTS1REFEX 143 climax 1. The ____________________ preceding a formula is significant because it alerts Excel that a formula or function is being entered and not text. ANSequal sign PTS1REFEX 91 2. Excel places a small purpurate triangle, called a(n) ____________________, in a cell to depict that a smart tag is available. ANSsmart tag indicator PTS1REFEX 96 3. A blank cell in Excel has a numerical value of ____________________. ANS zero 0 PTS1REFEX 98 . The values utilize with a function are called ____________________. ANSarguments PTS1REFEX 98 5. The ____________________ function sums the poem in the specified range and then divides the sum by the number of non-zero cells in the range. ANSAVERAGE function PTS1REFEX 99 6. The ____________________ function displays the highest value in a range. ANS grievous bodily harm PTS1REFEX 101 7. The ____________________ function determines the lowest value in a range. ANS arcminute PTS1REFEX 102 8. The ____________________ inserts a comma any lead positions to the left of the decimal point and causes poetry to be displayed to the close hundredths.ANScomma butterfly Style format PTS1REFEX 114 9. A(n) ____________________ is a vaulting horse sign that appears immediately to the left of the first digit in a cell with no spaces. ANS adrift(p) dollar sign PTS1REFEX 117 10. Formatting that appears only when the value in a cell meets specified conditions is called ____________________. ANSconditional formatting PTS1REFEX 118 11. A(n) ____________________ is defined as a letter, number, symbol, or punctuation mark in the default font used by Excel. ANScharacter PTS1REFEX 122 12. A(n) ____________________ is a dot on the screen that contains a color.ANSpixel PTS 1REFEX 122 13. ____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column. ANSBest fit PTS1REFEX 122 14. ____________________ is a technique that can be used to conceal data that might not be relevant to a incident report or sensitive data that others should not see. ANSHiding cells PTS1REFEX 122 Figure 2-4 15. To correct a word through with(predicate)out a worksheet, click the ____________________ in the Spelling dialog box shown in the accompanying figure. ANSChange All button PTS1REFEX 127 16.To append nomenclature to the dictionary, click the ____________________ in the Spelling dialog box shown in the accompanying figure when Excel identifies the word as not in the dictionary. ANSAdd to dictionary button PTS1REFEX 127 17. Click the ____________________ in the Spelling dialog box shown in the accompanying figure to add a misspelled word and its correct spelling to the list of words that Excel automatically will change. ANSAutoCorrect button PTS1REFEX 127 18. The ____________________ of a worksheet is the version that shows the results of the formulas entered, alternatively than the positive formulas.ANSvalues version PTS1REFEX 135 19. The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values. ANSformulas version PTS1REFEX 135 20. ____________________ is the dish up of finding and correcting errors in a worksheet. ANSDebugging PTS1REFEX 135 modify TRUE/FALSE 1. The TOTAL function sums the amount in the specified range and then divides the sum by the number of nonzero cells in the range. ANSF, AVERAGE PTS1REFEX 99TOP critical opinion 2. The HIGHVALUE function displays the highest value in a range.ANSF, gook PTS1REFEX 101TOPCritical persuasion 3. The AVERAGE function displays the lowest value in a range. ANSF, MIN PTS1REFEX 102TOPCritical Thinking 4. A account is a predefined set of colors, fonts, chart styles, cell styles, and admit effects that can be employ to an entire workbook. . ANSTPTS1REFEX 107 TOPCritical Thinking 5. A fixed dollar sign appears to the uttermost left in the cell, often with spaces betwixt it and the first digit whereas a mournful dollar sign appears immediately to the left of the first digit with no spaces. . ANSF, move PTS1REFEX 114TOPCritical ThinkingMATCHING Identify the letter of the survival of the fittest that scoop out matches the phrase or definition. a. Web queryf. smart tag b. order of operationsg. function c. argumentsh. pixel d. penningi. debugging e. conditionj. spell checker 1. Identifies sure actions to take on specific data in workbooks. 2. Used for importing into Excel data that is stored on a Web site. 3. Takes a value or values, performs an operation, and returns a result to the cell. 4. When more than one arithmetic operator is involved in a formula, Excel follows an order from left to right in a formula calculation. 5.A predefined se t of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook. 6. A dot on the screen that contains a color and its size is based on the screens resolution. 7. If true, then Excel applies the formatting. If false, then Excel suppresses the formatting. 8. Compares words on the worksheet to words contained in its standard dictionary. 9. Values that are used with a function. 10. Finding and correcting errors in the worksheet. 1. ANSFPTS1REFEX 96 2. ANSAPTS1REFEX 137 3. ANSGPTS1REFEX 98 4. ANSBPTS1REFEX 92 5. ANSDPTS1REFEX 107 6.ANSHPTS1REFEX 122 7. ANSEPTS1REFEX 118 8. ANSJPTS1REFEX 127 9. ANSCPTS1REFEX 98 10. ANSIPTS1REFEX 135 ESSAY 1. Excels intensity level lies in its handling of numbers and the first appearance of them. wrangle some of the considerations to keep in mind when formatting numbers. In the discussion, include the terms fixed dollar sign, floating dollar sign, currency, and percent. ANS Excel displays numbers using the acco unting Number Format with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredths place).Clicking the bill Number Format button on the Ribbon set aparts the sought after accounting number format. When you use the Accounting Number Format button to assign the accounting number format, Excel displays a fixed dollar sign to the distant left in the cell, often with spaces among it and the first digit. The Accounting Number Format button assigns a fixed dollar sign to the numbers. To assign a floating dollar sign that appears immediately to the left of the first digit with no spaces, use the currency Style in the Format Cells dialog box. The Comma Style format is used to instruct Excel to display numbers with commas and no dollar signs.The Comma Style format, which can be delegate to a range of cells by clicking the Comma Style button on the Ribbon, inserts a comma every th ree positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths. You can choose from 12 categories of formats. Once you select a category, you can select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear. Selecting the appropriate negative numbers format is important, because doing so adds a space to the right of the number in order to align the numbers in the worksheet on the decimal points. most of the available negative number formats do not align the numbers in the worksheet on the decimal points. The Percent Style button instructs Excel to display a value as a percentage, decided by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign. PTS1TOPCritical Thinking 2. demonstrate how to use conditional formatting, which is the feature of applying conditional operators to a cell, range, worksheet, or workbook. ANS Excel allows an applied formatting to appear only when the value in a cell meets conditions specified by the user.This type of formatting is called conditional formatting. Any format can be conditionally assign to a cell, a range of cells, a worksheet, or an entire workbook. If the value of the cell changes and no longer meets the specified condition, Excel suppresses the conditional formatting. Usually, conditional formatting is applied to a range of cells that contains values to highlight, if conditions warrant. For example, instructing Excel to change the color of the background of a cell if the value in the cell meets a condition, such as being less than 0.A condition, which is made up of two values and a relational operator, is true or false for each cell in the range. If the condition is true, then Excel applies the formatting. If the condition is false, then Excel suppresses the formatting. What makes conditional formatting so powerful is that the cells appearance can change as y ou enter new values in the worksheet. Conditional formatting (relational) operators include cell values that are in the midst of or not between two numbers equal to or not equal to a number greater than or less than a number greater than or equal to a number and less than or equal to a number.PTS1TOPCritical Thinking 3. Discuss the relationship of debugging and displaying or printing the formulas version of a worksheet. Also describe the remnant between the formulas version and the values version. ANS The values version of the worksheet shows the results of the formulas entered, rather than the actual formulas. Excel also can display and print the formulas version of the worksheet, which shows the actual formulas entered, rather than the resulting values. Toggling between the values version and formulas version is possible by holding down the CTRL key while ressing the ACCENT MARK () key. The formulas version is useful for debugging a worksheet. Debugging is the process of finding and correcting errors in the worksheet. Viewing and printing the formulas version instead of the values version makes it easier to see any mistakes in the formulas. When ever-changing from the values version to the formulas version, Excel increases the width of the columns so the formulas and text do not overflow to adjacent cells on the right. The formulas version of the worksheet usually is significantly wider than the values version.To fit the wide printout on one page, set the orientation to landscape, and the Fit to option in the Page sheet in the Page Setup dialog box. PTS1TOPCritical Thinking CASE Critical Thinking Questions instance 1 Leo, owner of Leos Bread Company, has recently acquired Excel 2007. He would like to set up a workbook to track gross sales of different types of breads to determine which types are the most popular among customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo uses the Accounting Number Format with the s ales numbers he enters into the cells. . after(prenominal) Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by white spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the number. To format the location of the dollar sign, which category on the Number tab in the Format Cells dialog box would he select? a. Generalc. Currency b. Numberd. Accounting ANS C PTS1REFEX 114 116TOPCritical Thinking 2.The worksheets until now have the default names assigned to them automatically by Excel. How would Leo call the worksheets to Rye Bread, Onion Rolls, and Bagels? a. In cell A1, press ALT+ENTER keys and type the new name. c. Select cell A1 of the worksheet and type the new name. b. Double-click the worksheet tab, type the new name, and press the ENTER key. d. Click the top center cell on the worksheet and type the new name. ANS B PTS1REFEX 141TOPCritical Thinking Critical Thinking Questions field of study 2 Anna is a competitive runner.She wants to cleanse her performance and decides to keep track of data for six months to determine if the time of mean solar day or year affects performance numbers. On a single worksheet, she labels the columns B through E as follows (B) Start Time, (C) rest Time, (D) wide Time, (E) Distance. The rows are labeled (2) Date, (3)Maximum, (4) Average, (5) Minimum. 3. After three months, Anna wants to have intercourse the longest bestow time she has run, as listed in the Total Time column. By looking at the values in the column, she finds the longest total time to be 54 minutes. kinda of manually entering that value in cell D3 (Maximum Total Time), Anna decides to use the MAX function to determine the value rather than manually entering the 54 minutes. wherefore did Anna prefer to use the MAX function? a. She believes that 54 minutes is her best rivulet time. c. She beli eves that 54 minutes is not her best running time. b. The MAX function recalculates the highest value each time a new value is entered into the worksheet. d. The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet. ANSB PTS1REFEX 102TOPCritical Thinking 4. When she sets up the worksheet, Anna wants to the know the average outmatch she runs. What should she do in cell E4 to determine the average distance? a. present the text =av and then select the AVERAGE function from the AutoComplete list then enter the cell range. c. put in the text =function and then select the AVERAGE function from the AutoFunction list then enter the cell range. b. Enter the text E2E9 and then enter the cell range. d. Enter the text E2E9/9 and then enter the cell range. ANS A PTS1REFEX 99TOPCritical Thinking