Urgent! The leader in charge of recruitment asked a set of questions that can cover the basic operation of excel forms. I don't know how to solve these problems.

Open the document% examine _ folder% \ excel \ d01\ ks4-6.xls in the spreadsheet software and do the following:

1. Environment settings and table modification:

According to sample 4-6A, insert a line before cell B7 of Sheet 1 and fill in the corresponding contents.

According to example 4-6A, set the height of the title row in the worksheet table of Sheet 1 to 25, and define the title row name as "student achievement".

2. Arrangement and modification of table format:

According to sample 4-6A, merge and center the title area A1:f1in the table; Set the title of the table to a square body with a font size of 20 points.

According to Example 4-6A, center the table title text, make it bold, and add light yellow shading; Set the data in the data area in the table to the center format.

According to example 4-6A, set% examine _ folder% \ excel \ d01\ tu4-6.jpg as the worksheet background.

3. Data management and analysis: According to sample 4-6B, in the worksheet of Sheet2, "Mathematics" is the main keyword, "Chinese" is the secondary keyword, and "geography" is the third keyword in descending order.

4. Application of chart: According to Example 4-5C, create a separated three-dimensional pie chart in the Sheet3 worksheet with the corresponding data in the Sheet3 worksheet, and display the numerical values.

5. Modification and protection of data and documents: protect the workbook structure and window, and the password is "gjks46".

Click the Open button on the toolbar to open KS4-6. Put the XLS file in the corresponding folder and click the "Open" button.

1. Environment settings and table modification:

Step 1: Select the B7 cell in the Sheet 1 worksheet, and then select the Line item under the Insert menu. According to Example 4-6a, enter the corresponding contents in the corresponding cells.

Step 2: click any cell where the title line is located, and select the "Line" item under the "Format" menu->; Select the line height item, enter "25" in the line height text box, and then click OK. Select the "A 1" cell, enter "student grades" in the name box on the left side of the edit bar, and then press Enter.

2. Arrangement and modification of table format:

Step 1: select the "A 1: F 1" cell area in Sheet 1, select the cell item under the format menu, select the alignment tab, and select center in the horizontal alignment drop-down list of text alignment. Select the font tab, select Founder Yao Style in the font list box, select 20 in the font size list box, and click OK.

Step 2: Select the cell range A2: F2, click the center button in the formatting toolbar, and click the bold button in the formatting toolbar. Select the cell item under the Format menu, select the Pattern tab, select the light yellow item in the color list in the cell shading area, and then click OK.

Select c3:F 13, and then click the Center button in the Format toolbar.

Step 3: Select the "Worksheet" item under the "Format" menu->; | Select the "Background" item, select the file TU4-6.jpg in the \EXCEL\D0 1 folder in the "Look in" drop-down list, and click the "Insert" button.

3. Data management and analysis:

Step 1: switch to the Sheet2 worksheet, select the A2 cell, select the sorting item under the data menu, select mathematics in the primary keyword drop-down box, select Chinese in the secondary keyword drop-down box, select geography in the third keyword drop-down box, and select the descending button respectively.

4. The use of charts:

Select the data in the cell areas of "B2: B 13" and "D2: D 13" of Sheet3, select the chart item under the Insert menu, select Pie Chart in the Chart Type list box, and select the separated 3D Pie Chart item in the Sub-Chart Type list. In the Chart Title text box under the Title tab, enter a Chinese report, select the Data Flag tab, select the Value check box in the Data Label Inclusion area, click Next, select the Insert as Object radio button, and then click Finish.

5. Revision and protection of data and documents:

Select the "Protection" item under the "Tools" menu->; Select the "Protect Workbook" item, select the "Structure" and "Window" check boxes, enter the password "gjks46" in the password text box, click OK to open the "Confirm Password" prompt box, enter the password "gjks46" in the "Re-enter Password" text box, and click OK.

Question 2: In the spreadsheet software, open the document% examine _ folder% \ Excel \ E01.a5.xls, rename the worksheet of Sheet 1 as "deposit trial balance", and follow the following requirements.

1. format setting: according to sample 5-6A, set the number format of the "final deposit amount" column as follows: currency, with two decimal places reserved.

2. Univariate analysis: As shown in Sample 5-6A, the univariate problem is analyzed by using the analog operation table, and the function of calculating the "final deposit amount" through the change of "monthly deposit amount" is realized by using the FV function.

3. Create, edit and summarize the scheme:

As shown in Example 5-6B, add a scheme to the scheme manager and name it "KS56".

Set "Monthly Deposit Amount" as a variable cell, and enter a set of variable cell values as "-8500, -9000, -9500,-10000,-10500".

Set Final Deposit Amount as the result cell and report type as Scheme Summary.

1. format setting

Step 1: Open the material file, right-click on the worksheet of Sheet 1, and select "Rename" in the pop-up shortcut menu, and the label will be highlighted. Enter the name "Deposit Trial Balance" and press Enter to confirm.

Step 2: Select the "E3: E9" cell area, select the "Cell" command under the "Format" menu, open the "Cell Format" dialog box, and click the "Numbers" tab.

Step 3: Select "Currency" in the category list, select or enter "2" in the decimal text box, and select "RMB" in the drop-down list of currency symbols.

Step 4: Click the OK button.

2. Univariate analysis

Step 5: Select the "E3" cell and select the "Function" command under the "Insert" menu to open the "Insert Function" dialog box.

Step 6: Select Finance in the Or Select Category: list box, select FV in the Select Function list box, and click OK to open the Function Parameters dialog box.

Step 7: Enter C5/ 12 in the Rate text box, C6 in the Nper text box, C4 in the Pmt text box, and click OK to get the result.

Step 8: Select the "D3: E9" cell area, and select the "Simulation Operation Table" command under the "Data" menu to open the "Simulation Operation Table" dialog box.

Step 9: Enter "C4" in the "Enter cells that reference columns" text box, and then click the "OK" button.

3. Create, edit and summarize the scheme