Spreadsheets: Creating charts REMEDIATION

Objectives – Lesson 1

Learning Goal:
Students will be able to create a
workbook. They will understand
how to set up and navigate a
spreadsheet, insert data and use
common shortcuts.

Standards – Lesson 1

Standards:

•10.01 Define “spreadsheet” and describe ways it may be used.
•10.02 Identify the parts of the spreadsheet display, including cells,
columns and rows, cell references, cell range.
•10.03 Create and navigate through multiple spreadsheets in a file
•10.04 Insert and format various types of data (text, numeric,
date/time) in a spreadsheet cells.
•10.05 Select multiple cells, including adjacent and non-adjacent
ranges, using mouse and keyboard techniques.
•10.06 Cut, copy, and paste information from one or more cells to
another part of the spreadsheet.
•10.07 Use the undo and redo tools in a spreadsheet.

•What is a spreadsheet?
•What kinds of things do we use
spreadsheets for?
•Who actually uses
spreadsheets?

Points to Ponder

•Spreadsheets save time and
increase productivity
•80% of all job openings require
some experience with
spreadsheets
• People who know Excel make
$22.66 per hour on average
compared to the $20.14 per
hour by those who don’t.
�That’s $20 per workday, $100 per

week, or $5,000+ per year

The Importance of Spreadsheets

Spreadsheet Basics

•A spreadsheet has multiple columns
and rows which can hold financial
information and store records of data
like test scores, contact information,
and much more.

Spreadsheets:
•Help managers make informed
decisions
•Are made up of columns – each
identified with a letter (A, B, C, etc.)
and numbered rows.
•The intersection of a row and
column is a cell
•Each cell is defined by a cell
reference or more simply, its column
and row – like C7 or J15.
•A group of selected cells (A1:D10) is
better defined as a cell range

Match

Match the following:

• Row

• Column

• Cell Reference

• Cell Range

• Formula Bar

Labeled with numbers

Labeled with letters

The location of a specific cell: J7

Refers to a group of cells: A1:D5

Where you can enter functions & formulas

• Labeled with numbers

• Labeled with letters

• The location of a specific cell: J7

• Refers to a group of cells: A1:D5

• Where you can enter functions & formulas

•To create a new spreadsheet, you open Excel and select Blank Workbook
•Like other Microsoft products, Excel has templates for things such as
budgeting, calendars, sales trackers, etc. that you can use.

Creating & Saving a Spreadsheet

Blank Workbook

Multiple Choice

Where would you click to add a sheet to an Excel Workbook?

• Open a new workbook and start a new sheet there

• Click New Sheet in the File tab

• Click on the + sign at the top of the open sheet

• Click on the + sign at the bottom of the open sheet

Multiple Choice

Which is an example of a cell reference?

• Column C

• A1:B4

• C2

• Row 3

•An Excel workbook can contain multiple spreadsheets
•By default, they are named by number (Sheet1, Sheet2, Sheet3 etc.)
•You can change the name by double clicking on the name tab and entering
a new name

a new name

Creating & Saving a Spreadsheet

Blank Workbook

Spreadsheet tabs

Multiple Choice

What is Data stored in a series of rows and columns is called?

• Table
• Spreadsheet

• Presentation

• Graphics file

Drag and Drop

To have the border lines print in a spreadsheet, you must select the ​

Placeholder

you want to have borders, then click the

Placeholder

button, and choose a border ​

Placeholder

Drag these tiles and drop them in the correct blank above

border

style

cells

•Saving frequently will help to avoid loss of work if there is a loss of power,
computer failure or your spreadsheet closes unexpectedly.
•Once you have named your file and completed the initial save, you can
quickly save changes to your file using the Save button in the Quick Access
Toolbar

Creating & Saving a Spreadsheet

Quick Access Toolbar

Ribbon

This is the formula bar (A1+D10)

Help Menu

Spreadsheet Title

•Text (words) automatically defaults to align to the left side of the cell.
•Numbers automatically defaults to align to the right side of the cell.
•You can also format cells any style you prefer by clicking on the open dialog
box or the drop down menu in the number section of the home tab.

Entering Data into a Spreadsheet

Open Dialog

box

Drop down

menu

•You can resize a column to fit your data
•Click between columns in the Column Header or select the columns to
widen and use format

Entering Data into a Spreadsheet

Format menu

Column Header

Multiple Choice

When you insert a column in a spreadsheet, where does the new column appear?

• Immediately to the right of the current selected column

• Immediately to the left of the current selected column

• As the last column in the spreadsheet

• As the first column in the spreadsheet

Fill in the Blank

If you merge and center the cells, the information will be in the middle of the them. If you unmerge them, the text defaults to the cell that is the most ____(Which direction?).

Autofill handle– the square that
appears on the bottom right corner
of a cell when you click on it.

Using the drag-and-drop motion to
copy cell content the Autofill can:
•Copy the contents of a cell.
•Populate cells with a pre-defined
series of content.
•Populate cells with a sequential
series of content based on your
entries.

Copy using Autofill

Multiple Choice

What can the Autofill handle do?

• Populate cells with series (pre-defined or sequential) of content

• Overwrite copied content

• Copy cell content

• Copy cell content and/or populate cells with series (pre-defined or sequential) of content

• Using your mouse, you can click a single cell to select it or click and drag

your pointer across a range of cells to select multiple cells.

• Or you can use these common keyboard shortcuts to select cells:

• Select All Cells =+

• Selects each cell as you move through = +

•Selects a group of cells =

+ +

Selecting Data

Shift

A

Shift

Multiple Choice

Using your mouse, you can click a single cell to select it or click and drag your pointer across a range of cells to select multiple cells. You can select random cells anywhere on the spreadsheet by holding down the ________ key and clicking each cell.

• Enter

• Alt

• Ctrl

• Shift

•Undo command - quickly back out the change and
restore your spreadsheet to its original format

•Redo command - restores whatever was undone.

Undo and Redo Commands

Z
+

Y
+

Multiple Choice

You overwrite data in a spreadsheet cell, then realize you need it. You can use the Undo feature to change it back to the original value. But what if you decide that you wanted the newer value after all? How can you most quickly redisplay the newer value?

• Highlight the cell and press CTRL+X.

• Use the Undo feature again.

• Use the Redo feature.

• Delete the original value and re-enter the newer value.

•Cut command - removes the selected cell(s)
from their current location

•Paste command - insert the cells into new
position in the spreadsheet

•Copy command - takes a picture of the selected
cell(s) and uses the Paste command to insert a
“copy” of the cells in other locations

•When you cut or copy text or an object, it is
placed in a temporary storage space called a
Clipboard

Cut, Copy and Paste Commands

X
+

V
+

C
+

Multiple Choice

 What keyboard shortcut will select all the cells in a spreadsheet?

• Shift + A

• Ctrl + A

• Alt + A

• Tab + A

1. Open the ‘Creating a Spreadsheet’

assignment in our Lesson 1 folder

2. Follow the directions, step-by-step, to

create your Excel workbook

3. Submit your completed Excel file to the

Schoology assignment

Lesson 1 Practice – Creating a Spreadsheet

Objectives – Lesson 1

Today’s Goal:
Students will be able to format the
cells, columns and rows within a
spreadsheet. They will be also for
format the data type within each cell.

Standards – Lesson 1

Standards:

•10.08 Apply and modify cell formatting for currency, date and
percentage values.
•10.09 Resize column width and row height in a spreadsheet.
•10.10 Insert and delete columns and rows in a spreadsheet.
•10.11 Merge and unmerge cells in a spreadsheet.
•10.12 Apply shading and borders to a spreadsheet.

This is a common data management task.
•If you forget a record or need to add another
field or information category to your data,
inserting rows and columns can move existing
data aside so you can enter your new
information.
• As records and fields of information are no
longer needed in your data, it is best to remove
them.

Steps to Follow:
•Right-click on the selected row or column to
display the right-click menu.
•Select Insert or Delete

Inserting and Deleting Rows and Columns

Multiple Choice

How do you move the data from the range B1:B13 to the range C5:C18. What keystrokes should he make to quickly make this move?

• highlight the data in the range B1:B13 in his spreadsheet. He should then press CTRL+X. Finally, he should use the mouse to select cells C5:C18, and press CTRL+V.

• highlight the data in the range B1:B13 in his spreadsheet. He should then press CTRL+C. Finally, he should use the mouse to select cells C5:C18, and press CTRL+V.

• highlight the data in the range B1:B13 in his spreadsheet. He should then press CTRL+C. Finally, he should use the mouse to select cells C5:C18, and press CTRL+P.

• highlight the data in the range B1:B13 in his spreadsheet. He should then press CTRL+X. Finally, he should use the mouse to select cells C5:C18, and press CTRL+P.

You can align your textvertically and horizontally with the alignment
buttons

You can quickly change how a number (quantity, currency, fractions/
decimals or percent, date and time) appears using this drop-down menu

Dates can also have different formats and often, time can be included with a
date for more accurate data recording

Formatting Numbers, Text, & Dates

Multiple Choice

Which format would be recommended for a cell that contained the data 12/25/2023?

• Time

• Number

• Currency

• Date

Excel is primarily used for data not sentences.
•Entering several words into a single cell causes the text to display across
several cells even though all the text is entered into only one cell

Formatting Cells, Columns, and Rows

You can format data by:
• Automatically adjusting the column width

to “fit” the content by double-clicking
when the double-arrow pointer appears.
Same with the row height.

• Wrap Text Button – wrap your content

within the existing boundaries of column
width and increase the row height.

Multiple Choice

How do you make everything on her spreadsheet more compact? There is a lot of empty space in her cells. What is quick way to resize a whole column to only be as wide as the largest item in that column?

• Right-click the column letter in the column header, then specify a width in the dialog box that appears.

• Double-click the right edge of the column in the column header.

• Drag the cell's fill handle as far to the right as necessary to completely cover the largest entry in the column.

• Double-click the cell containing the largest entry in the column.

•The cells in your spreadsheet can be combined
to create larger blocks for information.
•Excel will not only merge the content of the cells
but it centers that content.
•This can be very helpful if you recording multiple
sentences or large values in a single cell.
•Applying a border around the cell or group of
cells and adding some color can bring your data
to life!
•Or you can quickly apply any format elements to
other cells in your spreadsheet using the Format
Painter

Merging, Borders and Fills

1. Open the ‘Modifying & Formatting a

Spreadsheet’ activity in our Lesson 1 folder

2. Follow the directions, step-by-step, to

create, modify and format your Excel
workbook

3. Submit your completed file to the

Schoology assignment

4. Take the Formatting Spreadsheets

Learning Check on Schoology

Lesson 1 Practice – Formatting a Spreadsheet

Standards – Lesson 1

Standards:
•10.20 Use the sort function to organize information
numerically or alphabetically, including multiple levels of
sorting.
•10.21 Use the filter function to display spreadsheet data
based on specific criteria.

Sorting helps with re-organizing the data in
your records by a field or category (column).
•For example: Reordering your participants
by last name would place all the names in
alphabetical (ascending) order, making it
easier to find a participant’s name any
event.

Filtering helps with locating your record(s)
based upon specific criteria you select for one
or more fields or columns of data.
•When a filter is applied, records that do not
meet the criteria specified in the filter are
hidden from view.

Sorting and Filtering Spreadsheet Data

Multiple Choice

If I want to put the cities in alphabetical order, how do I do this?

• Sort by: Column D, Z → A

• Sort by: Row 3:7, Z → A

• Sort by: Column D, A → Z

• Sort by: Row 3:7, A → Z

Multiple Choice

When would you want to use the filter function to display only desired results?

• Display a list of all students in a class

• Reorder a list of students in ascending order

• Display all spelling and grammar errors on a sheet

• Display a list of students with birthdays in March

Excel is a smart spreadsheet application where it
will detect which cells contains data and
formatting to print.
•But: Be careful NOT to apply borders or shading
to an entire column or row. If not it will print
sheets continuously.

Printing Options:
•Print Active Sheets, Print Entire Workbook or
Print Selection
•Collated (in sequential order) or Uncollated
•Orientation - landscape or portrait
•Margins
•Scaling

Printing Spreadsheets

Multiple Choice

Combining multiple cells in your spreadsheet is called:

• Merging

• Mizing

• Aligning

• Formatting