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
How can you find the creation date of a file?
(these method is one of the simplest and might not be accurate as it might not display the correct date and it can be modified.)
Quick steps:
Right-click the file > Properties > Details
Detailed steps: 1. Using Windows Explorer (Windows Explorer is the basic software with a graphical user interface we use to browse our files)
2. Right-click the file you choose to find it's creation date.
3. A drop-down menu will appear. Click 'Properties'.
4. At the top part of the window that has just appeared, click the 'Details' tab.
5. 'Date created' will be shown (look for it, scroll way down) mostly under the 'File' section.
How to hide columns of a spreadsheet in Microsoft Excel 2007 with the steps?
To hide columns of a spreadsheet in Microsoft Excel 2007 simply select the columns and click on the hide option.
Highlight the whole row and column to show the current cell?
Place the cursor in the row or column to be selected. Press the shift key and the spacebar to select a row. Press the Ctrl key and the spacebar to select a column. Using the mouse you can click on the row number or column letter to select the row or column.
What is an example of a function?
Functions basically establish relationships between expressions. Many common Algebraic functions are expressed as functions of x:
f(x) = x2 + 4
Which could also be written as y = x2 + 4
However, this just scratches the tip of the universe. Not only do mathematical functions vary in complexity and offer an infinite number of possibilities, there are also programming functions. Programming functions are typically groups of commands that accept one or more parameters, then return one or more pieces of information.
The above Mathematical function can be re-written as a Perl programming function that accepts a value for x:
sub calculateFunction {
my ($x) = @_;
my $y = x**2 + 4;
return ($y);
}
Button that allows you to copy values with or without formatting?
It is the Auto Fill Options button that lets you copy values with or without formatting. Microsoft Excel is a spreadsheet application.
How do you shrink a selected cell's text to fit the cell in excel 2003?
Change the font size. You can do that on the formatting toolbar, or through Cells on the Format menu, or you can right click on the cell to do it from there. Also consider widening the column, merging with a neighbouring cell or using text wrapping.
Can you use the SUM function with boolean values?
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
Yes you can. TRUE is worth 1 and FALSE is worth 0. However it does behave slightly strangely in the it won't add them through cell references in all situations. So if you had TRUE in cell A2 and A3 then the following will both return zero:
=SUM(A2:A3)
=SUM(A2,A3)
However, the following will both return 2:
=SUM(A2+A3)
=SUM(TRUE,TRUE)
How many no of rows and columns in work sheet?
there are an infinite number of columns and row in a spreadsheet
How do I culculate my results in excel?
"I have a spreadsheet of results from a survey I have been preforming. In Column I there are results where 1 is yes and 0 is no. I need to be able to calculate the percentage of Yes answers in a separate tab, how do i do this?"
The first thing is to count the total amount of values, using the COUNT function. You then need to find the amount of times 1 comes up, which you can do by just using the SUM function. Then divide the result of the SUM by the result of the COUNT and format the result as a percentage. To specify the Sheet from another sheet, you put the sheet name followed by an exclamation mark and then the cell references.
Let's say your values were in the cells from I2 to I25 on Sheet1, then your final formula with the functions could be as follows:
=SUM(Sheet1!I2:I25)/COUNT(Sheet1!I2:I25)
The corporatist view is a political and economic theory that emphasizes the collaboration between government, businesses, and labor groups to create a harmonious society. It advocates for the organization of society into interest groups that represent various sectors, promoting collective bargaining and cooperation rather than conflict. This model often contrasts with pluralism, where multiple competing interests vie for power. Corporatism can be seen in various forms, ranging from state-led systems to more voluntary associations.
How do you enhance a chart in Excel?
Use headings to indicate what they chart is about. Include an overall chart title and ones on the x axis and y axis. Make sure the headings are clear. Use colours to enhance the chart by making things clear so that things can be seen. You can thicken lines on line charts so that they are clearer. Make sure the legend is clear. You might want to add some fancy effects, like 3-D styles, though it doesn't always enhance the chart. You have to make that decision based on the chart. If there are a lot of elements on it, they may be harder to see.
What is the most efficient way to select cells?
Clicking on a cell with the mouse and dragging out across the cells that you want selected.
yes
What two tabs are featured in excell and not in Word?
Formulas and data are two tabs that you will find in Excel and not in Word.
Yes, you can do that. You could also put the percetage directly into the formula. The best way is to put the percentage into a cell and refer to that cell in your formula.
It could be one in the Header of the file, one at the top of a column or start of a row, the name of the file, or even a title in a chart.
To ensure that the reference to a specific cell does not change?
You make it an absolute cell reference, but putting a dollar symbol before both the column and row reference like this:
$A$2
What is text vs numbers in excel?
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
Text is words and letters, while numbers are values.
The keyboard. Whatever you type will be inserted at the insertion point, provided Word is in Insert mode (the default). If it is in Overtype mode instead, and there is already some text to the right of the insertion point, what you type will replace it, character for character. You can switch back and forth between the two modes by pressing the Insert key on the keyboard, or by double clicking OVR on the status bar.
How do you get password of our own excel file or word doc file?
You need to remember the password to access the files. If you do not remember the password, you will not get in the files. The procedure to hack into MS Office files is not an appropriate topic for this on-line forum, so I will not post the information here.
