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 option button options lists error-checking option of an invalid formula to a cell?
In Excel 2007, on the Formulas ribbon, select the Error Checking option in the Formula Auditing section.
How do you use a formula to round up in Excel?
To round up a number to the next highest whole number of a certain multiple use the CEILING function. Use the built in function ROUND for general rounding to the nearest value. It can round down or round up. There is a function called ROUNDUP which always rounds up.
The CEILING function takes two arguments, the first is the number to be rounded up, the second is whole number multiple to round up to. For example: CEILING(1.2345,1) gives 2 but CEILING(1.2345,5) gives 5
To round the contents of cell A1 to the next highest whole 10 and put the result in cell B2 you would: Click on cell B2 Type =CEILING(A1,10) Click on cell A1 Type 14.65 And cell B2 will show the result 20 which is 14.65 rounded to the next highest whole multiple of 10.
CEILING will not handle negatives numbers and will return a #NUM! error if you try.
What functions are new to excel 2007?
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
Hi
A set of characters with the same design size and shape is called a what in windows excell?
In Excel they are simply called font.
What is bold in Microsoft Excel?
IT IS BOLD
How can meaning of word change!!.>COULDNT U ATLEAST TRY IT
What is each page of a spreadsheet called?
The term to identify a page in an MS Excel spreadsheet (workbook) is worksheet. The specific name of each worksheet is located on the tab below the worksheet. The default names for the three worksheets loaded when the default install of Excel is opened are: Sheet1, Sheet2, and Sheet3.
worksheet
What is the data called that is displayed in the formula bar in Excel?
It shows the cell contents which can be things like numbers, text, dates or formulas. It will always show values that are unformatted. It shows what is actually typed into a cell, like a formula, even though the cell may show an actual result of the formula.
Formula in excel to calculate total time?
If you put in the time they started and the time they finished, you can subtract the earlier time from the later time. The time must be put in in a time format, with a colon between the hours and minutes of the time. So if they started at 9:30am you'd put it into a cell like this:
09:30
You would put the time they finish in another cell. Then in another cell you put a formula to subtract the earlier time from the later time. So if you had 09:30 in cell A3 and 15:45 in cell A4, then in cell A5 you could have a formula like this:
=A4-A3
If they have breaks, you'd have to have several formulas to find the time worked between each start point and end point. All those times could then be added to find out their total time.
A good way to calculate breaks in Excel using only one formula can be found in the training section of http://www.calculatehours.com:
Log in- - - - -using an hh:mm format in cell A1
Log out - - - using an hh:mm format in cell B1
Log in- - - - -using an hh:mm format in cell C1
Log out - - - using an hh:mm format in cell D1
Than in cell E1 type:
=SUM((B1-A1)+(E1-D1)*24
Change the cell format of E1 to "Number" with 2 decimal places.
If that's too difficult, you can download ready Excel Time sheet Templates from:
<a href="http://www.calculatehours.com/timesheet-template-library.html">
Why do you need to delete and insert rows in Microsoft Excel?
There are many reasons, but generally they are as follows. Often you will realise you need some extra values between ones you have already put in, so you may want to insert rows or columns, which saves you from having to move things or start over. You may want to delete rows and columns that have values that you no longer need or when you have blank rows and columns in your data.
What does text formulas do in Microsoft Excel?
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
The TEXT function converts a value into formatted text. This can be useful when you want to use a value in the middle of a sentence and format it to one of the number formats like currency. So if the cell A2 had 4 in it, this would display it as 4.00 and left aligned if the formula is in a cell by itself.
=TEXT(A2,"0.00")
There are a lot of other text functions for manipulating text in all sorts of ways like extracting particular letters, finding certain letters, finding the length of a piece of text and many other functions.
A spreadsheet, such as Microsoft Excel, Lotus 123, Quattro Express, Open Office Calc etc.
When you start Excel what displays?
It activates the menus and the facility to use the keyboard shortcuts for options, like pressing Alt - F - S to save a file or Alt - F - X to exit Excel. In both examples, Alt - F is activating the File menu.
What will decrease the indent by three spaces each time you click it in Excel?
Decrease Indent Button
decrease indent button
What happens when you decrease the height of the row to 0 in excel?
The row will effectively be hidden. It can still be accessed and even have values in it that can be used in formulas.
Which key deletes character to get the right of the insertion point?
While holding down SHIFT, press END (near home, insert, delete, etc.). Then press DELETE or BACKSPACE.
Does a red triangle indicate a comment in a spreadsheet in Excel?
Yes, it indicates that the cell has a comment in it. Putting the cursor over the cell will show the comment.
What are 6 cell formats in Microsoft Excel?
Here are four specific formatting options for values:
Percentage.
Currency.
General.
Time.
You can also have text formatting like Bold and Italics and Underline. You can have alignment formatting, like left, right and centred. You can change borders around cells and the colours of cells. You can change the font of a cell and the size of its text.
How can you move from one cell to another in Excel?
You can use the Cut and Paste option. There are various ways of doing this, like using Ctrl - X to cut, or picking it off the Edit Menu or off the shortcut menu by right clicking on the mouse or by doing Alt - E - T. Paste can be done in several corresponding ways, with the key controls being Ctrl - V or Alt - E - P. You can also move a cell by putting the cursor on the edge of a cell or a group of selected cells and then dragging them. You can also do this when also hold Shift, in which case they will be inserted into a new location rather than overwriting cells that they are moved to.
What function is useful when you want to assign a value to a cell cased on a logical test?
The IF function can assign a value to a cell based on a logical test.
What are advantages of using a template on excel?
Hello
If you are Student, Business, Doing some research and making accounts then you must need excel templates. Excel templates make your life for easy with mathematics and tracking.
CFOTemplates.com continues to create professional content for finance professionals and small/medium business owners. Today CFO Templates has published a financial ratio analysis template that allows companies to compare their financial ratios against the ratios of their competitors.
What is the cell reference for the nonadjacent block of cells B5 through C10?
The range for cells B10 through to C15 is B10:C15
