DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
False
|
|
|
True
|
|
|
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: -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-3: -A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references. These are separated by calculation operators.
Detailed explanation-4: -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.