MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Sum Pmt Max Average Sum Pmt Max ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Double click the cell Press the F2 key Click the formula bar Press the Alt key Double click the cell Press the F2 key Click the formula bar Press the Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A formula that either directly or indirectly depends on itself Geometric modeling tool Always erroneous A cell that points to a drawing object A formula that either directly or indirectly depends on itself Geometric modeling tool Always erroneous A cell that points to a drawing object ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document contains a reference to the original source application The word document must contain a hyperlink The word document cannot be edit The word document contains a copy of the actual data The word document contains a reference to the original source application The word document must contain a hyperlink The word document cannot be edit The word document contains a copy of the actual data ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS