MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? View > window > split Window > split View > split Review > window View > window > split Window > split View > split Review > window ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Is defined by a bold border around the cell Only A and B Receives the data the user enters It is the formula bar Is defined by a bold border around the cell Only A and B Receives the data the user enters It is the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double clicking on the column left border of column header Double clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column name on column header Double clicking on the column left border of column header Double clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column name on column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? Both of above None of above Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide Both of above None of above Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide ANSWER DOWNLOAD EXAMIANS APP
MS Excel The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this? You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Select Format > Money from the menu Click the Currency Style button on the formatting toolbar You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Select Format > Money from the menu Click the Currency Style button on the formatting toolbar ANSWER DOWNLOAD EXAMIANS APP