# Tests, issues and tasks in MS Excel

this section contains various examples, practical tests, the questions and tasks in Excel that are often found in schools and Universities (often in science lessons). All test tasks in Excel are gathered on the basis of Your questions and requests. If You have further control work on Excel, you can send to our mail for further discussion.

Most popular articles in this section

### Using Pivot Tables in MS EXCEL

this article provides a checklist of tasks on Pivot tables in MS EXCEL. The basis is the actual Control tasks, which  proposed to be solved in the Universities, colleges, schools and other educational institutions on the topic MS EXCEL. Guests can choose to practice and to use the solution given in the example file.

### Calculation of loan parameters (interest, payments, terms) in MS EXCEL

this article provides examples of calculating the parameters of the loan: interest rates, amounts, monthly payments, terms, etc. - For real Control tasks, which  proposed to be solved in the Universities, colleges, schools and other educational institutions on the topic MS EXCEL. Guests can choose to practice and to use the solution given in the example file.

### One-dimensional Array in EXCEL

this article is assignment on the topic of a one-Dimensional array MS EXCEL. The basis is the real Control task, which is proposed to solve computer science students studying for civil engineer. Guests can choose to practice and to use the solution given in the example file.

### Using Autofilter in MS EXCEL

this article provides a checklist of tasks on AutoFilter. The basis is the actual Control tasks, which  proposed to be solved in the Universities, colleges, schools and other educational institutions on the topic MS EXCEL. Guests can choose to practice and to use the solution given in the example file.

### Using Subtotals in MS EXCEL

this article provides a checklist of tasks on Intermediate Results. The basis is the actual Control tasks, which  proposed to be solved in the Universities, colleges, schools and other educational institutions on the topic MS EXCEL. Guests can choose to practice and to use the solution given in the example file.

### Consolidate feature in EXCEL

this article provides a checklist of tasks on Consolidation. The basis is the actual Control tasks, which  proposed to be solved in the Universities, colleges, schools and other educational institutions on the topic MS EXCEL. Guests can choose to practice and to use the solution given in the example file.

### Using Advanced Filter in MS EXCEL

this article provides a checklist of tasks on Advanced filter. The basis is the actual Control tasks, which  proposed to be solved in the Universities, colleges, schools and other educational institutions on the topic MS EXCEL. Guests can choose to practice and to use the solution given in the example file.