MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.8 6.8 5430 5436.80 5436.8 6.8 5430 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Decrease the column width Adjust the row height Increase the column width Shorten the label Decrease the column width Adjust the row height Increase the column width Shorten the label ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which chart can be created in Excel ? Line All of the listed here Pie Area Line All of the listed here Pie Area 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Excel does not have option to match case for find You can Find and Replace within the sheet or workbook None of the listed here Both Excel does not have option to match case for find You can Find and Replace within the sheet or workbook None of the listed here Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Comments can be added to cells using Edit > Comments View > Comments File > Comments Insert > Comments Edit > Comments View > Comments File > Comments Insert > Comments ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS