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 How can you show or hide the gridlines in Excel Worksheet Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 1024 256 16384 128 1024 256 16384 128 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar The Edit > Copy Format and Edit>Paste Format commands form the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The cell content of selected cells disappear from cell and stored in clipboard ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS