Excel's powerful data manipulation capabilities

When I was on duty for my freshman year yesterday, I found myself unfamiliar with the basic Excel operations. For a long time I had no Excel operations. I have been programming for some time, I seem to have forgotten excel, but I often use word. I am much more familiar with word. So I found my shortcomings on duty, summarize and accumulate simple Excel operations.

How many questions are raised below? Check whether you can solve the problem?

We know the final exam scores of your class..

1. Determine who has the subject? 2. How many subjects are involved? 3. What is the ranking of each person?

Countif, if, and rank functions are used here.

Countif is used to calculate the number of cells that meet the given conditions in an area. The format of countif (range, criteria) is used, where range is the range of cells. You can select it by left-clicking the cell, criteria is the criterion.

Returns the ranking of a number in the number list. The ranking of a number is the ratio of its size to other values in the list (if the list has been sorted, the ranking of the number is its current position ).

In Excel, functions are divided into many types, including finance, date and time, mathematics and trigonometric functions, statistics, search and reference, database, text, logic, information, and engineering.

Over the past few days, I have been reading UML (Unified Modeling Language), which introduces Object-Oriented Technology. In Excel, its function implementation may also adopt object-oriented technology, each function is a specific method and an operation (operations ).

First, we can find out all the commonalities of functions as the mainclass. Then, we use the Inheritance (generation) to make the subclass inherit the features of the parent class, subclass also has its own special attributes and operations.

A function is a class. When we use this function, it will be instantiated. Of course, we can also customize functions, and inheritance will have good scalability.

Using this object-oriented technology seems to be able to implement function problems in Excel.

We are still at the beginner stage of using Excel. We still need to accumulate more than 1.1 points and make further efforts. We do not know much about many of its powerful table manipulation functions, let alone.

Continue to work! Love fight will win !!!