MS Excel What is the short cut key to highlight the entire column? Ctrl + Enter Ctrl + Space Bar Ctrl + C Ctrl + Page Up Ctrl + Enter Ctrl + Space Bar Ctrl + C Ctrl + Page Up ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =B7+14 =10+50 10+50 =B7*B1 =B7+14 =10+50 10+50 =B7*B1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? % $ & * % $ & * ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use drag-and-drop to embed excel worksheet data in a word document By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Alt key 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 Text formulas: Show formula error value Return ASCII values of characters Replace cell references Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references Concatenate and manipulate text ANSWER DOWNLOAD EXAMIANS APP