1.write the uses of a worksheet?
Answers
Answer:
Hola ....
Explanation:
Work sheets are important..
to score the best...
To know the types of questions
to improve the time mangement.
....................
❤❤❤❤❤❤❤❤❤
Answer:
Explanation:The uses are as under-
Calculating Combinations
The COMBIN function is used to determine the number of combinations that can be made from a group of elements. This tip explains the function and how you can use it.
Calculating the Day of the Year
Need to know what day of the year a certain date is? You can figure it out easily using the formulas in this tip.
Checking for Text
Need to figure out if a particular cell contains text? You can use the ISTEXT function to easily return this bit of trivia.
Cleaning Text
You can use the CLEAN worksheet function to remove any non-printable characters from a cell. This can come in handy when you want to pare down what is stored in a worksheet.
Colors in an IF Function
You can use the IF worksheet function to test for a number of different conditions or values. You can't use it to check for cell colors, however. Here are some ideas on how you can take cell colors into account in the IF function.
Converting Codes to Characters
Character codes are the numeric values used, by a computer, to signify various alphanumeric characters. You can use the CHAR worksheet function to discover the character code of any character.
Converting Radians to Degrees
When applying trigonometry to the values in a worksheet, you may need to convert radians to degrees. This is done by using the DEGREES worksheet function, described in this tip.
Converting to Hexadecimal
Excel allows you to easily convert values from decimal to other numbering systems, such as hexadecimal. This tip explains how to use the DEC2HEX worksheet function.
Converting to Octal
If you need to do some work in the base-8 numbering system (octal), you'll love two worksheet functions provided by Excel for this purpose. These functions allow you to convert values to octal and convert them back again.
Counting Displayed Cells
When you filter data, Excel displays only a portion of what is really in a worksheet. If you want to count the number of cells that are displayed after filtering, then you'll want to explore the techniques in this tip.
Counting the Number of Blank Cells
If you need to count the number of blank cells in a range, the function to use is COUNTBLANK. This tip discusses the function, along with a "gotcha" that you should be aware of.
Counting with Formulas
When you need to count a number of cells based upon a single criteria, the standard function to use is COUNTIF. This tip explains, through an example, how you can use the function to do the desired counting.
Determining a Value of a Cell
Cells can store all sorts of information that can be formatted and displayed in a myriad of ways. If you want to quickly get to the value stored within the cell, you can use the N worksheet function.
Determining Columns in a Range
If you need to know the number of columns in a particular range, you can use the COLUMNS worksheet function. This tip demonstrates how simple it is to use the function.
Determining the Least Common Multiple
Need to figure out the least common multiple of a range of values? It is a snap when you use the LCM function, described in this tip.
Displaying Letter Grades
Grading in schools is often done using numeric values. However, you may want to change those numeric values into letter grades based upon a determined scale. This can be done most easily using Excel's lookup functions.
EOMONTH Function is Flakey
Some users have reported problems using the EOMONTH function in later versions of Excel, beginning with Excel 2007. The problem seems to be related to Excel's compatibility mode and the fact that the function was moved from the Analysis ToolPak to Excel itself.