MS Excel Concatenation of text can be done using Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? A1 $A$1 #a#1 !A!1 A1 $A$1 #a#1 !A!1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel To activate the previous cell in a pre-selected range, press None of these The Enter key The Tab key The Alt key None of these The Enter key The Tab key The Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following series type is not valid for Fill Series dialog box ? Time Growth Autofill Linear Time Growth Autofill Linear ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS