MS Excel Concatenation of text can be done using Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you print three copies of a workbook? Select File > Print from the menu and type 3 in the Number of copies text box Select File > Properties form the menu and type 3 in the Copies to print 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 > Print from the menu and type 3 in the Number of copies text box Select File > Properties form the menu and type 3 in the Copies to print 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel We can save and protect the workbook by Write Reservation Password Protection Password Any of the above Read-only Recommended Write Reservation Password Protection Password Any of the above Read-only Recommended ANSWER DOWNLOAD EXAMIANS APP