Differentiate between count, counta, countif, and countblank in ms-excel.

666

---

What is the difference between substitute and replace function in ms-excel?

685

---

How can the users return to any particular area of a worksheet?

654

---

What is the role of cell reference in the calculation in excel?

673

---

What is if function in excel?

724

---

What are pivot tables and also mention its use?

651

---

In how many formats is a report available in excel?

751

---

Can a pivot table use multiple sources of data?

697

---

What are the useful functions in microsoft excel?

672

---

Explain types of workbook protection in excel.

682

---

How can you disable the automatic sorting of information in a pivot table?

688

---

How can the user change the size of the column?

657

---

What do you mean by ribbon?

643

---

What do you mean by freeze panes in ms-excel?

724

---

What do you mean by charts in ms-excel?

669

---