MS Excel Concatenation of text can be done using Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Enter Ctrl + C Ctrl + Page Up Ctrl + Space Bar Ctrl + Enter Ctrl + C Ctrl + Page Up Ctrl + Space Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you print three copies of a workbook? Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made Press Ctrl+P+3 Select File > Properties form the menu and type 3 in the Copies to print text box Select File > Print from the menu and type 3 in the Number of copies text box Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made Press Ctrl+P+3 Select File > Properties form the menu and type 3 in the Copies to print text box Select File > Print from the menu and type 3 in the Number of copies text box 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 Format Painter button on the standard toolbar The Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply 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 Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? All of above Formats Validation Formulas All of above Formats Validation Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Alt + Home Press Home Press Ctrl + Home Press Shift + Home Press Alt + Home Press Home Press Ctrl + Home Press Shift + Home ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS