Computing,MS Excel,MS Office

How to Create a Quiz in Excel or Works01 Oct

If you are a teacher of any grade or subject, you can use this article to help you learn how to quickly create your next quiz or test in Microsoft Excel. Most people think that Excel is only for spreadsheets and that you need to use Word to make a quiz or test, but Excel has a very fast an easy way to create your tests and quizzes for your students. Read on to find out how.

Steps to Create a Quiz in Excel or Works

Here are the basic steps involved. If you follow these precisely, you will be able to easily create your tests and quizzes in Works or Excel. The directions are exactly the same in Works Spreadsheet and Excel, so if you don’t have the more expensive Excel program, you can use Microsoft Works Spreadsheet just as easily. This will help you keep organized and also help you save time, so here is how to do it:

1. Open Excel or Microsoft Works and start a new spreadsheet.

2. The first… Read More

Computing,MS Excel,MS Office Applications

How to Use Charts in MS Excel01 May

Microsoft Excel has many uses and it is considered by many as the most important program in the Microsoft Office suit. It is a very powerful application for creating and editing spreadsheets, but you can also use it for other purposes: for example, it has a very powerful chart-generating module, an element many people search and need. Because it is included in the Office suit, Excel is a very intuitive program, although it holds many secrets and useful tools.

Using charts in Microsoft Excel is a very important feature of this application as you can use charts to present data that has been entered in the worksheet in a visual way. Microsoft Excel has a full range of chart types it can generate. One thing you should know is that before you can use Excel’s chart generating module you must have entered the data into the worksheet. Generating intuitive and easy to read charts is fairly easy in Microsoft Excel and the program has a wizard to assist you.

Step 1

After all the data has been introduced in the… Read More

Computing,MS Excel,MS Office Applications

How to Sort and Use the Auto Sum Feature in Microsoft Excel01 May

Microsoft Excel is one of the most used software applications for spreadsheet editing. Compared to a third party solution, it has the advantage that it comes along with the Microsoft Office suit and although it is one of the most powerful and features rich programs available, it is relatively easy to learn and use. Many people run away at first when they see the multiple menus and features Microsoft Excel has, but things are not that complicated. Because it is part of Microsoft Office, some of the menus ad features are common to all Office programs. This means that if you have worked with another Office application before (such of Microsoft Word), you will find many of the menus familiar (especially those related to opening a new work sheet, to saving files, to printing the spreadsheets and other similar actions). However, its main purpose is to create complex spreadsheets, calculations and graphs so may of these actions might be new for you.

msexcelone

It is a common situation that you have worked on a worksheet with multiple columns and rows,… Read More