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 am using the Track changes option on my document. My colleague has made several changes on my article and I would like to see how these would look if I accept them . Is there an option where I can preview these changes? Where can I look for it in the menu?
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

Latest Articles

Free cloud mining is coming! RICH Miner launches mobile mining, everyone can earn cryptocurrencies

RICH Miner officially launches a new mobile cloud mining application, subverting the traditional mining model! No need to buy mining machines, no technical experience required, just a mobile phone, global users can start the...

Rokid Max 2 Review: I Tried AR Glasses So I Could Watch Netflix in...

I’m not a tech geek. I don’t keep up with every new gadget launch. I fly a few times a year, watch many movies on my phone, and live in a small apartment where...

Top 10 Technology Trends For 2025

With 2025 just around the corner, it is time to start thinking about what tech trends will be coming our way. Tech moves at a rapid pace. Some things may pop up next year...

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...

10 Facts About The Dark Web

Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...

Top 10 Latest Steam Cleaner Machines

While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...

Latest Tips

Top 10 Internet Monitoring Software

Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...

Top 10 Best Partition Manager Software

A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software. 1....

Top 10 Best Online Music Production Software

Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...