IS Final

BCC (Microsoft Outlook)

(Blind Carbon Copy) Put the email address here if you are sending them a Copy and you do not want the other recipients to see that you sent it to this contact

CC (Microsoft Outlook)

(Carbon Copy) Put the email address(es) here if you are sending a copy for their information (and you want everyone to explicitly see this)

Sparklines

(Chart within a cell) A tiny chart in a worksheet cell that provides a visual representation of data. Sometimes called "in-line charts"

Methods of inserting a function in a cell

- On the Home ribbon, click on the arrow next to the AutoSum icon and select More Functions - Go to the Formulas ribbon - choose either the Insert Function icon to bring up the Insert Function dialog box (same dialog box you would get with the first method), or click the arrow next to the correct category in the Function Library Group, and then choose the desired function.

Active Cell (Cell outlined in green)

- Refers to a cell in Excel spreadsheet that is currently selected by clicking mouse pointer or keyboard keys.

Number Formats (Number, Accounting, Currency, Percent)

- They control how numbers are displayed in Excel. - They change how a number looks without changing any data. - (Number, Accounting, Currency, Percent)

Scenario Manager

A What-If Analysis to test various scenarios and their outputs Allows you to change or substitute input values for multiple cells (maximum up to 32). Therefore, you can view the results of different input values or different scenarios at the same time.

Goal Seek Manager

A What-If Analysis used to find what value needs to get to in order to reach a specific goal or target.

PMT function

A financial function that returns the periodic payment for a loan. =PMT (rate, nper, pv, [fv], [type])

Difference Between a Formula vs. Function

A formula is any calculation in Excel. A function is a pre-defined calculation. For example: =A1/A2 is just a formula. =MAX(A1:B20) is a formula containing a function.

Nested Function

A function that resides as an argument inside of another function. (i.e. =IF(AND(B7<300,B18>700),"It was a good day", "Not so much"))

Data Source

A place where data is being taken from. Any file that contains data is considered a _____

Absolute References

A reference that is "locked" so that rows and columns won't change when copied.

Mixed References

A reference that is fixed only on part of the reference: the row or the column. A part of the reference is absolute and part is relative.

Animations (PowerPoint)

A tab that allows the user to use options for images and words such as appear, blinds, checkerboard, spin, etc. DO NOT OVERDO animations

Transitions (PowerPoint)

A tab that allows the user to use options for the slides such as morph, fade, push, wipe, split - you should apply transitions to all to be consistent.

Formula Bar

A toolbar that appears at the top of Microsoft Excel and Google Sheets spreadsheets. - Also sometimes called the fx bar because that shortcut is right next to it. - Use it to enter a new formula or copy an existing formula; its uses also include displaying and editing formulas.

Chart

A visual representation of numerical data.

SUM function

Adds all numbers in a range of cells and returns the result. =SUM( number1, [number2, ... number_n] ) =SUM ( cell1:cell2, [cell3:cell4], ... )

Page Break View

Adjust amount of spreadsheets printed on each page.

Proper Syntax of a function vs incorrect syntax

All functions begin with the equal sign ( = ) Followed by the function's name such as IF, SUM, COUNT, or ROUND. Then, opening parenthesis Arguments Closing parenthesis

Chart Styles

Allows you to customize the look of a chart. A set of predefined formats applied to a chart, including colors, backgrounds, and effects.

Freeze Panes

Allows you to lock columns and rows. Add more?

IF function

Allows you to make logical comparisons between a value and what you expect. So this statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

Conditional Format Rule Manager

Allows you to see all conditional formats applied to specific cell ranges Allows you to place the precedence of conditional formats if there are multiple

VLOOKUP function

An Excel function to lookup and retrieve data from a specific column in the table. Supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right. =VLOOKUP (value, table, col_index, [range_lookup])

Contact Management (Microsoft Outlook)

An add-on to Outlook, so small business owners can use Outlook 2013 to store personal information and manage their calendars while using Business Contact Manager for Outlook to help them run their businesses. A listing of all the customer contacts that a salesperson makes in the course of conducting business.

Square Brackets in Arguments

An argument is optional if it's shown in square brackets. Or if it's unbolded in your insert function dialog box.

Additional Chart Elements

Axes Axis Titles Chart Title Data Labels Data Table Gridlines Legend Error Bars Trendline

Conditional Formats

Can be applied to a range and only cells that meet the condition will be formatted (i.e. bold, italic, font face, font size, etc.) Allows you to perform calculations on only those numbers that meet a certain condition. Returns one value if a condition is True and a different value if the condition is False. - Create this using the IF function

Data Point

Cell containing a value.

Non-adjacent cells

Cells that aren't connected. Use CTRL to select these cells.

Chart elements

Chart area Plot area X-axis Y-axis Legend

Axes (Chart Element)

Charts typically have two axes that are used to measure and categorize data: A vertical axis (also known as value axis or y axis), and a horizontal axis (also known as category axis or x axis). 3-D column, 3-D cone, or 3-D pyramid charts have a third axis, the depth axis (also known as series axis or z axis), so that data can be plotted along the depth of a chart.

4 Most Common Chart Types

Column Bar Line Pie

Calendar Management (Microsoft Outlook)

Creating Appointments Creating Meetings Recurring Schedules Editing or removing instances The calendar and scheduling component of Outlook that is fully integrated with email, contacts, and other features. You can create appointments and events, organize meetings, view group schedules, and much more.

Axes Title (Chart Element)

Describes category or value axes.

Chart Title (Chart Element)

Describes entire chart.

Line Chart

Displays category data on horizontal axis and value data on vertical axis.

Bar Chart

Displays values in horizontal bars and categories along vertical axis.

Column Chart

Displays values in vertical columns and categories along the horizontal axis.

Logical Operator =

Equal to

Button used to change between referencing types

F4 F4 adds dollar signs ($) before column or row of cell reference or both. This locks the column or row from changing when dragging the formula or function to other cells.

Information Ethics

Govern the ethical and moral issues arising from the development and use of information technologies, as well as the creation, collection, duplication, distribution, and processing of information itself.

Logical Operator >

Greater than

Logical Operator >=

Greater than or equal to

Data Table (Chart Element)

Grid that contains data source values and labels.

Data Series

Group of related data points.

How to clear sparklines from a cell

Here are the steps to delete a sparkline in Excel: Select the sparkline(s) you want to delete. On the Sparkline tab, do one of the following: To delete only the selected sparkline(s), click the Clear button. To remove the entire group, click Clear > Clear Selected Sparkline Groups.

Commonly used conditional formats

Highlight Cells Top/Bottom Rules Data Bars Color Scales Icon Sets

Grindlines (Chart Elements)

Horizontal or vertical lines.

Legend (Chart Elements)

Identifies attributes assigned data series.

Connecting to an email account (Microsoft Outlook)

In Outlook.com, go to Settings > View all Outlook settings > Sync email.

Is it illegal to monitor employees?

It's illegal to record an individuals phone call and there's some state regulation on how exactly you can monitor one's employee but overall, no.

Logical Operator <=

Less than

Presenter View (Powerpoint)

Lets you view your presentation with your speaker notes on one computer (your laptop, for example), while the audience views the notes-free presentation on a different monitor.

Trendline (Chart Elements)

Line that depicts trends.

Cell Range

Looks like A4:C20 and references every cell from the first cell (A4) through the last cell (C20) and every cell in between. Colon (:) separates the cell references in a range

Page Layout View

Modify header and footer

Filtering data

Narrow results shown based on criteria selected per column.

Logical Operator <>

Not equal to

Presentation (.pptx) (Powerpoint)

Opens in Normal view

Show (.ppsx) (Powerpoint)

Opens in Slide Show view

Elements that can be added to a header and footer

Page Number Number of Pages Current Date Current Time File Path (C:\Users\John\Desktop\MySpreadsheet.xlsx) File Name (MySpreadsheet.xlsx) Sheet Name Picture

Quick Layouts

Predefined layouts. Create prebuilt layouts of various elements. (same thing basically goes for quick styles)

Sorting data

Puts data in a specific order.

SMALL function

Returns numeric values based on their position in a list ranked by value. Can retrieve the smallest numerical values. =SMALL (array, n)

LARGE function

Returns numeric values based on their position in a list when sorted by value. Can retrieve the smallest numerical values. =LARGE (array, n)

AVERAGE function

Returns the average (arithmetic mean) of the arguments. =AVERAGE(number1, [number2], ...)

TODAY function

Returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY using any standard date format. =TODAY ()

NOW function

Returns the current system date and time. A built-in function in Excel that is categorized as a Date/Time Function. =NOW()

MAX function

Returns the largest value from a supplied set of numeric values. =MAX (number1, [number2], ...)

MIN function

Returns the smallest numeric value in a range of values. =MIN( number1, [number2], ... )

Freeze First Column

Select View > Freeze Panes > Freeze First Column. The faint line that appears between Column A and B shows that the first column is frozen.

Freeze Top Row

Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.

Data Labels (Chart Element)

Shows exact value or name of data point.

Pie Chart

Shows proportion of individual data points to the total.

Name Box

The cell reference area located below the Ribbon, which displays the cell reference of the active cell. - In Microsoft Excel, the ____ displays the cell that is currently selected in the spreadsheet. It is located to the left of the formula bar. If a name is defined for a cell that is selected, the ____ displays the name of the cell.

Order of Operations

The standard math protocol that Excel follows. 1. Parentheses 2. Exponents 3. Multiplication and Division 4. Addition and Subtraction 5. Concatenation 6. Logical operators

Relative References

The standard type of reference. A cell address without the $ sign in the row and column coordinates, like A1. When this reference is copied to another cell, it changes based on a position of rows and columns.

Text email (Microsoft Outlook)

This format works for all email programs, but it doesn't support bold or italic text, colored fonts, or other text formatting. The plain text format also doesn't support showing pictures inside the message, although you can include pictures as attachments.

HTML (Microsoft Outlook)

This is the default message format in Outlook. It is also the best format to use when you want to create messages that look like traditional documents, with various fonts, colors, and bulleted and numbered lists, and when you want to show pictures inside your message.

Structured Reference

Used when creating aggregations in a formatted table [January]. The special syntax for referencing Excel Tables. These work like regular cell references in formulas, but they are easier to read and understand. They're also dynamic and adjust automatically when data is added or removed from an Excel Table.

Error Bars (Chart Elements)

Visuals indicating statistics for data point or marker.

Range Name

When assigning a name like "expenses" to a range this is called a range name.

Notes Pane (Powerpoint)

Where you put supplemental information that doesn't appear on-slide during a presentation.

Signature (Microsoft Outlook)

You can create one or more personalized signatures for your email messages. Your signature can include text, images, your electronic business card, a logo, or even an image of your handwritten signature. You can set up Outlook so that signatures are automatically added to all outgoing messages or create your signature and add it to messages on a case-by-case basis.

Receipts (Microsoft Outlook)

You can verify that an email you sent is delivered or read by requesting a delivery or read receipt in the Microsoft Outlook 2019 or 2016 email client. Just follow these steps. While writing your message, select the "Options" tab. Under the "Tracking" section, select the checkbox for one or both of the following: Request a delivery receipt for this message request a read-receipt for this message

Formatted Tables group...

a range of cells into something Excel recognizes as a table.

Formatted table options you can turn on and off

o Header Row (Top row is shaded) o First Column (First column is shaded) o Last Column (Last column is shaded) o Banded Rows (Every other row is shaded) o Banded Columns (Every other column is shaded) o Total Row (Adds a new row where you can create aggregations like sum, average, min, max, etc.). Excel doesn't include the total row in sorts and will update to show values based on filtered results.