USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Excel formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx).
Detailed explanation-2: -The formula bar is a toolbar that appears at the top of our worksheet, below the Ribbon in our workbook. The formulas bar, sometimes called fx bar, displays text or number data in active or current cells, formulas in an active cell or range of cells in place of a selected data series in an Excel chart.
Detailed explanation-3: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).
Detailed explanation-4: -=T.TEST(array1, array2, tails, type) The formula uses the following arguments: Array1 (It is a required argument) – The first data set. Array2 (It is a required argument) – The second data set. Tails (It is a required argument) – Specifies if it is a one-tailed or two-tailed test.
Detailed explanation-5: -Select the cell with the formula, press F2, and then press ENTER. The cell displays the value. In the same cell, click Cells on the Format menu. The cell format category will be Text.