MS Excel Which of the following is invalid statement? Sheet tabs can be colored Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Sheet tabs can be colored Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red 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 the Ctrl key 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 Alt 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 Shift 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 How many worksheets can a workbook have? 8 none of above 255 3 8 none of above 255 3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + C Ctrl + Enter Ctrl + Space Bar Ctrl + Page Up Ctrl + C Ctrl + Enter Ctrl + Space Bar Ctrl + Page Up ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F10 F9 F8 F11 F10 F9 F8 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS