Karteikarten
Midterm
Karten in diesem Stapel (56)
- 1Accounting Number FormatDisplays numbers with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, an displays numbers to the nearest cent (hundredths place)
- 2ArgumentsThe information necessary to calculate the answer
- 3AsieriskA star-shaped character * used in printing
- 4Average FunctionAverage(C4:C18) determines the average of the range of cells from C4 through C18
- 5Best FitMeans that the width of the column will be increased or decreased so the widest entry will fit in the column
- 6Blank CellA numerical value of zero
- 7Comma Style FormatCan be assigned to a range of cells by clicking the Comma style button on the Ribbon, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths
- 8ConditionThe procedure that is varied in order to estimate a variable's effect by comparison with a control condition
- 9Conditional FormatingHighlights worksheet data by changing the look of cells that meet a specified condition
- 10DebuggingFixing errors
- 11E-mailA system of world-wide electronic communication in which a computer user can compose a message at one terminal that is generated at the recipient's terminal when he logs in
- 12Equal SignA symbol that shows two amounts have the same value
- 13Fixed Dollar SignPlaces a dollar sign to the left of the cell leaving spaces between it and the cell numbers
- 14Floating Dollar SignAppears immediately to the left of the first digit with no spaces, use the Currency Style in the Format Cell dialog box
- 15FormulaAn equation that calculates a new value from values currently in a worksheet
- 16Formulas VersionShows the actual formulas you have entered, rather than the resulting values
- 17FunctionA set sequence of steps, part of larger computer program
- 18Hiding CellsAllows you to hide data in cells
- 19Landscape OrientationPage orientation in which data prints across the wider portion of the page
- 20Max FunctionDisplays the highest value in a range
- 21Min FunctionDetermines the lowest number in the range
- 22Normal ViewThe default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane
- 23Order of Operationsmoving from left to right in a formula
- 24Page Layout ViewView that displays the worksheet as a printed page
- 25PixelA dot on the screen that contains a color
- 26Point ModeAllows you to select cells for use in a formula by using the mouse
- 27Portrait OrientationPrintout ,of a page, is printed across the width of a page
- 28Previewing The WorksheetYou can see exactly how it will look without generating a printout
- 29Range FinderChecks which cells are referenced in the formula assigned to the active cell
- 30Relative Cell ReferenceIs copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location
- 31Smart Tag IndicaterA small purple triangle in a cell that indicates that a smart tag is available
- 32Smart TagsIdentifies certain actions to take on specific data in workbooks
- 33Spell CheckerChecks for spelling
- 34ThemeA predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook
- 35Values VersionShows the results of the formulas you have entered, rather than the actual formulas
- 36Web queryUsed to import data stored on a web site
- 37AutoformatA built-in collection of cell formats (such as font size, patterns, and alignment) that you can apply to a range of data
- 38AxisA line bordering the chart plot area used as a frame of reference for
measurement - 39Base AddressThe relative path that Excel uses for the destination address when you insert a hyperlink
- 40BorderA decorative line that can be applied to worksheet cells or objects, such as charts, pictures, or text boxes
- 41Calculated ColumnIn an Excel table, a calculated column uses a single formula that adjusts for each row
- 42Calculated Field (Data Base)A field in the result set of a query that displays the result of an expression rather than data from a database
- 43Calculated Field (Pivot Table)A field in a PivotTable or PivotChart that uses a formula you create
- 44Calculated ItemAn item within a PivotTable field or PivotChart field that uses a formula you create
- 45Category AxisA chart axis that represents the category for each data point
- 46Category FieldA field that's displayed in the category area of the PivotChart
- 47CellA box formed by the intersection of a row and column in a worksheet or a table, in which you enter information
- 48Cell ReferenceThe set of coordinates that a cell occupies on a worksheet
- 49Certifying AuthorityA commercial organization, or a group within a company, that uses tools such as Microsoft Certificate Server to provide digital certificates that software developers can use to sign macros and users can use to sign documents
- 50Change HistoryIn a shared workbook, information that is maintained about changes made in past editing sessions
- 51Chart AreaThe entire chart and all its elements
- 52Chart SheetA sheet in a workbook that contains only a chart
- 53Column FieldA field that's assigned a column orientation in a PivotTable
- 54Column HeadingThe shaded area at the top of each Data pane column that contains the field name
- 55Column HeadingThe lettered or numbered gray area at the top of each column
- 56Comparison CriteriaA set of search conditions that is used to find data
Informationen
- Beschreibung
- Banks Karteikarten am Midterm, erstellt von Journi Levite am 04/12/2019.
- Erstellt von
- Journi Levite
- Aufrufe
- 1
- Bewertung