Microsoft Excel Functions: Workbook Features, File Formats and Navigation (Part 1)
Explore “Workbook Features, File Formats and Navigation” in this Microsoft Excel Functions lesson. Part 1 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Microsoft Excel
- MS Excel Features
- Recognizing the Excel File Formats
- Excel Worksheet Movement Keys
- Excel Sheet or Spread Sheet
Contents
- Read the original document
- Microsoft Excel
- MS Excel Features
- Recognizing the Excel File Formats
- Excel Worksheet Movement Keys
- Excel Sheet or Spread Sheet
- The Merge & Center command
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 01: original teaching slides for this study series.
Microsoft Excel
Microsoft Excel
MS Excel Features
MS Excel Features Excel Files Formats Movements Keys Excel Sheet or Spread Sheet Formatting Cell & Range Operators Excel Error Values Important Formulas
MS Excel Features
MS Excel Features Number Crunching Creating Chart Organizing List Accessing Other Data Creating Graphical Dashboards
Recognizing the Excel File Formats
Recognizing the Excel File Formats Format | Description XLSX | A workbook file that does not contain macros XLSM | A workbook file that contains macros XLTX | A workbook template file that does not contain macros XLTM | A workbook template file that contains macros XLSA | An add-in file XLSB | A binary file similar to the old XLS format but able to accommodate the new features XLSK | A backup file
Excel Worksheet Movement Keys
Excel Worksheet Movement Keys Key | Action Up arrow (↑) | Moves the active cell up one row. Down arrow (↓) | Moves the active cell down one row. Left arrow (←) or Shift+Tab | Moves the active cell one column to the left. Right arrow (→) or Tab | Moves the active cell one column to the right. PgUp | Moves the active cell up one screen. PgDn | Moves the active cell down one screen.
Alt+PgDn | Moves the active cell right one screen. Alt+PgUp | Moves the active cell left one screen. Ctrl+Backspace | Scrolls the screen so that the active cell is visible.
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Excel Sheet or Spread Sheet
Excel Sheet or Spread Sheet
The Merge & Center command
The Merge & Center command
Review questions and answers
What are the key points about MS Excel Features?
MS Excel Features Excel Files Formats Movements Keys Excel Sheet or Spread Sheet Formatting Cell & Range Operators Excel Error Values Important Formulas
What are the key points about Recognizing the Excel File Formats?
Recognizing the Excel File Formats Format | Description XLSX | A workbook file that does not contain macros XLSM | A workbook file that contains macros XLTX | A workbook template file that does not contain macros XLTM | A workbook template file that contains macros XLSA | An add-in file XLSB | A binary file similar to the old XLS format but able to…
What are the key points about Excel Worksheet Movement Keys?
Excel Worksheet Movement Keys Key | Action Up arrow (↑) | Moves the active cell up one row. Down arrow (↓) | Moves the active cell down one row. Left arrow (←) or Shift+Tab | Moves the active cell one column to the left. Right arrow (→) or Tab | Moves the active cell one column to the right. PgUp | Moves the active cell up one screen. PgDn | Moves the…
More lessons from this document
- Microsoft Excel – Presentation 01 — Part 1
- Microsoft Excel – Presentation 01 — Part 2
- Microsoft Excel – Presentation 01 — Part 3
- Microsoft Excel – Presentation 01 — Part 4
- Microsoft Excel – Presentation 01 — Part 5
Conclusion
The important points in Recognizing the Excel File Formats should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.