MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + R Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.8 5430 6.8 5436.80 5436.8 5430 6.8 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Work sheet Chart sheet Data sheet Macro sheet Work sheet Chart sheet Data sheet Macro sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a popular DOS based spreadsheet package? Lotus 1-2-3 Smart cell Word Excel Lotus 1-2-3 Smart cell Word Excel ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Exclamation (!) Hash (#) Tilde (~) Apostrophe (') Exclamation (!) Hash (#) Tilde (~) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS