There is another method to use the DGET function. The other method is to click the fx button on top of the worksheet. A Select Function dialog box will pop up.

But it’s also possible to set up the Touch Bar so it always shows the function keys in those apps. To do this, open Keyboard System Preferences, select Function Keys, and tap +.

Now users can select which function users can activate using the Camera Control button between the Camera app, QR code scanner, and Magnifier app. Now, simply select the QR code function.

Fortunately, it’s easy to change the power button’s function, which can be programmed to make the laptop sleep, shut down, or hibernate. Here’s how Vista users can make the change: ...

Tap Add Shortcut. Now, open the Settings app and tap Action Button. Swipe to the Shortcut option. Tap the selection button below "Shortcut" and select MultiButton. Now, long press the Action button.