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 do you use LEFT function in Excel?
It is used to extract a set amount of characters from the left of a cell. So for example, if you have the 12 months of the year in a column and wanted to just get the first 3 letters of each month, you could use the LEFT function. You specify the cell and the amount of characters you want. So if January was in cell A5, then to get Jan you need to specify cell A5 and that you want 3 characters from the left. To do this you would put this into another cell:
=LEFT(A5,3)
How in Excel can you select first 3 digits of a 5 digit number?
You can extract the first 3 digits using the LEFT or MID functions. EFT counts the amount of characters from the left of the cell. MID specifies where to start in the cell and how many characters to select. So if your number was in cell A2, you could do either of these:
=LEFT(A2,3)
=MID(A2,1,3)
It is a chart that plots the relationship between two paired sets of data, plotting one set of data from each pair on the horizontal (X) axis, and the second set of data from each pair on the vertical (Y) axis.
An example of a paired set of data you could plot using a scatter chart could be the average frequency a couple has sex relative to how many years the couple have been in a relationship.
A scatter chart can show the points by themselves or link them with lines, either straight or curved lines. This enables different kinds of charts to be shown, like bell curves or sine waves for example.
Excel rotates the chart 10 degrees in a direction each time you click the Increase?
This is a statement, not a question. Please ask again using words that make it clear what you what to know.
How do you enter an array formula?
After you enter your formula, press CTRL+SHIFT+ENTER at the same time. You will see the array formula displayed with brackets ({}) around it. If you type the same text, including the brackets and press just ENTER, you will not tell Excel the formula is an array and may display only text. You need to enter the formula, without the brackets, and press CTRL+SHIFT+ENTER to let Excel know it is an array.
See related links for more details about array formulas.
What feature enables you to change information already entered in a cell in keyboarding?
The ability to edit, but this has nothing to do with keyboarding, other than you can use a keyboard to edit a cell in Excel.
What are the functions of classroom displays?
The main functions of large classroom display screens are educational.
- Screens provide a classroom video projector allowing the teacher to access a huge range of online or off line video resources.
- Screens can be used to replace conventional whiteboards, allowing content to be created, annotated, saved, re-used and printed.
- Screens allow learners to interact with objects, to play educational games for example.
- Screens can be used for video conferencing, allowing classrooms to connect with remote experts, classes in other regions or even other countries.
Screens that are not interactive are harder to use for educational purposes. They are often used to support a 'talk and chalk' model of education or sometimes simply as
whiteboards.
How does a worksheet row heads?
Worksheet row heads, typically found in spreadsheet applications, are the numbered or labeled indicators on the left side of each row. They help users easily identify and reference specific rows, making data organization and navigation more efficient. Row heads often serve as a guide for data entry, analysis, and reporting within the worksheet. Additionally, they can facilitate functions like sorting and filtering data.
What is the definition of numerical analysis?
It is the study of algorithms that use numerical values for the problems of continuous mathematics.
How do you convert date to fiscal quarter in Excel?
There is no Excel format that will display a fiscal quarter for a date. However, you can accomplish this with a complex formula, using IF, AND, and DATE functions.
1) In cell A1 put a date and ensure the cell is formatted for date. You can use any display format you like, as long as the cell is formatted as a date. For the purposes of this example, use the date 5/5/2010.
2) In cell A2 put the following formula:
=IF(AND(A1>=DATE(2010,1,1),A1<=DATE(2010,3,31)),"1st QTR",IF(AND(A1>=DATE(2010,4,1),A1<=DATE(2010,6,30)),"2nd QTR",IF(AND(A1>=DATE(2010,7,1),A1<=DATE(2010,9,30)),"3rd QTR",IF(AND(A1>=DATE(2010,10,1),A1<=DATE(2010,12,31)),"4th QTR"))))
3) Observe cell A2 displays 2nd QTR and will adjust based on the date you enter in cell A1.
4) Change the fiscal quarter names to whatever you like, and modify the formula for your specific application.
NOTE: This formula does not have any error handling, so you will receive a response of FALSE if your input date is not a valid date. You could add another IF statement at the end of the formula to display a more helpful error message.
----
ALTERNATIVE OPTION NOT LIMITED TO A SPECIFIC YEAR WITHIN FORMULA
DISPLAY THE CORRESPONDING QUARTER FOR A DATE WITH FORMULAS FOR COMMON FISCAL YEAR BEGINNING MONTHS:(FORMULA PRODUCES: "Q#")
January
="Q"&FLOOR(((MONTH($A2)+2)/3),1)
April
="Q"&IF(FLOOR((((MONTH($A2)+2)/3)-1),1)>0,FLOOR((((MONTH($A2)+2)/3)-1),1),4)
July
="Q"&IF((((MONTH($A2)+2)/3)-2)<1,FLOOR((((MONTH($A2)+2)/3)-2)+4,1),FLOOR((((MONTH($A2)+2)/3)-2),1))
October
="Q"&IF(FLOOR((((MONTH($A2)+2)/3)-0),1)<4,FLOOR((((MONTH($A2)+2)/3)-0),1)+1,FLOOR((((MONTH($A2)+2)/3)-3),1))
FORMULA FOR DETAILED FORMAT (FISCAL YEAR STARTING JULY 1)(FORMULA PRODUCES: "FY2012-13 Q3")
="FY"&IF(MONTH(A2)<7,YEAR($A2)-1,YEAR($A2))&"-"&RIGHT((IF(MONTH(A2)<7,YEAR($A2)-1,YEAR($A2))+1),2)&" Q"&IF((((MONTH($A2)+2)/3)-2)<1,FLOOR((((MONTH($A2)+2)/3)-2)+4,1),FLOOR((((MONTH($A2)+2)/3)-2),1))
[Above formulas refer to date in cell A2]
yes
I have a 16 guage Excel single shot. At the base of the trigger guard is the # 90425XG. It was given to my father-in-law about 70 years ago. Other than that I don't know the exact age of the gun. -- Montgomery Wards -- EXCEL was a trade name used by Montgomer Wards on shotguns they retailed c.1900-1920. Some of the shotguns were made by Iver Johnson, some were sold to Wards by H&D Folsom (and were probably Crescent manufacture).
How can text transfer from capital to small in excel?
You need to use the LOWER function and put the cell reference or text in the brackets:
=LOWER(A1)
=LOWER("I WANT THIS TO BE IN LOWER CASE")
Is there a way to globally change the year in a multi-sheet spreadsheet that contains many dates?
If it is the same year that you want to change from then it can be done one year at a time. You can do individually by sheets, as outlined here, or globally using a Macro, outline later in this answer. So say you wanted to change all the dates with 2007 to 2009, then you would do the following. Open the Edit menu and pick Replace, or press and hold the Ctrl key and press H. In the Find What box type 2007 and in the Replace With box type 2009. Note that this would also change any cells with the value 2007 or the digits 2007 as part of another value like 20075 in them and also any text with 2007 in it. So it is something you need to use with care.
If you want to do it all at once across all worksheets then you need to use a Macro.
On the Tools menu in Microsoft Excel, point to Macro, and then click Visual Basic Editor. On the Insert menu, click Module. Type or copy the code into the code window of the module. If you want to run the macro from the module window, press F5. When you're finished writing your macro, click Close and Return to Microsoft Excel on the File menu. By pressing Alt-F8 you will get the Macro menu and you can run the macro from there. You will need to edit it for different years. The same precautions, in terms of other things that may also be change will apply here too. It would be advisable to make a copy of your workbook first, before trying this in case it is not exactly what you want. The code would be as follows:
Sub DateChanger()
'
' Macro to change dates on all sheets
'
Dim wsh As Worksheet
For Each wsh In ActiveWorkbook.Worksheets
wsh.Select
Cells.Replace What:="2007", Replacement:="2009", LookAt:=xlPart, _
SearchOrder:=xlByColumns, MatchCase:=False
Next wsh
End Sub
What is the home keys in Excel?
Home keys moves the current active cells to first column of current row.
