Read the clues and answer the following:
a) It calculates the maximum, minimum, average etc. of a set of numeric data.
b) It is used to highlight cells that contain values greater than a particular value.
c) . It is a mathematical symbol used to start a formula in MS Excel.
d) It is a way to arrange the data in ascending or descending order.
e) It is a type of charts in MS Excel that shows the correlation between two sets of values.
f) It is used to separate unwanted material from a mixture.
g) It is a key which shows the meanings of symbols and colours used in the Chart.
h) It is a shortcut key used to print the worksheet.
i) It is a built-in function that returns the current date.
Answers
a) Select a cell below or to the right of the numbers for which you want to find the smallest number. On the Home tab, in the Editing group, click the arrow next to AutoSum , click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.
b) Conditional Formatting
Using the Built-in Rule
On the Excel Ribbon's Home tab, click Conditional Formatting, to format the values greater than a specific one, select Highlight Cells Rules and then choose the option Greater Than.
c) A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
d) Sorting means arranging. Sorting data refers to the process of arranging data, either in ascending order or in descending order. Sorting can be done on numbers or text or both.
e) XY Scatter Plot Chart: Scatter charts in Excel (also known as XY scatter plot charts) are excellent for showing correlations between two sets of values
f) Hand-picking is a method of separation by which impurities that are different from the useful material in a mixture are hand-picked and removed. For example, rice, wheat, pulses, etc., contain impurities such as small stones or unwanted grains.
g) Colors, shading and symbols may be used on a map to show thousands of different things. A map key or legend is an essential part of the map. It explains what the symbols on the map mean and allows you to make sense of the map.
h) Ctrl+Shift+F6 Ctrl Shift F6 Previous Window
Ctrl+Shift+F12 Ctrl Shift F12 Print
Alt+Shift+F1 Alt Shift F1 New worksheet
Alt+Shift+F2 Alt Shift F2 Save
I) The Microsoft Excel TODAY function returns the current system date. ... The TODAY function is a built-in function in Excel that is categorized as a Date/Time Function. It can be used as a worksheet function (WS) in Excel.