0
Microsoft Excel 2007
-
It is a program used to create, format, analyse and compute numbers. It displays data in row-and-column format. MS Excel makes it easy to compute numbers and allows different ways to format data including charts and reports.
-
It is a very powerful electronic spreadsheet that lets the user enter and use numerical data with formulas and built-in functions.
A Workbook
is a file in MS Excel that holds worksheets.A
Worksheet
is composed of columns and rows that are similar to an accounting ledger. It displays characters like letters, and numbers, and can do computations. Excel 2007 has 1,048,576 rows, and 16,384 columns.
Parts and Uses of the MS Excel Environment
1.
Toolbars
- display commands that are commonly used for easy access
2.
Name Box
- displays the address of the active cell
3.
Formula bar
- displays the contents and formula entered on the active cell
4.
Status bar
- displays the information about a selected command
5.
Select all Button
- selects every cell in a worksheet
6.
Sheet Tabs
- let you display worksheets in the open workbook
7.
Row headers
- a number used to identify a row
8.
Column headers
- a letter used to identify a column
9.
Active cell
- the cell that has a thick border that will hold any data that you type or entered
10.
Scroll bars
- includes vertical and horizontal scroll bar and four arrow used to move the screen display horizontally or vertically
11.
Title bar
- displays the program and the name of the workbook that you are currently using
12.
Menu bar (7 Tabs)
- lists the names of the menus or tabs in Excel
13.
Minimize button
- minimizes the window to a button on the task bar
14.
Maximize/Restore button
- switch between maximizing a window and restoring a window to its previous size
15.
Close button
- closes the window
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What following functions was new in Excel 2007 sum ifs sum if count if or sum?
SUMIFS was new in Excel 2007.
What are some differences between Excel 2003 and Excel 2007?
The most obvious visible difference is the ribbon bar (new menu system) displayed by all Office 2007 products. You also will notice a new file format. Excel 2003 uses an extension of XLS, while Excel 2007 uses the extension of XLXS, You can open Excel 2003 files in Excel 2007, but not the other way around. Excel 2007 adds many new functions. See related links for what's new with Excel 2007. Also see the related links for how to match the old Excel 2003 menu items with the new Excel 2007 ribbon.
How many functions are in Microsoft Excel 2007?
348, at my count
How many functions can be nested with the same formula in MS Excel?
Excel 2003 = 8 levels of nesting Excel 2007 = 64 levels of nesting
What are the3 lookup functions in excel 2007?
LOOKUP, HLOOKUP and VLOOKUP.
MAX MIN COUNT and SUM are examples of what?
They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.
How many columns in 2003 and 2007?
In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.
A new feature of Microsoft Office Excel 2007 is?
Ribbons.
How do you find mini tab in Excel 2007?
It is stated that the Minitab functions as a dedicated statistical-analysis tool. Some of the ways to find the Minitab in Excel 2007 is by migrating the graph, pasting the graph, or by pressing Ctrl-C.
What are 5 different groups of functions provided by Microsoft Excel 2007?
Financial, Date & Time, Engineering, Statistical and Text.
Do you need the basics in Excel 2003 to learn Excel 2007?
Not necessarily. Having a good understanding of Excel 2003 will help in using Excel 2007. The main difference is the look, but the fundamentals are the same as it is still a spreadsheet, so it has to be able to do things that spreadsheets do, like with the formulas and functions. As those things are much the same, then you could use Excel 2007 without having ever used Excel 2003. Users of Excel 2003 would find Excel 2007 a little strange at first because of how different it looks, although they would quickly get used to it. Someone who has never used Excel 2003 won't have that problem.
How Excel 2007 Converted to Excel 2003?
You can open a 2007 Excel spreadsheet with Excel 2003 if you save the file in Excel 2007 using "Save As" and select the 2003 compatibility mode.
