MS Excel How do you rearrange the data in ascending or descending order? Data Subtotals Data, Form Data, Table Data, Sort Data Subtotals Data, Form Data, Table Data, Sort ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool Always erroneous A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool Always erroneous ANSWER DOWNLOAD EXAMIANS APP
MS Excel You cannot link excel worksheet data to a word document With the copy and paste special commands With the right drag method With the copy and paste buttons on the standard toolbar With a hyperlink With the copy and paste special commands With the right drag method With the copy and paste buttons on the standard toolbar With a hyperlink ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the oldest spreadsheet package? VisiCalc Lotus 1-2-3 Excel StarCalc VisiCalc Lotus 1-2-3 Excel StarCalc ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Scenarios Contents All of the listed here Objects Scenarios Contents All of the listed here Objects ANSWER DOWNLOAD EXAMIANS APP