Spreadsheets

Topic outline

• General

  Collapse all Expand all

  

                 Using a spreadsheet program (Spreadsheets) using Microsoft Excel. Creating or opening a workbook Identifying parts of the program window cell usage Manipulating tables and cells in various formats, inserting, saving, using formulas, functions for calculations, and printing.

   

   

  • 

    Forum

    Announcements Forum

• Open a new or existing workbook and save a workbook
  • 

    Vimeo

    Open a new workbook (New) or open an existing workbook (Open) and import data (Import) such as .txt .csv. Vimeo
  • 

    Vimeo

    Save the workbook (Save) Save by renaming the file (Save as) or setting a new location (Browse) and protecting the file. Vimeo

• Identify the part of the Excel screen
  • 

    Vimeo

    Identify and customize Microsoft Excel program interfaces such as Ribbon, Formula bar, Active cell, Name box, Column, Row, and Quick Access Toolbar ( Quick access toolbar) Vimeo
  • 

    Vimeo

    Page set up settings such as adjusting row height (Row), column width (Colum), adjusting the header and footer (Header and footer), and fixing rows and columns. Vimeo
  • 

    Vimeo

    Modify the view of the workbook, such as Normal view, Page layouts, and Page Break Preview. Vimeo

• Worksheet management

• Manage data cells and ranges

• Manage tables and table data

• Using a function formula for a calculation

• Manage charts

• Print and print settings