MS Excel You can use the drag and drop method to Copy cell contents & Move cell contents Copy cell contents Add cell contents Move cell contents Copy cell contents & Move cell contents Copy cell contents Add cell contents Move cell contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? Press Tab Press the Alt key Press Enter None Press Tab Press the Alt key Press Enter None 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 formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box ANSWER DOWNLOAD EXAMIANS APP