I am into creating voluminous reports on Excel and hence would need up to 10 worksheets on an average in a workbook. However, Excel by default provides only 3 worksheets. I would like to know if this number can be changed  so that I get 10 worksheets by default in a new workbook.How can i I change this?

What is conditional formatting in Excel? What is this feature used for? Where in the menu can I find the option to set up Conditional Formatting. I would like to highlight alternate rows in  a worksheet. Can I do this with the help of conditional formatting? What is the formula I need to set for this?

How can you check whether a Pivot Table is modified or not? How can I prevent a loss in the format of my Pivot tables? How can I turn off the auto Format option? Where can I find the options for this? How can I turn off  the automatic sorting feature in Pivot tables?

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?

Hello, I am a user of Microsoft word 2014. Recently I was working on a equation based exam paper worksheet. I usually work with our local typing/ keyboard software and it was working fine with Microsoft word 2010. But as I upgraded to 2014 it is very tough for me to create perfect equation worksheet as the symbols aren't showing. Any person here who have solution?

I have been having some problems saving Word documents file and have lost some few hours due to my computer going off intermittently. I would like to stop this frustrating experience by having word save at 5 seconds intervals. Could you kindly show me how to configure Microsoft Word in such a way that my Word document get saved every 5 seconds?