What is the F4 key used for in Excel 2013?
What will be an ideal response?
The F4 key toggles through relative, absolute, and mixed references. Click a cell reference in a formula, such as B2, and press F4. F4 will change the relative cell reference to absolute, $B$4, then to a mixed reference, B$4, and another mixed reference, $B4.
You might also like to view...
A black-and-white effect, achieved through a series of shades of gray from white to black, is called ________
Fill in the blank(s) with correct word
What states are displayed in the list box by the following program segment?
``` Dim states() As String = {"Colorado, "New Mexico", "Arizona", "Utah"} Dim query = From state in states Where state.length < 5 Select state.ToUpper For Each state in query lstBox.Items.Add(state) Next ``` (A) Utah (B) COLORADO, NEW MEXICO, ARIZONA, UTAH (C) UTAH (D) No states