ITB Benchmark 2
fixed income
"Loans" ( Do not Change)
Which formula would you enter into D3, and then AutoFill into D4 to D6, to calculate the winning percentage (Pct.) for the teams?
(A5/A6)*100
Three ways to change the column width in Excel
1. Click and drag the columns boundary line to the desired width. 2. Double- click on the columns boundary line. This adjust the width to the widest data in the column. 3. Right hand click on the column header, and click column
IF function
1. Conduct conditional test two possible results 2. Any 2 outcomes can added such as "TRUE & "FALSE" EX- =IF(F3<E3,"Yes","NO")
Two ways to edit a formula
1. Double click on the cell and edit the formula directly in the cell. 2. Select the cell and edit the formula in the Formula Bar
Ways to edit a formula:
1. Double-click on the cell and edit the formula directly in the cell. 2. Select the cell and edit the formula in the Formula Bar.
Two ways to enter a formula in a spreadsheet
1. Enter the formula directly in the cell, 2.Select the cell and enter the formula in the Formula Bar.
Ways to enter a formula:
1. Enter the formula directly in the cell. 2. Select the cell and enter the formula in the Formula Bar.
MIN & MAX
1. Finds the smallest value. 2. Finds the largest value included in a range of cells.
Two ways you can enter cell reference into a formula
1. Point and Click Method. 2. Typing the cell reference
Processes you would use to copy and paste a range of cells
1. Right click cell(s) and select copy. 2. Select the location where you like to paste the cell. 3. Right click cell(s) and select paste
What is the process described in this lesson for formatting a number using the ribbon
1. Select a cell. 2. On the home tab, in the numbers group, click the number format drop- down menu. 3. Select the desired Format.
Insert Column
1. Select a column. 2. Right-click on the selected column and click Insert. A column will be inserted after the column you selected.
Delete Row
1. Select a row. 2. Right-click on the selected row and click Delete
Insert Row
1. Select a row. 2. Right-click on the selected row and click Insert. A row will be inserted below the row you selected.
the Insert Cut Cells command.
1. Select the row. 2. Press the keyboard shortcut Ctrl+X. 3. Select the row where you want to insert the cut row. 4. Right-click on the selected cell and click Insert Cut Cells in the pop-up menu.
Using the correct order of operations, what does this formula equal? =4/(5-3)*2
4
Cell A1 contains the formula "=10+D2". If you copied A1 to B3, what would be the formula in B3?
=10+E4
Which of these Formula uses relative cell references
=F18+F19/2
Row
A Group of cells that run horizontally from left to right
CONCATENATE function
A function that joins two or more text strings into one text string
The three parts that make up a function
A function typically have three parts: an equal sign, a function name, and arguments
Column
A group of cells that run vertically from top to bottom
Cell reference
A way to point a cell location on the spreadsheet
What is the argument: Average(A1:A12)
A1:A12
Examples of Operators
Addition+,Subtraction-, Multiplication*,Division/
SUM
Adds all the values in range of cells
Auto Fill
Allows you to copy information into multiple cells at one time
Workbook
An excel file
absolute cell reference
Cause the reference to be locked. The reference is not updated when the formula is copied. A $ indicates an absolute cell reference. Ex-$B$2
Which of these statements about cell references is NOT true?
Cell referenes an only be entered in a formula by using a Formula Bar
Variable
Changes month to month/ overtime -Things that would change- Groceries, Utilities, Gas
What Clear command would you use to make cell A2 look like cell A4?
Clear Format
Three types of Clear commands
Clear Formats deletes the format from the selected cell. Clear contents deletes the content from a selected cell. Clear all deletes the format and the content from the selected cell
Which method is the most common way used to select the multiple cells shown in the image?
Click and Drag Method
Normal view
Default view in Excel
What Keyboard shortcut is used to clear content for a selected cell
Delete Button
Worksheet
Each file contains one or more spreadsheets
The three parts of a formula
Equal sign, Operand, Operator
Goal is for Zero Budget
Expenses( Disposable and Discretionary income) to be covered by net income 1st- Pay yourself -> put in savings
Describe how format attributes affect a cell and its content?
Format Attributes are associated with a cell and not the cell content. The attributes and content are independent
What does the format " General" indicate about a number in the cell
General is the normal/default format
Operator
Indicates the type of calculations
Process to use to cut a row and insert it above another row
Insert the copy or cut cell between existing cell.2. So you cut the cell you want to insert and right click and on the insert cell and the cell you just cut will not replace the one, you are trying to put between it.
Formula
Is a equation that is entered in a cell
Name Box
Is a input box that is directly to the left of the formula bar. It displays the address of the active cell.
Format Attributes
Is a piece of information that describe the appearances of a cell content.
Function
Is a predefined formula. It allows you to quickly enter a formula. Functions perform a calculation based on values, such as numbers and cell references that are entered in the function.
Cell
Is a rectangular spreadsheet in the excel
logical expression
Is an expression that evaluates to either True or False Ex- 3=3 True, It can contain cell reference
Ways to decrease spending
Make a Budget,Track your spending like receipts, Lower your house expenses,Re-evaluate your subscriptions.
Gross Inome
Money earned before taxes and deductions
Net income
Money left after taxes and deductions
Disposable income
Money remaining taxes and deductions to be spent on needs and savings Emergency Savings -> 3-6 months of Disposable income Wants Investing
Equal Sign
Must be the first character in the cell.It tells the spreadsheet you are starting a formula.
What group in the Home tab would be used to change the format of cell B2 to match cell B4?
Number
Ways to Increase income
Open a Business, Go back to school,Make money with your hobbies, Find a simple way to build a passive income, and ask for a raise or a promotion.
Two Types of cell reference
Relative and Absolute cell references
Increase Decimal Command
Show more decimal places
Decrease Decimal Command
Shows fewer decimal places
Which method is the most common way to select multiple cells?
The Click and Drag Method
The benefits of editing or entering a formula a Formula bar
The Formula Bar allows you to see more of the formula
Why do formulas make spreadsheets more powerful?
The ability to calculate additional information that helps analyze already existing cells
Cell Contain
The cell that contains numbers, formulas, and functions
Expenses
The cost of assets consumed or services used in the process of generating revenues.
Two methods for searching for a function
The formula tab the function Library group, browse for a function 2. Click insert function and enter a search phrase for the function.
Function Name
The name given to one of Excel's predefined formulas.
Cut and Special Insert
The special paste command will insert the copied or cut cells between existing cells
What symbol is used to indicate an absolute cell reference?
The symbol that would indicate an absolute cell reference would be the $ sign because the dollar sign in front of the letter lacks a column reference.
How The color coding of cell reference in a formula works and why it is useful?
These colors are used to highlight the cell reference in the formula,and the cell in the worksheet. The color coding of a cell reference is an easy way to see what cells in the worksheet are being used in the formula.
Ctrl+C
This key helps you copy the text in the cell.
Ctrl+X
This key helps you cut the text in outside the cell
Ctrl+V
To paste the selected text
When should you use the Ctrl Key method for selecting multiple cells
To select cells scattered across the worksheet
When should you use the the Shift Key method for selecting multiple cells
To select very large group of cells.
A cell reference in a formula allows you to point to another cell location.
True
Ctrl+Z
Undo the previous section
Example of Zero -Base- Budgeting
You run a hair salon and sell Shampoo and conditioner to customers. Last year, you purchased these products 30,000 You decide to use zero base budgeting for the upcoming year. You list all your expenses and you find out that you have to make your own hair products so the price can be cheaper than the companies Making your own products will save you about 2,000
Edit mode
allows you to edit existing data in a cell
relative cell reference
are automatically updated, if the formula is copied to the other cell The update reflects the distance Ex-$B2
Argument
are values , such as range of cells, used to calculate the function's value
Average
calculates the average in a range of cells by summing the cells and dividing by the numbers of cells used to find the sum
Page Layout View
divides your spreadsheet into pages
opportunity cost
giving up something to get something else (Money, Time, and other wants)
Active Cell
is a currently selected cell
Zero-base budgeting (ZBB)
is a method of budgeting in which all expenses must be secured for each period of time. It start from a zero base. When creating a budget you need categories. Ex:You decide your'Zero"- $50, $25, $100
Alignment
is how the text is positioned within the borders of the cell
Operand
is the value or data used in the formula's calculation
Cell Address
is where a row and column intersect.
Needs and Wants
need- basic requirement for survival, want- something not needed for survival. Ex. Home, Food, Clothing, Insurance, Utilities are Needs. Movie tickets, Nintendo Switch, and Books are all wants.
escape
this key lets you quit a task, you are performing
Wrap Text Command
wraps the text around to another line so it all fits within the cell.