OEG 14 Laboratory

Содержание и основные понятия

In a real job, an electronic table file is released. Here, the model reproduces key actions: imputation and sum, sorting, filter and diagram. After training, repeat the algorithm in Excel, LibreOffice Calc or P7-Office.
Grade 9
PIF · Big Data
OGE No. 14
01
School Fair Set
14
Table of 12 rows
Status Filter
Grade
Draft
Category
Sold
Price
A loan.
Status
02
Two calculations
A. How many projects are ready?
Pick a formula equivalent to a imputation of status.
Number of responses
B. Food grant
Use the category column as a term range, and the proceeds as a sum range.
Number of responses
03
Figure by category
▥
The Case — A Comparison of Categories
Why are the columns chosen?
Because the data goes over time.
Because separate categories are compared.
Because you always have to show the parts of the circle.
04
Transfer to real editor
download or open the original task file and don't change the column headings.
Add a calculation column only if it's allowed by condition.
Check the formula on one line manually, then copy.
For imputation, check both ranges and the criteria.
Select only the necessary signatures and values for the chart.
Keep it in format and under the name given by the organizer.
download XLSX set (120 lines)
Open Shet Studio