Microsoft Excel Questions...?

I had a few questions about Microsoft Excel, I was wondering if some one could help me out with my questions...

What function would you use to display the word "Paid" in a cell if the value in another cell in the worksheet had a value greater than 0?

What function would you use to calculate the day of the week on which you were born?

Your company maintains an Excel list with customer account data. You wish to Sort the data by last name. If you select the Last Name column and click Sort Ascending on the toolbar, what will happen to the records in your list?

You maintain a list of Inventory Items for your store. You have fields for item name, item price, and quantity on hand. You are asked for a report of all items with a quantity less than ten. Will you create a Pivot Table or a filtered list? Why?

Your co-worker wants to use long, descriptive Field Names for an Excel list you are creating for your department. Do you think she is right? Why or why not?

Microsoft Excel Questions...?virus removal

1. =IF(A1%26gt;0,"Paid","Unpaid")

2. try this one!

=DATEDIF(A1,NOW(),"y") %26 " Years,

"%26DATEDIF(A1,NOW(),"ym")%26 " Months, "

%26DATEDIF(A1,NOW(),"md") %26 " Days"

3. Mess up. If you sort the last name column only.

4. Pivot Table. efficient (time/effort)

5. If she thinks that it'll helped her to manage her data, why's not?

particularly if She is your boss :D

Microsoft Excel Questions...?anti virus protection

Sounds like this should be in the homework help section!