MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: 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 Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar 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 Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Row chart Pie chart Line chart Column chart Row chart Pie chart Line chart Column chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following Excel screen components can NOT be turned on or off ? Formula Bar Tool Bar None Status Bar Formula Bar Tool Bar None Status Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? None Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells None Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F8 F10 F9 F11 F8 F10 F9 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Pressing the Ctrl key while dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Dragging over the desired cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Dragging over the desired cells Pressing the Shift key and an arrow key ANSWER DOWNLOAD EXAMIANS APP