please answer the following questions, help needed urgent and please no false answers.
1. what is use of sorted data? ( 3 uses)
2. how many fields can you use for sorting data in Calc?
3. is it possible to perform a) case sensitive sorting, b) coloumn-wise sorting ?
4. how will you print multiple sheets in Calc?
5. how will you accomplish case sensitive and coloumn-wise sorting?
Answers
Answer:
Explanation:
1.Uses of Sorted data
Data sorting is any process that involves arranging the data into some meaningful order to make it easier to understand, analyze or visualize. When working with research data, sorting is a common method used for visualizing data in a form that makes it easier to comprehend the story the data is telling. Sorting can be done with raw data (across all records) or at an aggregated level (in a table, chart, or some other aggregated or summarized output).
Data is typically sorted based on actual values, counts or percentages, in either ascending or descending order, but can also be sorted based on the variable value labels. Value labels are metadata found in some programs which allow the researcher to store labels for each value option of a categorical question. Most software applications also allow sorting by multiple variables. This type of sorting will be executed in a predetermined variable priority, for example, a data set containing region and country fields can first be sorted by region as the primary sort and then by country. The county sort will be applied within each sorted region.
2.The sorting mechanism in a Calc document rearranges the data in the sheet. The first step in sorting data is to select the data that you want to sort. To sort the data in Table 1, select the cells from A1 to G16—if you include the column headers, indicate this in the sort dialog. Use Data > Sort to open the Sort dialog. You can sort by up to three columns or rows at a time.Click on the Options tab to set the sort options. Check the Range contains column labels checkbox to prevent column headers from being sorted with the rest of the data. The Sort by list box in the figure above displays the columns using the column headers if the Range contains column labels checkbox in the figure below is checked. If the Range contains column labels checkbox is not checked, however, then the columns are identified by their column name; Column A, for example.
3.In excel, you can sort values in descending or ascending order, but have you ever wanted to sort data by case sensitive? Actually, with Excel’s Sort function, you can sort data by case sensitive, but its sorting order maybe not the answer you want. In sometimes, you want to sort all uppercase in the top and follow the lowercase as screenshot 1 shown, but in sometimes, you want to sort the order like a, A, b, B… If you have used Excel for more than a week, you probably already know how to sort information in your worksheet. You can use sorting to arrange a list in either ascending or descending order. Ascending order for the English language is from 0–9, A–Z; descending order is the reverse. The sorting order for other languages will be different. To specify the sorting order you simply choose the Ascending or Descending radio buttons in the Sort dialog box.
You can also affect sort order by indicating whether Excel should pay attention to the case of the text in your cells. If a sort is case sensitive, then items are sorted A-Z and then a-z for ascending sorts. If a sort does not pay attention to case, then uppercase and lowercase letters are treated the same.
Answer:
1)
Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example, you might want to order sales data by calendar month so that you can produce a graph of sales performance. You can use Discoverer to sort data as follows: sort text data into alphabetical order.
2)
You can sort by up to three columns or rows at a time. Click on the Options tab (see Figure 5) to set the sort options.
3)
Actually, with Excel's Sort function, you can sort data by case sensitive, but its sorting order maybe not the answer you want. In sometimes, you want to sort all uppercase in the top and follow the lowercase as screenshot 1 shown, but in sometimes, you want to sort the order like a, A, b, B… as screenshot 2 shown.
4)
You can select one or more sheets for printing. This can be useful if you have a large spreadsheet with multiple sheets and only want to print certain sheets.
...
Selecting sheets to print
Go to the November sheet. ...
To print all of the sheets, go to File > Print and select Options.
Click OK.
5)
Below are the steps to sort data alphabetically as well as make it case sensitive:
Select the entire dataset.
Click the Data tab.
Click the Sort icon. ...
In the Sort dialog box, make sure my data has headers is selected. ...
Click the Options button.
In the Sort Options dialog box, check the 'Case sensitive' option.
Click OK.