How to excel in data structures in c?And how to make myself intrested in that particular subject?Please help.
Answers
Answer:
Give max time to that subject....Ask ur mom or the close ones to motivate u by apriciating u...
Explanation:
Watch a video on youtube...."Gigl" it will help u dear...❤
1. Vlookup(): It helps to search a value in a table and returns a corresponding value. Let’s look at the table below (Policy and Customer). In Policy table, we want to map city name from the customer tables based on common key “Customer id”. Here, function vlookup() would help to perform this task.excel, data analysis, lookup
Syntax: =VLOOKUP(Key to lookup, Source_table, column of source table, are you ok with relative match?)
For the above problem, we can write the formula in cell “F4” as =VLOOKUP(B4, $H$4:$L$15, 5, 0) and this will return the city name for all the Customer id 1 and post that copy this formula for all Customer ids.
Tip: Do not forget to lock the range of the second table using a “$” sign – a common error when copying this formula down. This is known as relative referencing.
2. CONCATENATE(): It is very useful to combine text from two or more cells into one cell. For example, we want to create a URL based on the input of hostname and request path.excel, data analysis, concatenate
Syntax: =Concatenate(Text1, Text2,.....Textn)
Above problem can be solved using formula, =concatenate(B3, C3) and copy it.
Tip: I prefer using the “&” symbol, because it is shorter than typing a full “concatenate” formula, and does the exact same thing. The formula can be written as “= B3&C3”.
3. LEN() – This function tells you about the length of a cell i.e. number of characters including spaces and special characters.
Syntax: =Len(Text)
Example: =Len(B3) = 23
4. LOWER(), UPPER() and PROPER() –These three functions help to change the text to lower, upper, and sentence case respectively (First letter of each word capital).
Syntax: =Upper(Text)/ Lower(Text) / Proper(Text)
In a data analysis project, these are helpful in converting classes of a different case to a single case else these are considered as different classes of the given feature. Look at the below snapshot, column A has five classes (labels) whereas Column B has only two because we have converted the content to lower case.
excel, data analysis
5. TRIM(): This is a handy function used to clean text that has leading and trailing white space. Often when you get a dump of data from a database the text you’re dealing with is padded with blanks. And if you don’t deal with them, they are also treated as unique entries in a list, which is certainly not helpful.
Syntax: =Trim(Text)
6. IF(): I find it one of the most useful functions in excel. It lets you use conditional formulas that calculate one way when a certain thing is true and another way when false. For example, you want to mark each sales as “High” and “Low”. If sales are greater than or equals to $5000 then “High” else “Low”.
Syntax: =IF(condition, True Statement, False Statement)
excel, data analysis, conditional
Ctrl +[Down|Up Arrow]: Moves to the top or bottom cell of the current column and combination of Ctrl with Left|Right Arrow key, moves to the cell furthest left or right in the current row
Ctrl + Shift + Down/Up Arrow: Selects all the cells above or below the current cell
Ctrl+ Home: Navigates to cell A1
Ctrl+End: Navigates to the last cell that contains data
Alt+F1: Creates a chart based on selected data set.
Ctrl+Shift+L: Activate auto filter to data table
Alt+Down Arrow: To open the drop-down menu of auto filter
Alt+D+S: To sort the data set
Ctrl+O: Open a new workbook
Ctrl+N: Create a new workbook
F4: Select the range and press F4 key, it will change the reference to absolute, mixed and relative.