Cast to a display from a Windows PC. You can wirelessly connect your PC to a TV, projector, or other kind of external display that supports Miracast. Turn on your TV, projector, or other display. If you're using a Miracast dongle or adapter, make sure it's plugged in to the display.

You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

Find operating system info in Windows 11. To find out which version of Windows your device is running, press the Windows logo key + R, type winver in the Open box, and then select OK. Here’s how to learn more: Select Start > Settings > System > About . Open About settings.

While you can drag content between your phone and your PC, not all apps will accept content you want to transfer. If an app doesn’t accept your content, you can try using phone screen to transfer it instead. You can’t drag and drop files between your mobile apps from your PC.

The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.

A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you consolidate budget data from different departments in your organization.

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

How to enable TPM. If you need to enable TPM, these settings are managed via the UEFI BIOS (PC firmware) and vary based on your device. You can access these settings by choosing: Settings > Update & Security > Recovery > Restart now. From the next screen, choose Troubleshoot > Advanced options > UEFI Firmware Settings > Restart to make the changes.

Loop access via Microsoft 365 subscriptions. Certain features of Microsoft Loop are licensed and made available as part of different Microsoft 365 plans. Select your account type to learn more: The Loop apps for iOS, Android, and the web are available to anyone with a personal Microsoft account.

SUM function. The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM (A2:A10) Adds the values in cells A2:10. =SUM (A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.