Computer learning is complete ( 1st retention , le

deliberately deleted data revitalization

accidentally, delete the wrong, and also empty the Recycle Bin, the assumed ah?
at all times three steps, you can delete and blank the Recycle Bin back your material


steps:

1, click the Enter regedit (open registry)

2, expand: HEKEY--LOCAL--MACHIME/SOFTWARE/microsoft/WINDOWS / CURRENTVERSION / EXPLORER / DESKTOP / NAMESPACE outdoor the left margin click on
, select: Recycle Bin .


Perhaps you have had hundreds of Excel to complete the fiscal statements, maybe you have used Excel functions for complex operations a thousand times, perhaps you think that Excel also many, or even nothing new. However, we repeated countless times daily in convenient to use all the skills in Excel is just one per cent. Excel in the heading from some little-known tips to start, get a glimpse on the Excel Different customs.
one, so that different types of data using different colors
in the payroll, if you want more than equal to the aggregate wages of 2,000 yuan to greater than or equal to the absolute wages of 1,500 yuan,
1. Open the Click the second drop-down box on the right button, select the Click the
2. Click
3. setup is complete, press the
discern it payroll, payroll data namely not along to your request that come in different colors.

Second, a category drop-down list fraught with items
name of the business we often want to enter into the table, the name in order to preserve consistency, the use of
1. in Sheet2 in the name of the business by category (such as
2. Select A column (
modeled on the above operation, the B, C ... ... column named such as the C column), the implementation of In the Enterprise
need to enter the company label and then select the column (eg column D),Lacoste Arixia FD Trainers, and then open the C1), OKAY to exit.
4. Select any cell in column C (eg, C4), click the right side of the drop-down button, select the appropriate Then select the cell corresponding to the D column cell (eg D4), click the drop-down button to the appropriate category affair name from the list, select the name of the enterprise need to fill the cell.
Tip: When printing a report in the future, if you do not need to print the
Third, establish a
1. the space in the toolbar right click, choose In the
Click
2. then in the (common document), and modeled it for the operation of the above named (such as
repeat the above operations, multi-document list to add a few names.
3. Select the distribution Hyperlink By urgent the
repeat the above operation, the menu item and its corresponding workbook, the hyperlink documents together.
4. After the need to open the
Tip: Although we will
four, making
1. the implementation of the Select the .
modeled ashore the on operation, an by 1 to record a special sign of the input of other agreeable
2. Open the A work area in the toolbar.
switch to the How many buttons).
3. Select one of the
4. Right-click the button after a name, in the following the shortcut menu, select exit.
Repeat this step, the button to correlate with the corresponding macro.
5. close the
five, with
1. Open the worksheet to publish, use the mouse without the need to publish the row (alternatively col) marked haul, select them and then right click in the shortcut menu that appears, select , ambition not need to print the row (alternatively column) secluded.
2. implementation
3. the hidden rows (or columns) are displayed, and repeat the operation,
4. After the absence to publish a manner, open the , publishing what, on the toolbar click the
six,Womens Lacoste Arin Trainers, so that data on demand whether you want to sort
ministries where workers are sorted according to these sectors is not the name of the relevant message by both the Pinyin order, not by stroke order, how do? can be self- defined series order.
1. perform The team, a workshop, two workshops, 3 workshops,
2. Select the one of the drop-down button, select the just-defined sequence, by two
seven
the data sheet entirely hidden portion of the contents of the cell do not want to enabling guests to way, had it hidden.
1. selected to hide the contents of the cell (area), the implementation of
2. and then switch to the
3. the implementation of the
after this set after the contents of the cell is no longer shown, is to use Excel's traits can not be granted to remove the sky.
Tip:
eight, so in English and Chinese input usage emerged
smart editing chart, some cells to enter the English, and some cells to enter the Chinese input method is not convenient to alternate afresh, why not set and let intelligent input method to adapt it?
selected range of cells to enter the Chinese, the implementation of tab, reception the After the plebiscite
range of cells that need to input Chinese symbols in anyone cell, Chinese input method (IME list, the first a Chinese input method) automatically open, elected in the other cell, Chinese input method automatically closed.
nine, so that
1. the implementation of the
2. In the then click
3. If you need to enter this text in the future, simply enter
ten, a custom function in Excel, however the wealthy
Excel feature, yet it does not encounter all our needs. We can customize a function to act certain operations. Here, we define a reckoned from the trapezoid place function:
1. The implementation of the
2. In the window, execute
3. the right of the defined function to complete.
can later use the built-in function is the same as using a custom function.
Tip: Use the above methods defined in the corresponding function is usually only used in the workbook.
XI header following pictures
lining additional to the background of the worksheet is the lining in the whole worksheet below, can not only lined the first in the table below it?
1. execute → Background Worksheet
2. while holding down the Ctrl key, right in the picture without lining cells (area) in drag, and select those cells (area).
3. Click After this setting after, leaving the cell lining on the picture underneath, and the selected cell (area) not lining the picture beneath (in fact, is the picture to be
Tip? lining the picture bedefect in ... the cell does not patronize printing.
second, with a hyphen get it (it is presumed that the B, C, D columns into one column.)
1. in the D column, insert two empty columns (E, F array), and then enter the formula in cell D1: = B1 & C1 & D1.
2. D1 cells again selected, use the
3. Select the E series, the implementation of , press the
4. the B, C, D, E column erased, completion of the combination work.
Tip: Complete the steps from 1,2 combined achieve has been achieved, but at this time if you delete B, C, D series, the formula peccadillo. And thus should be carried out step 3, the formula is converted to the same Performance of Students


article
friends constantly inquire, For this attention, I give here a easy method secondhand to effect the function.
cached in student achievement is pretended here Sheet1 worksheet range of cells A1 to G64, which doing title 1, 2 acts subject name.
1. Switch to Sheet2 worksheet, select cell A1, enter the formula: = IF (MOD (ROW (), 3) = 0, , sheet1! Aū, INDEX (sheet1! $ A: $ G, INT (((ROW () +4) / 3) +1), COLUMN ())))。
2. once again select the cell A1 , with the > At this point, the basic shape results section, the following simple modified see.
3. adjust the row altitude and column breadth, the same selected range of cells A1 to G2 (No. 1 student finishing bar area), according to The retinue operation).
4. likewise selected range of cells A1 to G3, click on the To add a border all the results segment.
press the What more fitting function. Excel carton input requirements (such as narrated assist files, you can rapidly resolve the necessary function.
fifth, while viewing a different worksheet in the multiple cells of data
Sometimes we edit a worksheet (Sheet1), it is necessary View other work sheet (Sheet2, Sheet3 ... ...) the contents of a cell, you can use Excel's .
later, no matter in which the worksheet, simply open the > In before versions of Excel 2002 for the operation of a range of cells is also many trouble to add a border, Excel 2002 which features a new evolution.
Click the pull button, pop-up in the subsequent drop-down list, choose drop-down button, select a border style, and then in the range of cells you need to add drag and drop the frame, you can quickly draw the corresponding range of cells on the border.
Tip: ① If you draw the bad border, does not matter, on the toolbar select Color >

XVII Enter the text in characteristic cells controlling the length of
Can you assume when you enter the four digits of the cell was filled with a numeral,Womens Lacoste Trainers, or entering text in the cell number you have entered time, Excel will automatically determine, immediate inquiry and pop-up warning, then be pleasing ah! To achieve this function, the Excel, is also not tough.
example, we enrol the cursor to a the cell in order to enter the enumeration of the unified and easy, we wish that the Card advising annual. manner time distance,
We kas long aseach time you open Excel, the software is all turned on by default multiple sheets. Thus we can see that Excel has a muscular appending to the processing power of unattached forms, more appropriate for multiple interrelated coordination table . to coordinate the coalition, of course, first need to sync input. Therefore, in numerous cases, will need more than one table simultaneously in the same cell type the same content.
So how do you edit a group of tables? First We click the first worksheet tab name ). At this point, we see the name of the title bar of Excel, a What, we found that change the format of how to do? First, we must change the data format of the premier table, and then click the period,Lacoste Trainers 2011, Excel will pop up IX, change the txt in the circumstance of
in Excel for form processing and data computing support is not the maximum mighty formula, nor is the database, but function. Do not consider that Excel, the function only for mathematics, in fact, at all times written into the contents of the table, Excel has a special function to edit it. such as changing the text of the case.
in Excel 2002, provide at least three of the text case conversion function. They are: UPPER (source data grid), case, such as getting the first letter of every word is capitalized. For example, we have a form of cell A1 enter the lowercase the result the automobile will be will be the method save distress, especially fhardly everme of the information primarily alike style, such as staff lists, place of origin and other information.
quickly if we want to extract the cells from A4 title, it is best to use to extract the number of characters) grid, the number of characters extracted) words, only in the target cell to enter and 5 words.
the twenty-first, into the pedestal ordinal number words to English words into ordinal base is a more intricate problem. for it is not a very fixed pattern: Most of the figures into ordinal number is used in the Moreover, function, just write a formula that can be lightly converted. do not trust, see: IF (OR (VALUE (RIGHT (A2)) = 1,2,3,, CHOOSE (RIGHT (A2), Despite the long list, but the meaning is very clear: ① If the number is to main and ordinal conversion words so simple and quick implementation.
XXII, filled with special symbols and financial dealings with the median
human know, when filling in the paperback there is a accustomed Safety Fill Law The elementary format is the formula to should be changed to REPT (brain paired with # # 0.00 worksheet consisting of plain text to create the histogram. It is also very simple principle, that is, the beautiful use of special symbols continual according to a specified cell showing the results of the relative effectiveness of different lengths.
example, we first Annual making of a balance sheet, and then The results have been ROUND (D3 * 100,0 )),> circular to calculate the total number of words in the cell
Sometimes, we may have the character of a cell in the number of interested need to calculate the total number of words in the cell. To solve this problem, in addition to using the SUBSTITUTE > is to use Finally, the number of spaces +1 to draw the number of characters in the cell was.
XXV, the euro transition
This is a fashionable tool in Excel 2002. If you choose to install the Excel 2002 is the default, then it may not be in the . with the Excel window, the other functions, we can set the money conversion mouse equality EU list of other currencies. Of course, in array to display the euro is more professional, we can also click on the Excel toolbar, the p>


to redo the computer system, study their own, can cost fewer money, ha ha [chart]

one,Lacoste Shoes, ready to work:
how to reinstall the computer system
First, start the computer when holding down the DELETE opener to enter BIOS, select Advanced BIOS Features discretion, and reception the Enter key to enter install. Select First Boot Device option, then press the keyboard Page Up or Page Down key to set the CD-ROM, so you can start the system to the record.
Second, the return to the chief menu, save the BIOS settings. (Preservation method is to press F10, then press Y button)
1. Prepared to simplified Chinese version of Windows XP Professional installation CD, and check the drive is supported from the start.
2. possible, ahead escaping the installer with all the hard disk to scan the hard disk error checking and repair, or install the program is running, such as checking that there is an error that will be hard very perplexing.
3. file with the paper records the product key to install (installation serial number).
4. feasible, with the driver backup tool (such as: Driver Genius 2004 V1.9 Beta.exe) all beneath the aboriginal Windows XP driver export to disk ( such as: F: Drive). Best to note the motherboard, network card, video card type and other important hardware manufacturers, pre-download the driver as use.
5. If you ambition to format the C drive during the installation or the D steer (recommended format the C pedal during installation), behind up the C drive or D drive profitable data.
Second, start the system with a CD-ROM:
(if you yet know the way, work to the next step), reboot the system and the CD-ROM set First boot disk, save the settings and reboot. The XP installation CD into the drive, restart the computer. Just started, as shown when there is press the Enter key when the fast, otherwise the system can not shoe XP CD. If you do not know the specific practices, please refer to the same with this -> how to get into pure DOS system:
CD-ROM from the start, if no chance to see the installation screen will appear as shown in Figure 1
;
View Original
prompted all Chinese, View original
license agreement, there is not alternative, according to partition, format the C drive if you have select the C section, select a good partition and press format, which become the file system format, or save an existing file system, a kind of alternative, but note that the NTFS format to save disk space, amend security and dilute disk fragmentation but there are many problems and MacOS 98/Me can not see the NTFS partition, here, choose Figure
alarm format C drive, press the F key will be ready to format the c drive, there is shown in Figure 6 under the original


view of the selected partition C space than 2048M ( or 2G), FAT file system does not support more than 2048M of the disk partition, so the installer will use the FAT32 file system format to format C drive, press the br> View original image in Figure 7 is formatted C partition; only start with the CD or install XP Setup boot floppy disks to provide during the installation process format the partition option; If you use MS-DOS boot disk into DOS, run i386 winnt to install XP,Lacoste Radiate Croc Trainers, install the XP partition without formatting options. Format C partition is completed, there is shown in Figure 8 under the original


see Figure 8 to begin copying file, duplicate the file after the installation program begins to initialize Windows configuration. and then the system will automatically restart in 15 seconds. restarts, there is shown in Figure 9 under the original


View 9

View Original
than 5 minutes later, when the prompt appears when needed 33 minutes emulating diagram 10

View Original
local and language settings to use the default amount can be a direct point of the Next step this password, Administrator System Administrator has the highest authority in the system, ordinarily landing system does not necessitate the list. Then click , prefer Beijing, click Original
allows you to choose the manner used by the network installation, select a typical set point
View Original
continue the installation, here after do not you partake in, the installation procedure will automatically complete the entire process. automatically restart behind the installation is complete, the splash shade appears, as Figure 19

View Original
first start takes a long time, amuse be patient, followed by the greet screen, set the system prompt, as shown 20

View Original
press the bottom right edge of the
View Original
here to create a broadband dial-up connection, not dial-up connection on the desktop shortcut, and dial-up connection the default name Wizard to create a broadband dial-up connection, dial-up connection on the desktop shortcut, and the default dial-up connection named button.
here I first create a broadband connection, select the first

View Original
Telecom or China Unicom are currently using (ADSL) Residential users have accounts and passwords, so I chose , as shown in Figure 23

View Original
Telecom or China Unicom to provide input account and password in the The name of the menu, and if left empty the system will automatically establish a file phoned the dial-up connection, Microsoft certainly want you to stimulate XP you, but even if there does not activate the 30-day trial duration, why the hurry? choose Figure 25 shows

View Original
you normally enter a user name to login the computer, click the Next button appears as shown below 26

View Original
Click Finish to complete the installation. the system will record off and log a new user. landing desktop as below 27

View Original
six, and ascertain common icons
; on the desktop start -> interlock to -> broadband connection, as shown 32

View original
left point Office on the desktop can be seen more than a the open display the bottom left of the diagram click on the My Network Places