In its simplest form, the VLOOKUP function says: =VLOOKUP (What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE). Tip: The secret to VLOOKUP is to organize your data so that the value you look up (Fruit) is ...

Delete the selected item and move it to the Recycle Bin. Ctrl + R (or F5) Refresh the active window. Ctrl + Y. Redo an action. Ctrl + Right arrow. Move the cursor to the beginning of the next word. Ctrl + Left arrow. Move the cursor to the beginning of the previous word. Ctrl + Down arrow. Move the cursor to the beginning of the next paragraph ...

In Settings: Select Start > Settings > Bluetooth & devices , and then turn on Bluetooth . In quick settings: To find the quick setting for Bluetooth, select the Network, Sound, or Battery icons ( ) next to the time and date on the right side of your taskbar. Select Bluetooth to turn it on.

First, launch Windows Backup: select Start , type windows backup, and select Windows Backup from the results. (Or you can select Start > All apps > Windows Backup .) Then select Folders to drop it down, and select which of your user folders you want to back up to OneDrive: You can back up your Desktop, Documents, Pictures, Videos, and Music ...

To view them, right-click the desktop, select View, and then select Show desktop icons. To add icons to your desktop such as This PC, Recycle Bin and more: Select Start , open Settings , then under Personalization , select Themes . Under Themes, scroll down and select Desktop icon settings. Choose the icons you would like to have on your ...

Select the link for your model to get the latest firmware and drivers for sound, display, ethernet, and Wi-Fi. On the Download Center details page, select Download. If multiple downloads are available and you want to update your Surface with the latest drivers and firmware from the Download Center, select the .msi file name that matches your ...

Sign in to Office.com and go to OneDrive. Select My Files. Choose where you want to upload a file or folder. Select Upload > Files or Folders. Find what you want to upload and select Open . Or, you can select files or folders on your computer and drag them into the OneDrive web browser window.

On modern team sites and classic sites (subsites), in the left pane, select Recycle bin. On modern communication sites, select Site contents, and then select Recycle bin in the top navigation bar. If you don't see the Recycle Bin, follow these steps: Select Settings and then select Site settings. Note: If you don't see Site settings, select ...

Swipe in from the right edge of the screen, and then tap Search.Or, if you are using a mouse, point to the lower-right corner of the screen, and then click Search.Type Command Prompt in the Search box, right-click Command Prompt, and then click Run as administrator.If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.

Select the Restore deleted favorites icon in the top right corner of the Favorites menu. Right-click (or select and hold) the item or folder you want to recover, then select Restore . Important: You can only restore favorites that have been lost or deleted in the past 28 days. To restore all available deleted favorites, press Ctrl + A to select ...