Microsoft Office
Microsoft Office
What is an array formula in Excel? I need to count the number of times the value in a cell is greater than 0 for a particular row or column. How do I use an array formula for this? Can I use the COUNT function? Is there any other function that I can use? |
- 701 views
- 2 answers
- 0 votes
What is the maximum number of rows and columns in a standard worksheet in Excel? Can I increase the number of rows or columns more than the standard available number? Can I create a database in Excel? If not, what is the option for me to use a database within Excel? What can I do to make this possible?ca
- 737 views
- 1 answers
- 0 votes
I want to protect the formulas that i have created in Excel.What can i do so that my formulas are hidden from all.I want Excel to hide the formulas but display the results only.What can id o to make this happen?What is the difference between the property 'locked' and hidden in Excel? |
- 1018 views
- 5 answers
- 0 votes
How does Excel store dates? How will excel calculate the difference between two dates? Can I create a formula for this operation? Is there any function in excel which will help to perform this operation with ease. What is its syntax? Please let me know where under Formulas can I find this function. |
- 1779 views
- 2 answers
- 0 votes
I am using a workbook where I have entered the number of hours worked by my contractor. In the Next column, I have the hourly rate. However, when I multiply them both, I do not get the total sum payable which should be number of hours x hourly rate. What could I be doing wrong here? |
- 746 views
- 1 answers
- 0 votes
I need to use the WEEKDAY function in Excel for my work. When I use the function it gives me an integer value from 1 to 7.Should it not be telling me which day of the week I am looking up? How can I make the function do that? Is there any other function that I could use for this instead? |
- 1171 views
- 2 answers
- 0 votes
Can I insert comments into a Word document? Where do the comments appear in a Print Layout? In the Normal View and the Outline view I can see the comments in the bottom of the page only. Can I see it side by side in the margin. Please let me know if I can change this? |
- 1100 views
- 2 answers
- 0 votes
What is the drawing canvas in MS word used for? How does it work? How can I delete the drawing canvas around my object? Can I prevent Word from automatically creating the drawing canvas each time I insert an object in Word? Where in the tools menu can I find an option to turn this off? |
- 789 views
- 1 answers
- 0 votes
- 735 views
- 1 answers
- 0 votes
I need to preview changes before I accept them.
|
I would like some help with formatting in MS word. I would like to know if there is an option to find and replace other things than words. For example, I would like to find all the times that I have mentioned America and make it as BOLD and change the font for it.Can I do that? |
- 615 views
- 2 answers
- 0 votes