MS Excel Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Edit > Delete command Deletes the content of a cell Deletes the comment of cell Deletes selected cells Deletes Formats of cell Deletes the content of a cell Deletes the comment of cell Deletes selected cells Deletes Formats of cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar 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 There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar 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 Which function is not available in the Consolidate dialog box ? Max Sum Average Pmt Max Sum Average Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can contain text and data It can be modified It can contain many sheets including worksheets and chart sheets You have to work hard to create it It can contain text and data It can be modified It can contain many sheets including worksheets and chart sheets You have to work hard to create it 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 Pressing the Shift key and an arrow key 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 Ctrl key while dragging over the desired cells Pressing the Shift key and an arrow key 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 ANSWER DOWNLOAD EXAMIANS APP