CGS2100 Excel Study Guide Margaret Cooksey Excel is an electronic version of a n SPREADSEET Excel stores its documents as files called WORKBOOKS The contents of an active cell are displayed in the FORMULA BAR A chart can be displayed WORKSHEET CHARTSHEET The intersection of a row and column is known as a CELL To make A1 the active cell press which of the following keys CTRL HOME The characters and are examples of MATHEMATICAL FUNCTIONS The expression used to calculate values displayed in a worksheet is called a n FUNCTION An Excel formula always begins with a n f x The formula used to multiply cell A1 by cell C1 is A1 C1 A n RANGE is a group of cells The contents of the active cell shown as item 2 in the figure above can also be seen in the To select a nonadjacent range select an adjacent range press and hold and Then press and hold 13 the Ctrl key and with the mouse select the next area One of the benefits of Live Preview is that YOU KNOW WHAT WILL LOOK LIKE WHEN IT PRINTS The LOGICAL FUNCTIONS category of Excel functions returns true false values 16 Which of the following is not a comparison operator The PMT function is a n PERSONAL FINANCES function The amount of money being loaned is known as the PRINCIPAL In the figure above nper stands for the The function being shown in the figure above is the function 21 Which item in the figure above is the required argument In the figure above where will item 5 also be displayed The AutoSum button is equivalent to using the SUM function The advantage of RELATIVE references is that you can create a general formula that you can use again and again in 24 your worksheet 1 2 3 4 5 6 7 8 9 10 11 12 14 15 17 18 19 20 22 23 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 29 30 31 32 Another name for the middle value is the MEDIAN value Arguments can be cell references numbers or text If an optional argument is not included Excel assumes a n value for it The fill handle copies content and formats is a n COMPARISON operator Charles has entered all of his monthly expenses He needs to create a formula that will deduct his monthly expenses 33 from his monthly income Since his monthly income is the same amount each month he uses a n absolute reference 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 36 ThePIE is the only one of the following charts to compare relative values from different categories to the whole 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