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
What is the CountIF function on excel?
Countif function is an excel function that counts the number of cells which answers a criteria.
Countif function looks like this =countif(range,criteria)
Range: the range we want to count.
Criteria: the criteria each cell must meet in order to be counted (if it contains data).
What is the addition formula for Excel spreadsheets?
Simple addition can be done using the + sign:
=A3 + A5
The formula for doing addition in Microsoft Excel can use the SUM function.
=SUM(A3+A15)
You click on the box you want the sum to appear in. In that box you type=SUM( then you write the boxes you want to add up. ex: B1,C1,D1. make sure you put a comma between each box number
ex:=SUM(B1,A1,C1)
To do a block of cells you can use a range reference. To sum all the cells from A2 to A15, you would use a colon in between them:
=SUM(A2:A15)
How do you get into the spreadsheet?
There are two kinds of spreadsheet; manual spreadsheetand electronic spreadsheet.
Manual Spreadsheet is a paper that has borders, rows, columns, and other elements.
Electronic Spreadsheets are spreadsheets(or worksheets) that are on the computer.
Steps on how to open spreadsheet on Microsoft XP:
1. Click "Start" button.
2. Programs.
3. OpenOffice.org.
4. Then click Openoffice.org.
5. You will see icons there. Click Spreadsheet.
Excel, Calc and Spreadsheet in the OpenOffice are also spreadsheets. The only difference are their names of applications.
-SikukuXIII
-Visit my site@ www.mypersonalsite.tripod.com
-E-mail me: jokermen_09@yahoo.com
-Contact me(only in Philippines): 09227550939
How do you search for a specific value in Excel?
Click on the Search button and enter what you want to find on the worksheet. Click on the options button in the search window to select advanced search options, such as search the entire workbook.
How do you add a record row to a table in excel?
It depends on how it is set up. You could just go to a new row and starting typing. If it is in a form, you can go to a new record by clicking the button to add a new record and it will do it automatically.
What command is used to locate data in worksheet?
The Find command will do it. If you go to the Edit menu, it is there. You can also press and hold the Ctrl key and press the F key.
A Pareto chart is a type of chart combining line and bar graphs. The bars represent the individual values while the lines represent the combined totals.
What is a cell called when it is selected?
You can have more than one cell selected at once. When that happens one cell is known as the active cell, which is also the case if there is only one cell selected. If you start typing, it is the cell into which data will go. There are no special names for the other cells that may also be selected at that time, so the answer you are looking for is the active cell.
When you press tab with the insertion point in the last cell in a table a new?
This is not a question. In the future, if you want someone else to do your homework for you, reword your homework items in the form of a question. In any event, you are looking for the word "row."
What is a workbook in Microsoft Excel?
A workbook is the MS Excel file in which you enter and store related data.
A worksheet (also known as a spreadsheet) is a collection of cells on a single "sheet" where you actually keep and manipulate the data.
Each workbook can contain many worksheets. (It's a lot like a book. One book contains an entire story. Each page of the book contains part of the story.)
Often one workbook has a single theme, such as a personal budget. Each worksheet would then have a part of the theme, such as the budget broken down by month.
What is the use of clipboard in Excel?
The clipboard is a software facility that can be used for short-term data storage and/or data transfer between documents or applications, via copy and paste operations.
Overhaul
What Excel function is used to calculate a total?
There is no function called TOTAL in Excel. You can get totals using several functions, most commonly the SUM function. There is a function called SUBTOTAL which allows you to do different types of standard calculations, including getting totals, averages, highest numbers, lowest numbers and some other things.
What is the function of the F22 key in Excel?
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
There is no F22 key. The F2 key allows you to start editing the contents of the cell. F12 does a Save As.
Sort highlighted cells in Excel?
With the cells selected, go to the Data menu and you will find Sort there. Alternatively, on the Standard toolbar you will two icons with A and Z on them, one for sorting from A to Z or lowest to highest if it is numbers, and the other for sorting in Z to A order or highest to lowest.
What are the 4 different ways of moving the cursor around the spreadsheet?
There are more than 4 ways. You could use the four arrow keys. You can use Page Up and Page Down. You can use Ctrl-Home, You can use Ctrl-End. You can use End with the arrow keys. You can click on the cells with the mouse. You can use the Goto option by pressing F5. You can use the Name box.
Where is the select all button on Excel?
Click in the upper left hand square above the line numbers, to the left of the letter A column heading.
What does Excel do when you press the enter key?
The thing you have typed will be entered into a cell. It may format it if the cell has pre-defined formatting. The cursor will move to the next cell below the cell you are entering something into.
What can companies use spreadsheets for?
Companies can use spreadsheets to track earning expenses, budget amounts, also for sorting, filtering, and reporting data. The list is endless of the different ways companies can use spreadsheets.
What is the key to make lower case letter on computer?
Normally letters start in lower case, so you don't need to press any other key when typing lower case letters. You can use the Caps Lock key to turn on capital letters and turn them off again. If Caps Lock is on, pressing and holding one of the Shift keys when typing a letter will put it into lower case.
What do Ribbon commands include?
Ribbon command include almost everything that you might want to do with Excel, such as setting the font and controlling the appearance of the font. Ribbon commands also let you create charts and graphs, import and export data, format cells, and more.
What are the parts of the MS Excel window?
The Main Screen Parts
Common Parts of the Excel Screen
Parts of the Microsoft Excel 2003 ScreenRelated Article: Parts of the Excel 2007 Screen
Active Cell
In a worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter
Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar
Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box
Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number
Rows run horizontally in an Excel worksheet and are identified by a number in the row header.
Sheet Tab
Switching between worksheets in a Microsft Excel file is done by clicking on the sheet tab at the bottom of the screen.
Parts of the Microsoft Excel 2003 ScreenRelated Article: Parts of the Excel 2007 Screen
Active Cell
In a worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter
Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar
Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box
Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number
Rows run horizontally in an Excel worksheet and are identified by a number in the row header.
Sheet Tab
Switching between worksheets in a Microsft Excel file is done by clicking on the sheet tab at the bottom of the screen.
Starting at the top and working down:
Title Bar
Menu Bar
Toolbar(s)
Formula bar
Column headers (Row headers at the left)
Worksheet
Sheet tabs and horizontal scroll bar
Status bar.
At the right is the vertical scroll bar.
The Main Screen Parts
Common Parts of the Excel Screen
You can find a detailed tutorial about this at Excel Edvantage website.
How is the proper way to format a date?
There is no single answer to that. Various date formats are provided and you have the choice of which one to use. Things you need to look for are the way the date is being shown, as it is different in different parts of the world. 02/05/95 in Europe means the 2nd of May 1995, but in America it would be February the 5th 1995. To be clear about this, you can choose a date format that shows the word for the month, so you would get something like 27-Jan-06 which leaves no confusion. Sometimes you only need to show the month, and sometimes you might want to show the full words for the months and days. All these possibilities are there. There is no proper way; it is your choice.
