USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
There must be a blank row and column between the data and other information
|
|
|
The data header information must be bold
|
|
|
The data header must be in a single row
|
|
|
The data you want to sort must be continuous without blank rows or columns
|
Detailed explanation-1: -Answer: All the data must be the same font and font size is not necessary for data sorting. Explanation: The most easier and frequently used tool for data organizing and sorting is Microsoft’s excel or google spreadsheet.
Detailed explanation-2: -Which of the following is NOT necessary for organizing data to make it easier to sort? The data header must be in a single row.
Detailed explanation-3: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-4: -On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.