Excel 2016 Formulas Cheat Sheet
Excel Tips and Tricks Cheat Sheet Keystroke Shortcuts Ctrl + s Saves your workbook. B Worksheet or Sheet An individual spreadsheet with rows, columns, and/or charts. E Name Box Displays the name of the currently active cell F Function Box Displays available functions G Formula Bar Displays the contents of the currently active cell H.
Free Excel 2016 Formulas Cheat Sheet
Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010 Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column. 
Here are the 10 functions that people read about most. Function Description Use this function to add the values in cells.
Excel 2016 Formulas Cheat Sheet
Use this function to return one value if a condition is true and another value if it's false. Use this function when you need to look in a single row or column and find a value from the same position in a second row or column. Use this function when you need to find things in a table or a range by row. For example, look up an employee's last name by her employee number, or find her phone number by looking up her last name (just like a telephone book).