COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Open the Start menu - Microsoft Support
To open the Start menu—which contains all your apps, settings, and files—you can do any of the following: On the center or left end of the taskbar, select the Start icon.
Zip and unzip files - Microsoft Support
To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.
Calibrate your HDR display using the Windows HDR Calibration app
Note: If you have a built-in display that can play streaming HDR video, but doesn’t support HDR games and apps, use Display calibration for HDR video found in Settings > System > Display > HDR.. To check if your display supports HDR games and apps, under Display capabilities on the HDR settings screen, see if the selected display says Use HDR is Supported or Not supported.
Use Smart charging in Windows - Microsoft Support
Lithium-ion batteries wear out over time, which can result in a battery not holding a charge for as long as it did when it was new. Keeping the battery charged to 100% all the time can cause it to deteriorate faster.
Account help
Microsoft account help and support. Get help with signing in, locked or compromised accounts, linked accounts, closing, reopening, and updating your security info and account profile.
How to open Registry Editor in Windows 10 - Microsoft Support
There are two ways to open Registry Editor in Windows 10: In the search box on the taskbar, type regedit, then select Registry Editor (Desktop app) from the results.
My Account portal for work or school accounts - Microsoft Support
Sign in using two-step verification or security info; Create app passwords in Security info (preview) Set up a phone call as your verification method
Form controls - Microsoft Support
In the Cell link box, enter a cell reference that contains the current state of the option button.. The linked cell returns the number of the selected option button in the group of options. Use the same linked cell for all options in a group.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Create or edit a hyperlink - Microsoft Support
To create a new, blank file and link to it, click Create New Document under Link to, type a name for the new file, and either use the location shown under Full path or browse to a different save location by clicking Change.You can also choose whether to Edit the new document later or open and Edit the new document now.
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Project Online Desktop Client, Word 2021, Outlook 2021, Project Professional 2021, Project Standard 2021, Word 2019, Outlook 2019, Project Professional 2019, Project Standard 2019, Word 2016, Outlook 2016, Project Professional 2016, Project Standard 2016, Office 2016, InfoPath 2013, InfoPath Filler 2013