Explain all the three types of cell reference with example.What is a cell reference?
What is sorting ? How many types of sorting are possible ?
Give the steps for importing data in Excel.
Explain:
Chart
Sorting
Filter
Mixed reference
Answers
Answer:
There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
Sorting is any process of arranging items systematically, and has two common, yet distinct meanings: ordering: arranging items in a sequence ordered by some criterion; categorizing: grouping items with similar properties.
two
There are two broad types of sorting algorithms: integer sorts and comparison sorts. Comparison sorts compare elements at each step of the algorithm to determine if one element should be to the left or right of another element.
Import data from a spreadsheet
Insert a new Excel worksheet, and name it Sports.
Browse to the folder that contains the downloaded sample data files, and open OlympicSports. ...
Select and copy the data in Sheet1. ...
On the Sports worksheet, place your cursor in cell A1 and paste the data.
A chart is a graphical representation of data, in which "the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart". A chart can represent tabular numeric data, functions or some kinds of quality structure and provides different info.
a device for holding back solid substances from a liquid or gas that passes through it.
A mixed reference is a reference that refers to a specific row or column. For example, $A1 or A$1. If you want to create a mixed reference- press the F4 key on the formula bar two or three times depending on whether you want to refer to row or column. Press F4 one more time to go back to the relative cell reference
Explanation:
hope it helps you!...☺
Answer:
The 3 types of references are:
Relative reference,Absolute reference,Mixed reference.
Explanation:
Relative reference:
the row and column reference can change when you copy formula to another cell.By default, excel 2013 creates relative references in a formula............................................