IF function - Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF (C2=”Yes”,1,2) says IF (C2 = Yes, then return a 1 ...
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
Upgrade Windows Home to Windows Pro - Microsoft Support
To upgrade from Windows 11 Home to Windows 11 Pro manually, first check which edition you’re running and your activation state: Select Start > Settings > System > Activation. At the top of the Activation page, you see your edition: either Home or Pro. You‘ll also see if you’re activated under Activation state . Open Activation settings ...
在 Teams 作业中设置加权评分类别 - Microsoft 支持
导航到所需的课堂团队，然后选择“ 成绩 ”选项卡。. 选择“ 分配设置 ”图标 。. 3. 滚动到 “评分设置” ，并将 “加权评分类别 ”切换为“ 开 ”。. 4.将显示 “管理评分类别 ”窗口。. 选择 “添加评分类别 ”。. 5. 命名评分类别，并输入要分配的百分比 ...
OneDrive 和 SharePoint 中的限制 - Microsoft 支援服務
新增功能. 2023 年 5 月 1 日：更新不正確字元、不正確檔案和資料夾名稱. 共用限制備註。 2021 年 3 月 3 日：檔案上傳大小上限已更新為 250 GB。 2020 年 9 月 16 日：已更新關於 OneNote 筆記本的資訊，以釐清 2GB 檔案大小限制適用於 SharePoint 和 OneDrive。. 2020 年 8 月 31 日：已更新當開啟 [已知資料夾移動 ...
Applies To:
SharePoint Server 2019, SharePoint in Microsoft 365, Office for business, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Freeze panes to lock rows and columns - Microsoft Support
Select View > Freeze Panes > Freeze First Column. The faint line that appears between Column A and B shows that the first column is frozen. Freeze the first two columns. Select the third column. Select View > Freeze Panes > Freeze Panes. Freeze columns and rows. Select the cell below the rows and to the right of the columns you want to keep ...
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
OneDrive 파일 또는 폴더가 동기화를 마치지 않음 - Microsoft 지원
대부분의 경우 최신 OneDrive 동기화 앱 (onedrive.exe)을 사용하는 것이 좋습니다. 어떤 OneDrive 앱인가요? 회사 또는 학교 OneDrive 를 사용 하 여 Microsoft SharePoint 라이브러리를 컴퓨터에 동기화 할 수 있습니다. 파일이 동기화 되는 로컬 폴더에서 파일을 볼 때 일부 폴더 ...
Applies To:
SharePoint in Microsoft 365, Office for business, OneDrive (work or school)
Ways to install Windows 11 - Microsoft Support
Create Windows 11 installation media. On the Windows 11 software download page , select Create tool now and follow the instructions to install Windows 11. Warning: Microsoft recommends against installing Windows 11 on a device that does not meet the Windows 11 minimum system requirements.
啟用或停用 Yammer 電子郵件和電話通知 - Microsoft 支援服務
控制在電子郵件中收到的通知. 執行下列其中一個動作：. 在 Yammer中 ，選取設定 的按鈕，然後 選取編輯 設定。. 在傳統 Yammer中，選取左側設定中的 按鈕，然後選取編輯 設定。. 在 帳戶設定 下，選取通知 選項卡 。. 如果您是多個網路的成員，您必須變更每個 ...
Applies To:
Microsoft 365 admin
使用壓縮及修復協助防止並修正資料庫檔案問題 - Microsoft 支援服務
使用壓縮及修復協助防止並修正資料庫檔案問題. Microsoft 365 Access Access 2021 Access 2019 Access 2016. 資料庫檔案會隨著您的使用而快速增長，有時還會妨礙效能。. 它們也可能偶爾損毀或損毀。. 您可以使用 [ 壓縮及修復資料庫 ] 命令來避免或修正這些問題。. 壓縮作業 ...
Applies To:
Access for Microsoft 365, Access 2021, Access 2019, Access 2016
Open Control Panel in Windows - Microsoft Support
Open Control Panel in Windows. Windows 10. In the search box next to Start on the taskbar, type control panel. Select Control Panel from the list of results. Note: Many Control Panel features are simpler and faster in Settings . Open Settings. Open Control Panel in Windows.