Table processing software Excel 2003 exercises

First of all, I'm not quite right, it's not jargon, but maybe it will help you a little.

It is a very useful software for processing data, it is a part of Microsoft Office software, which is very practical and effective in daily office, especially like finance, statistics and so on.

2.A worksheet is made up of cells, one or more worksheets make up a workbook, and excel file is a general term.

The data types are text, value, currency, time, and so on.

4.Left-clicking in a workbook should be the quickest way to select a worksheet.

5.If there are few worksheet labels, of course, all can be displayed, if there are multiple worksheet labels, it is difficult to display them all, of course, it can be achieved with a dot method, 6There are relative references, absolute references, and mixed citations.

7.It is the addition of the values in cell C2 in Tab Sheet3 + Cell C8 in Tab Sheet4 + Cell A4 in Tab Transcript.

8.Hold down Ctrl and click on the cell you want to select.

9.Click on the menu, insert - chart, and you can insert the chart.

10.Pivot tables are interactive reports that quickly combine and compare large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the breakdown of the area of interest (as explained in the Excel Help).

11.The purge of a cell is to delete the contents of the cell, but like formatting, etc. are not cleared (if the cell is set to yellow, this color will not be cleared), the deletion of a cell is to delete the entire cell, including everything in the cell (including the cell color).

12.Click on the settings in the print preview and adjust it to 1 page width and 1 page height in the appearance zoom.

There are too many, it's hard to do, and there's no time to get it.

The formula for calculating the number of people who fail the total score: =countif(e:e,"<60"The formula for calculating the number of students with a total score of 60-80:

countif（e:e,"<80")-countif（e:e,"<60")

The formula for calculating the number of people with a total score of 80-90 points: =countif(e:e,"<90")-countif（e:e,"<80")

The formula for calculating the number of people with a total score of 90-100 points: =countif(e:e,"<=100")-countif（e:e,"<90")

When expressing a negative value in finance, it is also often used to bracket this number, indicating that it is a negative value, that is, it is displayed as "8" or "(8)" to indicate the same meaning, which is a negative number, depending on personal habits.

As for how negative numbers are displayed, it is artificially set. Right-click -- set cell format -- number -- numeric value -- format -- display mode negative number form can be selected - if you select one with (), enter -8 to display it as (8); If you select -8 directly, the -8 input will still show -8. The above is a numerical display under the premise that the decimal place option is 0.

If you want to keep the decimal places, there is also the option to keep a few digits. If 2 decimal places are kept, then -8 is entered, which can be displayed in the form (; Keep 1 decimal place, which can be displayed as (;.).And so on.

Therefore, depending on the format setting, the display form is also diverse. Try it yourself.

Then the original answer that "False" is correct.

If you enter the information without quotation marks, you are right.

If the information entered is in quotation marks, the answer is correct.

One. True/False.

Data stored in Chinese form cannot be used for numerical calculations, but it can be compared in size (wrong).

2.By default, typing "11:12" into a cell can be recognized by Excel as "0:11:12 seconds" (false).

3.By default, the worksheet is protected and the user can select cells (pairs).

Two. Fill-in-the-blank questions.

1.By default, enter 6 31 in the cell, the cell will recognize the input data as (date) type, and display it as (June 31);

2.In the custom sequence, for numeric data, Excel will drag and drop the data as (copy and fill) mode; For textual data (including numeric text) and date-based data, Excel will drag and drop (sequential filling) method;

3.In Excel, if you want to convert numeric data of multiple cells to text type at the same time, you can use the (Text function to text) method.

First, it is correct, and the size can be compared.

Error, it's 11:12:00.

Error, after protecting the worksheet, the user cannot select the cell.

II. Types of Text, 6 31

Copying, filling (checked, it's different from my own understanding) using the text function (this problem can't be found).

True, False, False, Date, June 31, 2013, Copy, Fill, Paste Special.