# Quora.com how to use exel, tips & tricks excel

### What does the ! do in an Excel formula

**Details: **Answer (1 of 7): Every symbol in **Excel** is representative of something really amazing and in this case, the! symbol is used as the separator between cell address in worksheet and the worksheet name. For more shortcuts like this and for building strong muscle memory in …

› Verified *8 days ago*

› Url: https://www.quora.com/What-does-the-do-in-an-Excel-formula Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What does @ mean in an Excel formula

**Details: **Answer (1 of 6): It means “in this** row** only” in a structured reference. =[@Height]*[@Width] Means “Multiply only the contents of the cells in the columns called Height and Width that are in the same** row** as the cell holding this formula.” Structured references are typically only seen in Tables

› Verified *6 days ago*

› Url: https://www.quora.com/What-does-mean-in-an-Excel-formula Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Who invented Excel

**Details: **Answer (1 of 7): Microsoft already had a spreadsheet product called Multiplan when work started on **Excel**. Lotus 1–2–3 dominated the market, and **Excel** was intended to take back marketshare from Lotus. Doug Klunder (lead developer), Jabe Blumenthal (program manager), Charles Simonyi and Bill Gates

› Verified *Just Now*

› Url: https://www.quora.com/Who-invented-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What does ' ', ' ' mean in Excel

**Details: **Answer (1 of 6): Using Jery’s formula, let’s say this formula is in B1: =IF(A1="","",A1) This means IF the content of A1 is nothing (nothing indicated by “”, then, fill B1 with nothing, and if A1 is NOT NOTHING, then fill B1 with whatever is the value in A1. For anyone wanting to test this for

› Verified *7 days ago*

› Url: https://www.quora.com/What-does-mean-in-Excel-1 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What does '^' mean in Excel

**Details: **Answer (1 of 8): The** carat** (^) symbol is a math operator used to indicate an exponent. Say that you want to raise 4 to the 3rd power. A formula of =4^3 will calculate =4*4*4 or 64. As another example =3^10 will be =3*3*3*3*3*3*3*3*3*3 or 59049. =2^20 will …

› Verified *7 days ago*

› Url: https://www.quora.com/What-does-mean-in-Excel-7 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What is the use of ^ symbol in Excel

**Details: **Answer (1 of 2): I changed to 64-bit **Excel** a couple of years ago. One day not long after, I started having problems getting the exponentiation operator to work

› Verified *6 days ago*

› Url: https://www.quora.com/What-is-the-use-of-symbol-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What does “=!” mean in Excel

**Details: **Answer: The only time I typically see an exclamation point in an **excel** formula is when referencing a cell on a different sheet. For example, if you have a workbook with two sheets, “Sheet1” and “Sheet2,” you might have a formula on Sheet1 that is “=Sheet2!A1”, which would return the …

› Verified *7 days ago*

› Url: https://www.quora.com/What-does-mean-in-Excel-6 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to calculate years of experience in Excel

**Details: **Answer (1 of 2): There’s a tremendous difference between one year of experience using **Excel** repeated ten times, and ten years of progressive improvement in your **Excel** skills. For this reason, I don’t like to think in terms of years of experience, but rather in terms of Novice, Intermediate, Advan

› Verified *1 days ago*

› Url: https://www.quora.com/How-do-you-calculate-years-of-experience-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to write 10 to the power 6 in Excel

**Details: **Answer (1 of 3): To write 10 to the power 6, you might use Scientific notation, and type 1E+6. This value will be displayed as 1000000 in the formula bar when you hit Enter. If the cell is not formatted with Scientific number format, **Excel** will display …

› Verified *3 days ago*

› Url: https://www.quora.com/How-do-I-write-10-to-the-power-6-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What do you hate the most about Microsoft Excel

**Details: **Answer (1 of 14): What do you hate the most about Microsoft **Excel**? [Original question per the OP] **EXCEL** is an utterly daunting software to open. It’s telling you: If you don’t know what to do now, it’s not Microsoft’s problem. It needs to have a …

› Verified *9 days ago*

› Url: https://www.quora.com/What-do-you-hate-the-most-about-Microsoft-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What is the meaning of '<>' in an Excel formula

**Details: **Answer (1 of 8): <> means to check if two items are equal to each other or not. Here is an example IF formula is used to apply changes to cell value based on a logical test. below are sales for orange and apples. If column B is blank, we want to take col A’s value as the final sales - …

› Verified *6 days ago*

› Url: https://www.quora.com/What-is-the-meaning-of-in-an-Excel-formula-1 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to allocate more memory to Excel

**Details: **Answer (1 of 4): You don’t have any control over the allocation of memory to individual applications. Windows will allocate as much memory as the application asks for (swapping to disk if it needs to). **Excel** allocates as much memory as it needs. This said… **Excel** has a maximum size of 1,048,576 r

› Verified *1 days ago*

› Url: https://www.quora.com/How-can-I-allocate-more-memory-to-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to insert a table within a cell of Excel

**Details: **Answer (1 of 6): **Excel** cells are designed to hold numbers, texts, formulas, pictures, or shapes, but not Tables. However, you can insert a Linked picture into a cell that refers to a table. Copy the table > Right-click on the cell where you want to display table > Paste as a linked picture.

› Verified *8 days ago*

› Url: https://www.quora.com/How-do-I-insert-a-table-within-a-cell-of-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to set a primary key in Microsoft Excel

**Details: **Answer (1 of 4): My assumption is that you need this whenever you insert a new row or start a new row AND your data is formatted as an **Excel** table. Assign two columns, say A and B. Column A will hold the fixed unique key value and column B will contain the formula that creates the key. Creation

› Verified *8 days ago*

› Url: https://www.quora.com/How-can-I-set-a-primary-key-in-Microsoft-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### In Excel, what is the intermediate level

**Details: **Answer (1 of 3): Here’s how I would define the levels: Beginner: * Basic math formulas, including SUM, AVERAGE, MAX, MIN, etc * General concepts of relative references vs fixed * Knowledge of how to sort and filter tables * Ability to make basic graphs * Basically, this level is that you c

› Verified *1 days ago*

› Url: https://www.quora.com/In-Excel-what-is-the-intermediate-level Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to type 001 or 00 before 1 or any number in Excel

**Details: **Answer (1 of 3): Select your number range then go to Custom and format cells and use 000 as the format type.

› Verified *7 days ago*

› Url: https://www.quora.com/How-do-I-type-001-or-00-before-1-or-any-number-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What does [] mean in Excel

**Details: **Answer (1 of 3): In **Excel** if you format a table as a Table, use shortcut CTRL-T, then when you attempt to add formulas in adjacent columns **Excel** takes over and formats the functions as array functions creating Calculated Columns for you. This is …

› Verified *8 days ago*

› Url: https://www.quora.com/What-does-mean-in-Excel-17 Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What does a ‘&’ sign mean in an Excel formula

**Details: **Answer (1 of 4): An ampersand & is the concatenation operator. If you want to join two pieces of text into a single word or phrase, the ampersand is the most convenient way to do it. To return the word** “Jackrabbit”** you might use a formula like either of these: [code]="Jack" &** "rabbit"** =CONCATENA

› Verified *3 days ago*

› Url: https://www.quora.com/What-does-a-sign-mean-in-an-Excel-formula Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What does the @ symbol do in Excel

**Details: **Answer (1 of 11): There was a period of time (I'd guess mid 80s to mid 90s) where a program called Lotus 123 was the de facto standard in** spreadsheet** programs. It operated with** spreadsheet** formulas much like the ones you see today. The at sign (@) was the way you indicated the start of a formula.

› Verified *9 days ago*

› Url: https://www.quora.com/What-does-the-symbol-do-in-Excel-It-keeps-showing-up-as-why-is-this-happening Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to find x intercept in Excel

**Details: **Answer: There are several ways in which you can find the intercept in **Excel** * the high low method * by inspection using a graph * the INTERCEPT() function * the LINEST() function * a Trendline on a graph * the Data Analysis ToolPak regression utility Let’s choose these methods * by Inspe

› Verified *6 days ago*

› Url: https://www.quora.com/How-do-I-find-x-intercept-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What does a dollar sign mean in an Excel formula

**Details: **Answer (1 of 22): A dollar sign in **Excel** is used for absolute cell referencing. This tells **Excel** that you want to always refer to a specific cell even when your formula is copied across. Let me explain: What is cell referencing? A cell reference is simply telling **Excel** the location of the cell

› Verified *Just Now*

› Url: https://www.quora.com/What-does-a-dollar-sign-mean-in-an-Excel-formula Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What is the best programming language for Excel

**Details: **Answer (1 of 3): VBA (Visual Basic for Applications) is built-in. It’s fairly easy to learn, but by far the least powerful way to automate **Excel**. C# is the best way to automate (or “program”) **Excel**. It has libraries for not only wrangling **Excel**, but also Word or any other Microsoft Office applic

› Verified *9 days ago*

› Url: https://www.quora.com/What-is-the-best-programming-language-for-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use the number e in Microsoft Excel

**Details: **Answer (1 of 4): The constant e you are mentionning is the base of natural logarithm and roughly equals 2.71828182845904. **Excel** refers to it as the EXP function. This function will returns the contant e raised at a power of an arbitraty number you will pass onto the function. Just type : …

› Verified *8 days ago*

› Url: https://www.quora.com/How-do-you-use-the-number-e-in-Microsoft-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What are fixed cells in Excel

**Details: **Answer (1 of 3): Fixed Cells of selected data range are those cells which are absolute, or in simple words whose reference does not change, when you copy the function

› Verified *1 days ago*

› Url: https://www.quora.com/What-are-fixed-cells-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Why can't I delete a sheet in Excel

**Details: **Answer (1 of 3): Q. Why can't I delete a sheet in **Excel**? It is not possible to Add, Delete, Hide, or Unhide worksheets in a ‘protected’ **Excel** workbook. Following is a screenshot of an **Excel** workbook protected using a password. As you can see, the …

› Verified *6 days ago*

› Url: https://www.quora.com/Why-cant-I-delete-a-sheet-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to represent infinity in Excel

**Details: **Answer (1 of 3): Hold down the alt key and type 236 on the number keypad. This just displays the lemniscate symbol. There’s no functionality.

› Verified *Just Now*

› Url: https://www.quora.com/How-do-you-represent-infinity-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What are the eleven data formats in Excel

**Details: **Answer (1 of 3): **Excel** stores data as either: * Floating point numbers (double precision is default, single precision is available) * Integers (Long integers are default, short integers are available) * Text You may display these values in a wide variety of formats. Some of the display forma

› Verified *3 days ago*

› Url: https://www.quora.com/What-are-the-eleven-data-formats-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### In Excel, how to you type the Delta symbol

**Details: **Answer (1 of 11): Delta is a Greek Letter with 2 different Upper Case (Δ) and Lower Case (δ) forms. To insert any of these symbols into an **Excel** cell, go to the Insert Tab of **Excel** Ribbon > Symbols > Symbol > In the dialog for Symbol, select Greek and …

› Verified *3 days ago*

› Url: https://www.quora.com/In-Excel-how-to-you-type-the-Delta-symbol Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to square a number in Excel

**Details: **Answer (1 of 6): How do you square a number in **Excel**? There’s more than one way. Ok, let’s say that the number you want to square is in cell A1 and you want your result in cell A2. You want to know the formula that you have to type into cell A2. Well, there’s more than one …

› Verified *7 days ago*

› Url: https://www.quora.com/How-do-you-square-a-number-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How is a sigma formula calculated in Excel

**Details: **Answer (1 of 4): Sigma is a Greek letter that looks like the Latin letter M on its side! That is, ∑ In mathematics and statistics Sigma, ∑, means sum of, to add

› Verified *4 days ago*

› Url: https://www.quora.com/How-is-a-sigma-formula-calculated-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to make Excel ignore text within a formula

**Details: **Answer (1 of 2): If you are writing a formula with a numeric result, it is possible to put explanatory comments right within the formula. The N function returns 0 when passed text, and is perfect for this purpose. For example: [code]=SUM(J2:J25) + …

› Verified *1 days ago*

› Url: https://www.quora.com/How-can-I-make-Excel-ignore-text-within-a-formula Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Can you have two formulas in one cell of Excel

**Details: **Answer (1 of 3): You can do this with a formula: [code ]=IF(SUM([Weight]*[Price]+[Added])=0,"",SUM([Weight]*[Price]+[Added]))[/code] or by using a custom format for

› Verified *8 days ago*

› Url: https://www.quora.com/Can-you-have-two-formulas-in-one-cell-of-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What is the purpose of the exclamation mark in Excel

**Details: **Answer (1 of 7): Let’s say you have a reference like =Sheet1!$A$2:$B$10 The exclamation means the following reference is located at Sheet 1. The dollar signs are

› Verified *4 days ago*

› Url: https://www.quora.com/What-is-the-purpose-of-the-exclamation-mark-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What is the dump sheet in MS Excel

**Details: **Answer (1 of 2): Not very sure, but usually by dump in **Excel** we mean data dump. So basically a sheet where all your data comes from.

› Verified *6 days ago*

› Url: https://www.quora.com/What-is-the-dump-sheet-in-MS-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What is the difference between the field and field names

**Details: **Answer: Fields Each individual item of information in a database record – such as a telephone number or street number – is referred to as a field. In **Excel**, the individual cells of a worksheet serve as fields, since each cell can contain a single piece of …

› Verified *7 days ago*

› Url: https://www.quora.com/What-is-the-difference-between-the-field-and-field-names-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to adjust the plot line thickness in Excel

**Details: **Answer (1 of 3): To adjust plot line thickness, select the line on the chart, right click and select format data series. The format data menu shoud appear on the right: There are many options here, along with the width of the line. If you have many different lines, you …

› Verified *3 days ago*

› Url: https://www.quora.com/How-can-you-adjust-the-plot-line-thickness-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What is a column index number in Excel

**Details: **Answer (1 of 2): When you use the INDEX or VLOOKUP functions, you need to specify which column to return values from in relative rather than absolute fashion. Rather than saying give me a value from column C, you say give me a value from the third column in my lookup table. Using relative referen

› Verified *Just Now*

› Url: https://www.quora.com/What-is-a-column-index-number-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What are statistical functions used for in MS Excel

**Details: **Answer (1 of 6): Statistical Functions Average | Averageif | Median | Mode | Standard Deviation | Min | Max | Large | Small This chapter gives an overview of some very useful statistical functions in **Excel**. Average To calculate the average of a group …

› Verified *3 days ago*

› Url: https://www.quora.com/What-are-statistical-functions-used-for-in-MS-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to lock an Excel spreadsheet so only one person can

**Details: **When **Excel** crashes the tilde file is not always deleted and continues to act as a lock on the document. These files can only be deleted from the command prompt. Finally, my own view is that these locks occur more often on large sheets, stored on the network, large and medium sized documents on on Office 365 cloud and very regularly with shared

› Verified *1 days ago*

› Url: https://excelkida.quora.com/How-to-lock-an-Excel-spreadsheet-so-only-one-person-can-edit-it Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### What is the shortcut for inserting copied rows in Excel

**Details: **Answer (1 of 2): There are four good keyboard shortcuts to Insert Copied Rows: * Alt+i e * Ctrl+Shift+= using the key to the left of backspace * Ctrl++ using the plus sign on the numeric keypad * Alt, h, i, e I use the shortcut of Alt+i e. This stands for …

› Verified *7 days ago*

› Url: https://www.quora.com/What-is-the-shortcut-for-inserting-copied-rows-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to extend a formula in Excel

**Details: **Answer: **Excel** spreadsheet updates when a formula is copied in its entirety. However, if the formula needs to be extended across two or more cells, it can be easier to extend by using Paste Special. This will allow updating the formulas without …

› Verified *5 days ago*

› Url: https://excelbeginners.quora.com/How-to-extend-a-formula-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to import stock prices into Excel from Google Finance

**Details: **Answer: Why would you want to import stock prices into **Excel** from Google Finance? **Excel** has its own stock price feature using time delayed data from Refinitiv, with over 7500 tickers or foreign exchange rates from stock markets around the world. …

› Verified *1 days ago*

› Url: https://www.quora.com/How-do-I-import-stock-prices-into-Excel-from-Google-Finance Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to replace #value with 0 in Excel

**Details: **Answer (1 of 3): I agree with Marcus but his example creates another problem while solving the first. His example of dividing 100 with 10 results in #value because 100 is typed in as text. The iserror() function successfully replaces this with 0, but if …

› Verified *Just Now*

› Url: https://www.quora.com/How-do-I-replace-value-with-0-in-Excel Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to import data from Excel to an SQLite database in

**Details: **Answer: One easy way to do so is to use Pandas, which can read from and write to a variety formats, including MS **Excel** and SQL. The steps may involve: 1. Read the data from an MS **Excel** file into a DataFrame with the [code ]pd.read_**excel**()[/code] function. 2. Write the DataFrame to an SQLite data

› Verified *7 days ago*

› Url: https://www.quora.com/How-do-you-import-data-from-Excel-to-an-SQLite-database-in-Python Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to execute the Fibonacci sequence in Excel VBA

**Details: **Answer: You can write UDF for Fibonacci sequence in **Excel** VBA. Press ALT+F11 to open VBA IDE then create new Standard Module and copy paste below code in the new moudule. [code]Option Explicit Private Function FibNum(nthFib As Double) As Double Dim num1 As Double Dim num2 As Double num1 = 1.

› Verified *4 days ago*

› Url: https://www.quora.com/How-do-I-execute-the-Fibonacci-sequence-in-Excel-VBA Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Top Categories

### Recently Searched

› Excel function count colored cells

› How to use connections in excel

› Excel keyboard shortcut switch sheet

› Excel expense sheet template

› Compare two excel files and highlight changes

› Excel hide and protect sheet

› Payroll in excel free download

### Trending Searches

› How to use the sumif function

› How to use the countif function

› How to use the excel time function

› How to merge data tables in excel

› How to fix a circular reference error

› Mathematical formulas in excel