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
The Home Purchase Worksheet is designed to assist a buyer with the purchase of a personal residence. The worksheet leads the buyer through a section that allows the buyer to state his or her preferences, including price, location, style, and size of the residence.
For buyers who expect to finance a portion of the purchase price with a lender, the worksheet also analyzes the buyer's cash flow and net worth. The program then uses these factors to calculate estimates of the optimal purchase price and a suggested mortgage payment. In addition, the buyer can enter the loan terms (for example, interest rate, loan amount, number of years, "points") proposed by various lenders and the program compares the loan terms to determine which proposal offers the most economical terms.
The worksheet also offers a closing costs schedule to track the various costs that will be included as part of the purchase of the residence, including loan fees, credit reports, commissions, title fees, property taxes, insurance, and recording costs. An optional progress chart allows the buyer to monitor the progress of the real estate agent and the lender.
What does save mean in Microsoft excel?
Save does just that and saves the file so you can use it later. You can save the file to my documents, a USB stick or anywhere on your computer.
Word files are usually saved in either .doc or .docx format
What defines the color of characters in excel?
The cell format and font format.
The following is a very simple macro that will change the font in the selected cell to blue:
Sub Make_Blue
'
With Selection.Font
.Color = -4165632
.TintAndShade = 0
End With
End Sub
From the macro, you can see that the VB definition of color is numeric and is stored as Font.Color.
How are inserted columns placed in Excel?
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
By default, they go where the selected columns are, pushing the existing ones to the right.
What is the total number of rows and columns required in a table?
How ever many you need to display your data. Only you can determine how many rows and columns you will require in a table you design.
What is used for cutting and correcting formulas in Microsoft Excel?
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
Auditing is a facility that can help to check formulas. Evaluation of formulas is another facility used to help find the problem in a formula. Errors can also be detected by error messages.
What overrides the order of operations in Excel?
Anything in brackets is done first. Then power of, in other words exponetiations, like 10². After that, multiplication and division have equal precedence and are done left to right in the order they come. Finally addition and subtraction are done in equal precedence to each other. A simple acronym for all of this, using the first letter or each operation, is BOMDAS. That will help you remember. See the related question below for more detailed examples.
What does Print Preview mean in Excel?
Print Preview in Excel allows you to see how your worksheet will look when it is printed. So it would show a page and what will fit on it. The data may be on several pages and this would be shown in the Print Preview, so you could see what appears on each page without actually printing it. This can allow you to change the document and move some data so it appears on a different page.
What is Invoice.xlsx in Excel document?
An invoice is a document sent by someone selling something to the purchaser, outlining what they have ordered, how much they owe and when they have to pay it. You can use a spreadsheet to easily create an invoice and do calculations on it. It is one of many kinds of documents that you can create with a spreadsheet.
How do you create a border in Microsoft office Excel?
The cell borders, which you see when first opening an excel page will not appear on print preview or on paper. They are there by default, so you can tell which cell you are entering your data into. In order to see any borders, you have to create them yourself with the border tool.
What are control charts used for?
Control charts (also commonly called process-behaviour charts or Shewhart charts) are charts which are used to find out if a business or manufacturing process is in a state of statistical control. They were invented by Walter A. Shewhart in 1920.
What are keywords in a spreadsheet?
There are potentially a huge amount. Here are just some:
Worksheet.
Workbook.
Electronic.
Software.
Computer.
Cell.
Formula.
Function.
Row.
Column.
Absolute.
Relative.
Table.
Grid.
Copy.
Autosum.
Charts.
Data.
What toolbar in word contains commands related to changing the appearance of text in a document?
The formatting toolbar.
The formatting toolbar.
The formatting toolbar.
The formatting toolbar.
The formatting toolbar.
The formatting toolbar.
The formatting toolbar.
The formatting toolbar.
The formatting toolbar.
The formatting toolbar.
The formatting toolbar.
How are columns identified in an Excel worksheet?
Columns are identified by letters. After Z the next one is AA, then AB then AC and so on. After AZ comes BA, then BB, then BC and so on. Rows are identified by numbers. Where a row and column meet you get a cell, which is identified by its column letter and row number. So the cell where Column D and row 14 meet would be cell D14.
What can you assign to a cell so that Excel will calculate the result?
A formula. All formulas must start with the equals sign. You can also use functions. As an example, when you open the Microsoft Excel and you type up the numbers you want to calculate, you can select the cells that contain the numbers. After doing this, go to the toolbar and press 'Formulas'. There will be an option called 'AutoSum'. Press that and you'll see a subheading called 'Sum' with the sigma, which is similar to "E". The total will appear on the next cell available. Like this you can average numbers and you can identify the minimum and maximum number in your list. You can also choose other functions.
Why is VLOOKUP function used moere often than other lookup functions?
Vlookup is used when you are using a table and want to go to a certain column in that table, as your data is arranged vertically. Hlookup works on horizontally arranged data when you are looking for something on a certain row.
When the fill handle is used to copy a cell to an adjacent cell?
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Yes. You can use it to copy one cell, but also to copy a range of cells.
Why does a spreadsheet contain a label value and formula?
They are three fundamental elements. Spreadsheets are for numerical analysis and manipulation. So you need to have values to manipulate. The values are usually identified by having labels. Formulas can be used to manipulate them. So you might have a some prices you want to get a total of. You would put the prices in, which would be your values. To help you and others know what this list of numbers is, you might have a label at the top of them that says Sales. Then you would have a formula to total the sales. It too might have a label to indicate that it is a total.
Data is information that is stored in any spreadsheet program such as Excel. Data is stored in cells in a worksheet. In addition to being stored in the spreadsheet, the data can be used in calculations, displayed in graphs, or sorted and filtered to find specific information. There are three types of data in Excel: values, labels, and date/time. Examples: To help keep data organized in a worksheet, enter data into rows from left to right. Each row of data should have a heading on the left identifying what the data is.
What key to used in Excel for a range of cells?
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
The Shift key and any of the arrow keys can be used. The F8 key and arrow keys can also be used. Using Shift when working with F8 can also allow you to select multiple ranges.
What separates a worksheet reference from a cell reference?
An exclamation mark. To refer to cell B56 on Sheet3 you would do this:
=Sheet3!B56
What is the purpose of quick access toolbar and what can you put on it?
It's called the Quick LAUNCH Toolbar and its to the immediate right of the Start button.
