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
Why are pound signs not put into spreadsheets?
When you are entering what are going to be currency values, it is best to just type the numbers without any currency symbols. Then when they are all in, you can format them to the currency you want and it will put in the symbol that you choose. If you try to type a currency symbol in as you are entering the numbers, it may treat it as being text and not numbers, which is why it is best not to type any currency symbols.
When inserting a row in Excel worksheet may cause the formulas in other cells to change?
Some formulas may change when you insert a row. This is often done to accommodate the new row and make sure the worksheet still functions correctly. Formulas can adjust themselves to take account of the new row. So if it is inserted in the middle of a set of rows that a formula uses, the formula will adjust its references to make sure it still includes the cells that contain the values you want to add, rather than having a cell that you were adding being pushed out of range. So the ability to change is important. It could cause more problems if the formulas did not adjust themselves and make a lot more work for the user after inserting the row, in having to change all the formulas manually.
No. Pie charts are the main type of chart that do that. Line charts showing changes over a period of time.
What is the place in the spreadsheet called where the cursor is positioned?
Active Cell or Insert Location
What is difference between the menus of Microsoft Word and Microsoft Excel?
Both have File, Edit, Format, View, Insert, Format, Tools, Window and Help menus. Word has also got a Table menu, which Excel doesn't. Excel has a Data menu, which Word doesn't. On the menus they both have a lot of options are the same, but some options are quite different. For example Word's Insert menu won't have options like Cells, Rows and Columns that Excel will have, but will have options like Autotext, Reference and Field, that Excel won't have. As the two applications are for different jobs, they are naturally going to have different options. Some things will be common, like options to open, close and save files, or to cut, copy and paste things. Options on the Tools and Format menus in each application are going to be different because they are for different tasks. The same applies to other applications which will have a lot of the same menus and options and also have menus and options that are specific to those applications.
The Formula Bar shows those things. Included in it is what is specifically known as the Name Box, which is where the address is shown. The Insert Function button is beside that and then the Formula Box part, when you can see the contents of the cell.
What represent data on a chart?
Depending on the type of chart, different things can represent data. Pie slices on pie charts, bars on bar charts and columns on column charts for example.
What is a general syntax of all formulas in Excel?
You start with the equals sign. After that there is no fixed rule, as formulas are completely different to each other. If you are using functions then there are some rules. First there is the name of the function. After that you have an opening round bracket. Most functions will have arguments in them, and some will not. The square brackets used below indicate that there may or may not be arguments, but are not part of the function. If there are any arguments, they need to be put inside the round brackets. Finally there will be the closing round bracket.
=function_name([arguments])
This is how the SUM function can work:
=SUM(A2:A20)
You can also have formulas with no functions. They would include values and cell references:
=20+C5-34*4
Where can you find the options to align text within a cell in excel?
Go to the Format menu, then Cells, then Alignment and you will find the various settings there. You can also use the alignment icons on the formatting toolbar or Home ribbon.
What is the name of the clicked on cell on Excel?
When you refer to a cell in an Excel formula, you can use any of three different types of reference: relative, absolute and mixed.
Relative cell references are the most commonly used. A relative cell reference in a formula is based on the position of the formula's cell relative to the cell to which it refers. That means if you move the formula cell, or copy it elsewhere, the reference changes. You denote a relative reference simply by using the cell's column letter followed by its row number: A1. A simple formula that uses relative cell references to add the numbers in cells B1 through B9 is:
=SUM(B1:B9)
If you place this formula in cell B10 and then copy it across from B10 to C10, Excel makes the sensible assumption that you want to total the values in the same relative positions in column C - that is, cells C1 to C9 - and so it automatically adjusts the formula to read:
=SUM(C1:C9)
An absolute reference refers to a cell in a fixed location. Such references come in handy when you want to refer consistently to the same cell, or range of cells, throughout a worksheet. For example, if you use a worksheet to estimate a mileage allowance for business travel, you could put the allowance rate per mile in cell D2 and then use an absolute reference to that cell anywhere you use a formula based on the mileage rate. To indicate an absolute reference use dollar signs, thus: $D$2.
How do you see last colunm in Excel?
If you keep pressing the Ctrl and End keys, you will move past blocks of data to reach the last column. You can also use the GOTO command, by pressing the F5 key. If you are using versions of Excel up to version 2003, then you could enter IV1 to get to the last column, or XFD1 in versions from 2007 onwards.
Why does a nurse use a spreadsheet?
To make annotations of the health status of the patients she cares of, like temperature, blood pressure, and other items, so that the medical doctor can evaluate the patient's daily conditions.
Who are the beneficiaries of Microsoft Excel?
Microsoft benefit from Excel as people pay them to use it. Anyone that uses Excel can benefit from it in lots of ways. Businesses use it to do all sorts of financial work for their business to help them plan and forecast. Other people, like scientists, students, statisticians and many others can benefit from it. Almost anyone can make use of Excel.
What do scientist use spreadsheets for?
Recording Investigation Result Hope that helps p.s (Shopping lists of chemicals and scientific equipment?)
Which phrase best describes a spreadsheet?
They can manipulate numbers and change calculations when one number in the table changes.
Yes.
What does the AND function in Excel do?
The AND function is one of the logical functions in Excel. It used when testing more that one condition to see if all of these are true. So if you were testing for something like is someone earning over a certain amount of money and paying a certain tax rate, you would need the AND function, in conjunction with an IF function to help you achieve this. By itself it returns TRUE or FALSE. Only if all the tests are true does it return TRUE. The following one checks if 10 is less than 5 and is 6 less than 20. Obviously they are, so the function will return a TRUE value.
=AND(10>5,6<20)
The following one checks if 20 is less than 15 and is 60 more than 42. Obviously only one of those things is the case, so the function will return a FALSE value, as both must be true.
=AND(20<15,60>42)
Both of those are simple and obvious examples, but often you will be using values in cells which may or may not meet the conditions and could give different results.
=AND(A3>40,B3<10)
Excel tables are based on what concepts?
They are based on the accountant's paper-based spreadsheet, which consists of rows and columns into which values can be put and calculations can be done. The electronic spreadsheet enables the calculations to be done automatically and provides a whole host of other features that a paper-based spreadsheet can never achieve.
What does the percent style button multiply the cell entry by?
It does not multiply the cell by anything. The cell just appears in percentage format, but the value is not changed. It may appear to be multiplied by 100, but that is only because 1 = 100%.
What is the Fx formula on Excel?
Fx represents functions. It is on the Formula Bar and on the Insert Function Button. Clicking on it starts the process of allowing you to enter a function.
If you have multiple Excel workbooks open to close all open workbooks and exit Excel what do we do?
Click the X in the very top right of the title bar or use the Alt - F4 keyboard shortcut or the Alt - F - X keyboard shorcut.
How do you explode a pie chart?
Click on a slice and the whole chart will be selected. Then drag the piece out and all of the chart will explode.
What can Excel spreadsheets be used for in the home?
Excel spreadsheets are designed to make statistics, which could always come in handy when you are filling in your taxes. It could also be used to calculate your expenses or you could quickly create an invoice.
