1.02– Working with Microsoft Excel 2013– GuidedNotes

MOAC Microsoft Excel 2013

Lesson 02 – Working with Microsoft Excel 2013

Directions: Open Chapter 02 of the MOAC Excel 2013 textbook. Complete the sentences by finding the missing words in the section content.

Creating Workbooks

  1. There are ______ways to create a new Microsoft Excel workbook. You can also use a ______to create a new workbook. A template is a model that has already been set up to display certain kinds of data, such as ______reports, ______, and so on.

Creating a Workbook from Scratch

  1. To create a _____ workbook, launch Excel and select a ______workbook or another type of ______.

Switching Between Open Workbooks

  1. Windows and Excel enable you to work on ______projects simultaneously.
  2. If you have multiple workbooks ______, you might need to move quickly ______the workbooks to finish your tasks.

Saving Workbooks

  1. When you ______a file, you can save it to a folder on your computer’s ______, a network drive, ______, CD, _____ drive, SkyDrive, or other storage location.

Naming and Saving a Workbook

  1. When you save a file for the ______time, you are asked _____ important questions:
  2. ______do you want to save the file?
  3. What ______will you give to the file?
  4. By ______in all Office applications, documents are saved to the ______folder.

Saving to Your SkyDrive

  1. ______is a cloud-based application that allows you to store your files so you can retrieve them ______and share them with other people if desired. SkyDrive is also a great place to store ______files of important documents.

Saving a Workbook under a Different Name

  1. You can ______an existing workbook to create a new workbook.
  2. You can also use an existing workbook as a ______to create new workbooks.

Saving a Workbook in a Previous Excel Format

  1. Files created in ______Excel versions can be opened and revised in Excel 2013. However, if some of your users do not have the latest version or use other applications, they might not be able to ______your file.
  2. You can save a copy of an Excel 2013 workbook (with the .______file extension) to a version that is compatible with Excel 97 through Excel 2013 (with the ._____ file extension) versions.
  3. The program symbol displayed with the filenames is ______…
  4. It is also a good idea to check which issues might be lost with Excel’s ______.

Saving in Different File Formats

  1. The ______that are listed as options in the Save As dialog box or on the FILE tab depend on what type of file format the application supports. When you save a file in another file format, some of the ______, data, and ______might be lost.

Entering and Editing Basic Data in a Worksheet

  1. You can type data ______into a worksheet cell or cells. You can also ______and ______information from another worksheet or from other programs.
  2. To ______to the next column after text is entered, press _____.

Entering Basic Data in a Worksheet

  1. When you finish typing the entries in a _____, press ______to move to the beginning of the next row. You can also use the ______to move to an adjacent cell or click on any cell to make that cell active.

Changing the Column Width

  1. In Excel, ______is established based on the existing data. When you add an entry in a column that extends ______the column’s width, it is necessary to ______the column width to accommodate the entry.

Editing a Cell’s Contents

  1. To ______information in a worksheet, you can make changes ______in the cell or edit the contents of a cell in the ______, located between the ribbon and the worksheet.
  2. You can also ______directly in the formula bar.
  1. When you are in ______:
  2. The insertion point appears as a ______and most commands are inactive.
  3. You can ______the insertion point by using the left and right arrow keys.

Deleting and Clearing a Cell’s Contents

  1. To ______the entire contents of a cell, click the cell and press ______.
  2. Pressing Delete removes the cell’s contents, but does _____ remove any ______(such as bold, italic, or a different number format) that you might have applied to the cell.

Using Data Types to Populate a Worksheet

  1. You can enter ______types of data into Excel: ______, ______, and ______.

Entering Labels and Using AutoComplete

  1. ______are used to identify numeric data and are the most common type of ______entered in a worksheet. Labels are also used to ______and ______data.
  2. If the first few characters that you type in a column match an______entry in that column, Excel automatically enters the remaining characters. This ______feature works only for entries that contain text or a combination of text and numbers.
  3. To accept an AutoComplete entry, press ______or press _____. When you accept AutoComplete, the completed entry ______the pattern of uppercase and lowercase letters of the existing entry. To delete the automatically entered characters, press ______.

Entering Numeric Values

  1. Numeric values are the foundation for Excel’s ______, analyses, ______, and graphs. Numbers can be formatted as currency, ______, decimals, and ______. By default, numeric entries are ______-______in a cell.


  1. The ______value is always displayed in the ______.

Entering Dates

  1. Dates are often used in worksheets to ______over a specified period of ______.
  2. Like ______, dates can be used as row and column headings. However, dates are considered ______, which means that they are sequential and can be ______, subtracted, and ______in calculations.
  3. The way a date is initially ______in a worksheet cell depends on the ______in which you type the characters.
  4. In Excel 2013, the default date format uses ______for the year. Also by default, dates are ______-______in the cells.
  5. If you type 1/28 without a ______, Excel interprets the date to be the ______year. 28-Jan will display in the cell, and the formula bar will display 1/28/ followed by the current year.

Filling a Series with Auto Fill

  1. Excel provides ______options that automatically fill cells with ______and/or ______.
  2. To populate a _____ cell with data that exists in an adjacent cell, use the Auto Fill feature either through the command or the ______. The fill handle is a small green ______in the lower-right corner of a selected cell or range of cells.
  3. A ______is a group of adjacent cells that you select to perform operations on _____ of the selected cells. When you refer to a range of cells, the ______cell and ______cell are separated by a ______(for example, C4:H4).
  4. To use the fill handle, point to the ______-______corner of the cell or range until the mouse pointer turns into a ___. Click and ______the fill handle from cells that contain data to the cells you want to fill with that data, or have Excel automatically continue a ______of numbers, numbers and text combinations, dates, or time periods…
  5. … a______is a formatted series of text or numbers that are in a normal ______such as ______, weekdays, numbers, or ______.

Filling Cells with Flash Fill

  1. ______is like Auto Fill, but Excel does more work. When Excel recognizes a pattern based on other ______in your workbook, it will use the pattern.

Cutting, Copying, and Pasting Data

  1. ______you enter data into a worksheet, you frequently need to rearrange or reorganize some of it to make the worksheet easier to understand and analyze.
  2. You can also copy ______contents or attributes from the cells. For example, you can copy the format only without copying the cell value, or copy the resulting value of a formula without copying the formula itself. You can also copy the value from the original cell but retain the formatting of the destination cell.

Copying a Data Series with the Mouse

  1. By default, ______-_____-______editing is turned ___ so that you can use the mouse to ______(duplicate) or ______cells. Just select the cell or range of cells you want to copy and hold down ______while you point to the ______of the selection. When the pointer becomes a copy pointer (arrow with a ______), you can drag the cell or range of cells to the new location.

Moving a Data Series with the Mouse

  1. To move a data series, ______the cell or range of cells and point to the border of the selection. When the pointer becomes a ______, you can drag the cell or range of cells to a new location.

Copying and Pasting Data

  1. The Office Clipboard collects and stores up to ___ copied or cut items that are then available to be used in the active workbook, in other workbooks, and in other Microsoft Office programs. You can ______(insert) selected items from the Clipboard to a new location in the worksheet.
  2. If you copy ______items and then click Paste, only the ______item copied will be pasted. To access multiple items, you must ______the Clipboard pane.

Cutting and Pasting Data

  1. ______of the options for copying and pasting data also apply to ______and pasting. The major difference is that data copied and pasted ______in the original location as well as in the destination cell or range.

Editing a Workbook’s Properties

  1. The workbook has a number of ______that are associated with it to make managing it easier. The properties include items that you ______change such as ______and last edit date. The workbook properties also include items you ______change such as ______.
  2. Assigning keywords to the document properties makes it easier to ______and ______documents.

Assigning Keywords

  1. ______a file is saved, the ______tab records when the file was accessed and when it was modified. It also identifies the person who last saved the file.

Page 1 of 6