Question

State the process of formatting a group of numbers in excels, so that it displays 2 digits after the decimal.

Answer 1

Answer:

Summary

This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet.

When you use the Word Mail Merge feature, Word merges a main document with a recipient list to generate a set of output documents:

The main document contains the basic text that is the same in all of the output documents. It may contain a letterhead, text, and instructions in merge fields for inserting text (such as recipient names and addresses) that vary from one output document to another.The recipient list is a database that contains the data that is to be merged into the output documents. For example, the recipient list is a Microsoft Access database file or an Excel worksheet.

This database is typically a list of names, addresses, phone numbers, and other categories of personal information.The output documents are the result of the mail merge. The text in an output document can be the same in all output documents, but you can apply formatting to specific documents.

Answer 2

Answer:Click the Table Tools' Layout tab, select Data and then click Formula. Click the Number Format menu and select 0.00 for two decimals. Delete the default =SUM(ABOVE) formula and type the formula you used in Excel based on the cell locations in Word's table. In this example, the formula is =AVERAGE(B2,B3).

Explanation: