USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Configure Excel formulas to have the R1CI reference style and enable Error Checking using the color Blue. What are the few steps?
|
|
file tab, click options, click on formulas
|
|
|
file tab, click options, click on general
|
|
|
file tab, click options, click on save
|
|
|
none of the above
|
Explanation:
Detailed explanation-1: -In the Excel Optionswindow, select the Formulas tab. In the Working with formulassection, check R1C1 reference style. In the Error Checking section, check Enable background error checking. In the color dropdown, select Blue and click OK.
Detailed explanation-2: -To enter a R1C1 reference in Excel, you can simply type the reference into a cell (e.g., R1C1). Alternatively, you can select a cell and then enter the reference into the formula bar above the worksheet. When using R1C1 references in formulas, you must enclose them in square brackets [ ].
There is 1 question to complete.