MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Macro sheet Chart sheet Work sheet Data sheet Macro sheet Chart sheet Work sheet Data sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A range of values such as from 23 to 234 A group of worksheets A command used for data modeling A group of cells A range of values such as from 23 to 234 A group of worksheets A command used for data modeling A group of cells 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 Which of the following option is not available in paste Special dialog box ? Divide SQRT Subtract Add Divide SQRT Subtract Add ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Unfreeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Freeze panes command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Freeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scrolling button Allow you to view a different worksheet Allow you to view additional worksheet columns to the right Allow you to view additional sheets tabs Allow you to view additional worksheet rows down Allow you to view a different worksheet Allow you to view additional worksheet columns to the right Allow you to view additional sheets tabs Allow you to view additional worksheet rows down ANSWER DOWNLOAD EXAMIANS APP