What is the use of lookup function in excel?

694

---

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

699

---

How can you wrap the text within a cell?

679

---

What is the easiest solution to reduce the file size?

612

---

What is ribbon?

730

---

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

632

---

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

611

---

What are left, right, fill and distributed alignments?

696

---

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

728

---

What are charts in ms-excel?

731

---

What is the syntax of vlookup?

704

---

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

597

---

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

652

---

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

546

---

What is the difference between bdc and bcs?

820

---