Smart Tutorials

Functions are the built-in formulas in MS Excel which will let you to perform common calculations on data easily. Functions can be entered in a worksheet using keyboard, AutoSum drop-down menu or Insert Function. You can also learn about Inserting and Positioning Picture in MS Word.

Using Keyboard for Finding the Average:

With the following steps you can calculate the average value of any data by using AVERAGE function.

• 1st of all select the cell where the result will appear e.g. E5.
• Now type =av to display the Formula AutoComplete list.
• Point to AVERAGE function and then double click.
• Now you need to select the range B5:D5 to insert it as argument to the AVERAGE function.
• Now you need to press the Enter key.

Using Insert Command to Find the Highest Value:

For finding the highest value you need to follow these simple steps.

• 1st of all you need to select cell B11 where the answer will appear.
• Now click Insert Function command and you will notice that Insert Function dialog box will be displayed.
• Now select MAX in the function list and then click OK.
• Now type B5:B8 in the Number 1 text box of Function Arguments dialog box and then click OK.

Using AutoSum Drop-down Menu to Find the Lowest Value:

With the following simple steps you can find the lowest value in the range B5:B8 by using AutoSum drop-down menu.

• 1st of all you need to select the cell B12 where the answer will appear.
• Now click on the Formulas tab.
• In the next step you are required to open the AutoSum drop-down menu in the Function Library group and then select Min.
• Now you need to type the range B5:B8 and then press Enter.

MS Word is a handy application for creating text documents and it is the most widely used text editing application all across the world. With MS Word text documents can be created very easily. In MS Word you can easily insert a picture in your documents so that your documents can be enhanced greatly. You can also learn about Saving and Sharing Documents in MS Word 2013. For Inserting a picture in a document you need to follow these simple steps.

• 1st of all you need to place the cursor where to insert the picture.
• Now in the next step you are required to click on the Insert tab.
• After this click on the Picture command present in the Illustrations group. You will notice that the Insert Picture dialog box will appear.
• Now you need to browse and select the picture file to insert and then click Insert button.

Positioning the Picture within a Page:

With the following simple steps you will be able to position a picture on page.

• 1st of all click the picture that is to be positioned. You will notice that Format tab will appear on the screen.
• Now in the next step you need to click on Position the command on the Arrange group.
• Now you are required to select a position from the menu. e.g. top right corner or top left corner etc.
• Once the position is defined the picture will be positioned in your page.

With these simple step you will be able to insert and position the pictures easily.

Whenever you create a new document in MS Word you need to know how to save it so that you can easily access as well as edit the document later on. Word documents can be saved on your computer as well as on cloud by using OneDrive. Documents can also be exported and shared directly from MS Word. MS Word offers two different ways of saving the file which are Save and Save As. Both of these options work in a similar manner with just a few minor but important differences. You can also learn about How to Hide your Name and Email Address on Windows Login Screen.

Save: Whenever you create or edit a document you will use the Save the command for saving your changes. This command is used most of the times. When you have to save the file you will need to select a file name and location for the first time and after that you can click the Save command for saving it with the same location and name.

Save As: Save As command is used for creating a copy of a document while you will keep the original. Whenever you use the Save As command you have to select a different name and location for the copied version.

Saving a document:

• In order to save a document you need to follow these simple steps.
• 1^st of all locate and select the Save command on the Quick Access toolbar.
• Now if you are saving the file for the very 1^st time the Save As pane will appear in the Backstage view.
• After this you need to select where to save the file and then give it a name. For saving the document to your computer, select Computer and then click Browse. (Alternatively you can click on OneDrive in order to save the file to your OneDrive.)
• Now the Save As dialog box will appear and then select the location where you need to save the document.
• Now in the next step you are required to enter the file name for the document and then click on Save.
• The document will be saved and you can click on Save command again once you modify the document.

Using Save As Command:

Now if you need to save a different version of a document while keeping the original you need to create a copy. For this you are required to click on Save As command in the Backstage View. After this you will need to select the location for saving the file and then need to specify the file name.

Using the AutoRecover option:

For using the AutoRecover option you need to follow these simple steps.

• 1^st of all open MS Word 2013 and if the Autosaved versions of a file are found the Document Recovery pane will appear.
• Now you need to click to open an available file and the document will be recovered.

Sharing a Document:

In order to share a document you need to follow these simple steps.

• 1^st of all you need to click the File tab to access the Backstage View and then you need to click Share.
• The Share pane will appear with various different options for sharing the file.