D388 - Fundamentals of Spreadsheets and Data Presentations

D388 - Fundamentals of Spreadsheets and Data Presentations 24 studiers today Leave the first rating Students also studied Terms in this set (90) Western Governors UniversityD 388 Save D388 excel 36 terms ray_ray_ray4Preview D388 - Fundamentals of Spreadshe...53 terms tromighPreview Fundamentals of Spreadsheets and ...76 terms brookec_ward Preview D388 e

• terms

ray_ Practice questions for this set Learn1 / 6Study using Learn

The part of a calculation to which an algorithm is applied example: revenue

WorkbookAn excel file that stores all the information, previous calculations, and analyses that you may have already completed. Must contain atleast one worksheet.WorksheetA collection of cells arranged in the form of a table that contains the actual data and calculations.Choose an answer 1Find And Replace2Date 3Review4Measure Don't know?

CellSmall box that stores an individual piece of data or a calculation in a worksheet ValueThe content within a cell.ColumnA stack of cells arranged vertically from the top to the bottom of a worksheet - labeled with a letter.RowCollection of cells arranged horizontally from left to right of a worksheet- labeled with a number of FunctionBuilt in method for performing a calculation in excel FileA group of menu items used to manipulate workbooks HomeA group of menu items used to format the appearance of data in cells InsertGroup of menu items that includes features for specializing elements into workbooks, such as charts, pictures, and shapes DrawGroup of menu items used to insert freehand sketches into worksheets Page layoutGroup of menu items used to format the appearance of worksheets when they are printed FormulasGroup of menu items used to perform calculations using excels built in functions DataGroup of menu items used to aid in importing and working with data ReviewGroup of menu items that help in sharing an excel workbook with colleagues ViewGroup of menu items that are used to change how a worksheet is displayed on the screen HelpGroup of menu items that are used to obtain assistance on spreadsheet features ZoomGroup of menu options that allows the user to change how much of the worksheet appears in the window WindowView of the current workbook PaneThe area of a worksheet that is visible on the screen ShowThe options that determine whether gridlines, column letters, and row numbers are visible in the worksheet Title barThe bar located at the top of an Excel worksheet. It displays the name of the application and the name of the spreadsheet.

Tool barThe bar located below the title bar. Provides access to tools commonly associated with task performed in an Excel workbook.Formula barA bar located beneath the toolbar in an Excel worksheet, where the user can add or edit the contents of a cell Insert function iconThe "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.FormattingChanging the appearance of the data and cells in a worksheet RangeA 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 faceThe style or design of letters, numbers, or other symbols Font sizeThe size of letters, numbers, or other symbols HeaderA label, generally, at the top of a column of data, used to describe the rest of the data NumberAn 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.CurrencyUsed to define a number as money; currency values will be displayed with the monetary symbol appropriate for the currency described in two decimal places AccountingUsed to define a number as money; the accounting data type has fewer options in the currency type DateUsed to display the number in a cell as a date TimeUsed to display the contents of a cell as a specific time of day PercentageUsed to display the contents of a cell as a percent Wrap textAn 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 BorderAn 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 SortingA feature that allows you users to re-organize data based on the values in one or more columns.FilteringA feature that allows users to limit the number of visible rows in a worksheet

FormulasThe calculations performed in a spreadsheet.ExpressionThe calculation prescribed by a formula in a spreadsheet.StaticA formula that produces a consistent value DynamicA formula that references and responds to changes and values in other cells order of operationsSequential rules to follow in order to solve an expression with multiple operations ArgumentThe information that a function requires to perform the intended calculation CountA function that counts the number of numbers in a data set COUNTAA function that counts the number of cells that have values, example, non-blank cells AverageA function that calculates the simple average of a data set MaxThe function that displays the largest cell value in a data set MinA function that displays the smallest cell value in a data set Relative referenceA cell reference that automatically updates when it is copied from one cell to another Absolute referenceA cell reference that stays fixed when a formula is copied from one cell to another Mixed referenceWhen 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) A1Both the column and row references are relative and will change when the references copied and pasted to other cells $A1The 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$1The 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 DataStructuring and converting data from one form to another Text to ColumnsA tool in the data tools group that separates groups of text into individual columns