MS Excel Which of the following Excel screen components can NOT be turned on or off ? Formula Bar None Status Bar Tool Bar Formula Bar None Status Bar Tool Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 128 16384 256 1024 128 16384 256 1024 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of worksheet currently working on Shows the name of workbook currently working on None of the listed here Shows the name of cell or range currently working on Shows the name of worksheet currently working on Shows the name of workbook currently working on None of the listed here Shows the name of cell or range currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Financial Math & Trigonometry Statistical Logical Financial Math & Trigonometry Statistical Logical ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 All of above Apply Conditional Formatting command on Format menu 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 All of above Apply Conditional Formatting command on Format menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS