DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
4, 3, 1, 2
|
|
|
apples, oranges, bananas, grapes
|
|
|
4/1/2018, 4/1/2017, 3/29/2017, 6/18/2018
|
|
|
horses, ducks, dogs, cats
|
Detailed explanation-1: -For example, ordering a set of numbers from greatest to smallest value means that you’re arranging them in descending order.
Detailed explanation-2: -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.
Detailed explanation-3: -The formula bar is found at the bottom of the Excel window.
Detailed explanation-4: -How? On the Data tab, in the Sort & Filter group, click Filter. in the column header to display a list in which you can make filter choices. Note Depending on the type of data in the column, Microsoft Excel displays either Number Filters or Text Filters in the list.