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
Use the Insert menu. First put the cursor where you want the new row or column to be. Better still, select the current column or row where you want the new one to be. So say you want to put a column between Column A and B. Select Column B by clicking on the B at the top of the column. Then go to the Insert menu and select Columns. It will insert the new column and move what was Column B to become Column C. If you are inserting rows, select the row header where you want the new row to be. You can also select several columns beside each other and insert several columns. So if you selected Columns B, C and D, it would insert 3 columns between A and B, and Column B would become Column E. It works the same for rows.
A row header are the numbers that run down the page to identify the row of cells that go across the sheet (horizontal cells). Columns are the headings that are at the top of the page and represent the cells that go up and down the sheet (vertical cells).
How do you freeze an excel cell?
You use the Freeze Panes option. When you do it, columns to the left of the active cell and rows above the active cell will be frozen. So if you wanted to freeze just the first column, you would make B1 the active cell before freezing the panes. To freeze just the first row, you would make A2 the active cell before freezing the panes. To freeze both the first column and first row, the you would make cell B2 the active cell before freezing the panes.
What is the leftmost column of a table called in Excel?
There is no special name. It would be column A. It is the first column. It could contain headings for each row.
What are the MSAccess database objects?
MS Access Database objects are: Tables, Queries, Forms, Reports, Modules, Macros etc..
What are the file extensions of Word Powerpoint and Excel files?
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
It is .docx for Word and .xlsx for Excel.
How can you put a counter in a vba project from excel?
There are various way to add counter in VBA code dim i as integer FOr i = 1 to 100 Cod you want to execute. Next i
It could be a list of text that has a number in front of it.
How do you calculate the sum on Excel?
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
You use the name of the sheet, followed by an exclamation mark and the cell reference. So if you were on Sheet2 and wanted to sum cells A2 to A20 on Sheet1 you would do this:
=SUM(Sheet1!A2:A20)
What is a way of showing your data on Excel in a pictorial form?
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.
Which one is more difficult Microsoft Excel or MS Word?
If you open it up and go to the help features you would have a hard time not understanding how to use it within 30 minutes. It really straight forward to do basic things. But like anything the more complex the usage the more complex the knowledge required to use it in that fashion. Overall It is fairly simple.
--edit I suppose that is assuming you have basic computer skills and are at least some what experienced in the usage of a computer and menus, biased on the ability to post this question it was assumed.
What do you use to calculate things in spreadsheets?
Every formula starts with equal sign =
If you want to display list of all functions in Excel from the upper toolbar select: Insert - Function.
How do you apply the accounting number format?
The Accounting format lines up decimal points to the right and currency symbols to the left in a column.
What does the auto fill feature do?
auto-fill on web browsers works by remembering what you have previously typed into the search boxes, and automatically filling the search box with your selection.
auto-correct (aka predictive text) on mobile phones uses a dictionary that is programmed into the phone and, based on what you've already typed, make a prediction as to what word your intending to type.
Google auto-complete (unbelievingly) works by anonymously sending what you type to Google HQ where a Google auto completer makes a prediction as to what your going to type, types it out and it goes back to your screen.
Can you select nonadjacent ranges using the shift key in excel?
No. You need to use the Ctrl key to select non adjacent ranges.
What does default mean in Excel?
The default settings are those settings that are automatically used when a program is run. For example, the default typeface in MS Word is Times New Roman and the default size is 10 point. Likewise the default paragraph spacing is single line, so if you wanted a double space between paragraphs you would have to hit Enter twice.
However, all default settings can be altered, so you could elect to have whatever typeface you choose, at whatever size you choose, with whatever spaces between paragraphs you choose.
What does excel do in insert mode?
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
It allows you to overwrite text when typing in a cell.
What key do you press on the TI-30X IIS to get an exponent?
If you are us using scientific notation, with the format (a x 10b), you'll need to look for a key with EE or EXP on it or above it, often as a second function for the key. It means ( x 10EXP). For example, 5 x 104 means 5 times 10 raised to the power of 4, which means 5 followed by 4 zeroes, which is 50000.
If you are needing an exponent to raise a number to a different power, use the caret key (^). 5^4 = 625
The symbol used to indicate the multiplication operation is?
Some people just use a simple x. Others will use the asterix * .
If you looks on your keyboard where the number pad is located, it has the addition subtraction multiplication and division keys marked on the top right four keys.
What is a surface chart in Excel?
A surface chart shows a three-dimensional surface that connects a set of data points. It is for when you want to find optimum combinations between two sets of data. The colours and patterns indicate areas that contain the same range of values. They are like maps showing hills and mountains and flat areas, indicating similar heights by using similar colours and giving a three-dimensional effect.
A sheet tab appears at the bottom of your worksheet. It has the name of the worksheet on it, which can be changed and you can also change its colour. This can be done by right clicking on it and picking the option from the shortcut menu that appears. By clicking a sheet tab, you can make that sheet the active sheet so that you can work on it. You can click on the sheet tab to move its position by dragging on it, or also from the shortcut menu.
How do you ensure that Excel interprets year values the way you intend?
You should type in the year using 4 digits when entering a date instead of entering just 2 digits for the year. This is because anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges. So, for example, if you want your date to be the 1st of January 1920, then typing 1/1/20 will not work, as it will treat it as the year 2020. So you need to type 1/1/1920 instead. You should also make sure the cell is in a date format.
Can you explain the application for using only one worksheet in business?
Business --> Balance Sheet
Personal --> Personal Budget
There are many situations that can use a single worksheet. Some of them are: Balance sheet, work schedule, application form, etc. Additionaly, all of those applications also can use multiple worksheets to accomplish the same function.
