E. Answer the following questions.
1. List the components of mail merge.
2. Name the four options in the Delete dialog box in Excel 2010.
3. Write the steps used to change the Date and Time using the Control Panel.
4. How will you delete a worksheet?
5. What is the difference between a simple formula and a complex formula?
6. Explain the three types of cell references in Excel 2010.
7. What is the use of the IF function in Excel?
F. Identify the commands represented by the following icons in
Answers
Answer:
1.) -
A mail merge is used to create form letters, mailing labels, envelopes, directories, and mass e-mail message and fax distributions. There are three documents that are involved in the mail merge process: the main document, the data source, and the merged document.
2.)-
Shift cells left, Shift cells up, Entire row, and Entire column
3.)To set the date and time:
Choose Start > Control Panel > Clock, Language, and Region > Date and Time.
or
Click the clock in the taskbar's notification area; then click Change Data and Time Settings.
or
Right-click the taskbar clock and choose Adjust Date/Time.
or
Choose Start, type date and time in the Search box, and then press Enter.
On the Date and Time tab , click Change Date and Time, adjust the date and time as needed and then click OK.
4.)-
Delete a worksheet
Right-click the Sheet tab and select Delete Delete.
Or, select the sheet, and then select Home > Delete > Delete Sheet.
5.)-
A simple formula is a mathematical expression with one operator, such as 7+9. A complex formula has more than one mathematical operator, such as 5+2*8. When there is more than one operation in a formula, the order of operations tells your spreadsheet which operation to calculate first.
Answer:
450 diamonds I have buy dimonds