WGU D388 Fundamentals of Spreadsheets and Data Presentations

WGU D388 Fundamentals of Spreadsheets and Data Presentations Workbook - -An excel file that stores all the information, previous calculations, and analyses that you may have already completed. Must contain atleast one worksheet. Worksheet - -A collection of cells arranged in the form of a table that contains the actual data and calculations. Cell - -Small box that stores an individual piece of data or a calculation in a worksheet Value - -The content within a cell. Column - -A stack of cells arranged vertically from the top to the bottom of a worksheet - labeled with a letter. Row - -Collection of cells arranged horizontally from left to right of a worksheet- labeled with a number of Function - -Built in method for performing a calculation in excel File - -A group of menu items used to manipulate workbooks Home - -A group of menu items used to format the appearance of data in cells Insert - -Group of menu items that includes features for specializing elements into workbooks, such as charts, pictures, and shapes Draw - -Group of menu items used to insert freehand sketches into worksheets Page layout - -Group of menu items used to format the appearance of worksheets when they are printed Formulas - -Group of menu items used to perform calculations using excels built in functions Data - -Group of menu items used to aid in importing and working with data Review - -Group of menu items that help in sharing an excel workbook with colleagues View - -Group of menu items that are used to change how a worksheet is displayed on the screen D388 D388 Help - -Group of menu items that are used to obtain assistance on spreadsheet features Zoom - -Group of menu options that allows the user to change how much of the worksheet appears in the window Window - -View of the current workbook Pane - -The area of a worksheet that is visible on the screen Show - -The options that determine whether gridlines, column letters, and row numbers are visible in the worksheet Title bar - -The bar located at the top of an Excel worksheet. It displays the name of the application and the name of the spreadsheet. Tool bar - -The bar located below the title bar. Provides access to tools commonly associated with task performed in an Excel workbook. Formula bar - -A bar located beneath the toolbar in an Excel worksheet, where the user can add or edit the contents of a cell Insert function icon - -The "fx" symbol located to the left of the formula bar. Users can click on the symbol and select built-in calculations that can be applied to data. Formatting - -Changing the appearance of the data and cells in a worksheet Range - -A consecutive block of cells, arranged in a row, a column, or a combination of both. For example, A1:B3 is the range of cells that includes A1, A2, A3, B1, B2, and B3. Font face - -The style or design of letters, numbers, or other symbols Font size - -The size of letters, numbers, or other symbols Header - -A label, generally, at the top of a column of data, used to describe the rest of the data Number - -An option in the number format, drop-down menu that defines any type of number and can be configured to display the number in standardized ways. Currency - -Used to define a number as money; currency values will be displayed with the monetary symbol appropriate for the currency described in two decimal places Accounting - -Used to define a number as money; the accounting data type has fewer options in the currency type Date - -Used to display the number in a cell as a date D388 D388 Time - -Used to display the contents of a cell as a specific time of day Percentage - -Used to display the contents of a cell as a percent Wrap text - -An icon in the alignment group of the home menu that, when selected, spans, or wraps the content of a cell across multiple lines within the same cell, so that all the content is showing Border - -An icon in the font group of the home menu that, when selected, gives multiple options to add lines, or borders, to one or more sides of a cell Sorting - -A feature that allows you users to re-organize data based on the values in one or more columns. Filtering - -A feature that allows users to limit the number of visible rows in a worksheet Formulas - -The calculations performed in a spreadsheet. Expression - -The calculation prescribed by a formula in a spreadsheet. Static - -A formula that produces a consistent value Dynamic - -A formula that references and responds to changes and values in other cells order of operations - -Sequential rules to follow in order to solve an expression with multiple operations Argument - -The information that a function requires to perform the intended calculation Count - -A function that counts the number of numbers in a data set COUNTA - -A function that counts the number of cells that have values, example, non blank cells Average - -A function that calculates the simple average of a data set Max - -The function that displays the largest cell value in a data set Min - -A function that displays the smallest cell value in a data set Relative reference - -A cell reference that automatically updates when it is copied from one cell to another Absolute reference - -A cell reference that stays fixed when a formula is copied from one cell to another D388 D388 Mixed reference - -When one part of the cell reference, either the column or the row, is fixed (Absolute) and the other part is relative (changes based on proximity to other cells) A1 - -Both the column and row references are relative and will change when the references copied and pasted to other cells $A1 - -The column reference is absolute and will remain constant when copied and pasted to other cells. The row reference is relative, and will change when copied and pasted to cells and other rows of the worksheet. A$1 - -The row reference is absolute and will remain constant when copied and pasted to other cells. The column reference is relative, and will change when copied and pasted to cells and other columns of the worksheet. Parsing Data - -Structuring and converting data from one form to another Text to Columns - -A tool in the data tools group that separates groups of text into individual columns Delimiter - -A character or symbol that demonstrates where data should be split Duplicate Data - -Data that are entered more than once, when all elements of the data are the same Resizing - -Changing the width of a cell Bold - -A feature in the font group, that thickens and darkens the font face, making it stand out Centering - -Aligning values in the center of a cell Alignment - -The way values in a cell are positioned Find and Replace - -An Excel tool that finds values and replaces them with other specified values TEXTSPLIT - -A function that separates the values of a cell into multiple cells based on a delimiter Column Headings - -The first row in a data set that contains labels, describing the information in the data set Outlier - -A value that falls outside and expected range of values D388 D388 Table - -A container within an excel worksheet that can be used to easily store, edit, and format data. Calculated column - -A column in an excel table in which a calculation is created in any of the cells and then automatically applied to all the cells in that column Total row - -A row added to a table that automatically displays the sum of values in a column. Users can format the row to display other functions. Table filters - -A feature that allows users to display table rows based on values in a specific column Pivotal - -A table that re-organizes and summarizes data from a more complex table based on one or more categories Quantitative data - -The elements of a data set that are measured. It makes sense to perform calculations (sum, average, or count) on quantitative data Qualitative data - -Labels or descriptions of the data and a data set Measure - -The part of a calculation to which an algorithm is applied example: revenue Algorithm - -The part of a calculation that is applied to the measure. Example average