DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Fch
|
|
|
fz
|
|
|
wean
|
|
|
F5
|
Detailed explanation-1: -There is a shortcut for placing absolute cell references in your formulas! When you are typing your formula, after you type a cell reference-press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.
Detailed explanation-2: -F4 is a predefined keyboard shortcut in Excel that repeats your last command or action.
Detailed explanation-3: -F5 Displays the Go To dialog box. Ctrl+F5 restores the window size of the selected workbook window. F6 Switches between the worksheet, ribbon, task pane, and Zoom controls.
Detailed explanation-4: -It locks a reference, making it absolute to some extent depending on how many times you press it. Written in Excel terms, it “toggles absolute and relative references”. The F4 shortcut to lock a reference only works on Windows. If you’re running MAC, use the shortcut: ⌘ + T to toggle absolute and relative references.