MS Excel Which of the following is invalid statement? You can set the column width automatically fit the amount of text Sheet tabs can be colored The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text Sheet tabs can be colored The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Automatically adds range of cell values Applies a boarder around the selected cells All of the listed here Extends a sequential series of data Automatically adds range of cell values Applies a boarder around the selected cells All of the listed here Extends a sequential series of data 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 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 None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Shift key 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 None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? !A!1 $A$1 #a#1 A1 !A!1 $A$1 #a#1 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? none of above 8 3 255 none of above 8 3 255 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS