**Unformatted text preview:**

CGS2100 Excel Study GuideMargaret Cooksey1. Excel is an electronic version of a(n) SPREADSEET.2. Excel stores its documents as files called WORKBOOKS.3. The contents of an active cell are displayed in the FORMULA BAR.4. A chart can be displayed WORKSHEET/CHARTSHEET.5. The intersection of a row and column is known as a CELL.6. To make A1 the active cell, press which of the following keys? CTRL+HOME.7. The characters +, -, *, and / are examples of MATHEMATICAL FUNCTIONS.8. The expression used to calculate values displayed in a worksheet is called a(n) FUNCTION.9. An Excel formula always begins with a(n) f(x).10. The formula used to multiply cell A1 by cell C1 is =A1*C1.11. A(n) RANGE is a group of cells.12. The contents of the active cell shown as item 2 in the figure above can also be seen in the ____.13. To select a nonadjacent range, select an adjacent range, press and hold and Then press and hold the Ctrl key and with the mouse select the next area.14. One of the benefits of Live Preview is that YOU KNOW WHAT WILL LOOK LIKE WHEN IT PRINTS15. The LOGICAL FUNCTIONS category of Excel functions returns (true-false) values.16. Which of the following is not a comparison operator? ____17. The PMT function is a(n) PERSONAL FINANCES function.18. The amount of money being loaned is known as the PRINCIPAL.19. In the figure above, nper stands for the ____.20. The function being shown in the figure above is the ____ function.21. Which item in the figure above is the required argument? ____22. In the figure above, where will item 5 also be displayed? ____23. The AutoSum button is equivalent to using the SUM function.24. The advantage of RELATIVE references is that you can create a “general” formula that you can use again and again in your worksheet.25. Absolute references are marked with a $.26. When you copy a formula that contains an absolute reference to a new location, the reference ACCOMMODATES THE INFORMATION TO THAT CELL WITH THE SAME FORMULA.27. Which type of RELATIVE references should you use when you want different formulas to refer to the same cell.28. Another name for the middle value is the MEDIAN value.29. Arguments can be cell references, numbers, or text.30. If an optional argument is not included, Excel assumes a(n) value for it.31. The fill handle copies content and formats.32. >= is a(n) COMPARISON operator.33. Charles has entered all of his monthly expenses. He needs to create a formula that will deduct his monthly expenses from his monthly income. Since his monthly income is the same amount each month, he uses a(n) absolute referenceidentify the cell containing the income value.34. Pamela needs to borrow $30,000 as a down payment for her condominium. This amount will be the _interest paid is calculated on the principal and any previous interest payments that have been added to that principal35. ThePIE is the only one of the following charts to compare relative values from different categories to the whole.36. One advantage of breaking up a sparkline group is CAN BE FORMED INDIVIDUALLY37. A column sparkline can be COUMN CHARTS.38. The most efficient way to format an entire table is to USE A TABLE STYLE.39. How can you format using the Number group in Excel’s home tab? BY SELECTING THE GROUP OF NUMBER YOU WANT HIGHLIGHTED, THEN SELECTING WHAT TYPE OF FORMAT YOU WANT40. Know the parts of the

View Full Document