Syntax: AVERAGE(number1, [number2], ...) Tip: When you average cells, keep in mind the difference between empty cells and those containing the value zero, especially if you have cleared the Show a zero in cells that have a zero value check box in the Excel Options dialog box in the Excel desktop application. When this option is selected, empty cells are not counted, but zero values are.

Back on your PC, right-click (or long-press) Start , then select Settings > Bluetooth & devices > Devices and find your phone or other PC that you just paired with in the list. On the right side, select More Options > Join Personal Area Network (PAN). You may need to select the connection mode, then select Connect in the dialog that appears.

Compare two Excel workbooks. Click Home > Compare Files. The Compare Files dialog box appears. Click the blue folder icon next to the Compare box to browse to the location of the earlier version of your workbook. In addition to files saved on your computer or on a network, you can enter a web address to a site where your workbooks are saved.

Use desktops to keep different tasks organized or for different parts of your life, like work and home. To create a new desktop, select Task view > New desktop. To switch between desktops, select Task view . To change a background on a desktop, in Task view, right-click (or press and hold) on the desktop and select Choose background.

The model number for the Surface power supply unit is in small print in one of two places—on the bottom of the unit or on the adapter itself. Note: The USB port available on some power supply units is only for charging other devices while your Surface is charging and can’t be used to transfer data. For info on how to properly care for the ...

If Windows Media Player stopped working correctly after the latest updates from Windows Update, verify that the updates are the problem by using System Restore. To do this: Select the Start button, and then type system restore. Select Create a restore point, and then in the System Properties pane, select System Restore.

From the Overview page, select Office apps and on that page, find the Microsoft 365 product you want to install and select Install. To install Microsoft 365 in a different language, or to install the 64-bit version, use the dropdown to find more options. Choose the language and bit version you want, and then select Install.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Under My Notebooks, right-click (PC) or Control-click (Mac) the name of the notebook that you want to export, and then select Export notebook. On the screen that opens, select Export. Follow your browser’s prompts to save the file in the location you choose. Tip: If the notebook you’re exporting is very large or contains a large number of ...

The SORT function will return an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER.If your supporting data is in an Excel Table, then the array will automatically resize as you add or remove data from your array range if you're using Structured References.