IT Homework

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.

Are you Looking for Quality and Plagiarism-Free Assignment Help? Get Trusted Help From the Most Skilled Writers at Homeworkmaven.com. Hire Your Personal Writer Today and Keep Up Your GPA this Semester.
275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.

12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.

Double line spacing

Your essay will have double spaced text. View our sample essays.

Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.

We Accept
Image 3