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 There is no way to copy and apply formatting in Excel – You have to do it manually 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 The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the format painter multiple times before you turn it off by Double clicking the format painter button Pressing the Ctrl key and clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Alt key and clicking the format painter button Double clicking the format painter button Pressing the Ctrl key and clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Alt key and clicking the format painter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Press the Alt key Press the F2 key Click the formula bar Double click the cell Press the Alt key Press the F2 key Click the formula bar Double click the cell 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 Ctrl + Home Press Home Press Shift + Home Press Alt + Home Press Ctrl + Home Press Home Press Shift + Home Press Alt + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above ANSWER DOWNLOAD EXAMIANS APP