使用 SUMPRODUCT 对一个或多个数组中的对应值的乘积求和
示例. 如果要使用 SUMPRODUCT 和 创建数组公式，下面是一个 Excel 网页版 工作簿，其数据与本文中使用的不同。. 复制下表中的示例数据，然后将其粘贴进新的 Excel 工作表的 A1 单元格中。 要使公式显示结果，请选中它们，按 F2，然后按 Enter。
Applies To:
Excel 2013
管理 Microsoft 365 订阅或 Office 产品 - Microsoft 支持
登录到 microsoft365.com 以查看Microsoft 365 工作或学校帐户。 登录. 安装和管理应用。 在 Office 应用 卡上，选择“ 管理”，然后选择“ 安装 ”以安装或重新安装最新的桌面应用或其他应用，例如 Project 或 Visio 。(只要管理员 为你分配了许可证 并授予你自安装的权限，安装选项就可用。
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 admin, Outlook on the web, Word Web App, Microsoft account dashboard, New Outlook for Windows
管理 Xbox 設定檔的 PIN | Xbox Support
按 Xbox 按鈕 以開啟快顯功能表。; 移至 [設定檔與系統] > [設定] > [帳戶] > [登入、安全性與 PIN] > [變更我的登入和安全性喜好設定]。. 選擇 [詢問我的 PIN]，或 [將此鎖定] 以使用預設安全性設定，這在使用特定 Xbox 功能與服務之前，會要求驗證您的帳戶。; 選擇 [自訂] 以設定控制您的 PIN 設定的確切 ...
Smart charging on Surface - Microsoft Support
Smart charging will be paused and allow a full battery charge until your Surface needs to turn it on again. It may take several days before smart charging turns on again and limits your battery capacity to 80%.
如何安装最新版本的 DirectX - Microsoft 支持
DirectX 9.0c 通过安装 DirectX 9.0c 最终用户运行时适用于 Windows XP 和 Windows Server 2003。. 某些应用程序和游戏需要 DirectX 9。 但是，你的计算机包含更新版本的 DirectX。 如果安装并运行需要 DirectX 9 的应用程序或游戏，你可能会收到错误消息“无法启动此程序，因为计算机中丢失 d3dx9_35.dll。
Take a screenshot or record your screen on Surface
Tip: Don't see the Screen Record quick setting?Swipe down from the top of the screen twice, then tap Edit (the pencil icon). Under Hold and drag to add tiles, drag the Screen Recorder tile up to add it.
Combine text and numbers - Microsoft Support
Examples. See various examples in the figure below. Look closely at the use of the TEXT function in the second example in the figure. When you join a number to a string of text by using the concatenation operator, use the TEXT function to control the way the number is shown. The formula uses the underlying value from the referenced cell (.4 in this example) — not the formatted value you see ...
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
新 Outlook 和经典 Outlook for Windows 功能比较 - Microsoft 支持
我们正在积极听取你的反馈，并将根据你告诉我们的内容更新和更改功能路线图。 如果你有关于我们应该考虑将哪些内容添加到新 Outlook 的反馈，请使用应用内 帮助 > “提供反馈” 链接。. 功能比较
Applies To:
Outlook for Microsoft 365, New Outlook for Windows
解决游戏或应用下载缓慢的问题 | Xbox Support
滚动到“安装…”< 要下载的游戏名称 >。 转到“我的游戏和应用”>“管理”>“队列”，并记下显示的正在安装游戏或应用的下载速度。这表示当前的下载速度。如果看到速度缓慢（例如，每秒小于 1 兆位），则可能需要很长时间才能完成下载。
View device and app use with Family Safety activity reporting
Screen time reporting shows daily and weekly details about when and for how long your family member used their devices. Gain insight into the amount of time your family member spends on a particular social media app, game or web browser and decide whether you would like to enable screen time limits for any connected devices. To view screen time for a family member, tap Today, then Screen time ...
Applies To:
Microsoft Family Safety