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.