使用 SUMPRODUCT 对一个或多个数组中的对应值的乘积求和
示例. 如果要使用 SUMPRODUCT 和 创建数组公式,下面是一个 Excel 网页版 工作簿,其数据与本文中使用的不同。. 复制下表中的示例数据,然后将其粘贴进新的 Excel 工作表的 A1 单元格中。 要使公式显示结果,请选中它们,按 F2,然后按 Enter。
Applies To: Excel 2013
Getting started with Planner in Teams - Microsoft Support
Track your tasks in My Tasks. Planner offers a purpose-built My Tasks view, designed to centralize all the tasks relevant to you. My Tasks is organized into four distinct views, each serving a unique purpose: Private tasks: Private tasks is a place for you to quickly jot down tasks at the speed of thought.This is a place where you can create tasks that do not belong to a plan yet.
Applies To: Microsoft Planner, Microsoft Teams, Microsoft Teams for Education, Microsoft Teams personal, Microsoft Teams small business
在 Outlook 中阻止或取消阻止发件人 - Microsoft 支持
提示: 若要编辑或删除来自于阻止发件人或安全发件人列表中电子邮件地址或域的电子邮件,请在列表中选择项目,然后选择 或 。. 若要清空垃圾邮件文件夹,请在左窗格中选择垃圾电子邮件。在屏幕的顶部,选择全部删除。
Applies To: New Outlook for Windows
在工作表中插入、移动或删除分页符 - Microsoft 支持
返回到“普通”视图. 若要在完成分页符操作后返回“普通”视图,请在“视图”选项卡上的“工作簿视图”组中,单击“普通”。 也可以单击状态栏上的“普通” 。 在“分页符预览”视图中处理分页符之后,“普通”视图中可能仍会显示分页符,这是因为分页符已自动打开。
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Word for Windows training - Microsoft Support
Learn how to use Word in Windows with training guides, articles, and videos from Microsoft Support.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Office for business
Excel 中的 Copilot 入门 - Microsoft 支持
Excel 中的 Microsoft Copilot 通过生成公式列建议、在图表和数据透视表中显示见解以及突出显示有趣的数据内容,帮助在 Excel 表中执行更多操作。
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for iPad, Excel Web App
Encrypt messages by using S/MIME in Outlook on the web
A key icon in the message list or reading pane indicates an encrypted message.. If you normally use Conversation view, you'll have to open the message in a new window to read it. There will be a link on the message to make this easier.
Applies To: Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
How to add an email address or phone number to your Microsoft account
Tip: Creating an Outlook.com email address gives you a brand-new email address that is attached to your existing Microsoft account.This makes several benefits and features available to you within the Microsoft suite of products, particularly within Outlook. You might want to do this if your Microsoft account is not currently tied to an Outlook.com email address.
Multiply and divide numbers in Excel - Microsoft Support
Multiply numbers in different cells by using a formula. You can use the PRODUCT function to multiply numbers, cells, and ranges.. You can use any combination of up to 255 numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT(A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4 ...
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
如何获得 Microsoft Rewards 积分 - Microsoft 支持
可以轻松累积 Microsoft Rewards 积分,并获取礼品卡、电影、游戏、非营利性捐赠等丰厚奖励。 使用你的 Microsoft 帐户保持登录状态,你将因执行已执行的操作而获得积分。
Applies To: Microsoft account dashboard