DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Function name, data and cell reference.
|
|
|
Equal sign, function name and cell reference.
|
|
|
Equal sign, cell reference and formula.
|
|
|
None of the above
|
Detailed explanation-1: -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.
Detailed explanation-2: -A 3D reference in Excel refers to the same cell or range of cells on multiple worksheets. It is a very convenient and fast way to calculate data across several worksheets with the same structure, and it may be a good alternative to the Excel Consolidate feature.
Detailed explanation-3: -Once you have inserted the equal sign into your spreadsheet, you can then use it to perform mathematical operations. For example, if you type “=5+5” into a cell, Excel will automatically calculate the answer and display it as “10". You can also use the equal sign to create formulas.