1, the title is "required receipt/issue statistics", select 13 column A-M, center the merged cell, and then set the font size.
2, according to the ordinary A4 paper horizontally, the appropriate proportion is good. After entering 1 and 2, select the serial number cells of 1 and 2, and drag the mouse down to the lower right corner to automatically generate serial numbers, and drag as many serial numbers as you want (here we default to 3 1).
3. Continue to enter other title texts, names, specifications, models and units; Quantity and time; Quantity and warehousing date; Quantity and time; Finally, let's write a note. Positions ①-④ in the figure below need to be merged separately.
4. After merging the above cells, enter the text in four places: Start Inventory, Receipt, Issue and Actual Inventory. Continue to merge cells according to the position of ①-⑤ below.
5. After text input, we need to adjust the cell spacing and text size style. Select all the text except the title, and set the text style, font size, centering method, etc.
6. Then we adjust the style of the title, select the title cell, set the font size, bold and other styles to highlight the title.
7. Add the border line of the table, click any text part in the table with the mouse, press Ctrl+A to select all tables, or drag with the mouse. Find the top and bottom-Font Options Bar-Borders-All Borders.
8. After the setting is completed, let's print the preview and look at Ctrl+P, and set it to landscape. Then finally put it in storage, and the multimeter will do storage and inventory statistics.
Statistical tables are tables that reflect statistical information:
It is a form of reasonable description of statistical indicators, which makes statistical data organized, concise and clear, and is convenient for checking the integrity and accuracy of figures and comparative analysis. Formally, statistical tables are composed of titles, rows, columns, numbers and so on. From the content, it consists of two parts: subject and object language.
The main speech is the object to be explained in the statistical table, which consists of the names of the whole, the whole group and the whole unit. The target speech is the name and numerical data that explain the statistical index of the main speech.