Excel ppt ch 01

You can design a ______________to separate main or column headings, to emphasize totals, or to group data. You can use the ____________ or the Format Cells dialog box to apply borders and fill color. Key Terms: Fill- A background color or pattern and is used to highlight or draw attention to data

border Ribbon

SLO 1.2 Enter and edit labels and values in a worksheet. A worksheet consists of ________________________. Columns are labeled with letters and rows are labeled with numbers. After completing SLO 1.2, assign Pause & Practice 1-1.

columns and rows

Function Syntax Syntax Argument- The cell reference or value to complete the function A function can have a single or multiple arguments. In = SUM (B5:B9), the argument is the range B5:B9. Multiple arguments in a function are separated by _______________. There are three arguments in this function: =SUM (B5, B10, B15).

commas

You can format values with _______________________________________, and more so that data is quickly recognized and understood.

currency symbols, decimal points, commas, percent signs

Why do you use different types of graphs in the spreadsheet?

diagrams can also help you draw and keep the attention of your listeners

Indentation is the __________________the cell contents and the left boundary of the cell. Use the Increase Indent or Decrease Indent buttons on the Alignment group to adjust indentation.

distance between

SLO 1.1 Create, save, and open an Excel workbook. When you open a blank workbook, Excel automatically assigns a _________________________, such as Book1. The first time you save a workbook, you should type a descriptive file name for the workbook in the _____________________________ _______________________________________: To preserve an existing workbook, you can open and save it with a different file name, creating a copy of the original file with a new name. Follow the same steps that you would when saving a new workbook. Methods: §File tab, Save As §Ctrl+S §Quick Access toolbar, Save §F12

file name Save As dialog box. Saving a Workbook with a Different File Name

SLO 1.4 Format a worksheet with font attributes, borders, fill, cell styles, and themes. A new workbook uses a default theme named Office which is a collection of ________________________________. The default theme applies the 11 point Calibri font and the General number format to all cells.

fonts, colors, and special effects

SLO 1.4 Format a worksheet with font attributes, borders, fill, cell styles, and themes. A cell style is a set of ____________________that includes font style, size, color, alignment, borders, and fill as well as number formats.

formatting elements

Key Terms: Range Finder- Excel feature that ___________________________as you enter or edit a formula or function You can drag a Range Finder handle to select a different argument range, expanding or shrinking the number of included cells.

highlights and color-codes formula cells

Data shaping

is a common task in Excel that involves reducing and rearranging one or more tables into a subject table that matches your data analysis requirements. Power Query provides an intuitive user interface to help you define data shaping and transformation steps with simple user actions over a set of data.

Font size- Specifies the size of the character, measured in _____________(a point is equal to ________________)

points 1/72 of an inch

count

returns the number of cells in a range that contains numbers You can use the COUNT function to count the number of cells containing numbers.

Microsoft Excel is ___________________ for creating an electronic workbook. A workbook consists of _______________________and can be simple or complex personal or business related.

spreadsheet software rows and columns

SLO 1.2 Enter and edit labels and values in a worksheet. Data in a worksheet cell is ______________________________. When you type data that includes alphabetic characters and numbers, Excel treats that data as a label.

text, a number, or a formula

Alignment refers to the_______________________alignment in reference to the cell. You can choose these from the Alignment group on the Home tab. In addition to horizontal and vertical settings, the Alignment group on the Home tab includes the _______________button to display data vertically or at an angle.

vertical and horizontal Orientation

The workbook is just the vessel in which the worksheets and the data that is to be manipulated are held. The workbook is the same as any other book in that it simply stores the pages with all the information - in essence, the workbook is simply the name of the project. ... A workbook is a file that stores the entered related data; a worksheet is a page of the workbook on which all the data is held

workbook vs worksheet

Workbook Themes

§Three combined elements §Colors §Fonts §Effects

•Values

•Number •Can be used in a calculation or be the result of a calculation

•Label

•Text •Displays descriptive information

The most common, simplest, and classic type of chart graph is the line graph. This is the perfect solution for showing multiple series of closely related series of data. Since line graphs are very light-weight (they only consist of lines, as opposed to more complex chart types, as shown further below), they are great for a minimalistic look.

#1 Line Graphs

Bars (or columns) are the best types of graphs for presenting a single data series. Bar charts have a much heavier weight to them than line graphs do, so they really emphasize a point and stand out on the page.

#2 Bar Graphs

The above two types of graphs can be combined to create a combo chart with bars and lines. This is very useful when presenting two data series that have a very different scale and might be expressed in different units. The most common example is dollars on one axis and percentage on the other axis.

#3 Combo Chart

Pie charts have a bad reputation and are known for being messy and hard to read. However, if you're trying to illustrate the percentage breakdown of a small number of data points, then they can be very effective. For example, the percentage of people who prefer bananas, pineapples, and grapes.

#6 Pie Graph

Histograms are a type of graph that shows the distribution of a dataset. They graph the percentage or the number of instances of different categories. For example, to show the distribution of age categories (0-10, 11-20, 21-30, etc.), we can clearly see which categories are the biggest and how many people fall into each.

#7 Histogram

SLO 1.5 Modify columns and rows in a worksheet. A worksheet has a default number of rows and columns, each in the default width and height for the workbook theme. There are over 1 million rows and more than _______________ columns available for use. You can: Modify Insert Change Delete And More!

16,000

SLO 1.2 Enter and edit labels and values in a worksheet. ______________________________ Excel recognizes a combination of letters, numbers, spaces, and other characters as a label. Labels are aligned on the left and bottom of the cell. When you type only numbers into a cell, Excel identifies the entry as a value. Values are aligned on the right and bottom of the cell.

Align and Indent Cell Contents

Portable Document Format .pdf

An uneditable image of the workbook for viewing that can be opened with free software

It works only for data that is alphanumeric, not for a column of values

AutoComplete

SLO 1.3 Use the SUM function to build a simple formula. SUM is a function that adds the values in a cell range. Key Terms: Formula: _____________________________ ____________________: A built-in formula

Calculates a result for numeric data in a cell Function

PMT

Calculates the payment for a loan based on constant payments and a constant interest rate

SLO 1.2 Enter and edit labels and values in a worksheet. ________________: The intersection of a column and a row. ____________________: The column letter and row number that represents the location of the cell. ___________________ The cell ready for input ____________________ The active cell address or reference appears in the name box _______________ A rectangular group of cells _________________: A calculation or expression that displays a result

Cell Cell Reference(cell address) Active Cell: Name Box: Range: Formula

Text .txt

Data only with columns separated by a tab character. File can be opened by many applications

Comma Separated Values (CSV) .csv

Data with only columns separated by a comma. File can be opened by many applications

SLO 1.2 Enter and edit labels and values in a worksheet. ________________________ You can edit cell data as you type or after the entry is complete. Methods: While in an active cell, edit using the Delete or Backspace keys. After entry, to enter edit mode, press F2 or double-click the cell.

Edit Cell Contents

Excel Workbook .xlsx

Excel workbook compatible with versions 2010 and later

Web Page .htm, .html

Excel workbook formatted for posting on a web site that includes data, graphics, and linked objects

Copy the SUM Function When a function is copied into adjacent cells, use the ______________. Excel copies the formula and adjusts each argument based on the location in the worksheet.

Fill Handle

sum

If you want to add multiple numeric values within different cells you can use the SUM function.

_______________- Settings and content including the author name, the date the file was created, the type and size of file, and more

Metadata

Excel Template .xltx

Model or sample Excel workbook stored in the Custom Office Templates folder

Excel Macro-Enabled Template .xltm

Model or sample Excel workbook with embedded macros stored in the Custom Office Templates folder

Different workbook Views: ____________: The default and is used to create and modify a worksheet Page ________________: Opens the header and footer areas, indicates margin areas, and shows rulers Page ___________________: Displays printed pages with dashed or dotted lines to mark where new pages start

Normal Layout Break Preview

A workbook can consist of rows and columns used to:

Organize data Perform calculations Print Reports Build Charts

SLO 1.1 Create, save, and open an Excel workbook. A workbook can be opened from the Start page, the Open area in the Backstage view, or the Open dialog box. When a workbook is opened from an Internet or unrecognized source, it opens in_____________________. Click _________________________ when you know that it is safe to work with the file. Methods: §File tab, Open §Ctrl+O §Ctrl+F12

Protected View Enable Editing

SLO 1.2 Enter and edit labels and values in a worksheet. _______________________________ Methods: To replace the contents, select the cell and type the new text. Press Enter to replace the content. To remove the contents, select the cell and press Delete or click the Clear button.

Replace or Clear Cell Contents

You can adjust how you see data in a worksheet to make your work as easy as possible.

Select a view Zoom in or out Freeze parts of the screen Split worksheet into two panes Switch between multiple open windows

SLO 1.1 Create, save, and open an Excel workbook. From the ____________page, you can create a new blank workbook, open an existing file, or create one from an Excel template. Methods: _____________ ____________ ___________

Start Esc from the Start page File tab, New Ctrl+N

SLO 1.1 Create, save, and open an Excel workbook. SLO 1.2 Enter and edit labels and values in a worksheet. SLO 1.3 Use the SUM function to build a simple formula. SLO 1.4 Format a worksheet with font attributes, borders, fill, cell styles, and themes. SLO 1.5 Modify columns and rows in a worksheet. SLO 1.6 Insert, delete, and move worksheets in a workbook. SLO 1.7 Modify the appearance of a workbook by adjusting zoom size, changing views, and freezing panes. SLO 1.8 Review and prepare a workbook for final distribution by spell checking, setting properties, and adjusting page setup options.

Student Learning Outcomes Excel:

average

The AVERAGE function in Excel calculates the average (arithmetic mean) of a group of numbers. The AVERAGE function ignores logical values, empty cells and cells that contain text.

max

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values.

min

The Excel MIN function returns the smallest numeric value in a range of values. The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.

mod funtion

The Excel MOD function returns the remainder

_____________________ The Fill Handle is a small, black square in the lower right corner of the cell or selected range. You drag this handle across the cell range for the series or to copy data. For series such as days of the week and the months, you only need to enter the first item in the series. For other series, such as 2, 4, 6, 8, you need to enter at least two items for Excel to recognize the pattern. Key Terms: Series-A list of labels or values that follows a pattern. (Example: Days of the week or the months of the year).

The Fill Handle

SLO 1.1 Create, save, and open an Excel workbook. Key terms: _______________: File that is open, edited, and saved _________________________: Pages within the workbook

Workbook Worksheet/Spreadsheet/Sheet

Excel 97-2003 .xls

Workbook compatible with older versions of Microsoft Excel

OpenDocument Spreadsheet .ods

Workbook for the Open Office suite as well as Google Docs

Excel Macro-Enabled Workbook .xlsm

Workbook with embedded macros

View Options

Zoom Options Freeze Panes Split a Worksheet into Panes Hide or Unhide Worksheets Switch Windows Command

SLO 1.3 Use the SUM function to build a simple formula. SUM is a function that ____________________________________

adds the values in a cell range.