MS Excel Which of the following is an absolute cell reference? A1 #a#1 !A!1 $A$1 A1 #a#1 !A!1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Data can be arranged in a worksheet in a easy to understand manner using All of the listed here Auto formatting Changing fonts Applying styles All of the listed here Auto formatting Changing fonts Applying styles ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =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) =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text No data will be entered in the adjacent cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text Sheet tabs can be colored The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text Sheet tabs can be colored ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: It is the formula bar Only A and B Receives the data the user enters Is defined by a bold border around the cell It is the formula bar Only A and B Receives the data the user enters Is defined by a bold border around the cell ANSWER DOWNLOAD EXAMIANS APP