New version page

# TCC CGS 2100 - Study Guide

Pages: 2
Documents in this Course

## This preview shows page 1 out of 2 pages.

View Full Document
Do you want full access? Go Premium and unlock all 2 pages.

Unformatted text preview:

CGS2100 Excel 2010 Test REVIEW1. 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+HOME7. 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 PRINTS_.15. The _LOGICAL FUNCTIONS___ category of Excel functions returns (true-false) values16. 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 reference__ to identify 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 principal___.35. The _PIE___ 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 WANTKnow the parts of the

View Full Document Unlocking...