MS Excel Which function is not available in the Consolidate dialog box ? Pmt Sum Max Average Pmt Sum Max Average ANSWER DOWNLOAD EXAMIANS APP
MS Excel To delete an embedded objects, first Double click the object Select it and then press the delete key Select the object by clicking it Press the Shift + Delete keys Double click the object Select it and then press the delete key Select the object by clicking it Press the Shift + Delete keys 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? Pie Chart Column Chart Line Chart XY Chart Pie Chart Column Chart Line Chart XY Chart 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 There is no way to copy and apply formatting in Excel – You have to do it manually 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The spelling dialog box can be involved by choosing spelling from ________ menu. Insert View Tools File Insert View Tools File ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP