Q&A for How to Type Formulas in Microsoft Excel

Return to Full Article

Search
Add New Question
  • Question
    What is the name of ";"?
    Community Answer
    Community Answer
    It is called a semicolon, which can be used in programming languages to separate the statements or print variables by using one output statement.
  • Question
    How do I subtract one cell from another in Excel?
    Community Answer
    Community Answer
    If you want to subtract cell A1 from cell B1, in cell C1 you would type "=A1-B1" and hit enter. You can also use the autosum feature in the far right of the header.
  • Question
    How do I type the symbols that are used in Excel?
    Community Answer
    Community Answer
    You click Shift and the number/letter you see the symbol on (for example, if you want the multiplication symbol * you hit Shift+8) when using a keyboard. On a phone you have to switch the keyboard to the special characters one and find the symbol you want.
  • Question
    How do I auto calculate across columns?
    Community Answer
    Community Answer
    Type in the "=" sign, then select the cell you wish to calculate and press "Enter".
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit

Return to Full Article

You Might Also Like

Use If‐Else in Excel Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
Use Summation Formulas in Microsoft Excel Use the SUM Function in Excel to Add Cells, Ranges, & Numbers
Copy Formulas in Excel Copy & Paste Formulas in Excel: 4 Quick Ways
Add in Excel Add Numbers & Cells in Excel: Complete Guide
Multiply in ExcelMultiply in Excel
Fix a Formula in Excel Fix a Formula in Microsoft Excel
How Do You Write an if then Formula in Excel Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
Subtract in ExcelSubtract in Excel
Use Index Match Combine INDEX and MATCH in Excel to Create Lookup Formulas
Edit Data in Microsoft Excel3 Simple Ways to Edit Data in MS Excel
Use Vlookup With an Excel Spreadsheet Use VLOOKUP with an Excel Spreadsheet
Convert Measurements Easily in Microsoft Excel Convert Measurements in Excel with the CONVERT Function
Combine Two Columns in Excel Combine Columns in Excel Without Losing Data
Learn Spreadsheet Basics with OpenOffice CalcLearn Spreadsheet Basics with OpenOffice Calc