answersLogoWhite

0

📱

Microsoft Excel

Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.

9,788 Questions

Which feature helps to insert the contents of the clip board as text without any formatting?

The way I do this is to open Notepad, paste the text into it to remove formatting, and then copy the text back out of Notepad. Once you get used to it, it can be a very fast control-v, control-c in Notepad to remove formatting, and then control-v where you want the text to go.

If you are doing many copies, just leave Notepad open. Each time you have new text, click on the Notepad session. To get rid of the previous text you just add one control-a (when necessary - usually not) before the above.

The overall then goes select what you want to copy, control-c, click on Notepad, control-a, control-v, control-c, click on the destination, control-v. It is always the same sequence, so you get to where you can do the whole sequence very quickly.

This works for many sources, but does not always work for copies from web pages.

Excel helps you organize and identify your files by using which are the details about a file?

Excel is not a file manager. However, you can organize Excel files by storing them in folders for specific purposes.

When using Excel does a circular reference occur when a formula in a Cell refers to another cell or cells that include a formula that refers back to the original cell?

A circular reference usually happens when a formula refers to the cell that it is in. So it could be doing something like adding itself to itself or including itself when totalling a group of cells. That creates an infinity situation as it keeps referring back to itself, causing a circular reference. It can also happen when it refers to another cell that refers to the cell that the formula is in. If you have a circular reference it is usually a matter or excluding the cell reference of the cell that the formula is in from within the formula. For more complex circular references it may be a case of reviewing the logic of your spreadsheet. This can always be done.

How do you activate Range Finder to verify a formula in a cell?

Not sure what you meant exactly, but you can use the evaluate formula tool (under the formula ribbon) to see how your formula calculates and verify that it's working as you planned.

See related links for a video that shows you how:

What best describes conditional formatting?

Changing something in a workbook according to the value of a cell or range.

I.e. If a cell's value is negative (lower than 0) colour the cell red, if it is positive colour the cell green.

How do you calculate a square root of a number in Excel?

You calculate square root in Excel using the Sqrt() function.

for example:

If the value of A1 is 81

and A2 contained the formula "=Sqrt(A1)",

The number 9 would be displayed.

What is excel used mainly for?

It is used for numerical analysis and manipulation, so almost anything to do with numbers, like business, accounting, statistics. It is widely used because it is the best known spreadsheet application and is made by the biggest software company in the world, so it is well marketed.

Which chart type is ideal for showing changes over time?

Line graphs are generally used for this purpose. Bar graphs are also used to show change over time.

What is the cell reference for the cell located in the fourth column and third row of a worksheet?

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

Assuming the first column from the left it would be A3. If it is the second column from the left, then it is B3. If it is the third column from the left then it is C3 and so on.

When printing a worksheet can the orientation be changed either on the page layour tab or in print preview?

when printing a worksheet you can changes the orientation either on the page layout tab or in print preview? It this yes or no

How does the Mini toolbar appear on your screen?

In a faint, ghosted fashion over the selected text

What are ways you can change a worksheet?

Select the cell that contains the data you want to change and edit the cell, by double-clicking on the cell or editing in the formula bar.

What are the advantages of using Excel Modelling?

Precisely MS Excel as a tool is used to solve all logical problems, being it arithmetic, algebraic, statistical, scientific, financial and logical statement based. Also a user have good handle to present the date in the way it is intended to.

Modeling of a problem in excel means - creating a generalized way of solving a problem. Modeling is different from solving problem for once as it is meant to be reusable, variables well defined to represent input and output, generalized and well explained, understandable to a general user ( of that domain).

So precisely Excel Modeling means:

1.creating a well structured model for a particular type or group of problems

2. It is reusable

3. It is generalized

4. Result /output is well structured

How does the F9 function work in Excel?

It recalculates the spreadsheet. This is particularly important when the spreadsheet is in Manual Calculation mode. F9 can be used for the manual updating of formulas. This is called Manual Calculation. Usually when you change a value, the entire spreadsheet updates automatically and all formulas are recalculated. You can change this to manual recalculation. Then when you change a value you can look at a formula and see it update when you press F9. It can let you see how changing a figure affects other cells. Doing that along with other debugging techniques are ways of finding and reducing errors. F9 will also update dynamic functions such as NOW or RANDBETWEEN for example. Manual Calculation does not have to be on to do that. Pressing F9 at any time causes the whole spreadsheet to recalculate.

What are the advantages of using sparklines in excel?

Sparklines in Excel provide a compact visual representation of data trends within a single cell, making it easy to interpret fluctuations over time without taking up much space. They allow users to quickly identify patterns, trends, and outliers in large datasets, enhancing data analysis efficiency. Additionally, sparklines can be customized in terms of style and color to suit the user's preferences, improving the overall presentation of data. This feature is particularly useful in dashboards and reports to provide a clear overview at a glance.

In performing calculations using excel are processed first?

It follows the laws of mathematics which determines the precedence of the operators. Operations inside brackets are done first. Power of or exponentiation has the highest precedence, with multiplication and division having equal precedence and finally addition and subtraction having equal precedence. The acronyms BODMAS, BOMDAS and PEDMAS are sometimes used to represent the order of these precedents when they are being taught in schools.

What key can you press to get help with PowerPoint?

if you use a mac you look at the very top of the screen (where the apple botton is)look right then there should be a botton labled help then type in your question and it will give you help like if you go to a apple store and ask a genius they will send your question to a genius then give you links to look at

Give TWO reasons for creating a chart?

1. because you have 2

2. because if u dont u will get a low grade (if your in school)

3. (i kno 3 answers, im awesome like that) because you feel like it :P and if you dont the soccer player who is running 500m naked and doing a flip will kick ur A** (o yeah i went there smart a**. next time answer my questions seriously) =P

What is a text that is entered in a cell?

First you type it and then you can press the Enter key or the Return key, which will put the text into the cell. You can also type it and click on the little green tick character on the formula bar to put it into the cell.

What are the two keys of the key board that delete the character?

Backspace deletes the characters to the left of the cursor while delete deletes the characters to the right.

(The cursor is the vertical line that flashes on and off where you are typing text)