d. required b. dynamic 44. The header and footer sections include a a. left and right section c. top and bottom section b. center section only d. lelt, right, and center section 45. The category of Excel functions retums (true-false) values. a. Information c. Logical h. Statistical d. Math & Trig v 46. Which of the following is a Statistical function? 2. INT C. ROUND b. RAND b d. AVERAGE 47. Which of the following is a Math & Trig function? a. INT 6. MIN . b. COUNT d. AVERAGE 48. ROUND(AVERAGE(A1:A100),2) is an example of a(n) function. a complex c. absolute b. logical d. nested d 49. One way to perform a is by changing one or more of the input values to see how they affect the calculated results. . 3. goal seck c. scarch b. gunction d what-if analysis 50. If the VLOOKUP function cannot find the lookup value, the error value is displayed in the cell. a. #VALUE c. #ERROR h. #N/A d. #NULL V 51. functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas. 2. Sum c. Lookup h. Averag d. Find 52. =IF(G22"x", SUM(H22:J22), ") with display ir G22 is not equal to "x". a. a blank cell c. dashes b. the result of the SUM d. False 53. A contains the actual values that are plotted on the chart. a data source a. 6. category values b. data series d. legend v 54. Category values are usually located in the of the data source. a. first row c. either a orb b. first column d. neither a norb da is the only one of the following charts to compare relative values from different categories to the whole. a pie c. line b. column d. area 56. To add and remove chart elements, you can use the Add Chart Element button in the Charts Layout group on the tab. a. CHART TOOLS LAYOUT C. INSERT b. CHART TOOLS DESIGN d. HOME 57. The displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series. al clustered column chart c. 100% stacked column chart b. stacked column chart d. column chart 58. The possible values for the type argument in the function above are. a. O or null c. 0, 1, or 2 b. 0 or 1 b d. 0, 1, 2, or 3 59. The amount of money being loaned is known as the a. mortgage c. loan amount b. principal d. proposed principal V 60. The FV function stands for a. function value c. financial value b. future value d. formulated value 55. The