A+ Answers

1. Which one of following is an example of a formatted number using the Currency option? A. 7,7789.2 B. 777892 C. $7778.92 D. 7778.92% 2. If you sort a portion of an Excel sheet and you get an error message such as #DIV/0, what is a likely cause of the error message? A. One or more cells contain relative cell references. B. One or more cells contain absolute cell references. C. The cell ranges are incorrect. D. You're attempting to sort too many cells. 3. A feature in Excel that allows you to graphically display in a single cell the trend across a range of cells is called a A. spark point. B. pivot point. C. pivot line. D. sparkline. 4. A rectangular range of cells with headings to describe the cells' contents is referred to as a A. sparkline. B. bar chart.
C. table. D. complex formula. 5. Which of the following processes should Angel use to merge cells A1:D4 to create a title? A. Highlight cells A1:D4, right-click and select Format Cells, click Number, and choose the Merge cells option. B. Highlight cells A1:D4, click on the Home tab, and click on the Merge cells icon in the Styles group. C. Highlight cells A1:D4, click on the Home tab, and click on the Wrap text icon in the Alignment group. D. Highlight cells A1:D4, right-click and select Format Cells, click Alignment, and choose the Merge cells option. 6. Helga needs to lay out her newly created pivot table. What are the two ways she can set up a pivot table? A. Helga can drag the fields to the four boxes in the pivot table field list or right-click a field name and choose its location from the shortcut menu. B. When Helga created the pivot table, Excel automatically put the fields to the appropriate cells of the pivot table. There aren't two ways to set up a pivot table. C. Helga can slide cells to the four boxes or double-click
properties to choose from a list of pivot table options. D. Helga can check the field or type in the data in the pivot table. 7. To combine a range of cells into one large cell, you should highlight the cells and choose A. Increase Indent. B. Decrease Indent. C. Wrap Text. D. Merge Cells. 8. Which of the following is a group of cells chosen to perform an action? A. Data series B. Command C. Range D. Group 9. You plan to use the Fill Down feature on a formula and you need to keep a cell reference the same. Which one of the following formats will allow you to keep the same cell reference? A. E19 B. $E$19 C. $E19 D. E$19 10. What category of predefined formulas in Excel contains the Boolean functions? A. AutoSum B. Recently Used C. Logical D. Math and Trig 11. You've been asked to find the largest number in a range of numbers. Which of the following could you use to find the largest number in range E11:E23? A. =MAX(E11:E23) B. =SUM(E11:E23) C. =MIN(E11:E23) D. =AVERAGE(E11:E23) 12. Andrea needs to format the legend on her chart. She clicks on the chart to select it. Which of the following options appears only when a chart is selected? A. Page Layout B. Insert C. Chart Tools D. Review 13. Which of the following ranges of cells is correctly named? A. A/E5 B. A5:E5 C. A5:G1 D. A5+G1 14. John wants to see the formulas he has used in his spreadsheet but he does not want to see the results of the formulas. How does he display his formulas? A. Click Print Formulas. B. Click on Trace Precedents. C. Click Evaluate Formulas. D. Click on Show Formulas. 15. The order of precedence determines A. the properties of the cell reference. B. the order in which calculations are performed. C. the order in which worksheets are printed. D. how values are divided and multiplied. 16. David has a small business and is working on an Excel worksheet to help manage his inventory. David realizes cell E14 has the wrong output. To check the problem, David should first select cell E14 and look at the _______ to check the formula. A. range B. Name box C. Function tab D. Formula bar 17. You've been asked to find the average of a range of numbers. Which of the following could you use to find the average of cells A1:A10? A. =MAX(A1:A10) B. =AVERAGE(A1:A10) C. =MIN(A1:A10) D. =SUM(A1:A10) 18. The functions you tend to use regularly are listed where on the Ribbon? A. Date & Time B. Text C. Logical D. Recently Used 19. Joshua needs to join the text in two cells together. Which of the following would perform this function? A. =Good "&" Morning B. ="Good"&"Morning" C. ="Good"+"Morning" D. ="Good"&&"Morning" 20. Which of the following is an example of a complex formula? A. =A1<= A14 B. Income – Expenses C. =150*.05 D. SUM(A1:A14