MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Alt + Home Press Shift + Home Press Home Press Ctrl + Home Press Alt + Home Press Shift + Home Press Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to None of above Fill the selection with active cells to the right Remove the cell contents of selected cells Right align the content of cell None of above Fill the selection with active cells to the right Remove the cell contents of selected cells Right align the content of cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Only A and B Is defined by a bold border around the cell It is the formula bar Receives the data the user enters Only A and B Is defined by a bold border around the cell It is the formula bar Receives the data the user enters ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date only in MS Excel? Time () Now () Today () Date () Time () Now () Today () Date () ANSWER DOWNLOAD EXAMIANS APP