MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To select a distribution of figures To add borders To add shading or color to a cell range To insert a background To select a distribution of figures To add borders To add shading or color to a cell range To insert a background ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.8 5430 6.8 5436.80 5436.8 5430 6.8 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column numbers and row letters Cell locator coordinates Column latters and row numbers Cell names Column numbers and row letters Cell locator coordinates Column latters and row numbers Cell names ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Select the cell you want to place the formula into Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Select the cell you want to place the formula into ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Fill across worksheet Fill series Custom List Auto fill options Fill across worksheet Fill series Custom List Auto fill options ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS