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
What is the F1 function in Excel operation?
F1 shows the help in MS Excel. Infact, F1 key is for help in all application.
How do you copy using the fill handle?
The simplest way is to drag down. You can also do series, like if you type in Sunday and drag down, it will fill out the rest of the week. The same works for months. If you type a number in and press Ctrl and drag down, it will increase the number by one each cell. You can do the same with dates.
Which Paste Special option can give you trouble with the formatting of your spreadsheet data?
Microsoft office excel worksheet object
Did you hear about worksheet math joke?
I think it might be "the very sad guy who tried to kiss his girlfriend in the fog and mist".... not sure though (girl friend-2 words)
What is the button that allows you to copy values with or without formatting or format only?
hi..to paste the selected cells in value/other formats press the folllowing in a sequential order (not simultaneously)
1. alt
2. E
3. V
4. S
Then, select the desired option
Which key do you press to convert a related cell reference to an absolute cell reference?
As you are typing in the actual cell reference, press the F4 key and it will change it between the 4 available settings. So if your cell is C10, when you press F4 immediately after typing it, it will become: $C$10 then C$10 then $C10 and then back to C10. When you have it the way you want it, continue typing your formula or just press return if the formula is finished.
A criteria is a condition used in any of the logical functions or filters in Excel. This allows you to do things like find cells that meet certain conditions, like checking if values in a cell are above a certain value. If you wanted to know if students had passed an exam or not, the criteria used would be to check their score against the pass mark.
What is the benefit of using the Sort option?
There are many benefits of using the sort option in Excel. Some benefits are allowing you to sort by number, date, color, letter, columns, or text. This benefits the user because it allows the user to bring data up more easily.
Ctrl - 1 - A will open the Alignment Tab in the Format Cells dialog box.
What excel number format inserts thousand comma separators?
the excel number format that applies a thousand comma separate where appropriate inserts a fixed us dollar sign aligned at the left edge of the cell applies two decimals places and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers is the what?
The answer is accounting number format
In Excel what is done to emphasize certain worksheet entries?
There are many things that could be done. You could change the colour of the text or the cell. You could put borders around the cell. You could bold, underline or italicise the text. You could increase its font size. You could change it to a different font.
What is the title bar in excel?
The title bar in excel is placed at the very top of the screen. It shows the application's name and document's name.
What are the cells that go down vertically on excel on a spreadsheet?
The vertical columns are marked with a letter, A, B, C, and so on, along the top.
The horizontal rows are marked with numbers, 1, 2, 3, and so on, down the side.
The first cell in top left-hand corner is A1 (in column A and row 1).
How do you perform Geometric standard deviation in Excel?
I just had this problem myself. A simple solution, not 'the solution' (as i believe you can pay for this function to be added to excel), is as follows: (NB. This can be checked with reference to the GEOMEAN function).
e.g. your data is in column A (A3-A33)
in cell B3 type =LN(A3) (i.e. the natural log)
copy and paste down to B33.
In B34, calculate the standard deviation of the loged numbers i.e. =STDEV(B3:B33)
In A34 type =EXP(B34) This is your geometric standard deviation!!
You can check this method with ref. to the GEOMEAN function.
Take the mean of column B. i.e. in cell B35 type =average(B3:B33)
In cell A34 type =EXP(B34).
This should returen the same answer as =GEOMEAN(A3:A33)
There is an error in the above mentioned function which is:
//In B34, calculate the standard deviation of the loged numbers i.e. =STDEV(B3:B33)
Here do not calculate the STDEV(b3:b33) instead, calculate the =AVG(b3:b33)
Formula that will calculate sum in excel?
Without seeing your precise spreadsheet and knowing what types of figures you already have and what cells they are in, it is impossible to give you the precise formula. There are also various ways you could do it, but the function you would be most likely to use is the Sum function. So if you already have individual incomes and just want to total them, then in the cell where you want the total type in:
=Sum(
and then select the cells that you want added using the mouse and then press enter.
If your figures were in cells B1, B2, B3, B4, B5, B6 and B7 and your formula was in B8, then the formula would be:
=Sum(B1:B7)
That is telling Excel to add all the values in the cells from B1 to B7.
Right-click on the cell, select cell format and chose format numbers as text (Category: text). You also can begin the cell entry with an apostrophe (') to tell Excel to treat the cell contents as text.
Make the first character in the call an apostrophe and Excel will treat the entry as text. EXAMPLE: '123
One component of an Excel function is the argument. What is an argument?
In Excel, an argument is a value that is passed to a function in order for it to carry out its task. So for a SUM function, it needs to know what values to add up. This means giving the SUM functions cell references or actual values to use in its calculations. Most functions require arguments, though some don't.
Here A1:A15 is the argument:
=SUM(A1:A15)
Here is an IF function with 3 arguments, as it needs a condition, an action if the condition is true and an action if the condition is false:
=IF(A3>=40,"Pass","Fail")
Arguments are the elements that are required by some functions in order to operate. To carry out their calculations they need certain information or figures to work on. Some functions have lots of required arguments and can be quite complicated. The arguments of the function are contained in the brackets of the function. For example, the A5:A10 here is the arguments for the function, telling the Sum function what cell range it is going to add.
=Sum(A5:B10)
All functions have brackets, though not all need to have arguments in the brackets. For example, this functions gives you the current date and time, and it doesn't require any arguments:
=Now()
What is an actual cell reference?
They are the way cells are identified in a spreadsheet. This is done by the column and row of the cell. Columns are identified by letters and rows by numbers. Cell C12 is the cell in column C and row 12 for example.
Which is the correct process for selecting an entire column?
Click on the letter at the top of a column or put the cursor in any cell in the column and press and hold the Ctrl key and then press the space bar.
How do you enter a date in MS Excel?
You can use almost any format you like to enter the date. The key to using and viewing dates is the cell format. Right-click on the cel and select cell format. Then you can format the date to look almost any way you like.
Why would a banker use a spreadsheet?
A banker would use a spreadsheet to keep an organised system of money being loaned, taken out, placed in etc. It also may be useful to add their mathematical solutions correctly. also to keep track of how many people are with the bank.
The column width will remain set at its default width, which is usually 12.43 pixels. If you type something longer than that, it will appear to spill out into the neighbouring cell if it is empty, or appear truncated if there is something in the next cell.
