Current location - Training Enrollment Network - Mathematics courses - How to do the simplest calculation with Excel spreadsheet
How to do the simplest calculation with Excel spreadsheet
Type data A in column A, type data corresponding to column A in column B for calculation, and if there are third and fourth data, it is in column C, and so on. For example, to calculate 5 times 6, A 1 input 5 B 1 input 6.

Enter data in column A and column B in turn, as shown in the figure below.

Move the cursor to C 1, as shown.

Enter =A 1*B 1 in the calculation column (the symbol in the middle is the operation symbol). We have to calculate multiplication, so we play multiplication symbols (addition, subtraction, multiplication, Divison symbol on the keyboard).

Press enter to exit.

Place the cursor in the lower right corner of C 1. When the cursor changes to a black cross, press the left key and drag it down.

After several operations, it will be very convenient after proficiency.