Fill-in-the-Blanks
Instructions: While watching Lesson 4, fill in the missing words according to the information presented by the instructor. [References
are found in the brackets.]
Lesson 4 - Spreadsheets Part I
1. The rectangular boxes in a spreadsheet, database, or worksheet are referred to as . [Spreadsheet
Terminology]
2. In the Home tab of Excel, use the button to change the row height or column width of a
spreadsheet. [Cells, Rows, and Columns]
3. Using the tab, you can sort and filter information alphabetically. [Sort and Filter Data]
4. An is a symbol or sign used to represent mathematical equations. [Formula Basics]
30| Projects IC3 GS5: Key Applications Project Workbook
Label Spreadsheet
Description:
Being able to have a working knowledge of a spreadsheet workspace is very important for you to work quickly and effectively. In this
project, you will have the opportunity to label an Excel interface.
Steps for Completion:
1. Label each of the items shown below.
a. b. c.
d. e. f.
g. h.
Reference:
LearnKey’s IC3 GS5: Key Applications Training:
Spreadsheets: Spreadsheet Terminology; Formula Basics
Difficulty: Beginner
Project File: N/A Required Materials: N/A
2.3.a.ii Column 2.3.a.vii Navigation
Objectives:
2.3.a.iii Row 2.3.e Understand functions, formulas, and operators
2.0 Key Applications
2.3.a.iv Range 2.3.e.i Understand their purpose and how they are
2.3 Spreadsheets
2.3.a.v Worksheet used
2.3.a Understand common spreadsheet terms
2.3.a.vi Workbook 2.3.e. iii Be able to create simple formulas
2.3.a.i Cell
31 | Projects IC3 GS5: Key Applications Project Workbook
Modify Cells and Sort Data
Description:
Learning how to modify cells and sort data can help you make a spreadsheet which is easy to read and understand.
For this project you will use the file to modify cell size and filter/sort information for a spreadsheet. Then you will add up the grand
total of donations.
Steps for Completion:
1. Open document.
2. Change cell size on the even columns.
3. Sort column A to be in alphabetical order.
4. Add the total number of donations using the Quick Sum option.
Reference:
LearnKey’s IC3 GS5: Key Applications Training:
Spreadsheets: Cells, Rows, and Columns; Sort and Filter Data; Formula Basics
Project File: 03_Last Years Donors
Difficulty: Intermediate
Required Materials: Microsoft Word, Google Docs, LibreOffice Text Document
Objectives:
2.0 Key Applications
2.3 Spreadsheets
2.3.c Be able to modify cell sizes
2.3.d Be able to filter and sort data
2.3.e Understand functions, formulas, and operators
2.3.e.iii Be able to create simple formulas
32| Projects IC3 GS5: Key Applications Project Workbook
