MS Excel The auto calculate feature Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet A and C Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet A and C Can only add values in a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Pie Chart XY Chart Column Chart Line Chart Pie Chart XY Chart Column Chart Line Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will None of the listed here Open the font dialog box Fill down in the selection Apply double underline for the active cell None of the listed here Open the font dialog box Fill down in the selection Apply double underline for the active cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? 10+50 =B7*B1 =B7+14 =10+50 10+50 =B7*B1 =B7+14 =10+50 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can move a sheet from one workbook into new book by From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK None of the listed here From Edit menu choose Move of Copy then choose (Move to end) and click OK From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK None of the listed here From Edit menu choose Move of Copy then choose (Move to end) and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 6.8 5436.8 5436.80 5430 6.8 5436.8 5436.80 5430 ANSWER DOWNLOAD EXAMIANS APP