MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following series type is not valid for Fill Series dialog box ? Time Linear Autofill Growth Time Linear Autofill Growth ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Appears to the left of the formula bar Appears below the menu bar Shows the location of the previously active cell Appears below the status bar Appears to the left of the formula bar Appears below the menu bar Shows the location of the previously active cell Appears below the status bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel To activate the previous cell in a pre-selected range, press The Alt key The Tab key None of these The Enter key The Alt key The Tab key None of these The Enter key ANSWER DOWNLOAD EXAMIANS APP