DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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-2: -For example, ordering a set of numbers from greatest to smallest value means that you’re arranging them in descending order.
Detailed explanation-3: -Answer: Option a-Currency is the number format used to apply to the cell showing the total sales for the month. Explanation: Numbers must be formatted as currency in order to be displayed as monetary values.
Detailed explanation-4: -There may be times when you do not want a cell reference to change when filling cells. Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant.