MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: It is the formula bar Receives the data the user enters Only A and B Is defined by a bold border around the cell It is the formula bar Receives the data the user enters Only A and B Is defined by a bold border around the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Hyperlinked placed in a word table Linked Use the word menu bar and toolbars Embedded Hyperlinked placed in a word table Linked Use the word menu bar and toolbars Embedded ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? Review > window View > window > split Window > split View > split Review > window View > window > split Window > split View > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both None Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both None ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Ctrl + Home Press Alt + Home Press Home Press Shift + Home Press Ctrl + Home Press Alt + Home Press Home Press Shift + Home ANSWER DOWNLOAD EXAMIANS APP