DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS 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: -You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler. The column doesn’t appear, but the data is still there. What happens when you hide a column in Microsoft Excel? Microsoft Excel can use Headers and Footers, just like Microsoft Word.
Detailed explanation-2: -The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-3: -Q. What happens when you hide a column in Microsoft Excel? A. The column doesn’t appear, but the data is still there.
Detailed explanation-4: -The parts of a function The basic syntax for a function is an equals sign (=), the function name (SUM, for example), and one or more arguments. Arguments contain the information you want to calculate.