**Unformatted text preview:**

CGS2100 Excel 2010 Test REVIEW 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 1 2 3 4 A chart can be displayed WORKSHEET CHARTSHEET The intersection of a row and column is known as a CELL 5 To make A1 the active cell press which of the following keys CTRL HOME 6 The characters and are examples of MATHEMATICAL FUNCTIONS 7 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 14 One of the benefits of Live Preview is that YOU KNOW WHAT WILL LOOK LIKE WHEN IT and with the mouse select the next area 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 In the figure above nper stands for the 19 20 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 22 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 31 The fill handle copies content and formats If an optional argument is not included Excel assumes a n value for it 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 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 Know the parts of the Chart

View Full Document