Emt L1

Subdecks (2)

Cards (35)

  • Excel is a spreadsheet software used to input and analyze data. It contains grids where you can place values. Although it is commonly used for computations, you can also place images, graphs, and charts to represent various data in a document for easier understanding and presentation.
  • Workbook is the document itself when you open your Excel. Spreadsheet on the other hand is just one portion of your document.
  • Formulas in Excel works as your normal arithmetic operation but you need to place an equal sign (=) before performing any operation between two or more values.
  • Functions on the other hand are specialized operations with assigned names that use predefined formulas and return a value.
  • Cell, in spreadsheet context, is a rectangular box where you can input your values. Each cell can contain texts, numbers, images, or formulas.
  • Row Number shows the number in a row of the currently selected cell. These numbers are arranged in numeric order.
  • Column Letter shows the letter in a column of the currently selected cell. These letters are
    in alphabetical order from A-Z and will have a combination afterwards such as AA, AB, AC,
    and so on.
  • Name Box shows the cell currently selected if you are selecting only one cell. It also shows
    the number of rows and columns if you are trying to select a big portion of your document
    which contains several cells. The name of a cell is composed of a column letter and a row
    number. Examples are A1, B2, J2, and MJ218 for a bigger data set.
  • Formula Bar is the long rectangle beside the name box where you can input your formulas
    for your data.
  • Ribbon is found on the top of the grid in Excel. You can find different buttons and tools to
    edit and customize your data.
  • Quick Access Toolbar - allows you to access frequently used tools such as save, undo, and
    redo.
  • Status Bar shows different information about the document. You can set the layout of how
    you like your spreadsheet to appear on your screen.
  • Spreadsheet Tab, also known as sheets, is where you can select a different sheet to look at
    its contents.