**“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.

### Premium **Service**

- 100% Custom papers
- Any delivery date
- 100% Confidentiality
- 24/7 Customer support
- The finest writers & editors
- No hidden charges
- No resale promise

### Format and **Features**

- Approx. 275 words / page
- All paper formats (APA, MLA, Harvard, Chicago/Turabian)
- Font: 12 point Arial/Times New Roman
- Double and single spacing
- FREE bibliography page
- FREE title page

### 0% **Plagiarism**

We take all due measures in order to avoid plagiarisms in papers. We have strict fines policy towards those writers who use plagiarisms and members of QAD make sure that papers are original.