Very complete computer knowledge (first save, leav
Filed Under (Uncategorized) by admin on 24-07-2010
Tagged Under : burberry bags, discount coach, jimmy choo sto
wrong
accidentally deleted data recovery, deleted wrong and brought empty the Recycle Bin, Zaban ah?
as long as three steps, you can delete and empty the Recycle Bin to recover your things
steps:
1, click the \Enter regedit (open registry)
2, followed by start: HEKEY–LOCAL–MACHIME/SOFTWARE/microsoft/WINDOWS / CURRENTVERSION / EXPLORER / DESKTOP / NAMESPACE left blank outer click on the \
, select: \Recycle Bin \.
to redo the computer system, learn their own, can spend less money, ha ha [map]
1, the preparatory work:
how to reinstall the computer system
First, start the computer while holding down the DELETE key to enter BIOS,discount coach handbags, select Advanced BIOS Features option, press the Enter key to enter setup. Select First Boot Device option, then press the keyboard’s Page Up or Page Down key will be the setting for the CD-ROM, so that you can boot the system to CD.
Second, the return to the main menu, save the BIOS settings. (Save is by pressing F10, then press the Y button)
1. Ready for Simplified Chinese version of Windows XP Professional installation CD-ROM drive and check whether the support from the start.
2. possible, before running the installer with all the hard disk to scan your hard disk error checking and repair, or install the program runs as a hard disk error checking to the Council very troublesome.
3. using paper records document the product key to install (installation serial number).
4. possible, with the driver backup tool (such as: Driver Wizard 2004 V1.9 Beta.exe) under the original Windows XP backup all the drivers to the hard disk ( such as: F: Drive). Best to record motherboard, network card, graphics card type and other major hardware manufacturers, pre-backup to download the driver.
5. If you want to format the C drive during the installation or the D drive (recommended install process to format C drive), back up the C drive or D drive useful data.
Second, start the system with a CD-ROM:
(if you already know that method, go to the next step), reboot the system and the CD-ROM Set First boot disk, save the settings and restart. The XP CD into the drive, restart the computer. Just started, when there is rapid as shown when pressing the Enter key, or else the system can not boot XP installation CD. If you do not know the specific practices, please refer to the same with this -> how to enter the pure DOS system:
CD from the start, if no accident you can see the installation screen will appear as shown in Figure 1
;
View Original
all Chinese prompt, \View Original
license agreement, where there is no choice, press \partition, format the C drive if you have select the C partition, select a good partition and press \format, thereby converting the file system format, or save an existing file system, there are several choices, but note that NTFS 格式 Ke save disk space for increased safety and Jian Xiao Tong Shi disk fragmentation, but there are many problems and MacOS 98/Me can not see under the NTFS partition, the election here, \Figure
warning formatted C drive, press the F key will be ready to format the c drive, appear as shown in Figure 6
View Original
as the selected partition C space is greater than 2048M ( or 2G), FAT file system does not support more than 2048M of the disk partition, so the installer will use FAT32 file system format to format drive C, press \br> View original image Figure 7 is formatted C partition; only start with the CD or install XP Setup boot floppy to format the partition during the installation options available; If you use MS-DOS boot disk into DOS, run i386 \ winnt to install XP, install the XP partition without formatting options. formatted C partition is completed, the next appears as shown in Figure 8
View Original
Figure 8 to begin copying file, the file copy finished, the installation program starts to initialize Windows configuration. and then the system will automatically restart in 15 seconds. restarts, appears as shown in Figure 9 under
View Original
9
View Original
than 5 minutes after 33 minutes when you are prompted when needed as below 10
View Original
regional and language settings to use the default value can be a direct point of the \Next \step \this password, Administrator System Administrator has the highest authority in the system, usually do not need the account login system. and then point \, choose Beijing, point the \Original
allows you to select the network installation method used,asics gel stratus 2.1 Shoes, select a typical set point \
View Original
continue the installation, not after you here involved, the installation program will automatically complete the whole process. automatically restart after the installation is complete, a startup screen, as Figure 19
View Original
first start takes a long time, please be patient, followed by the Welcome screen, set the system prompt, as Figure 20
View Original
click on the bottom right corner of the \\
View Original
here to set up broadband dial-up connection, not dial-up connection on the desktop shortcut, and dial-up connection the default name \broadband dial-up connection set up wizard, the desktop creates a shortcut dial-up connection, dial-up connection and the default name of \button.
where I first create a broadband connection, select the first \
View Original
Telecom or China Unicom are using (ADSL) for residential users have the username and password, so I choose \, as shown in Figure 23
View Original
enter telecommunications or Unicom to provide the account number and password in the \the name of the menu, if left blank the system will automatically create a file called \the dial-up connection, Microsoft, of course, XP is activated to your friends now, but Jishi 不 activation also a 30-day trial period, You then why anxious? 选择 \Figure 25 shows
View Original
you normally enter a user name to login the computer, point the next step as below 26
View Original
Click Finish, the end of the installation. the system will log off and log a new user. Sign your desktop as Figure 27
View Original
6 and find the common icons
; on the desktop points to Start -> Connect to -> broadband connection, as Figure 32
View Original
left point \area, which could see the desktop more than a \the open display \bottom left of the graph click on \My Network Places \
Perhaps you have had hundreds of Excel to complete the financial statements, perhaps you have been using Excel functions to achieve thousands of complex calculations, you probably think the same about Excel, or even nothing new. But we repeated many times daily in handy to use only one per cent of Excel all skills. The topic from the Excel skills of some of the little-known start to enjoy the look of Excel Different customs.
one, so that different types of data using different colors
in the payroll, if you want more than equal to the total wage of 2,000 yuan to \greater than or equal to the total wages of 1,500 yuan, \
1. Open the \Click the second box to the right of the drop-down button, select the \Click the \
2. press \
3. set is complete, press the \
see it payroll, payroll data is not in accordance with your request in a different color is displayed.
Second, a category drop-down list filled with items
we often want to enter the business name to form, in order to maintain the name of consistency, use of \
1. in Sheet2 in the Company Name by category (such as \
2. Select A column (\
follow the above operation, the B, C … … column named \If C out), the implementation of \In the \Enterprise \
then need to enter the business name of the selected column (eg column D), and then open the \C1), OK to exit.
4. Select any cell in column C (eg, C4), click the right side of the drop-down button, select the \Then select the cell corresponding column D cell (such as D4), click the drop-down button to the appropriate category business name from the list select the Company Name enter the cell.
Tip: print the report at a later time, if not print the \
Third, establish a \
1. Right-click on blank space in the toolbar, select \In the \
Click \
2. and then in the \(common document), and modeled it for the operation of the above named (such as \
repeat the above operation, add a few more documents list name.
3. Select the \distribution Hyperlink \By pressing the \
repeat the above operation, the menu item and its corresponding workbook and hyperlink documents together.
4. After the need to open the \
Tip: Although we will \\
4,keen targhee ii shoes, making \
1. implementation of the \\Select the \.
follow the above operation, 11 special symbols to record the input of other good \
2. open the \appear in the workspace of a toolbar.
switch to the \How many buttons).
3. select one of the \
4. Right-click the button after a name in the following pop-up shortcut menu, select \exit.
Repeat this step, the button to link with the corresponding macro.
5. close the \
five, with \
1. Open the need to print a worksheet, use the mouse without the need to print the row (or column) marked drag, select them and then right click in the resulting shortcut menu, select \, will not need to print the row (or column) hidden.
2. implementation of the \\
3. the hidden rows (or columns) are displayed, and repeat the operation, \
4. 以后 need to print Mouzhong form, open the \, layout click, click on the toolbar’s \
6, so that data on demand sort
staff if you want to sort according to your department, the name of both of these sectors in accordance with the relevant information is not phonetic order, nor the order by stroke, how do? can use self- defined sort sequence.
1. implementation of the \team, a workshop, two workshops, three workshops, \
2. select the \One of the drop-down button, select the just-defined sequence, by two \
7, the data sheet completely hidden part
cell contents do not want to enabling visitors to access, had it hidden.
1. selected to hide the contents of the cell (area), implementation of the \\
2. and then switch to the \
3. implementation of the \
after this set after the contents of the cell are no longer displayed, is the use of Excel’s features can not be allowed to borrow this transparent.
Tip: In the \
8, so in English and Chinese input method appeared
intelligent editing table, some cells to enter the English, and some cells to enter the Chinese repeatedly to switch input method is inconvenient, why not Set a bit and let it automatically adjust input?
selected range of cells to enter the Chinese, the implementation of \tab, click \
later elected to the range of cells that need to input Chinese characters in any one cell, the Chinese input method (IME list, the first a Chinese input method) automatically open, elected in the other cell, the Chinese input method automatically Close.
9, so that \
1. implementation of the \
2. In the \then click \
3. If you need to enter the text later, just enter \
10, a custom function in Excel,
Excel function, though rich, but it does not meet all our needs. We can customize a function to accomplish some specific operations. Here, we define a calculation from the trapezoid area function:
1. Implementation of the \
2. In the window, the implementation of the \
3. in the right \defined function to complete.
can later use the same function as using the built-in custom functions.
Tip: Use the above method of self-defined function is usually only used in the corresponding workbook.
11, table header contrast images
following worksheet to add to the background, is the lining in the whole work sheet below, can not only lined the first in the table below it?
1. implementation of the \Worksheet → Background \
2. While holding down the Ctrl key while using the mouse in the picture without lining cells (area) in drag, and select those cells (area).
3. click \After this set after leaving the cell lining on the picture below, but the selected cell (area) below no contrast image of the (in fact, is the picture being \
tips? lining in the cell does not support the following picture is printed.
12, with a hyphen \get it done (here assumed that the B, C, D out into a column).
1. in the D column, insert two empty columns (E, F series), 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. to B, C, D, E series removed, the completion of the merger work.
Tip: Complete step 1,2-operation, combined effect has been achieved, but at this time if you delete B, C, D series, the formula error. Therefore, to carry out step 3, the formula is converted to the same \Performance of Students
article
Friends often ask \For this consideration, I would like to use function gives a simple method to achieve.
here assumes that student achievement save in the Sheet1 worksheet range of cells A1 to G64, which act 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. again select cell A1 using the \> Thus, the results basic shape, the following simple modification look.
3. adjust the row height and column width, the same selected range of cells A1 to G2 (1 results section area students), according to \\The following).
4. also selected range of cells A1 to G3, click on the \Add articles results for all of the border.
click \What function is more appropriate. Excel’s \box input requirements (such as \related help files, you can quickly determine the required function.
15, view different worksheet within multiple cells of data
Sometimes we edit a worksheet (Sheet1), the need to View other work in the table (Sheet2, Sheet3 … …) the contents of a cell, you can use Excel’s \\.
later, no matter in which the work table, simply open the \> In previous versions of Excel 2002, add border operations for the range of cells is too much trouble, Excel 2002 This feature has a new expansion.
Click the \pull button, pop-up in the subsequent drop-down list, choose \drop-down button, select a kind of border styles, and then in the range of cells you need to add border in drag, you can quickly draw the corresponding range of cells on the border.
Tip: ① If you draw the wrong frame, does not matter on the toolbar to select \Color \>
17, Enter the text control specific cell length
you can imagine when you enter the four digits of the cell was filled with a digit, or enter text in the cell number you have entered time, Excel will automatically determine the immediate analysis and pop-up warning, it nice to ah! To achieve this function, Excel is,jimmy choo store, it is not difficult.
example, we position the cursor to a register \the cell, in order to enter the unity and computing convenience, we hope that the \Card \warning \the year. \style \time distance, \
we know that each time you open Excel, the software is always the default to open multiple sheets. From this we can see that Excel has a powerful leaflets in addition to the form of processing power, more suitable for multiple interrelated forms of co-ordination work . to coordinate related, of course, first need to synchronization input. Therefore, in many cases, will need more than one form simultaneously in the same cell type the same content.
form then how to edit it in groups? first We click the first worksheet tab name \). At this point, we see the name of the Excel title bar to a \What we found, \change the format of how to do? First of all, we have to change the first table of data format, and then click the \time, Excel will pop up, \9, change the text of the case
in Excel, the form processing and data computing support to provide the most powerful formula is not, nor is the database, but the function. Do not think that Excel, the function only for the figure, as long as they write 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 relevant text case conversion function. They are: \UPPER (source data grid), \case, as to the first letter of each word is capitalized and so on. For example, on a table cell A1 enter lower case \The results obtained after vehicle will be \will be \entirely easy, particularly with similar information on some styles even more so, such as staff lists, country of origin and other information.
fast if we want to extract from the title cell A4, then best to use the \extract the number of characters) \lattice, the number of characters extracted) \word, they only need to enter the target cell \and 5 words.
21, the base sequence numerals to words into English words into ordinal base is a more complex problem. because it does not have a very fixed pattern: most of the figures Numerals are used in order to become the \Moreover, the \function, just write a formula that can be easily converted. do not believe it, 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 \base words and numerals in order to achieve the transformation was so easy and fast.
22, padded with special symbols and financial dealings with the median
people know,burberry bags, when filling in the book there is a convention, \Safety Fill Law, \The basic format is \formula to \be changed to \REPT (\head with \# # 0.00 \worksheet to create a histogram from the plain text form. It is also very simple principle that smart to repeat the use of special symbols, according to a specified cell results demonstrate the comparative effectiveness of different lengths.
Biru we first Annual production of a balance sheet, and then \The results have been \ROUND (D3 * 100,0 )),\> 24, calculate the total cell number of words
Sometimes, we may be a cell of interest in the number of characters, need to calculate the total cell number of words. To solve this problem, in addition to using \SUBSTITUTE \> \first use \Finally, the number of spaces + 1, we arrive at the number of characters in a cell has.
25, on the euro conversion
This is a new tool in Excel 2002. If you choose to install the Excel 2002 is the default, then it may not be in the \\. and the Excel window, the other functions, we can set the currency conversion mouse \EU Member States a list of comparative prices in other currencies. Of course, in order to display the euro is more professional, we also can click on the Excel toolbar, the \p>