What is the use of lookup function in excel?

769

---

Which function is used to determine the day of the week for a date?

753

---

How can you wrap the text within a cell?

754

---

What is the easiest solution to reduce the file size?

679

---

What is ribbon?

815

---

What does a red triangle at the top right of a cell indicate?

683

---

What are some best practices when creating complex models in excel?

688

---

What are left, right, fill and distributed alignments?

749

---

How many rows and columns are there in microsoft excel 2003 and later versions?

820

---

What are charts in ms-excel?

816

---

What is the syntax of vlookup?

797

---

In your opinion, what are a few of the most useful functions in excel? How do you use them?

638

---

What is a pivottable, and when would you use one? What are the key pivottable ‘sections’ into which users can drag columns?

699

---

What could you do to stop the pivot table from loosing the column width upon refreshing?

591

---

What is the difference between bdc and bcs?

868

---