What are 3 ways other than words to represent a function?
Input/output table, Equation, or some type of graph
What is the name for the cell you are currently working in?
The cell you are currently working on is the active cell.
What lets you create pyramids in excel?
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
You can draw them with the shapes or create them with the Smart-Art facilities.
How can you convert QPW files to XLS files?
Some of the Quattro pro file formats are supported by Microsoft Excel. Here's a list - http://support.microsoft.com/kb/147643/EN-US/ Also on the page linked above you'll find a link to supplemental converters that may be of use.
Can Microsoft Excel find moving average?
Yes it can. Say you have you values listed from cell A2 to A20, then in B2 you could enter the following formula and copy it down and it would get your moving average:
=AVERAGE(A2:A$2)
What is back stage view in Excel?
Backstage includes the commands for doing things like creating, saving, opening, printing and sharing sheets. On older versions of Excel, these would have been on the File menu.
The Criteria Range is a range of cells that hold cells from which criteria are tested for functions in Excel.
When the Mini toolbar initially appears what color is it?
Depends on what version of excel you are using.
Why are Excel spreadsheets called book1?
The default file name for an MS Excel workbook is book1. I suppose because the programmer decided book made sense for a workbook and the 1 represents the first one you save. You can change the file name to whatever you like.
In excel a dot on the screen that contains color is what?
In any computer application, a dot on the screen is called a pixel.
What do you mean by payroll in ms Excel?
Payroll involves keeping track of pay owed to employees in exchange for work. The meaning related to MS Excel depends on the context. If someone says, "I do payroll with Excel," they most likely mean they keep track of employee's time, taxes, and other data to generate information needed to create a paycheck.
How do you switch in XL sheet from one tab to another tab?
You can either click on the tabs with the mouse, or you can hold the Ctrl key and hit the Page Up key or Page Down key, depending on which way you are going through the sheets.
What is a embedded object in a spreadsheet?
An object is something that is controlled by another application. You copy an object to excel to display the object in the spreadsheet, but the underlying application comes up when you double-click to edit the contents of the object.
Which view do you use when you want to adjust the margins in a document in the word program?
web, or print, look at Page Layout tab for Page Stup section and locate Margins, then press triangle below and choose option, if you want manually to adjust then in View tab click before Ruler to display Ruler select text you want to adjust or place insertation point in paragraph, then click on triangle on Ruler and move it
What symbol concatenates two text items in excel?
The & symbol.
The & symbol.
The & symbol.
The & symbol.
The & symbol.
The & symbol.
The & symbol.
The & symbol.
The & symbol.
The & symbol.
The & symbol.
Can you use cell background color in a COUNTIF statement in Excel?
Not directly. You could set a list of cells that indicate the colours of other cells and then could count them. So for example, in the cell beside each cell that is red, put the word red, and then use the COUNTIF to count the cells that have the word red in them.
If the original cells have been coloured based on conditional formatting, you may be able to use the condition to count the cells too.
When will AutoCalculate will quickly add selected cells?
When worksheet cells are selected, a message displays on the status bar in the AutoCalculate box. AutoCalculate is not a substitute for writing worksheet formulas or functions. However, it is handy for making quick, temporary calculations that are not recorded on the worksheet. AutoCalculate can average, count, sum, and find the minimum or maximum number in a group of numbers. The default calculation is SUM. To use AutoCalculate, click and drag across the values you want to calculate. The sum of the values will display automatically on the status bar. To make a different type of calculation (for example, an average), right-click the AutoCalculate box on the status bar to display its shortcut menu. Choose the appropriate type of calculation.