Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
在 Excel 中将 IF 与 AND、OR 和 NOT 函数配合使用 - Microsoft 支持
但如果需要测试多个条件,例如我们假设所有条件都需要为 True 或 False (AND),或只有一个条件需要为 True 或 False (OR),或者如果想要检查某个条件是否不 (NOT) 符合你的条件,这时该怎么做呢?这三个函数均可以单独使用,但它们更常见于与 IF 函数成对使用。
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, Excel Web App, Excel for Windows Phone 10
Change desktop background and colors - Microsoft Support
Select Start > Settings > Personalization.The preview window gives you a sneak peek of your changes as you make them. In Personalize your background, you can select a picture, a solid color, or a slideshow of pictures you create.Or you can choose Windows spotlight to see a new image from around the world every day.
Desktop Themes - Microsoft Support
A theme is a combination of desktop background pictures, window colors, and sounds. Get a theme. To get a theme, expand one of the categories below, select a link for the theme, and then select Open.This saves the theme to your PC and puts it on your desktop.
Manage the input and display language settings in Windows
To switch the keyboard layout you're using in Windows 10, press and hold the Windows key and then repeatedly press the Spacebar to cycle through all your installed keyboards. (If this doesn't do anything, it means you have only one installed.)
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
What's the difference between a paid Microsoft 365 subscription and the ...
Free. A Free badge means an active Microsoft 365 Family or Personal subscription isn't associated with the account you signed in with. Only the free web versions of Word, Excel, and PowerPoint are available to you. To access these apps in your browser, all you need to do is to sign in to Microsoft365.com with your Microsoft account and select the app you need from the app launcher .
Use Microsoft Teams for work or school in Windows 11
If you are planning to use Teams free or if you were a guest in an org, you can connect and collaborate by downloading and installing another version of Microsoft Teams (work or school) and signing in with your Microsoft account or the guest account where the invite was sent to.
Applies To: Microsoft Teams, Microsoft Teams personal, Microsoft Teams small business
Keyboard shortcuts in Microsoft Edge - Microsoft Support
Press this key. To do this. Command + Shift + B. Show or hide the favorites bar. Command + Shift + C . Open Developer tools. Command + D. Save your current tab as a favorite. Command + Shift + D. Save all open tabs as favorites in a new folder
激活 Windows - Microsoft 支持
若要在 Windows 11 中检查激活状态,请选择“开始 ”按钮,然后选择“设置 > 系统 ” ,然后选择“激活 ”。 。 激活状态将在“激活”旁边列出。 在“设置”中检查激活状态. 你将在“激活”页面上看到以下一条激活状态消息:
Create a drop-down list - Microsoft Support
After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.
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