Explain pivot tables and its uses.

754

---

How can you add a new excel worksheet?

611

---

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

689

---

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

655

---

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

662

---

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

654

---

Explain macro in ms-excel.

765

---

How can you disable the automating sorting in pivot tables?

734

---

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

876

---

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

787

---

What is the and function does in excel?

690

---

How would you format a cell?

669

---

What are the several report formats in excel?

631

---

How would you add comments to a cell?

687

---

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

717

---