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
How are data classified according to source?
Data can be classified according to source into primary and secondary data. Primary data is collected firsthand by the researcher for a specific purpose, such as surveys or experiments. In contrast, secondary data is obtained from existing sources, such as books, articles, or databases, which were originally collected by someone else for a different purpose. Understanding the source of data helps assess its reliability and relevance for research or analysis.
Excel formula from date to day?
You can use the WEEKDAY function, which will give a number from 1(Sunday) to 7(Saturday), to indicate the day of the week. So say your date was in cell A2, then the function could be put into another cell, like this:
=WEEKDAY(A2)
You can also format the date to show the day in different ways. See the related question below.
P stand for purpose
s stand for survey
q stand for qustion &
5r stand is reding selectively, resciting, recording, reflecting and reviewing.
All vehicles have an oil pressure sensor, it is usually located on the engine block on the exhaust side.
How do you link the quantity to effect the price on Excel?
On excel i am trying to link it so that when i change the quantity, the price will be increased as at the moment all that happens is the quantity will go up without effecting the total cost
How do make an times table on Microsoft Excel?
Enter one set of numbers in a column and another set of numbers in a row at the top of that column, so that the numbers you want to multiply intersect at a column and row.
EXAMPLE:
In A2 enter 2.
In B1 enter 3.
In B2 enter =A2*B1 (observe the answer 6)
TIP: If you want to be able to enter the formula only in the first intersecting cell of the row, then copy the formula to all the rest of the cells in the row, use the formula =$A$2*B1. That will make A2 and absolute reference that will not change as you copy the formula to other cells in the row, but will automatically update B1 to C1, D1, etc.
Can Excel cells formatted as dates be used in calculations?
Yes they can be. A lot of calculations are done on dates, like finding out how may days there are between two dates.
What button lets you copy text into a cell instead of inserting the next higher number?
You can type whatever you want into a cell. You do not have to enter numbers.
How would you troubleshoot a formula that is giving you an error?
Often the best tool to use is the 'Evaluate formula' option. You can watch as each step of the formula is carried out and you hopefully will then be able to notice when it does something unexpected. You can then go back to your formula and correct it.
Click on the help icon and search for 'evaluate formula' for further information.
Feel free to message me with the formula and the problem if you are still stuck!
What is a default viewin Excel?
A default filename is a name given to a file if you do not choose your own. In Excel the first default filename used is Book1.xls and your file will be called this if you don't specify another one.
What is enclosed in parentheses in a formula with a function?
The arguments of the function are contained in the brackets of the function. For example:
=Sum(A5:B10)
All functions have brackets, though not all need to have something in the brackets. For example:
=Now()
Formulas can also have brackets to change the precedence of operators. See the related question below.
How do you automatically resizes the column to fit the width of the column's contents in Excel?
You can adjust column width by dragging the right border of the column header (where the column letter is), by selecting Width from the Column sub-menu of the Format menu and typing the new width in average number of characters in the standard font, or by selecting Auto Fit Selection from the same sub-menu.
The difference between selection sort and insertion sort is simple: selection sort is an in place sort, while insertion sort builds the sorted array one element at a time.
Selection sort:
[10, 6, 1, 23, 56, 22, 3, 17]
[1, 10, 6, 23, 56, 22, 3, 17]//1 is placed in its final correct position
[1, 3, 10, 23, 56, 22, 6, 17]//3 is placed in its final correct position
[1, 3, 6, 23, 56, 22, 10, 17]//6 is placed in its final correct position
[1, 3, 6, 10, 56, 23, 22, 17]//10 is placed in its final correct position
[1, 3, 6, 10, 17, 56, 23, 22]//17 is placed in its final correct position
[1, 3, 6, 10, 17, 22, 56, 23]//22 is placed in its final correct position
[1, 3, 6, 10, 17, 22, 23, 56]//23 is placed in its final correct position
Insertion sort:
[10, 6, 1, 23, 56, 22, 3, 17]
[6, 10, 1, 23, 56, 22, 3, 17]//The first two elements of the list are correctly sorted
[1, 6, 10, 23, 56, 22, 3, 17]//The first three elements of the list are correctly sorted
[1, 6, 10, 23, 56, 22, 3, 17]//The first four elements of the list are correctly sorted
[1, 6, 10, 23, 56, 22, 3, 17]//The first five elements of the list are correctly sorted
[1, 6, 10, 22, 23, 56, 3, 17]//The first six elements of the list are correctly sorted
[1, 3, 6, 10, 22, 23, 56, 17]//The first seven elements of the list are correctly sorted
[1, 3, 6, 10, 17, 22, 23, 56]//The eight elements of the list are correctly sorted
What is used to display a dialog box that will move a chart to a different sheet?
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
The last stage of the Chart wizard does it when you are creating a chart. If you select and then right click on an existing embedded chart and click Location, you will get the option to move the chart.
fill formatting
Do rows run left to right and are labeled with numbers?
Yes, rows run left to right in most tabular formats, such as spreadsheets and databases. They are typically labeled with numbers to indicate their position within the table. This labeling helps users easily reference and navigate the data contained in the rows.
What operators perform mathematical calculations such as adding and subtracting?
The main four operators are:
Plus (+)
Minus (-)
Multiply (*) or (x)
Divide (/) or (÷)
What formula displays A2 times E5 E5 being an absolute cell reference?
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no special name for a formula with an absolute reference in it.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
You use the MIN with an IF and enter it as an array formula. So say you have regions North, South, East and West, in column A and values in column B. The regions can be repeated multiple times. So the function would be as follows to find the lowest for the North region:
=MIN(IF(A2:A25="North",B2:B25))
When you type it, then press Ctrl-Shift-Enter to put it in as an array formula, rather than just the Enter key.
Write an essay on Microsoft Excel?
Microsoft excel is a spreadsheet program developed by Microsoft corporation. There are different version of Microsoft excel with the latest being Microsoft excel 2010 which is boundled with Microsoft office 2010. Microsoft excel contains basic features of which all the spreadsheet programs have. It has worksheets which are a grid of cells. The grid of cell is arranged in rows and columns with the rows being referred to with numbers and rows with alphabetical letters. Microsoft excel has many wonderful features to offer the small business user. Excel is mosyt widely known for its spreadsheet function, though it has numerous other uses. Spreadsheets are useful to any type of small business. For example, spreadsheet can be used as an accountant's ledger or a professor's grade book. Invoices and budgets can be prepaired with excel and one might use it to balance a checkbook as well.
How do you lock the first row in excel so you always see the label?
Select cell A2. Then, on the menu bar, select Window, Freeze Panes.
