Reference no: EM132022661
Question: The tasks for this block are:
1. Watch the videos on functions and formatting.
Lecture 2 Excel Functions Version 1 (By James Curry)
Lecture 2b Formatting Cell Values (By James Curry)
2. Answer the block questions.
Please find the Excel function that performs these tasks. Write the function and describe the inputs to the function.
1. What function in Excel returns the current time?
2. What function in Excel rounds up a fractional number?
3. What function in Excel rounds down a fractional number?
4. What function in Excel rounds a fractional number with above .5 rounded up?
5. What function in Excel returns the month of a date?
6. What function in Excel returns the day of the month?
7. What function in Excel returns the year of a date?
8. How does Vlookup work? Please provide a small example.
9. What function generates a random number in Excel?
10. What log math functions does Excel support?
11. Write a function using the if statement for the price of an item. If less than 20 items are purchased, the price is $3. If 21 to 99 items are purchased the price is 2.80 per item. If over 100 items are purchased, the price is 2.70. The discount applies to all items.
12. What are the common formats for values in Cells?
|
Describe and analyze the five elements of a contract
: Explain why this contract is governed by common law or the Uniform Commercial Code (UCC). When is a contract governed by common law? By the UCC?
|
|
How you do or could use operations security in current job
: If you are currently unemployed or in a job in which you are not able to apply the class concepts, define the job you are looking to apply for.
|
|
What is the irr for the project
: That is, it will return $2,100 at the end of the second year, $2,205 at the end of the third year and so on. What is the IRR for the project?
|
|
How much money will be in the account
: How much money will be in the account at the end of that time period?
|
|
What function in excel returns the current time
: Please find the Excel function that performs these tasks. Write the function and describe the inputs to the function. What function in Excel returns the current
|
|
What is the contribution margin ratio for segar company
: Segar Company budgets sales of $3,200,000, fixed costs of $ 700,000, and variable costs of $2,240,000. What is the contribution margin ratio for Segar Company?
|
|
Project performance measures
: You were asked to revise your discounted cash flow analysis for a particular project assuming a higher required return.
|
|
What is liam asset allocation
: What is Liam's asset allocation? Is it appropriate, and why?
|
|
How to convert the virtual to physical in linux kernel
: Learn how to convert the virtual to physical and vice versa in Linux kernel. Ability to look at and if necessary understand the struct page entries.
|