* Conditional formatting lets you specify formatting for a cell range on the basis of the contents of the cell range.
*To view the conditional formatting options, first select the range you want to fo
I have entered in a worksheet the number of units sold and total revenue for each salesperson, and I can easily
a nice format that is automatically copied if I enter new data? Also, is there an easy w
1. The INDEX function allows you to return the entry in any row and column within an array of numbers:
INDEX(Array,Row Number,Column Number)
2. The INDEX function makes it easy to reference an entire
LEFT function:The function LEFT(text,k) returns the first k characters in a text string
RIGHT function:The function RIGHT(text,k) returns the last k characters in a text string.
MID function:The funct
LEFT function:The function LEFT(text,k) returns the first k characters in a text string
RIGHT function:The function RIGHT(text,k) returns the last k characters in a text string.
MID function:The funct
* Excel assigns serial numbers to times (as a fraction of a 24-hour day). The starting point is midnight, so 3:00 AM
5, 6:00 PM has a serial number of .75, and so on. If you combine a date and time in
A.
Assign the names east and west to cells F3 and F4 respectively
east
west
B.
5
10
Assign the name data to a rectangular range of cells
1
3
5
2
4
6
Average
C.
Name a range of cells made up of several
How can I efficiently determine each of my employee's weekly wages?
Employee
Tricia Lopez
Will Wong
Jack Sprat
Vivian Hibbits
Jose Gomez
April Chou
Tanya Walters
Damon Brown
Totals
Hours
Wage Per Hour
In the game, two dice are tossed. If the get a 2 on the first roll, you win. Otherwise, the game keeps going.
How can I write a formula to determine the status of the game after the first roll?
Toss
R
I have a 5-worksheet workbook. How can I easily navigate between worksheets?
Notes:
* Ctrl+Page Down takes you to the next worksheet in the workbook while Ctrl+Page Up takes you to the previous worksh
*When youre entering a lot of information into Microsoft Excel, its easy to make an error. The data validation feature in
validation, you begin by selecting the cell range that you want to apply data
The MATCH function enables you to find within a given array the first occurrence of a match to a given t
MATCH function instead of a lookup function in situations in which you want the position of a n
How can I move the results of calculations (not the formulas) to a different part of a worksheet?
Games
Dan
Gabe
Gregory
Christian
Max
Points
4
4
5
6
6
28
28
35
22
15
Points/game
7.00
7.00
7.00
3.67
2
1. When I enter dates in Excel, I often see a number such as 37625 rather than a date such as 1/4/2003. What does this n
Dates
Reformatted
37622
37623
37624
37625
37626
37627
37628
37629
37630
37631
*
*Sparklines are exciting graphics that can summarize a row or column of data in a single cell.
*From the Design tab, you can make the following changes to your sparklines:
a. Change the type of sparkl
A) VLOOKUP(lookup value,table range,column index,[range lookup])
- Lookup value is the value that you want to look up in the first column of the table range.
- Table range is the range that contains t
Chapter 15
Stock Options
15-1
Options
A stock option is a derivative security, because the value of
the option is derived from the value of the underlying
common stock.
There are two basic option ty
Chapter 6
6-1
Security Analysis: Be Careful Out There
Fundamental analysis is a term for studying a companys
accounting statements and other financial and economic
information to estimate the economi
Chapter 11
Diversification and Risky
Asset Allocation
11-1
Intuitively, we all know that if you hold many
investments
Through time, some will increase in value
Through time, some will decrease in va
Price quotes for all types of investments are
easy to find, but what do they mean?
Learn the answers for:
1. Various types of interest-bearing assets.
2. Equity securities.
3. Futures contracts.
4. Op
How
to calculate the return on an investment using different
methods.
The
historical returns on various important types of
investments.
The
historical risk on various important types of
investments.
T
Chapter 7
Stock Price Behavior
and
Market Efficiency
7-1
Market Efficiency
The efficient market hypothesis (EMH) is a theory that asserts: As a
practical matter, the major financial markets reflect a
Chapter 2:
The Investment Process
1
2-1
LEARNING OBJECTIVES
Dont sell yourself short. Instead, learn about these key investment
subjects:
1. The importance of an investment policy statement.
2. The va
Chapter 12
Return, Risk, and the
Security Market Line
12-1
In this chapter, we define risk more
precisely and discuss how to measure risk.
In addition, we quantify the relation
between risk and return
Chapter 15
Stock Options
15-1
Writing Call Options
Call Writer (Seller):
Obligated to sell stock at the options strike
price if the buyer decides to exercise call option
Price of the option (premium)
3.
(18 points total) The following information is available concerning stocks A and B. In
addition, you know that the expected market return (krn) is 14%, and the risk free rate of
return (krf) is 6%.
Finance
Jay Fisher
Chapter 1- Introduction to Financial Management
Basic Areas of Finance:
1. Corporate Finance- Business Finance
2. Investments- Work with financial assets (Stocks & Bonds). Deals wit
FIN315
9:30 - 10:45
Exam 3
NAME
1 Refinancing
You are paying 4% on a mortgage with an unpaid balance of $48,000 with 48 months to pay.
You can refinance this loan at 2%. Refinancing would require $480