Microsoft Excel

writing down questions about the notes you've already taken.

Format the cell to display the number as text. (format - cells - "numbers" tab - select "text") If you still want the value to display with a right-hand alignment you will need to change that option, as it is not the default for text entries.

Active cell

That depends on the version you have. Up to and including Excel 2003, the standard amount of columns has been 256. They are labelled by letters. After Z you get AA, AB, AC etc. until you get to AZ. Then it is BA, BB, BC and so on. The 256th column is IV. In Excel 2007 the number of columns is 16,384 which means the last column is column XFD.

Excel 2007 can support up to 16,384 (A - XFD) columns, assuming your computer has enough memory to load everything.

Freeze Panes freezes all rows above the active cell and all columns to the left of it. So in this case you would make C10 the active cell.

Yes you can. You can use the Save As to do this. It gives you lots of different file types that you can save your spreadsheet as.

also, if you have office 2008 for mac installed, the default xml file format is only compatible with office 2007 for PC. when you save a file, be sure to select .doc for work, .ppt for powerpoint, and .xls for excel.

When you are recording the results of several separate objects, e.g., favorite fruit. You use a bar chart when graphing somthing with time. Ex: numbers and months. You use a line graph when graphing numbers with numbers.

A dollar sign is used to indicate absolute references. An absolute reference will always have two dollars:

$A$2

If there is only one dollar like $A2 or A$2 then it is a mixed reference, not an absolute reference. If there are no dollars like A2 then it is relative.

You would use the Goal Seek feature to do this.

Excel is a specialized program that manages numbers in various ways. It uses spreadsheets and data to process a large amount of numbers. One enters the data, or numbers, and the program calculates the numbrs in the manner you designate in the program.

If you mean inserting columns, you can insert new columns into a worksheet, like when you may need a new column in the middle of existing ones. The Insert Function, allows you to insert new functions in a cell. The Insert key can change between Insert mode and Overtype mode, allowing you to change what happens when text is typed into existing text. In Insert mode, existing text is pushed to the right by the new text. Overtype mode replaces existing text as you type. The Insert tab on the ribbon allows you to insert lots of things, like charts or objects.

A chart legend is used to identify and explain the symbols, colors, or patterns representing different data series or categories within a chart. It provides clarity by helping viewers understand what each element of the chart signifies, ensuring accurate interpretation of the data. Typically placed alongside or within the chart, the legend enhances the overall readability and effectiveness of the visual representation.

They are radically different. A table in Word, just displays your data in a tabular form. A pivot table has a lot of functionality, enabling you to do things like calculations, picking different types of calculations, switching the table layout, changing what pieces of the data that it is based on that you use. Pivot tables are used to analyse data and simply manipulate the results as you do so. Tables in Word can actually do simple calculations, something many people don't even realise, but they can't do the same kinds of things a pivot table can do. Pivot tables are closer in their function to a Crosstab query in Access, than to a table in Word.

It allows you to generate a random number between a range. So say you want to get a random number between 1 and 100, then you would use the RANDBETWEEN function like this:

=RANDBETWEEN(1,100)

It is a dynamic function, meaning every time something changes on the spreadsheet, it regenerates new numbers. This will also happen if you press the F9 key. It is a good function to get a set of numbers quickly and to test functions with, removing the need for you to create a load of random numbers yourself.

amar

This could be the Tab key, or the Right Arrow key, depending on the context.

The range is the cells that are selected or used in some way. For example, a SUM function using a range of A2:A4 would add the values in A2, A3, and A4, or all of the cells within the range. Ranges can span many rows, columns, or both. They can be called a range or a block.

In Excel 2010 the number of rows per worksheet is 1,048,576 and the number of columns is 16,384 which is column XFD. That makes 17,179,869,184 cells.

Rows are identified by numbers in Excel.

If one function is inside another, then the functions are nested.

I have used the stars (the Sun) to cross the Atlantic Ocean, to find my way in the woods during the day (the Sun), to grow crops (Freedom Garden, sunlight, season-tracking) and to find my way at night in the woods (Polaris, or The North Star). With a magnifying glass, a fire may be initated for warmth or cooking. it is quite possible that every civilization has used the stars. However, I also wish upon one every time I see a shooting star.

The answer you are looking for would be a Spreadsheet, but those things can also be done with Word Processors and Databases, amongst other applications.

There are things that both can do when entering data, but the Tab key is more used for moving around the spreadsheet and around menu options. The Enter key is more used to just enter data. In conjunction with other keys there are other things it can do, like using Ctrl-Enter to fill out a selected range when entering something. Pressing Tab normally moves a cell to the right, while Enter usually moves down a cell.