Explain pivot tables and its uses.

723

---

How can you add a new excel worksheet?

585

---

How would you provide a dynamic range in "data source" of pivot tables?

638

---

Specify the order of operations used for evaluating formulas in excel.

616

---

How can you sum up the rows and column number quickly in the excel sheet?

621

---

Is it possible to prevent someone from copying the cell from your worksheet?

620

---

Explain macro in ms-excel.

728

---

How can you disable the automating sorting in pivot tables?

692

---

What filter will you use, if you want more than two conditions or if you want to analyze the list using database function?

824

---

What is the quick way to return to a particular area of a worksheet?

745

---

What is the and function does in excel?

634

---

How would you format a cell?

626

---

What are the several report formats in excel?

599

---

How would you add comments to a cell?

623

---

What is a macro in excel? How to create an excel macro?

653

---