MS Excel Getting data from a cell located in a different sheet is called ___ Updating Referencing Functioning Accessing Updating Referencing Functioning Accessing ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =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 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many characters can be typed in a single cell in Excel? 65535 1024 256 32767 65535 1024 256 32767 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing any arrow key on the keyboard Pressing spacebar Clicking the Enter button on the Formula bar Pressing enter Pressing any arrow key on the keyboard Pressing spacebar Clicking the Enter button on the Formula bar Pressing enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts non-empty cells Counts cells having alphabets Counts empty cells Counts cells having number Counts non-empty cells Counts cells having alphabets Counts empty cells Counts cells having number ANSWER DOWNLOAD EXAMIANS APP