Find Autocad commands, as well as basic statistical commands for Microsoft Office Excel the more co

Hehe! I also have to take the computer test in No. 1 Middle School.

Let's take a look at this friend upstairs first, it's a good way. You can also do this: select the CAD diagram you want to insert, just right-click and drag it, then press Ctrl+C, then go to Excel, and then press Ctrl+V, and you're done.

In addition, I would like to recommend a new method to you. The feature of this method is that after the conversion, the deletion of CAD changes will not affect the ** in the Excel file. In CAD, select File Export, and in the pop-up dialog box, select under Name.

BMP or. WMF last press Save. In this way, the CAD is saved as **.

Then insert the file you just saved in excel. This file is generally your original file in**,It will be saved for you**,Go directly to the original file to find it.。 Remember that when the CAD is turned to **, you can first adjust the color of the CAD space to white, and then turn it to a white background, which is convenient and looks better.

In this way, when you are in excel, you can directly adjust it as **. After inserting it into Excel, the original CAD and the ** that has just been converted have nothing to do with the existing Excel.

I don't know! Take a place to learn!

Copy and paste it into Excel from the clipboard.

Truncating the first few characters in a cell can use the left function. leftReturns a specified number of characters starting from the first character of the text string. The format is left(text, [num chars]).

Software tool: excel2013

1. Suppose you want to take the first 4 characters from B3.

2. Enter =left(b3,4) in the appropriate cell and press the enter key to confirm.

3. If the whole column is full, you can fill the formula down. This allows you to take a screenshot of the specified number of cells in the specified number.

Explanation: left(text, [num chars]).

1. text is a text string containing the characters to be extracted. In the picture above, B3 is taken out of B3.

2. [num chars] is optional. Specifies the number of characters to be extracted by left. In the above figure, the first 4 characters in B3 are taken.

Extended Content:Microsoft Office is an office software suite developed by Microsoft Corporation, which can run on Microsoft Windows, Windows Phone, Mac family, iOS and Android. Like other office applications, it includes federated servers and internet-based services.

From 2007 versions of Office are called "Office System" instead of "Office Suite", reflecting the fact that they include servers.

Office is often the standard for making document files, and there are some features that other products don't have, but other products also have features that Office lacks. Since Microsoft 2007 Office System, there has been a very different user interface than previous versions, which is called the ribbon interface and is used in Microsoft Office 2010, Microsoft Office 2013 and Microsoft Office 2016. [1]

There are three ways to do this:

1) It can be done with a function, assuming that A1 corresponds to "Zhang San: 50 points", and A2 corresponds to "Li Si: 85 points", then enter =left(A1, find() in B1":,a1, 1)-1) can extract "Zhang San", fill the formula to b2, and you can extract "Li Si". Fill the formula with the other cells in column b to extract all the boxes in column a.

The implication of this formula is that first use find("：",A1, 1) Find the location of : in A2, and then use left() to extract the data before the : sign from A1.

In addition, if column A uses : is a half-width (: is a half-width, : is full-width, different), put the"："Changed to":", otherwise there will be an error.

2) Columnization method: If you don't use a function, you can use data-column, first select "separator", then select "other", enter: number, the next step will change the target area to C1, press complete to divide column A into two columns, column C is the name, column D is the score.

3) Find-Replace method: You can also find and replace, enter :* in the search, and nothing will be lost in the replacement, and the : number and the score behind it will be removed by replacing all.

=left(a1,2), 2 means to take a few characters, you can set it yourself.

Includes full Word, Excel, Access, PowerPoint, and Office tools.

Safe and non-toxic, follow the prompts, you can use it for life after installation.

Among them, Office2003 General Edition can support both 32-bit and 64-bit Windows

It is said that you need to change the configuration of office again, and the operation is actually very simple: control panel - add and remove programs - office - change - remove the tick in front of excel - OK (office will configure).

Again after restarting:

Control Panel - Add & Remove Programs - Office - Change - Tick the box in front of excel - OK (Office will configure again).

Reboot, now it's OK.

Of course, your installer is still there.

Check out the loading macros in the Tools menu.

Refer to the documentation, the operation is very simple.

1.Create a new electron**.

2.Select the cell.

3.Plus borders.

4.Enter serial numbers, dates, summaries, incomes, expenses, balances, remarks, and more.

5.In the second line, enter information about your income, such as your salary.

6.In the third line, enter the information of the expenditure, such as paying rent, etc.

7.Set the formula in the column of cell balance in the third row, i.e. the balance in the previous column plus income minus expenses equals the current balance.

8.Pull down the formula and add the total to reflect your income and expenses over time.

9.Set the format of the text to make it look more beautiful.

1. Open Excel**, enter the label (name of the company) in the first line, enter the address (the company's detailed address) in the second line, enter the company's (** and fax) in the third line, enter the fourth line (statement), and enter the fifth line (customer, month, print date), as shown in the figure.

2. Press and hold the "Ctrl" key in the keyboard, select the area [A1:H1,A2:H2,A3:H3,A4:H4,A5:H5], and click the [Merge and Center] button in the menu bar, as shown in the figure.

4. Enter [date, delivery note number, name and specification, unit, quantity, unit price (yuan), amount (yuan), remarks] in **, after entering, press and hold the "CTRL" key in the keyboard, select the area [A18:C18,D18:G18], and click the [Merge and Center] button in the menu bar, as shown in the figure.

5. Enter the "total amount of this month's payment (RMB) and RMB symbol" in the merged cell, and indicate the above matters below, account name (the name of the company's payee), Agricultural Bank account number, **business confirmation, customer confirmation, as shown in the figure, and finally adjust the font size and format according to the content. When making a statement, you can take a seat according to the delivery note number.

Method steps.

Open Excel**, enter the label (company's name) in the first line, enter the address (the company's detailed address) in the second line, enter the company's (** and fax) in the third line, enter the fourth line (statement), enter the fifth line (customer, month, print date), hold down the "Ctrl" key in the keyboard, select the area [A1:H1,A2:H2,A3:H3,A4:H4,A5:H5], click the [Merge and Center] button key in the menu bar, Select the region [A6:H18], click the [Border] button key in the menu bar, select [All Borders], enter [Date, Delivery Note Number, Name and Specification, Unit, Quantity, Unit Price (Yuan), Amount (Yuan), Remarks] in **, after entering, press and hold the "Ctrl" key in the keyboard, select the region [A18:C18,D18:G18], click the [Merge and Center] button in the menu bar, and enter " in the merged cells respectively The total amount of this month's payment (RMB) and RMB symbol", and indicate the above matters below, account name (the name of the company's payee), Agricultural Bank account number, **business confirmation, customer confirmation, and finally adjust the font size and format according to the content OK. When making a statement, you can take a seat according to the delivery note number.

Buy a book about excel, or read it on the Internet, follow the steps and learn it step by step, there must be no problem.