Skip to main content

Northstar Learning Guide: Module 7: Excel Basics

This guide contains instructional materials designed to help learners build the basic computer skills defined by the Northstar Digital Literacy Assessments.

Northstar Certificates

Don't forget your Northstar certificates!

When you take the Northstar assessments at a Northstar sponsoring site and pass with a score of 85% or better, you can earn a certificate in one or all of the test areas. Ask your librarian or instructor for more information on taking an assessment and earning this valuable credential today!

Not at a Northstar sponsoring site? You can still take the assessments for free online at

Module 7: Excel Basics

The resources on this page will introduce you to the basics of using, editing, and creating spreadsheets in Microsoft Excel 2010. Using your Northstar assessment results page, locate the skills you need to improve in the left-hand column of the table. Then, follow the links in the right-hand column to access the corresponding online learning resources. Ask a librarian or your tutor/instructor if you have questions or need help.

Northstar Standard
Learning Resource
1. Open a workbook.
2. Identify parts of  Excel Screen: ribbon, formula bar, active cell, name box, column letter, row number.
3. Identify sheet tabs, create a new tab, and rearrange tabs.
4. Name worksheets.
5. Locate a cell.
6. Create headings and freeze them.
7. Adjust rows and columns.
8. Insert and delete rows and columns.
9. Drag and drop.
10. Enter data in a cell.
11. Select a range.
12. Sort data (least to greatest, alphabetically, etc.).
13. Use AutoSum (Sum, average, etc.).
14. Write a formula in the formula bar (-, +, *, /).
15. Use Auto Fill.
16.Copy and move cell entries.
17. Choose page orientation.
18. Create a graph using data.
19.Save and name workbook.
20. Select a print area and print.
21. Save and close workbook using the ribbon.