Columns and Rows Teacher Resources

When working in Excel, sometimes it's necessary to modify a cell's layout or size. Viewers explore modifying columns, rows, and cells in an Excel spreadsheet. In addition, they discover how to wrap text, merge cells, use the AutoFit...

Students create their own spreadsheet. They identify the different parts that make up a spreadsheet and organize their data. They practice using functions and formats.

Learners experiment with the basic functions of a spreadsheet. They practice using headers, footers, functions and fonts. They also organize information.

Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the...

Students, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...

Learners analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.

Build spreadsheet skills while investigating decimal multiplication. An open-ended task asks learners to edit a spreadsheet to create a multiplication table for decimals. Provided with a specific interval, pupils create formulas...

Freeze! It's time to learn about freeze panes and view options. Using video 16 from the 27-part Microsoft Excel 2016 series, viewers learn how to freeze and unfreeze rows and columns in a spreadsheet. The video also includes information...

How do Excel users create tables to format their worksheets? With the informative 20th video from the 27-part Microsoft Excel 2016 series, viewers learn how to format data as a table within a spreadsheet. Pupils also discover how to add...

Students study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...

Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.

Eighth graders discuss and analyze Civil War data, manually graph data on handout, work with partners to enter data into spreadsheets, and create charts on spreadsheet for each data set.

In this temperatures instructional activity, students view a spreadsheet of the high temperatures of the states and change the data on it using spreadsheet tools. Students complete 4 tasks.

In this geography worksheet, students identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students use a...

In this lunch menu worksheet, students make a spreadsheet where they count the calories of different food items on the lunch menu, chart their findings, and answer short answer questions. Students answer 5 questions.

Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.

In this technology worksheet, students examine the definitions. The words are used in order to match the them with the bullet points.

Sometimes too much information can be overwhelming. PivotTables to the rescue!  Show scholars how to use PivotTables to summarize and manipulate content with a short, engaging video. Learners also discover how to use the feature to...

Students are introduce to basic Excel skills, rank their opinions of menu items from fast food restaurants, add their answers to the spreadsheet, and then create a simple graph of the results.

Keep track of events, holidays, and deadlines on one colorful and easy-to-edit calendar. The page includes two main columns, one for a color-coded calendar for each month and one for typing in events. Instructions are included on the...

Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...

Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...

Students create addition sentences. They review number lines and how to jump between numbers to solve equations. They play the "Magic Number" game by using a spreadsheet and guessing numbers. They discuss how they found the magic numbers.

Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...