1. Copy this folder: \ Zisha Tea Set. Doc, PIC2 17.jpg, pic220.jpg, PIC2 10.jpg to g:\

2. typesetting according to the following requirements

Steps:

(1). page setup

1. Select "> Settings"->; Margin: 1.3cm, direction? "level"

In the "clip"? Select all, and then select the menu format? "Column"? "Number of columns": 3

2. Select "> Settings"->; For layout, header and footer, please select different parity pages.

(2). Set the Header and Footer.

1. Enter "Wuyutai Tea House, No.23 Wangfujing Street, Wangfujing, Beijing +00-6736 726 1 fax 0/kloc-0-67367260" in the header of the home page, and set "official script", with four levels aligned in the middle.

2. Enter "Little Knowledge of Purple Tea Set" in the header of the second page, set "Official Script", and align it in the middle of Level 4.

3. Insert the watermark image

Select the menu "insert"->; Pictures? "From file", insert pic2 1 7.jpg in the header of1page, double-click the picture, and select the layout in the Format Picture dialog box. "Under Text" and select the "Erosion" effect for the color in the "Image Control" column of the "Picture" tab. Drag the picture so that it is in the middle of columns 1 and 2.

Insert the picture pic220.jpg in the same way so that it is between the second and third columns.

In addition, insert the picture pic2 10.jpg on page 2.

(3). New calendar

1. Subtitle 1: bold, small four, bold, centered and aligned. Select "Automatic" for paragraph leading distance and paragraph trailing distance.

2. Subtitle 2: Bold, small four, bold, left-aligned, and select "Automatic" for paragraph leading distance and paragraph trailing distance.

3. Subtitle 3: Bold, No.5, left-aligned, and "Automatic" is selected for the distance between the front and back paragraphs.

4. Subtitle 4: Song Ti, No.5, left-aligned, paragraph spacing 14 lbs.

(4). Document format

1. Apply the style established above to the document.

The main heading applies the style "Subtitle 1"

X.x applies the style "Subtitle 2"

X.X.X application style "Subtitle 3"

X) Apply "Subtitle 4" style

Set "Indent the first line by 2 characters" for the remaining text paragraphs.

(5) Insert wordart.

Place the cursor in the middle column of the second->, and then click Insert->; Pictures? In the Art Font, select the "Vertical" style in the upper right corner. Enter "Little Knowledge of Zisha Tea Set" with the font of "Lishu" and the font size of "66" in bold.

Insert text after WordArt:

Wuyutai tea house Beijing Wangfujing store

No.23 Wangfujing Street

Telephone 0 10-6736 726 1

Fax 0 10-6736 7260

Copy lx.xls under this folder to G:\, open lx.xls, and complete the following operations as required:

1. In the sheet 1, line 22 stores the credits of subjects, such as 2 credits for college Chinese and 4 credits for advanced mathematics. Requirements:

(1) Calculate everyone's credit score and round it up. The formula is:

Credit score = ((sum of subject scores * subject credits))/total credits.

Namely: Li Zhen's credit score = (76 * 2+84 * 4+73 * 4+90 *1+70 * 2+87 * 6)/19.

(2) Rank according to the credit score, and then fill in everyone's ranking.

(3) According to the ranking, calculate the scholarship grade with if function. The rules are as follows: the ranking is within the whole class 10% (18 students), fill in the "first prize", the ranking is between 10% and 30%, fill in the "second prize" and the rest are "no prize".

2. In the "total wages", use (1) to calculate the wages payable, that is, basic salary+bonus+subsidy-provident fund; (2) If the income tax is calculated by function, the quick calculation rules are as follows: Payable wages.

(3) Calculate the actual salary, and the actual salary = payable salary-income tax.