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

637

---

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

650

---

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

608

---

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

623

---

What is if function in excel?

668

---

What are pivot tables and also mention its use?

603

---

In how many formats is a report available in excel?

694

---

Can a pivot table use multiple sources of data?

640

---

What are the useful functions in microsoft excel?

612

---

Explain types of workbook protection in excel.

633

---

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

645

---

How can the user change the size of the column?

618

---

What do you mean by ribbon?

610

---

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

674

---

What do you mean by charts in ms-excel?

635

---