Science Tutor

Showing posts with the label M.S. EXCEL TUTORIALSShow all

MICROSOFT OFFICE

Some important Information Technology Questions with Answers | Science Tutor

Some important Information Technology Questions with Answers 1. How many orientations are there in page setup option? Ans. There are two …

MICROSOFT OFFICE

CountIF - Formula in M. S. Excel - Science Tutor

CountIF - Formula Another useful function that uses Conditional Logic is CountIF. This one is fairly straightforward. As its name suggests, it counts t…

MICROSOFT OFFICE

Conditional Formatting in Excel 2007/2010 - M. S. Excel Tutorials - Science Tutor

Conditional Formatting in Excel 2007/2010 You can use something called Conditional Formatting in your Excel spreadsheets. Conditional Formatting allows y…

MICROSOFT OFFICE

The IF Function - M. S. Excel Tutorials - Science Tutor

The IF Function The IF function can be quite useful in a spreadsheet. It is used when you want to test for more than one value. For example, has a bil…

MICROSOFT OFFICE

Move and Resize your Chart - M. S. Excel Tutorials - Science Tutor

Move and Resize your Chart You might find that your chart from the previous lesson is covering your data. In the image below, our chart is overlappi…

MICROSOFT OFFICE

Create an Excel Chart - M. S. Excel Tutorials - Science Tutor

Create an Excel Chart We’re now going to create a chart from our BBC1 Viewing figures. If you haven't yet completed the sorting tutorial, go back…

MICROSOFT OFFICE

How to Sort Data in Excel - M S. Excel Tutorials 2016 - Science Tutor

How to Sort Data in Excel Section three of this course is really all about charts. Later, you'll see how to create a variety of charts and chart s…

MICROSOFT OFFICE

Review Number One - M. S. Excel Tutorials - Science Tutor

Review Number One Reproduce the simple spreadsheet below, from a junk-food addict! You can pick your own colours for the cells and data, but try to incl…