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
When a delimited file is imported into Excel fields become?
Different fields will go into columns in the spreadsheet. Records would go into rows in the spreadsheet.
If you want to compare the contents of cell A1 on Sheet1 to A1 on Sheet2 and put an X in cell B1 on Sheet1, then in cell B1 on Sheet1 you would put the following formula:
=IF(A1=Sheet2!A1,"X","")
Use the Paste Special facility. From there you can then choose to paste the values, rather than the formulas.
Which button would you click to preview the text before printing?
One ways is to press Alt then F and then V. You can also click on the Print Preview icon, which looks like a page with a magnifying glass over it.
how am i surpose to no?? go on the internet and find out for your self !!
How do you display Excel data on an LCD TV and have the data scroll from left to right?
all you need is a hdmi cable or vga cable based on the port that is supported in your PC (hdmi is latest and provides high visual quality and in addition it will also transmit audio whereas vga will transmit video only).
Press function and f4 in the keyboard to project on the lcd screen as external monitor. In lcd tv, you have to select PC source as input to view the excel spreadsheet.
Maximize the excel window and you should be seeing vertical and horizontal scroll bars. Sometimes, the horizontal scroll bar is shrunk, you may have to resize the list of tabs shown on the bottom left to view the horizontal scroll bar in the bottom right of the excel window pane.
Hope it helps!
How do you print odd pages and even pages in MS Excel?
MS Excel does not have the ability to selectively print odd or even pages. You need to use the function on your printer for that option. When you print from Excel, instead of just clicking the print button, select print and click on the printer PROPERTIES button. If your printer has the ability to selectively print odd or even pages, you will select that option according to your printer's specifications.
You may mean the cells in Excel. They are where a column and a row intersect. They are the main components of a spreadsheet.
To enter a blank line into a document press the key without typing any text on the line?
Either the enter key or the tab key
How can you calculate an age with a date to date range in Microsoft Excel?
Say the dates are in A2 and A3, with A2 being the earlier date. If you want their age based on the last birthday, no matter how close the next one is, you could use the following formula:
=INT( (A3-A2)/365.25)
How are new rows inserted The selected row and existing rows shift accordingly?
New rows go where the currently selected rows are and the existing rows are pushed down. So if you selected row 3 and inserted, there would be a new row 3 and what was row 3 would now be row 4, with all rows below it also being pushed down.
What is the formula to multiply and add a cell in Excel using hlookup?
The HLOOKUP function searches for value in the top row of table_array and returns the value in the same column based on the index_number. It has nothing to do with multiplying or adding cells, unless you use the results in some kind of calculation. If this does not answer your question, please ask a more specific question. If you want to know about both multiply and add, ask two questions--one for each subject.
Socio-Economic TAB
What would be the result of trying the function INT(RAND)(5) into cell B1?
what would be the result of typing the function =INT(RAND()*5) into cell B1?
Can you make a cell flash in excel?
Apparently not. You really should suggest it to Microsoft though.
How do you add text files to a MS Access database?
There are two methods to add a text file to a MS access Database.
1) Link the text file. Go to File/Get External Data/ Link Tables. In the link file screen change the file type to Text file and then browse to the text file and select your text file. MS Access will prompt you to give the specs of the file when you are linking it. 2) Import the file to an access table. Go To File/Get external Data/ Import. In the screen change the file type at the bottom to text, and select your text file.
- A piece of paper with rows and columns for recording financial data for use in comparative analysis.
- Computer Science. An accounting or bookkeeping program that displays data in rows and columns on a screen.
- A spreadsheet is an interactive computer application program for organization and analysis of information in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets.
A computer Spreadsheet package like Excel can add up the rows and columns for you. If you want it can multiply for instance column one by column two. So if col 1 were entered quantities and col 2 were entered prices then col 3 could be the calculated values.
A spreadsheet is a grid that is filled in with information. Most commonly, they're used to keep track of finances. The Microsoft program "Excel" will help you make spreadsheets.
A screen-oriented interactive program enabling a user to lay out financial data on the screen.
it is a computer application that simulates a paper
It is a excel document or something that you can make graphs or put info using a table to organize your information.
a screen-oriented interactive program enabling a user to lay out financial data on the screen
What excel formula allows to breake a word into two pieces?
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
There are several functions which allow you to manipulate text by taking part of them out, like LEFT, RIGHT and MID. If you wanted to separate a word into two parts and have a space in between, you could use them. It would be important to know the length of a word. You can use the LEN function to find that out. The following function will split a word in half and show each half with a space in the middle. If there are an odd number of letters, the first part will be one letter shorter than the second part. A1 is where the original word is. You can change the A1 if your word is in a different cell
=LEFT(A1,LEN(A1)/2)&" "&RIGHT(A1,LEN(A1)-INT(LEN(A1)/2))
Is GV51372 a valid cell named in an Microsoft Excel?
Yes it is. It is the cell in column GV and row 51372.
Why important to have standard text code?
standard text code is important because it would enable any programmer or programme to use the same combination of numbers to represent the same individual pieces of data.
