3M MP220 Operation Guide - Page 117

Formula with Cell Reference: A1+A2, Inserting Functions and AutoSum

Page 117 highlights

3M™ Pocket Projector MP220 Formula with Cell Reference: A1+A2 1 Select a Cell where you want the results to appear. For this example, select cell A3. 2 Press the Touch Sensor and the onscreen keyboard opens. 3 Type = and press the Back button. 4 Press Menu and select Cell Reference. 5 Move the selector to the A1 cell and press Menu and then Enter. 6 Press Menu and select Operators. 7 Select + and press the Touch Sensor. 8 Press Menu and select Cell Reference. 9 Move the selector to the A2 cell and press Menu and then Enter. 10 Press Menu and then select Enter and the results will appear in the Cell. Inserting Functions and AutoSum 1 Select the cell where you want the results of the function or autosum to appear. 2 Press Menu and select Insert. 3 Select Function or Autosum. The Insert Function screen appears. © 2012 3M. All Rights Reserved. 117

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150

117
3M
Pocket Projector MP220
© 2012 3M. All Rights Reserved.
Formula with Cell Reference: A1+A2
1
Select a Cell where you want the results to appear. For this example, select
cell A3.
2
Press the Touch Sensor and the onscreen keyboard opens.
3
Type = and press the Back button.
4
Press Menu and select Cell Reference.
5
Move the selector to the A1 cell and press Menu and then Enter.
6
Press Menu and select Operators.
7
Select + and press the Touch Sensor.
8
Press Menu and select Cell Reference.
9
Move the selector to the A2 cell and press Menu and then Enter.
10
Press Menu and then select Enter and the results will appear in the Cell.
Inserting Functions and AutoSum
1
Select the cell where you want the results of the function or autosum to
appear.
2
Press Menu and select Insert.
3
Select Function or Autosum. The Insert Function screen appears.