MS Excel Which command will you choose to convert a column of data into row? Cut and Paste Paste Special > Transpose Both of above None of above Cut and Paste Paste Special > Transpose Both of above None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Line Chart Column Chart XY Chart Pie Chart Line Chart Column Chart XY Chart Pie Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Goal seek Solver All of above Scenario Manager Goal seek Solver All of above Scenario Manager ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? ROUND ( ) FACT ( ) Div ( ) MOD ( ) ROUND ( ) FACT ( ) Div ( ) MOD ( ) 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 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 Format Painter button on the standard toolbar 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 Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu 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