How to use Relative, Absolute, and Mixed References in Excel

You use a cell reference when you want to capture information that is contained within another cell or range of cells. For example, the following formula references cells A1 and A2, and will add their contents together to produce a result.

=SUM(A1+A2)

You can use the following types of cell references to achieve specific outcomes:

  • By default, references in Excel are relative, which refers to the relative position of the cell. If you are typing a formula in cell A1 that involves cell A2, you are referencing the cell that is one cell below where you are typing. If you were to copy the formula into another cell, the reference would automatically perform the same relative action as in its previous location.
  • You can also use an absolute reference, which does not change if you copy the formula into another cell. If you create a formula that refers to a cell using an absolute reference, that same cell will be referred to wherever the formula is used.
  • Finally, you can use a mixed reference, which is a combination of the two.
    Let’s look into these in more detail.
[mai mult...]

How to disable an unknown AirTag

If you see an “AirTag Found Moving With You” message on your iOS device, you can simply dismiss it as you normally would or, preferably, disable the unknown AirTag altogether.

  1. When you see a notification on the display of your iPhone, iPad, or iPod touch, saying “AirTag Found Moving With You,” tap the notification.
  2. Now choose Continue.
  3. To disable the AirTag, tap Instructions to Disable AirTag, and follow the onscreen steps.

You can also hit the Play Sound option if you don’t know where the AirTag is located.

A screenshot of the Apple Find MY app showing the safety options when an unknown AirTag is detected

Basically, you’ll be instructed to reset the AirTag to its factory by removing its battery:

  1. Press down on the AirTag’s polished stainless steel battery cover, then rotate counterclockwise until the cover stops rotating.
  2. Remove the battery cover along with the battery itself.
  3. Now replace the battery.
  4. Press down on the battery until you hear a sound.
  5. When the sound finishes, repeat the process four more times: remove and replace the battery, then press down on the battery until you hear a sound. You should hear a sound each time you push the battery down, for a total of five sounds.
  6. Replace the battery cover by aligning its three tabs with the AirTag’s three slots.
  7. Press down on the cover until you hear a sound.
  8. Rotate the cover clockwise until it stops rotating.

Doing so will disable the AirTag and prevent sharing your location. Don’t forget that a single AirTag can be associated with one Apple ID. If the previous user removed the AirTag from their Apple ID but was out of the device’s Bluetooth range, resetting it will let you re-use it with your devices.

[mai mult...]