O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Flashcards

Midterm

Journi Levite Banks Inglês 56 flashcards

Flashcards do conjunto (56)

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

Informações

Descrição
Banks FlashCards sobre Midterm, criado por Journi Levite em 04-12-2019.
Criado por
Journi Levite
Visualizações
1
Avaliação

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?