<u>Best method to sort data:</u>
Best method to sort for data people use excel sheet. If we have 4 quarter sales data of each select man wise.
1. Open the MS Excel
2. Create blank sheet
3. Create list of salesman and quarter sales in each cells from A1….
4. Select all whole worksheet and paste it the data
5. Once data is copied, custom list is created and select advanced options dialog box, select required field and sorting is achieved.
This is simple’s method for sort the list based on the names of the first four gas in ascending order.
Answer: Operate over existing telephone lines to carry voice, data, and video.
Explanation:
Digital subscriber line is a means of transferring high bandwidth data over a telephone line. Such data could be a voice call, graphics or video conferencing. DSL uses a user's existing land lines in a subscriber's home, allowing users to talk on a telephone line while also being connected to the Internet. In most cases, the DSL speed is a function of the distance between a user and a central station. The closer the station, the better its connectivity.
Answer:
D. Create a cell reference in a formula by typing in the cell name or clicking the cell.
Further Explanation:
To create a cell reference in a formula the following procedure is used:
First, click on the cell where you want to add formula.
After that, in the formula bar assign the equal (=) sign.
Now, you have two options to reference one or more cells. Select a cell or range of cells that you want to reference. You can color code the cell references and borders to make it easier to work with it. Here, you can expand the cell selection or corner of the border.
Again, now define the name by typing in the cell and press F3 key to select the paste name box.
Finally, create a reference in any formula by pressing Ctrl+Shift+Enter.
Answer:
Sorting tools allow you to organize data into columns and rows that help you locate what you are looking for.
Explanation:
Spreadsheet applications and relational databases are similar in configuration as they are both arranged in rows and columns (tabular). Sorting a spreadsheet or database is useful as it helps to organize data. A sorted spreadsheet or database can be in ascending or descending order which makes it easier and faster to locate rows of data manually or by query.
Answer:
getline(cin, address);
Explanation:
Given
String object: address
Required
Statement that reads the entire line
The list of given options shows that the programming language is c++.
Analysing each option (a) to (e):
a. cin<<address;
The above instruction will read the string object until the first blank space.
Take for instance:
The user supplied "Lagos state" as input, only "Lagos" will be saved in address using this option.
b. cin address:
This is an incorrect syntax
c. getline(cin,address);
Using the same instance as (a) above, this reads the complete line and "Lagos state" will be saved in variable address
d. cin.get(address);
address is created as a string object and the above instruction will only work for character pointers (i.e. char*)
<em>From the above analysis, option (c) is correct.</em>
