Skip to content
US +1(508)-456-0531
Home
About Us
Our Services
Pricing
LOGIN
ORDER NOW
2 and 3
Post navigation
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 &
Anotated Biblography- Greek/Roman Mythology