Reference no: EM131103094
Instructions: Answer the flowing questions and submit the word document on Canvas. You need to save your file as "Assignment3-lastname-firstname"
1) What are the benefits associated with formatting cells as Table in excel?
2) What does "convert to rage "do in the Table Design?
3) Explain the commonalities and differences between functions and formulas.
4) Explain how should we calculate (5/5)*4/ (3-3*(3*6)) using Excel's order of operations.
5) Suppose that cell A1=1, B1=2 and C1=3, and in Cell A4 we type SUM (A1:C1) and in Cell A5 we type =A1+B1+C1, are the values in Cell A4 and A5 equal? If not explain why.
6) Suppose that Cell A1=1, B1=2 and C1=3 and D1 is blank, In Cell A2 we type =COUNT (A1:D1), what is the output of the function? Explain briefly.
7) Suppose that Cell A1=1, B1=2 and C1=3 and D1=4, in cell A2 we type =SUM (SUM(A1:B1),AVERAGE(C1:D1)). Write an equivalent formula for the function and calculate the result.
8) Can we use a function in a formula? Justify your answer with an example.
9) Can we use a formula as an argument of a function? Justify your answer with an example.
10) Suppose that Cell A1=1, B1=2 and C1=3 and D1 is blank, in cell A2 we type =AVERAGE(SUM(COUNT(B1:D1),AVERAGE(A1:D1)),COUNT(A1:D1)). Explain your approach (steps) to find the return value of the function.
|
Track of the ticket sales
: Another thing is tht the program should give the user an option to see how many seats havebeen sold, seats available in each row, and seats available in thewhole theater.
|
|
Provide a brief description of an organization
: Provide a brief description of an organization where you currently work, would like to work, or one in which you have an interest that you have chosen for this assignment.
|
|
What is the basic accounting problem created by the monetary
: What is the basic accounting problem created by the monetary unit assumption when there is significant inflation? What appears to be the FASB position on a stable monetary unit?
|
|
Business sales and claim punitive damages
: Tyler has always had a 180 day full warranty from Business Sales when purchasing office equipment over the past five years. On this occasion Tyler purchased a fax machine that broke thirty days after Tyler purchased it. Business Sales asserts taht..
|
|
What does convert to rage do in the table design
: Suppose that cell A1=1, B1=2 and C1=3, and in Cell A4 we type SUM (A1:C1) and in Cell A5 we type =A1+B1+C1, are the values in Cell A4 and A5 equal? If not explain why.
|
|
Handle situations and make decisions about the course
: Every person has a different way in which they handle situations and make decisions about the course of action to be taken. Ultimately, every decision comes down to a go point, that decisive moment when the essential information has been gathered,..
|
|
Write a java program to demonstrate the use of iterator
: Write a Java program (non-GUI preferred) to demonstrate the use of Iterator.
|
|
Four basic categories of innovations
: Briefly describe the four basic categories of innovations. Briefly distinguish between product R&D and process R&D.
|
|
What influence has it had on accounting entries
: What has been the effect of this practice on accounting? What is its relation to the accrual system? What influence has it had on accounting entries and methodology?
|