CGS EXAM 1 Study Guide - Comprehensive review of concepts and vocabulary covered on the first exam of PDF

Preview

Summary

Comprehensive review of concepts and vocabulary covered on the first exam of cgs2518 (online section)....

Description

CHAPTER ONE QUESTION BANK 1. In Microsoft Excel, the file you create and edit is called a: Workbook 2. By default, Excel 2019 files are saved with this extension: .xlsx 3. When you click on a cell to activate it, the cell address appears in the: name box

4. When you want to delete characters in a cell to the left of the insertion point press: backspace 5. A rectangular group of cells in Excel is called a: range 6. To quickly select all the cells in a worksheet: Ctrl + A 7. After you select and cut cells, the cells are temporarily placed: On the Clipboard

8. In an Excel worksheet dates and times are: Values 9. When you want column and row headings displayed whether you are at the top, bottom, left, or right of the spreadsheet, select: Freeze Panes 10. Use this button to combine two or more cells into one cell and center the text over a group of columns: Merge and Center CHAPTER TWO QUESTION BANK 1. This Excel feature allows users to use common arithmetic operations to perform a calculation: Formulas 2. This symbol alerts Excel that you are entering a formula and not text: = 3. When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns: An error message that begins with a number sign (#) 4. The Excel tool button that allows you to step through each part of a formula is called: Evaluate Formula 5. When you are creating formulas using a cell location, the default cell reference is: Relative 6. This type of cell reference does not change when copied and remains in a fixed position during operations: Absolute 7. A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell reference, adding the dollar sign ($) in front of the column and row addresses, is: F4 8. It is important to remember that Excel calculates these operations before any others are performed: Items in Parentheses 9. Excel comes with many built-in formulas called: Functions 10. This Excel feature allows you to view totals, averages, or other statistical information without creating a formula: AutoCalculate 11. This function calculates loan payment amounts when the borrower makes regular payments and the loan has a constant interest rate: PMT 12. This useful Excel function evaluates a specified condition or statement and returns one value if the condition or statement is true and another value if it is false: IF 13. To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a: 3D Cell Reference

CHAPTER THREE QUESTION BANK 1. When you want to visually represent the numeric data in a worksheet, Excel helps you create an appropriate: Chart 2. The text label that describes each data series in a chart is called the: Category Label 3. In a histogram chart, the category labels are shown: Horizontal Axis 4. An Excel chart that is displayed on its own sheet in the workbook is called a: Chart Sheet 5. To apply changes to your chart’s Shape Fill, Shape Outline, or Shape Effects separately, use the: Format Tab 6. The type of chart that shows percentages of a whole and has no axes is a: Pie Chart 7. The Excel chart element that displays averages in your data and can be used to forecast data by plotting future approximate averages is the: Trendline 8. A variegated blend of colors in a chart element is called a: Gradient 9. A chart that includes two chart types such as a line chart and a column chart is referred to as a: Combination Chart 10. A Miniature chart that is displayed in a cell or cell range next to your data to illustrate a pattern or trend is called a/an: Sparkline CHAPTER SIX QUESTION BANK 1. The Statistical function that does computations only after data meets multiple criteria is: COUNTIFS 2. The Math & Trig function that totals cells only if they meet specified criteria, including cells from more than one column, is: SUMIFS 3. In an OR function, if any one of the arguments is true, the result is: true 4. A function within a function is described as: Nested 5. This function displays the contents of the cell at the intersection of an identified column and row: INDEX 6. A range of cells that you select in which to apply a function is called a(n): Array 7. Which type of function would you use to format a value as a label? Text 8. What text function that includes a delimiter argument allows you to join or combine strings of text? TEXTJOIN 9. The Standard Deviation functions are found in this category: Statistical

You’ve got to fight fight fight for FSU you’ve got to scalp em seminoles! You’ve got to win win win win this game and roll on down and score the goal, For FSU is on the warpath now and at the battle’s end she’s great So fight fight fight fight to victory our seminoles of florida state F-l-o-r-i-d-a-s-t-a-t-e florida state florida state florida state!...