Unformatted text preview:

CGS2100 Excel Study Guide Margaret Cooksey 1 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 PRINTS 15 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 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 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 INDIVIDUALLY 37 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 WANT 40 Know the parts of the Chart


View Full Document

TCC CGS 2100 - Study Guide

Download Study Guide
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Study Guide and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Study Guide 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?