MS Excel Which menu option can be used to split windows into two ? View > split Window > split Review > window View > window > split View > split Window > split Review > window View > window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification All of the listed here Contents Objects Scenarios All of the listed here Contents Objects Scenarios 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 Clicking the Enter button on the Formula bar Pressing enter Pressing spacebar Pressing any arrow key on the keyboard Clicking the Enter button on the Formula bar Pressing enter Pressing spacebar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =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) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 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 Ctrl+ D shortcut key in Excel will Open the font dialog box Apply double underline for the active cell Fill down in the selection None of the listed here Open the font dialog box Apply double underline for the active cell Fill down in the selection None of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS