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
Version of a worksheet that allows you to display the actual formulas instead of the?
On the Toolbar click "Help". Type "Display or hide formulas" Find :
Switch between displaying formulas and their values on a worksheet- Press CTRL + ` (grave accent).
What button in excel allows you to copy values with or without formatting or the format only?
Copy the values by either highligting the cells and clicking copy or by highlighting the cells and using the keyboard shortcut of ctrl+c ( apple users apple + C) then paste the copied data into its new location. When pasting the data right click in the designated cell or use paste special and select the formatting of your choice Values only, values with source formatting or values with destination formating.
What are two ways to change the width of a column in Excel?
- Format the colun for the width you want. Under the format option, select column width.
- Put your cursor on the line between the column headings (letters at the top of the window), left-click and drag the column to the width you like.
- Format the cell for auto-width and the column will automatically adjust to the width of the largest cell entry in the column.
What industries use Microsoft Excel?
Business owners, teachers, and office workers and other types of people who do computer work for businesses (like tracking expenses, etc.). For them, Microsoft Excel is a staple.
+++
It is not merely a book-keeper's tool. It is also very useful for scientific and engineering calculations, with the understanding that its programmers cannot understand scientific graphs properly! (How many degrees are there in a circle, Mr. Gates?) You can for example write basic mathematical models in which you can observe all the numerical consequences of changing any one variable.
This would be a database. Properly termed, the rows are records and the columns are fields. A spreadsheet, though used frequently as a "poor man's database," is properly used for calculations such as a profit and loss statement or a balance sheet for a business.
So, the question that may be asked is, why is Excel (a spreadsheet program) often used for database-like display of data? The reason is that there are few easily-found basic database programs available nowadays. One of the last that I have often used with clients was the database feature in Microsoft Works. However, Works 9.0 was the last version and that was released back in September 2007. The program is no longer under development.
Most database programs produced today are relational databases, such as Microsoft Access, MySQL, Microsoft's MSSQL, etc. Those are beyond the needs of most folks who want to have a simple flat database such as a personal address book or an inventory of their DVDs or music CDs. The power of a relational database is its ability to associate various types of data by certain relationships.
To explain, consider a college. There are various sections of, say, English 101. Each has the same course description and curriculum but the location, time, and instructor changes from one section to another as do the enrolled students, their grades, majors, etc. So, how is all this handled? Each section of English 101 is given a certain identifier. All students also have their own identifiers (such as a student number). So, when the student enrolls, rather than duplicate the student's name, address, phone number, email address, and other information, a table is produced in which the student's identifier and the section's identifier are referenced. This way, when someone wants to gather a student roll for the section, all the database has to do is find those in the table who have that section's identifier and then use the student numbers to build the required report with all the students' information.
To take this further, if someone wished a report on all the courses that the student had completed with a grade above a C, then the database could be queried for all records for the student number and then filtered by the grade field so that only the courses matching that request would be displayed.
This is the power of the relational database and is great for those who want or need to make use of it but, as I said, that is typically beyond what the typical end-user needs. Since there are so few flat database options available nowadays and Excel is readily available since it comes with every edition of Microsoft Office (specifically, Home and Student, Home and Business, and Professional), it is used as a poor substitute. It does not have the capability to perform searches such as a true database nor can it provide reports such as either a flat database or relational database allows. It is only a convenient way to provide a similar look without the functionality. For those who need only to display the data in a static format, such as a chore chart for the kids or a work schedule for the staff, this works well enough but it is by no means a database.
What are the advantages of protecting an Excel worksheet?
Protecting an Excel worksheet helps to prevent other users from accidentally adding ,changing, moving, deleting or modifying data or information in a worksheet and than protect it with a passwoord so that other user can't open and access it.
What must you type to start off a formula in Excel?
Excel formulas begin with an equal sign, for example:
=SUM(A1:A7)
will give you the total of the numbers in cells A1, A2, A3, A4, A5, A6 and A7.
Array formulas start with = but are enclosed in brace bracket{}.
You can also use the plus or minus sign to start a formula, but as soon as you press Enter, a plus will be converted into an equals sign and a minus sign will have an equals sign inserted before it, so the formula will still show as starting with an equals sign.
+5+7 will become =5+7
-10*2 will become =-10*2
Lotus 123 was the big spreadsheet application before Excel. It used the @ sign to start its functions. In order to help people moving from using Lotus 123 to Excel, the ability to start functions with the @ sign was included in Excel, and you can still do that. This applies only to functions at the start of a formula, not any formula.
What is the full form of PPMT in Excel?
It is the Principal Payment function. It returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
PPMT( rate, per, nper, pv, fv, type )
Rate is the interest rate per period.
Per specifies the period and must be in the range 1 to nper.
Nper is the total number of payment periods in an annuity.
Pv is the present value- the total amount that a series of future payments is worth now.
Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
Type is the number 0 or 1 and indicates when payments are due.
It will change relative addresses when the formula is copied, but not absolute cells or mixed cells. See the related questions below.
What is MS Excel extension name?
Excel files are usually .xls
In Office 2007 Excel files that are single pages are still .xls while workbooks (more than one page) are .xlsx
There are other extension for documents that are web pages in Excel, documents that have macros enabled and other such things. To find out, go to your Excel program and click "save as"
When the menu comes up, click on the pull down menu "save as type"
You will be able to see all the different options there.
What function is useful when you want to add values in a range only if they meet a criteria?
The SUMIF function.
Are Microsoft Excel and OpenOffice Calc are examples of spreadsheet software?
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Yes, they are both electronic spreadsheet programs.
Conditional Formatting
You can do a simple copy and paste. You can save a file into different formats and then import them into other applications. Some things can be very easily converted for Excel, like different kinds of tables in Word and Access. Powerpoint gives the facility to create simple spreadsheets like Excel ones. You can enter links into the different applications and have them automatically updated when the various applications are opened so that data can be shared.
What function would you use to find the mean in a Microsoft Excel document?
The AVERAGE function returns the average (arithmetic mean) of the numbers provided.
=AVERAGE(number1,number2,...number_n)
number1, number2, ... number_n are numeric values. They can be numbers, named ranges, arrays, or references to numbers. You can enter up to 30 values.
What are the three steps in the worksheet planing process?
WA kind of answer .com don't have answers on it . the thing making you write yyou own answers
Each column has a set width when you start. As you type text into different cells, some of that text will be too wide to fit into its cell. Different pieces of text are different widths. If you looked down a column, it would have to be made wide enough to allow the longest piece of text fit in a cell. At the top of each column there is a letter to identify it. If you put the cursor on the dividing line between it and the next column header, the mouse pointer will change to a double arrow. If you then double click it will then find the longest piece of text or other data in the column and adjust the column width so that it fits perfectly into it. If the text is wider than a cell, then the column will widen out to fit it. If it is narrower, the column width will reduce its size to fit it.
How can you select nonadjacent ranges of cells?
Select your first range in the normal way. Then press and hold the Ctrl key and with the mouse select the next area. The original area will remain selected. If you do this you can select cells that are non adjacent.
A less common way to do it is using the F8 key. Put the cursor in the first cell. Press the F8 key. To select several adjacent cells use the arrow keys. To stop the selection press F8 again. To stop the selection but retain the selected cell and move to a non-adjacent cell to select again, press and hold the Shift key and then press F8. Go to the cell you want using the cursor keys and then press the F8 key when you want to start selecting again. You could also just drag the mouse over different areas of the worksheet having pressed Shift and F8, in the same way as you can with the Ctrl key.
Within a formula cells that are not adjacent can be specified by listing them with a comma in between them. Ranges are specified with colons. It is possible to use both:
=SUM(A1:A20,B16,C45,D11:D13)
Is Microsoft Access better than Microsoft Excel?
Both Excel and Access are capable of doing a lot of things that the other can do. Excel is a spreadsheet application and Access is a database application, so they are used for different things. They are different kinds of applications so they cannot be compared in full, only on certain things. If you want to do a lot of databasing things, while you can do them in Excel, Access is better for it. If you are doing a lot of calculations, then Excel is better although Access can do calculations too. So it depends on what you want to do.
Which element of an Excel worksheet display cell address and includes the column letter and row?
The Name Box will show the address of the current cell that is active.
How do you print a Microsoft Excel?
There are various ways to print an Excel file. From the file manager (explorer), select the file, right click and choose print Open the Excel file - Press Ctrl + P to print - Choose File from the top menu, Click Print - Click the Printer Icon from the Toolbar Hope this helps Rohini
