Use the SUM function to sum numbers in a range - Microsoft Support
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Multiply and divide numbers in Excel - Microsoft Support
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:J6).
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
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
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
Change the capitalization or case of text - Microsoft Support
Do one of the following: To capitalize the first letter of a sentence and leave all other letters as lowercase, select Sentence case. To exclude capital letters from your text, select lowercase. To capitalize all of the letters, select UPPERCASE.
Applies To:
Word for Microsoft 365, PowerPoint for Microsoft 365, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, PowerPoint for the web, Word 2021, PowerPoint 2021, Word 2021 for Mac, PowerPoint 2021 for Mac, Word 2019, PowerPoint 2019, Word 2019 for Mac, PowerPoint 2019 for Mac, Word 2016, PowerPoint 2016
Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
Change from a 32-bit version to a 64-bit version or vice versa. Activate Windows. Fix Bluetooth problems in Windows. Learn how to install, reinstall, or activate Microsoft 365 or Office 2019 on a PC or Mac.
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 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 - Admin, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Find out which version of Microsoft Edge you have
Microsoft Edge Windows 11 Windows 10. Here's how: Open the new Microsoft Edge , select Settings and more at the top of the window, and then select Settings . Scroll down and select About Microsoft Edge. Note: This topic is for the new Microsoft Edge . Get help for the legacy version of Microsoft Edge .
Which version of Windows operating system am I running?
Find operating system info in Windows 11. To find out which version of Windows your device is running, press the Windows logo key + R, type winver in the Open box, and then select OK. Here’s how to learn more: Select Start > Settings > System > About . Open About settings.
安装 Office 更新 - Microsoft 支持
了解如何更新电脑上的 Microsoft Office 以及安装 Office 更新的故障排除提示。
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, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Office 365 operated by 21Vianet, InfoPath 2013, InfoPath Filler 2013, Office.com
Fix sound or audio problems in Windows - Microsoft Support
1. Check your speaker output. 2. Run the audio troubleshooter. 3. Verify that all Windows Updates are installed. 4. Check your cables, plugs, jacks, volume, speaker, and headphone connections. 5. Check sound settings. 6. Fix your audio drivers. 7. Set your audio device as the default device. 8. Turn off audio enhancements. 9. Restart Audio Services
Keyboard shortcuts in Windows - Microsoft Support
Copy, paste and other general keyboard shortcuts. Learn how to navigate Windows using keyboard shortcuts. Explore a full list of taskbar, command prompt, and general Windows shortcuts.