Name some functions in Excel and how I can use them? What is the purpose of the lookup function in EXCEL? What operation does the AND function perform? What is IF function in Excel? How is the “What If “condition used in Excel to give different answers when you change the data ?

What is the Dynamic Named Range? How can you create a dynamic named range in excel? How would you provide a Dynamic Range in Data Source for a Pivot Table? Is it possible to make a pivot table from multiple sources of data in the same workbook .Can you make one from data in different workbooks?

How can I protect my Workbook from being copied by others? Can I prevent others from copying the contents of a cell from my Workbook? Where can I set a password to my workbook? Can I set a password so that people can have only read access and be able to modify it? How do I do this?

What are Macros in MS Excel? What are they used for? How can I create a macro in Excel? How can I run a macro? How does macros help make a task easier for the user? What are the disadvantages of using Macros in excel? Where in Excel can I find Macros?

I want to automate certain computations in Microsoft Excel but I do not know how to go about it. I have read a few guidelines but they have not worked to date. I would like someone with experience and expertise in writing macros for Microsoft Excel to help me with some short steps to write a macro and run it successfully in Excel.

What are the most distinct vital and technical features of Microsoft Office Excel 2013 from Microsoft Office Excel 2010 that are to be noted by lay person? Are there any similarities thus any feature found in the 2010 version that is still maintained technically in the 2013 version? Thank you.

I am using Microsoft Office 2007, today I encountered a problem using MS Excel. Firstly I opened a file in Excel and after a few seconds, I connected to the Internet through WiFi. Now when I returned back to my Excel file, it started hanging up, and later on, it asked to save the file, as I clicked on Yes button, the Excel application got Abnormally Terminated. I didn't clicked the close button, despite that this all happened. So please tell me, why my Excel application is closed and what could be the reason behind this problem ? 

In MS Excel 2007 and 2010, I have a database of my sites where places are also various sites AUG2345, AUG2346 differentiated AUG2347 and so on. When I'm in AUG2345 in Excel, it converts it updated immediately. when I try to format the cell, it converts it into numbers, but I want AUG2345 data AUG2346 and so continue. Please help.

I am novice to the computer though I have to regular use the Excel due to my office requirements, If anyone knows the how to wrap texts formula for MS Excel. Though I can use the wrap text and it’s useful for me but I want to know the formula. I know this may be very easy question but if anyone knows the formula then please share it with me as this will be great useful me.