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
Where do you find a list of Excel arguments?
Each function in Excel that has arguments will differ in terms of what arguments are needed. The help for a particular function will indicate what arguments may be needed. Some functions can be used in different ways and may not always need all arguments.
What is A6 and E9 called in a spreadsheet?
They are both cell references. A6 is the cell where column A meets row 6. E9 is where column E meets row 9.
What term refers to separating the slices of a pie chart in excel?
Exploding is the term that refers to separating the slices of a pie chart in excel.
How do you get text in a pivot table?
If you select the main text headings, they will be included in the pivot table as headings. You can type into any cell in a pivot table that has text, though not ones that have values.
What does each row in a table represent in Excel?
In the context of it being a database, then the row of values would represent a field in that database.
False
What is a button on the standard toolbar that allows you to select a formula to apply?
The Autosum button allows you to choose several functions that you can use for formulas, and appeared on the old Standard toolbar.
Can you decrease the file size of a photo in Microsoft paint?
Try saving as a different file type. A .jpeg file would be smaller than a .bmp file.
Comma exchange with full stop in Microsoft Excel?
Go to the Edit menu and pick Replace. In the "Find what" box enter the comma and in the "Replace with" box enter the full stop. Then you can replace them. If you are certain you want to do it for all full stops you can click Replace All. It will only change them where you have literally type them in. Decimal points that are in calculations as a result of formulas will not be replaced.
The above is a quick fix but the data entry isn't correct.
To change from the "," appearing when entering a "." as a decimal point you need to change the regional and language settings in Windows.
Go to your 'Control Panel' and open 'Regional and Language Options'. You can leave the language as is, click on the 'Customize this format...' button.
Now change the "Decimal symbol" to a "." and the "digit grouping symbol" to a ","
Problem solved.
How many parameters are possible using the IF function in Excel?
The IF function has 3 parameters. The condition, the true part and the false part.
What is upper and lower case numbers?
Your question is a little vague however, you may be referring to 'superscript' and 'subscript' numbers - as you would find in mathematics or chemistry. See the following examples...
Mathematics - 3.1415 x 106 - meaning the short form of 3,141,500 or
Chemistry H2SO4 - the chemical formula for Sulphuric acid.
Why would you bold a cell entry in excel?
To emphasise it and make it stand out amongst other values in the spreadsheet. Main headings may be bolded or significant totals could be.
Why do pharmacy technicians use Microsoft Excel?
Pharmacy technicians use Microsoft Excel because it is a fast and efficient means of organizing data.
What would be the EXCEL formula to calculate 15 percent of 6058.82?
15 / 6058.82 = 0.00247572959751238690041955364246. Formatting the cell for percentages will yield a result of 0.25%
How do you combine two columns of email addresses into one column?
Without writing a custom macro, here are two ways you can combine two columns of any kind of data into one column. Assume your first column is in A, the second column in in B, and all data starts in row 1. In cell C1 enter one of these formulas:
- =A1 & " " & B1
- =concatenate(A1, B1)
Then, copy the formula to all cells in column C that correspond with entries in columns A and B.
The advantage of the first formula is that you can include a separator between the two entries: " " gives you a space; " - " gives you a dash with spaces on both sides. If you want to join the two columns without anything between the two entries, just use =A1&B1.
If you mave more than two columns, use the same sequence to combine more cells.
How much money does an Excel spreadsheet designer make?
I do not think there is a job title for a "spreadsheet designer," so there are no salary tables available through public sources. A spreadsheet is a tool used in all industries. Spreadsheet design is a skill that may distinguish you from other job applicants and may allow you to demand a higher salary, because you possess excceptional Excel skills, but I do not think you will find a job called "spreadsheet designer."
If you use your shift key when selecting objects with your mouse what happens?
You select everything between your two clicks. Click on the first object, hold down the shift key, click on the last object. You will see that you have selected everything between the two clicks.
How do you print all sheets in excel workbook one at a time?
Your question is not clear. If you want to print all sheets in the workbook, use the print command. In the print box there is a section called "Print what." The default setting is Active sheet(s). Select Entire workbook.
If you want to print only a single sheet "one at a time," then leave the setting at Active sheet(s).
How can you print an Excel page with the columns and lines visible?
If you go to the Page Setup on the File menu, and then the Sheet tab, there is an option to print them or not. In Excel 2007, go to the Page Layout ribbon, and you'll see Gridlines having both a View and a Print option.
If you mean you want to find how far the numbers are from zero, whether they are positive or negative, you could use the ABS function. So if the first value was in A2, then in B2 you could enter the following formula and copy it down:
=ABS(A2)
How do you fix circular data in Excel?
A circular reference error is caused when a formula directly or indirectly refers to the cell that the formula has been typed in. When this happens you will see the cell that the circular reference is in at the bottom of the worksheet. You need to check the formula in that cell and formulas in other cells that it refers to in order to find the problem. Then you can change the formula so that you can still do what you want without the error.
