Consolidate

Using the Excel merge feature you can combine worksheets in one workbook or workbooks into one worksheet. You can find workbooks for the three districts below.

Before you begin: If the worksheets are the same, it may be easier to create a 3D reference (if you have a workbook) or an external reference (if you have multiple workbooks) and merge the data.

As you can see, the worksheets are not exactly the same. However, the advantage of the integration feature is that you can easily summarize, count, average, and so on with this tabular data. This is much easier than creating expressions.

Note: If you do not select Top row and Left column, Excel sums all cells in the same position. For example, cell B2 (in distric1.xlsx) + cell B2 (in district2.xlsx) + cell B2 (in district3.xlsx). Because the worksheets are different, have Excel sum the cells with the same label. If [Create Source Data Link] is checked, Excel creates a link to the source data (if the source data is changed, merge data is updated) and creates an outline.

(1) Number of consolidated subsidiaries The names of major consolidated subsidiaries of 25 companies are described in the form of "A", so the description is omitted. Company overview, 3. As a result of the merger with subsidiaries and affiliates, NERD Inc. merged with Nintendo Technology Development Inc., a surviving company, during the consolidated fiscal year ended March 31, 2017. The above subsidiaries are accounted for in accordance with the financial statements of the subsidiaries' closing dates due to the difference in deadlines within three months. We will make necessary adjustments to the consolidated financial statements to reflect significant transactions between the closing date and the consolidated closing date.

We conducted our audit and expressed our opinion on the consolidated financial statements as a whole. The consolidation schedule (described on pages 18 to 19) is intended to provide additional analysis of the consolidated financial statements and is not part of the necessary consolidated financial statements, but rather the financial position, net assets and cash flows of various affiliates It does not aim to show the variation of . Such information is management's responsibility, derived from the underlying accounting and other records used to prepare consolidated financial statements, and is directly related to them. We believe this information relates to the consolidated financial statements in all material respects.

The preparation of the consolidated financial statements and the notes to the consolidated financial statements in this annual report are based on estimates that affect the reported assets, liabilities, sales and expenses and the related disclosures of contingent assets and liabilities . We base these estimates based on historical experience and various other assumptions that we believe to be reasonable and they provide a basis for estimating the carrying value of assets and liabilities that are not available to all other sources Form. Actual results may differ from these estimates.