MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? A10 Sheet3.A10 Sheet3!A10 Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 Sheet1!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Applies a boarder around the selected cells Automatically adds range of cell values All of the listed here Extends a sequential series of data Applies a boarder around the selected cells Automatically adds range of cell values All of the listed here Extends a sequential series of data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following Excel screen components can NOT be turned on or off ? Status Bar None Formula Bar Tool Bar Status Bar None Formula Bar Tool Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into 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 Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into 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 Which menu option can be used to split windows into two View > window > split Format > window View > split Window > split View > window > split Format > window View > split Window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Click on Sheet 3 and from Edit menu choose Delete None of above Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete None of above Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu ANSWER DOWNLOAD EXAMIANS APP