WEEK 5 MS EXCEL

Cards (11)

  • COMBINE DATA =CONCATENATE(D4&","&C4)
  • A parallelogram is a quadrilateral with two pairs of parallel sides
  • An Excel spreadsheet is a grid of cells, with each cell containing a value or formula, arranged in rows and columns
  • The Home tab of the Excel ribbon contains basic tools for working with spreadsheets, such as Cut, Copy, and Paste buttons, formatting tools, and font tools
  • Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS, Android, and iOS, featuring calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications
  • Microsoft Excel parts include the Title Bar, Ribbon, Name box, Formula bar, Column headings, Row headings, and Cells
  • The Ribbon in Excel contains all the commands needed to perform common tasks, with multiple tabs and groups of commands
  • Each cell in Excel has a unique cell address composed of a column and row, and the active cell is the one that receives the data or command given, identified by a darkened border called the cell pointer
  • Navigation buttons in Excel allow moving between worksheets in a workbook, displaying the first, previous, next, and last worksheets
  • A workbook in Excel consists of three worksheets labeled Sheet1, Sheet2, and Sheet3, each made up of columns and rows
  • Excel offers three ways to view a worksheet: Normal View, Page Layout View, and Page Break Preview