In Office 2011 for Mac, Excel has hundreds of built-in functions that you can use in cell formulas. While you type a function in a cell formula, a pop-up menu appears. The following example uses Excel’s built-in SUM function.
Start with a blank worksheet.
Type 1 into both cells A1 and B1.
The value of 1 displays in cells A1 and B1.
In cell C1, type =S.
While you type, a pop-up menu showing all worksheet functions beginning with the letter S displays. Look at all the functions that start with the letter S! Right now, you’re interested in the SUM function.
Choose SUM from within all those S options in the pop-up menu with the arrow keys on your keyboard; then press the Enter or Tab key. Don’t type anything else for now.
Excel displays =SUM(|) with the vertical bar indicating the insertion cursor is ready to fill in the argument.
Drag over the range A1:B1.
Excel enters the cell range for you and you don’t have to worry about making a typing mistake. Is that neat or what?
(Optional) You can manually type the argument.
Click the green Enter button to finish.
Excel displays the value of the formula in cell A1 and displays the formula containing the SUM function in the Formula bar.
Jan 27, 2020 Our software library provides a free download of Microsoft Excel 16.33 for Mac. Our built-in antivirus scanned this Mac download and rated it as 100% safe. This Mac application is an intellectual property of Microsoft. The program lies within Productivity Tools, more precisely Office Tools. Note: If you have Office 365 or a one-time purchase of Office 2016 for Mac, see Download and install or reinstall Office 365 or Office 2016 on your PC or Mac for install instructions. Mac 2011 Home & Student or Office for Mac 2011 Home & Business (one-time purchase of Office) installation instructions.
The SUM function is so popular that it has its own button! You can find it by clicking the Ribbon’s Formulas tab, and in the Function group, clicking AutoSum. Click a range of contiguous numbers and then click the button and choose a SUM function. Excel deduces the range for you and enters the formula.
When you enter a cell formula that includes a function, Excel shows you the function’s name and its syntax. The function’s name is blue and is underlined like a hyperlink. That’s because it’s a link to the Help topic for that particular function.
Each function is thoroughly documented with complete sample data and examples so that you can easily see how to use it. To display the complete list of all functions by category, click the Ribbon’s Formulas tab, and in the Function group, click Reference. Click a disclose triangle to display a list of that category’s functions. In the disclosed list, clicking a function name displays detailed information about the function, including how to properly use the function’s arguments. Some topics explain the calculations used by the function to arrive at its result.
Microsoft has officially ended support for Office for Mac 2011 as scheduled, nearly seven years after the software suite was first released. 2011 versions of Word, Excel, Outlook, and PowerPoint will no longer receive feature or security updates as of October 10, 2017. Any form of paid or free technical support from Microsoft has also ended indefinitely. Microsoft Lync for Mac 2011 still has an extended support period through October 9, 2018 for any possible security updates. Since the mainstream support period for the rest of the Office for Mac 2011 was already extended beyond the usual five years, there is no extended support period for those apps. In other words, support has completely ended.
Earlier this year, Microsoft said it had not even tested Word, Excel, PowerPoint, Outlook and Lync on macOS High Sierra, but some users on the web have reported that the suite is mostly functional on the new operating system.
Word 2011 totally works in High Sierra: pic.twitter.com/whpRH0bQeV
— Spider Mann (@spidermann) September 30, 2017 Microsoft recommends users upgrade to Office 2016 for Mac, which is fully supported on macOS High Sierra. OS X 10.10 or later is required. (Thanks, Jacob Harvey!)
Guides
Upcoming
Front Page Stories
Apple Arcade Ad Shared Ahead of Super Bowl: 'A New World to Play In'