Excell

Cards (616)

  • Title Bar

    Displays the name of the current file
  • Display Options
    Change how much of the ribbon is displayed, minimize, maximize or restore the screen, or close Excel altogether
  • Quick Access Toolbar
    A fast way to access the most used features
  • The Ribbon
    Where you'll find all the options you need to make a spreadsheet. The options are grouped into tabs
  • The Tell Me Field
    Allows you to find a command by typing it out. This way you can skip searching through the ribbon tabs for a command
  • Row and Column Headings
    Each column is labeled with a letter, and each row is labeled with a number; giving each cell a unique name
  • Microsoft Account User Info

    When you log in with your Microsoft account, your name and picture appear here
  • Name Box
    Shows which cell is currently selected
  • Formula Bar
    Displays the information or formula in the selected cell
  • Scroll Bars
    Use the scroll bars to move up and down, or left and right in a worksheet
  • Worksheet
    All the cells make up a single worksheet
  • Status Bar and Views
    The status bar at the bottom will let you know if the document is currently saving or if it is ready to be worked on. Next to it, you can change the view of the spreadsheet by zooming in or out
  • Workbook
    Multiple worksheets make up the workbook, or the file
  • Spreadsheet program

    Allows you to store, organize, and analyze information
  • Excel has powerful features that anyone can learn to take advantage of
  • The procedures in this tutorial will work for all recent versions of Microsoft Excel, including Excel 2019, Excel 2016, and Office 365
  • Excel Start Screen
    Appears when you open Excel for the first time, allows you to create a new workbook, choose a template, and access recently edited workbooks
  • Accessing the Excel interface
    Locate and select Blank workbook from the Excel Start Screen
  • Parts of the Excel window
    • Quick Access Toolbar
    • Name box
    • Formula bar
    • Column
    • Ribbon
    • Microsoft Account
    • Tell me
    • Cell
    • Row
    • Worksheets
    • Zoom Control
    • Worksheet View Options
    • Vertical and Horizontal Scroll Bars
  • Quick Access Toolbar
    • Lets you access common commands no matter which tab is selected, can be customized
  • Name box
    Displays the location or name of a selected cell
  • Formula bar
    Where you can enter or edit data, a formula, or a function that will appear in a specific cell
  • Column
    A group of cells that runs from the top of the page to the bottom, identified by letters
  • Ribbon
    • Contains all the commands you will need to perform common tasks in Excel, has multiple tabs each with several groups of commands
  • Tell me
    Works like a search bar to help you quickly find tools or commands you want to use
  • Cell
    The intersection of a row and a column
  • Row
    A group of cells that runs from the left of the page to the right, identified by numbers
  • Worksheets
    Excel files are called workbooks, each workbook holds one or more worksheets
  • Zoom Control
    Allows you to adjust the zoom percentage of the worksheet
  • Worksheet View Options
    There are three ways to view a worksheet: Normal view, Page Layout view, and Page Break view
  • Vertical and Horizontal Scroll Bars
    Allow you to scroll up and down or side to side
  • Ribbon
    • Contains multiple tabs, each with several groups of commands, used to perform common tasks in Excel
  • Ribbon Display Options
    Allows you to choose how the Ribbon is displayed: Auto-hide Ribbon, Show Tabs, or Show Tabs and Commands
  • Quick Access Toolbar
    • Lets you access common commands, can be customized by adding commands
  • Worksheet views
    Excel has Normal view, Page Layout view, and Page Break view to change how the workbook is displayed
  • Backstage view

    Gives you various options for saving, opening a file, printing, and sharing your workbooks
  • Excel
    A spreadsheet program that allows you to store, organize, and analyze information
  • Things you can use Excel for
    • Create contact lists
    • Create budgets
    • Create invoices
    • Create just about anything else you can imagine
  • Opening Excel
    1. Taken to the start screen first
    2. Can access recent workbooks
    3. Can create something new - from scratch or from a template
  • Ribbon
    • Collection of tools and features at the top of the screen
    • Divided into tabs like Page Layout, Insert, and Home
    • Commands on each tab organized into groups