A04 Create Formulas with Quick Formula 1:31

prev < Numbers ’09 > next

1
00:00:01,134 --> 00:00:02,802
Create formulas with Quick Formula

2
00:00:02,802 --> 00:00:04,771
You can have Numbers automatically perform

3
00:00:04,771 --> 00:00:06,806
common calculations on cells values,

4
00:00:06,806 --> 00:00:08,942
then display the calculations results

5
00:00:08,942 --> 00:00:10,343
in your spreadsheet.

6
00:00:10,343 --> 00:00:13,046
To display the average of all values in a column

7
00:00:13,046 --> 00:00:14,981
first select the entire column

8
00:00:14,981 --> 00:00:17,384
by clicking on its references tab

9
00:00:17,384 --> 00:00:20,153
then in the toolbar click on a "Function" button

10
00:00:20,153 --> 00:00:22,489
and then choose "Average".

11
00:00:22,489 --> 00:00:24,324
The average of that column values

12
00:00:24,324 --> 00:00:26,659
would then appear at the bottom of the column.

13
00:00:26,659 --> 00:00:29,229
If your table doesn't already have a foot row

14
00:00:29,229 --> 00:00:31,064
Numbers will create one for you.

15
00:00:32,198 --> 00:00:35,368
To add values in two or more
adjacent cells in a row

16
00:00:35,368 --> 00:00:38,171
select the cells

17
00:00:38,171 --> 00:00:40,273
and choose "Sum" from the pop-up menu.

18
00:00:42,308 --> 00:00:44,511
The sum appears in the first empty cell

19
00:00:44,511 --> 00:00:47,113
to the right of the selected cells.

20
00:00:47,113 --> 00:00:51,017
To view an entire collections
of calculation results the same time

21
00:00:51,017 --> 00:00:53,686
select two or more cells

22
00:00:53,686 --> 00:00:56,189
in the lower left you'll se the sum,

23
00:00:56,189 --> 00:00:59,926
average, and other data related
to the cells you selected.

24
00:00:59,926 --> 00:01:01,661
The values update instantly

25
00:01:01,661 --> 00:01:03,930
as you add or remove different cells

26
00:01:03,930 --> 00:01:06,433
and you can command+click
on not adjacent cells

27
00:01:06,433 --> 00:01:08,468
to include them in your result.

28
00:01:08,468 --> 00:01:10,804
If you wanna display the result of a particular

29
00:01:10,804 --> 00:01:12,372
calculation in your table

30
00:01:12,372 --> 00:01:15,175
simply drag the calculation
to an empty table cell.

31
00:01:16,409 --> 00:01:18,845
The value in the cell update automatically

32
00:01:18,845 --> 00:01:21,714
whenever related cell value change.

33
00:01:21,748 --> 00:01:24,584
Using Instant Formulas for common calculations

34
00:01:24,584 --> 00:01:26,553
is here another simple way

35
00:01:26,553 --> 00:01:28,621
to build quick spreadsheet in Numbers.
All videos are copyright by Apple Inc.; transcriptions, subtitles and translations are volunteer efforts by members of this wiki.