After dragging formula cells with the right mouse button, which option do you choose to discard the formulas and keep the results?

Suppose you right-click and drag the fill handle in the lower right corner of a cell. When you release the right mouse button, what option appears?

Which keystroke shortcut should you use to display all worksheet formulas instantly?

In Calc, when you copy or move the formula to the other cells, the reference cellautomatically gets changed is called ____

If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell numbers used in the formula?

Ch9 Part 2 Q2 Match the words with the concept:Drag and drop options on the right-hand side and submit. For keyboard navigation...SHOW MOREPress space or enter to grab An area that displays the workbook name worksheet name cell addresses values and formulas so you can monitor and examine formula calculations involving cells not immediately visible on the screen.Watch WindowAn area that displays the workbook name worksheet name cell addresses values and formulas so you can monitor and examine formula calculations involving cells not immediately visible on the screen.Press space or enter to grab Occurs when a formula contains a direct or an indirect reference to the cell containing the formula.Circular referenceOccurs when a formula contains a direct or an indirect reference to the cell containing the formula.