# Archive List for October 2017

## Line feed code/CHAR(10), replace・delete, CHAR function

Insert a new line in cells (Using a code) To insert a new line in Excel, we can add a text called ‘line feed code = CHAR (10)’. Let us review this line feed code first. → For more information on the CHAR function, click here   Example of use) Insert a new line using・・・

## How to create graphs (rotate row/column, grid lines, 2 axis…)

Create a bar graph In Excel, not only can we keep and calculate data, but we can also create graphs very simply. Let us look at how to create graphs, starting with the most simple, bar graphs. Example of use) How to create a bar graph The table below shows the number of stationary (HB・・・

## 【Practice question】Sum up values that meet a condition_

Practice question 1/Sum up cells that includes a specific text 【Practice question 1 : Question】 The table below shows the number of employees in each office. In each region, there is a department that supervises the offices (branches) named the ‘supervisory’ department. Calculate the number of employees in the ‘supervisory’ department. The total number of・・・

## 【Practice questions】Count data with conditions (empty, full, other than～, duplication）

Practice question 1/Count cells that meet a condition/Empty, full cells 【Practice question 1 : Question】 Below is a business trip schedule of the Sales manager. It shows the location of the trip and if the tickets for transportation are arranged. 1. Calculate the number of trips in which the tickets are arranged. 2. Calculate the number・・・