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 kind of excel function is ROUND(AVERAGE(A1A100)2)?
=ROUND(AVERAGE(A1:A100),2)
The answer you may be looking for is a nested function, as one is inside another. ROUND is a math function and AVERAGE is a statistical function.
Can an application like EXCEL normally export spreadsheet data to a database application?
Yes you can. Spreadsheets are normally laid out in columns and rows with headings, like you would have fields and records in a database. With that structured layout, data in Excel can easily be exported to various database applications. There are various approaches you can take, like directly exporting them or saving the data as a text file and opening it for importing into a database.
What kind of application software is Excel?
Excel is a type of applications software/. All applications software need an operating system to run on. Different types of computer will have different operating systems. Most commonly Excel is run on one of the Windows operating systems like XP, Vista, 7 or 2000. The version of Excel you have will determine what operating systems it can run on. Excel can also run on other types of computers that do not have a Windows operating system, like a Macintosh.
How do you edit an Excel spreadsheet received on your Excel computer?
Your email suggest that you have received an MS Excel file which you want to edit. Kindly check if you have MS Excel software Installed on your computer. if you have that on your computer than you may double click on MS Excel file to open and edit it. Also, if you just want to view file that you may download MS Excel viewer from Official Microsoft website(Its free). If you wish to learn MS Excel than there is lot of resources available on internet.
What is a series of data used to create a chart called?
It is called the source data.
It is called the source data.
It is called the source data.
It is called the source data.
It is called the source data.
It is called the source data.
It is called the source data.
It is called the source data.
It is called the source data.
It is called the source data.
It is called the source data.
What removes all the data in a cell?
There are lots of ways, but the easiest is to press the Delete key.
What is displayed when a new document is opened in Excel?
A blank workbook called Book1.xls with 3 worksheets and opened on Sheet1.
What is Excel sheet reference?
As a workbook can have multiple sheets there are occasions where you would be referring to data on different sheets from each other. It is then a requirement that you specify which sheet you are referring to. So there needs to be a sheet reference along with a cell reference. This is done by having the name of the sheet followed by an exclamation mark, after which you can have the cell. The cell A6 on Sheet2 would be referred to as follows:
Sheet2!A6
Do landlords use spreadsheets?
Yes. It can be used by business people and almost anyone, so lots of landlords would use a spreadsheet.
What is one of the guidelines for good workbook and worksheet design?
Test all of your formulas to ensure they are accurate and reflect what you what to show.
In Spreadsheets what is a chart?
A chart is graphical representation of numeric values. It's useful when you want to analyze changes in business income or sales percentages.
How on Numbers for Macs can you make your own blank spreadsheet?
From the Numbers File menu select New From Template Chooser.... And then select the Blank spreadsheet template.
What Formula in Excel convert lbf to Newton?
If the lbf value was in cell B2, then the formula to convert it to Newton would be:
=B2*4.44822162
How do I retain Excel cell formatting during mail merge into a table in Word?
Merge brings one to several individual cells from Excel into Word. The formatting in the merged Word document depends on Word, not Excel. If you would like to retain the same formatting as you had in Excel, then format the target location in Word to match the cell from Excel.
How do you format cells as percent?
Click on the cell you want to format. In the Standard toolbar select Format then Cells. In the window that opens click on the Number tab then select Percentage from the list displayed under Category:. Enter the number of Decimal places you want (the default is 2) then click OK.
Which excel function can be used to find an answer located in a vertical table?
VLOOKUP is the name of the function you are looking for. There are other ways of doing it, like using INDEX and MATCH together, which is the way some people prefer to do it.
In Microsoft Excel functions can be entered using what?
You can enter them by just typing them in with the keyboard. You can also use the Insert Function facility.
How do you add a zero automatically to east coast zip codes in excel?
You don't add the zero automatically, but you can display a leading zero by beginning the input with an apostrophe (') to indicate that you want to display text, instead of a number.
There is a divider between the worksheet tabs section and the horizontal slider section. Click and drag the divider bar to the left to reduce the space allowed to display worksheet tabs and to the right to increase the viewing area of the worksheet tabs.
It is because it represents 180 degrees of a wavelength. every 180 degrees the impedance on a transmission line repeats itself
Does The insertion point move in a Word document when the PageUp or PageDown keys are pressed?
it will not hurt you if you try,if you asking yourself will somebody answer,yes i answered
Does field indicator separates imported data into columns?
A field indicator or a delimeter, as it can be called, can be used to indicate where fields end. In a spreadsheet or a database it can be used a guide when importing data to help put it into the correct columns.
