MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) 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 You can use the horizontal and vertical scroll bars to Edit the contents of a cell Split a worksheet into two panes View different worksheets View different rows and columns edit the contents of a cell Edit the contents of a cell Split a worksheet into two panes View different worksheets View different rows and columns edit the contents of a cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Complex Formulas Standard Formulas Smart Formula Array formula Complex Formulas Standard Formulas Smart Formula Array formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Workbooks Group of Worksheets Group of Rows Group of Columns Group of Workbooks Group of Worksheets Group of Rows Group of Columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS