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 are valid format symbols that can be entered with a number in Excel?
Excel does not use format symbols. If this question is asking about arithmetic operators, the symbols are:
- Addition (+)
- Subtraction (-)
- Multiplication (*)
- Division (/)
- Exponent (^)
Where do you place the mouse pointer to display a hidden column?
If you suspect that there is a hidden column, consider doing this:
1. Press Ctrl + A. This will select all cells in your current sheet.
2. Position your mouse pointer between two columns so that the icon changes. Example: You could place the mouse pointer between the column names A and B, on the line.
3. Click and drag the line so that the width of all columns in the sheet is increased.
4. The hidden columns [if any] will now be visible.
To go back to the previous width of columns, use Undo [Ctrl Z]
How do you add a hyperlink in a Google Spreadsheet?
Use the following formula and enter it into the cell: =hyperlink("http://url.com";"Text")
Enter in the URL that you want to be directed to and substitute whatever text you want displayed in the "Text" portion.
It is not designed for that purpose, so you would not use it to do so. You could write words and manually write musical notes, but the use of the traditional symbols associated with music are not practical to create in Excel. So there are better applications for this purpose.
You want to print only the fourth page of your research document.what would you do?
If you want to print only the fourth page of your research document, you can easily do that. Just go to the printer options and select the current page you want to print and you will have it printed.
- Enter employee's name in A1 (e.g., Bob).
- Format Cells A2 and A3 as dates (your choice of formats).
- In cell A2 enter employee's start date (e.g., 4/1/2005).
- In cell A3 enter the formula =TODAY(). [This enters today's date and will allow you to evaluate year's of service in real time.]
- In cell B3 enter the formula:
= A1 & " has been employed for " & ROUND((A3-A2)/365,) & " years."
- [Bob has been employed for 4 years.]
How many rows equal a page in Excel?
It depends on the height of the rows, the height of the paper, the margins you set, and many other factors.
What symbol appears at the beginning of a function in Excel 2007?
The equals symbol appears before all formulas, like:
=SUM(A1:A15)
=AVERAGE(B2:B20)
=MAX(C10:E14)
What is the lowest number and letter you can go on Microsoft Excel?
the lowest number is 65536 and the lowest letter is IV
What is the difference between executing a macro and calling a macro?
Calling a macro loads the macro into memory, while executing the macro runs the macro.
How do you easily create Excel files in c?
You might be able to use C to extract data from an Excel file, but there is no easy way to write a program to create an Excel file.
What does ADD mean on a spreadsheet?
There's no in-built function called "ADD"; "SUM" is usually used instead. If you have this in a formula, it is either a user-defined function or name, or it is simply text.
In Excel how do you add 50 to a number in each cell?
If you wanted to just change the original cells and add 50 to them, then first type 50 into a blank cell. Then copy it. Then select the cells you want to add 50 to. Go to Paste Special and pick the Add option. 50 will be added to all the selected cells, replacing their original values with that value plus 50. That is the simplest way.
Another way to add a number to the value in each cell of a column is to insert another column. If your original values are in C2:C26 you can enter the following formula in D2 (=C2+50), then copy the formula to D3:D26.
To clean up the worksheet, you have a couple of options:
- Hide column C and view the numbers in column D.
- Copy column D, then paste values into column C. This will change the values of column C to the +50 values, and also increase column D by an additional +50. When you are satisfied with your numbers in column C, delete column D and you will be back where you started, except your values in column C will be +50 from the original values.
Does the name box display entries as they are made and edited in the workbook window?
The name box displays the name or cell reference of the active cell.
How do you fit words in the cell box in excel?
This question is not clear. To enter text in a cell, click on the cell and type your text. If the text is too long to display in the cell, you can make the column wide enough to display the text. Another option is to format the cell to wrap text.
How many words can you fit in one Microsoft Excel cell?
It depends on the length of each word. The number of words does not matter; the limit is the number of total characters, including spaces. The maximum length of cell contents (text) is 32,767 characters. Only 1,024 display can display in a cell, but all 32,767 characters display in the formula bar.
What is an excellent standard to use in determining the bacterial safety of water?
Total coliform count
How do you calculate net present value in Microsoft Excel?
Enter the following formula: =PV(rate,periods,payment,FV,type) Rate is the interest rate you are using. Period is the number of periods, payment is the amount of any periodic payment (if there aren't any, enter 0). FV is the future value you want at the end of the investment (again, enter 0 if there is no remaining balance. Type is 1 if the first periodic payment is at the beginning of the period or 0 if the first payment comes at the end of the period. Remember to keep all of your terms in the same format of time - so if you are getting monthly payments, your periods must be expressed in months (not years) and your annual interest rate must be divided by 12. So, if you wanted to receive monthly payments of $100 for 10 years beginning at the end of month 1, and you wanted $5,000 left over at the end, and the annual interest rate was 8%, you would enter: =PV(.08/12,120,100,5000,0) If you just wanted to know how much you have to invest today at 8% to end up with $5,000 in ten years, the formula is: =PV(.08,10,0,5000,0) However, if the interest is compounded monthly, you would have to change the rate and term to months (.08/12 and 120).
What is likely the problem when a portion of a complicated page does not print?
The printer does not have enough memory to hold the entire page
If you enter 90 in the degree box in the orientation box how will the text appear?
The text will rotate 90 degrees to the right. The beginning of the text will be at the top. If you rotate another 90 degrees, the text will display upside down.
When you copy or cut something it is stored into memory. This is known as the Clipboard. From there it can be pasted to other locations. The clipboard is capable of holding multiple items for pasting.
