FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In MS Excel, if you want to fix the absolute cell address, use the . key
A
Fch
B
fz
C
wean
D
F5
Explanation: 

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.

There is 1 question to complete.