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.