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.