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
Where possible you should always use cell references. It makes things a lot easier when you are changing or maintaining a spreadsheet. Even if you are using the exact same value in all of a set of formulas, you should put that value into one cell, and use an absolute reference in the formula to reference it. If formulas have cell references in them, then when figures change, you do not have to redo all the formulas. You just change the relevant figures and the formulas will all recalculate them.
Values.
What is a Table array in Excel?
An array is a list of related values of the same data type. Excel can deal with arrays and actually has some specialised array formulas. You can do things like in a single formula multiply corresponding values in two separate lists and total the result. You would type in the formula as normal:
=SUM(C10:C20*D10:D20)
Then press the Ctrl, shift and Enter keys, rather than just the Enter key. The formula will then appear with the braces around it to indicate that it is an array formula as follows:
{=SUM(C10:C20*D10:D20)}
That formula will multiply what is in C10 by D10, C11 by D11 and so on up to multiplying C20 by D20, and then total all the results in one single formula.
What are five examples of spreadsheet software?
Some examples of spreadsheet application software are the following:
- Openoffice.org Calc
- Microsoft Office Excel
- GoogleDocs
- Gnumeric
- Apple iWork Numbers
- Lotus 1-2-3
How does grouping work in Microsoft Excel?
Grouping can refer to taking blocks of data with similar headings and bringing them together. It can refer to selecting more than one worksheet at the same time. It can refer to grouping graphical items together into one item.
What action do you perform on a data source in order to merge only certain records?
You would do a Merge using conditions, normally with an IF command or by filtering the records. It will depend on the application for the merging and the source data as to how specifically you would do it, as there are various options.
How are page breaks indicated in page preview from Excel?
Lines show on the page to indicate where the breaks are.
A set of characters with the same designsizeand shape is called a?
A typeface is a set of characters with common design and shape (also called font).
font
Font.
font
What is the name of a spreadsheet for a nations economy?
There are thousands of spreadsheets used to track a country's economic condition. Perhaps you are thinking of Gross Domestic Product, a basic measure of a country's overall economic output.
Here is how you calculate GDP:
GDP = private consumption + gross investment + government spending + (exports − imports)
What sign must be typed at the beginning and end of cell locations in a formula?
An equals sign is needed at the beginning of a formula. There is no particular character needed at the end of a formula. A cell reference will begin with one or more letters and end with a number. If it is an absolute reference, it would start with a $ sign. A mixed reference will start with a $ sign or a letter.
A template is a master worksheet that includes the basic element for a particular type of worksheet that you are going to be using.
What are the steps for adjusting the columns width?
There are several ways to adjust column width in Excel:
- Select at least one cell in each of the columns you want to adjust, then select the funtion from the menu bar. In Excel 2007, it's Home/Cells/Format/Column Width. If you selected one column, or if all of the columns you selected are the same width, it will show the current width in the window. Type the new width you want then press Enter or click OK.
- Another way to access that same window from the Excel 2007 menu is to type Alt+H O W.
- The rest of these methods are good for any version of Excel. In the column heading, the box above the top cell of the column containing the column letter, position the cursor on the right edge of the box. The cursor should change to a short vertical line with arrows pointing left and right. Press and hold the left mouse button. You will see the current column width. While continuting to press the mouse button, move the mouse left or right to your desired column width, then release the button.
- If you select several entire columns then do the previous procedure on any of the selected columns, all of the selected columns will have the new column width when you release the mouse button. To select an entire column you click on the column heading. To select several, you can either position the mouse in the column heading, press and hold the left mouse button as you move the cursor horizontally to the last column you want to select, then release the button, or after selecting the first column click on the headings of additional columns while pressing Ctrl.
- To automatically resize a column to fit the cell of the column with the most contents, double click the right edge of the column's heading.
- If you select several entire columns then double click the right edge of the heading of any one of them, each of the selected columns will be fitted to its own widest cell.
What happens when you enter the formula G15 into a cell in excel?
If you just type G15 into a cell, it is not a formula but just a piece of text. If you put an equals before it, then it will display what is in the cell G15 when you type it into any other cell.
=G15
If you type it into G15 itself you will get an error known as a circular reference, because a cell cannot mention itself in a formula.
Is it possible to sort text data into alphabetical order in Excel?
Select all of the text that you want to sort. Then click the "sort ascending" button. This is a button with a blue A over a purpley red Z and a black arrow to the right pointing downwards. If you can't see this you might to change your settings to allow you to see the "tables and border" toolbar.
What do supermarkets use a spreadsheet for?
to pay enough money to the factories for their products that they buy from them to pay enough money to the factories for their products that they buy from themto pay enough money to the factories for their products that they buy from them
To instruct Excel to display a hidden column, position the mouse pointer to the?
to the right of the column heading boundary where the hidden column is located and drag to the right.
How are columns referenced in Excel worksheet?
In a macro, the cell at the intersection of the third column and the fifth row can be referenced as range("C5") or cells(5, 3). In the cells property, the numbers can be replaced with variables.
This is a true statement, but it is not a guestion.
How do you export data from access to excel?
Use the import function and select the spreadsheet you wish to bring in. You can create a new table in Access, or you can make sure the column headings match up and bring it into existing tables.
How do you copy an Excel report onto flash drive?
The same way you copy any other file to a flash drive.
How to sort data in spreadsheet?
You can sort your data by clicking on "sort and filter" you will see this option at the top bar. This will give you option to sort your selected data acceding or descending order, or you can temporarily filter out your values.
What does the MIN Excel function do?
The Min function gives you the lowest of a set of values in the values, cells or range you specify. The following function would display the lowest value entered in all of the cells between A1 and A12.
=MIN(A1:A12)
