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

637

---

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

651

---

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

610

---

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

626

---

What is if function in excel?

669

---

What are pivot tables and also mention its use?

605

---

In how many formats is a report available in excel?

697

---

Can a pivot table use multiple sources of data?

642

---

What are the useful functions in microsoft excel?

615

---

Explain types of workbook protection in excel.

635

---

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

648

---

How can the user change the size of the column?

621

---

What do you mean by ribbon?

610

---

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

679

---

What do you mean by charts in ms-excel?

637

---