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
Windows 10 and Windows 11 in S mode FAQ - Microsoft Support
To increase security and performance, Windows 11 in S mode only runs apps from the Microsoft Store. If you want to install an app that isn't available in the Microsoft Store, or if you have Windows 10 Pro, Enterprise, or Education and want to upgrade to Windows 11, you'll need to permanently switch out of S mode.
Troubleshoot Outlook email setup - Microsoft Support
If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin
Set apps to run automatically when you start your device
Note: If you see the icon next to the On/Off toggle for an app, you can select it to see the registry location that contains the path for the app. Apps installed through Microsoft Store (.MSIX apps) don’t have these icons. If you select the icon for these apps, File Explorer opens and highlights the executable file.
Change your screen resolution in Windows - Microsoft Support
In the Display resolution row, select the list and choose an option.It's usually best to stick with the one that's marked (Recommended). Monitors can support resolutions that are lower than their native resolutions, but text won't look as sharp and the display might be small, centered on the screen, edged with black, or stretched.
Change default programs in Windows - Microsoft Support
To change the default app, you can do either of the following: Set a default for a file type or link type In the search bar, enter the file type or link type you want, then select it from the list of results.
Change or reset your PIN - Microsoft Support
If you forgot your PIN and need to reset it, you can do so from the Windows sign-in screen. Look below the PIN text box: If you see I forgot my PIN , select it and follow the instructions to reset your PIN.If there are multiple accounts on the device, choose the one you need to reset.
How do I use the Fn key/F Lock key/Alternate command keys?
Alternate command key. What it does. Help. Opens the Help system (if any) for the active window. Undo. Cancels the previous action. Redo. Cancels the previous Undo action.
Server settings you'll need from your email provider
Setting. Description. Write Your Setting Here. Example. Host Name. Your incoming mail server name. outlook.office365.com. Username. The email address you want to set up.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Outlook.com, Office 365 operated by 21Vianet - Admin, New Outlook for Windows, Outlook for iOS, Outlook for Windows Phone 10, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016
Turn Microsoft Defender Firewall on or off - Microsoft Support
Under Microsoft Defender Firewall, switch the setting to On.If your device is connected to a network, network policy settings might prevent you from completing these steps. For more info, contact your administrator.