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

639

---

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?

617

---

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

632

---

What is if function in excel?

672

---

What are pivot tables and also mention its use?

607

---

In how many formats is a report available in excel?

700

---

Can a pivot table use multiple sources of data?

645

---

What are the useful functions in microsoft excel?

619

---

Explain types of workbook protection in excel.

637

---

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

650

---

How can the user change the size of the column?

629

---

What do you mean by ribbon?

612

---

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

680

---

What do you mean by charts in ms-excel?

640

---