MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 Sheet1!A10 A10 Sheet3.A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing an arrow key Pressing the Tab key Pressing the Esc key Clicking on the formula bar Pressing an arrow key Pressing the Tab key Pressing the Esc key ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you wrap the text in a cell ? Format, cells, font Format, cells, number Format, cells, protection Format, cells, alignment Format, cells, font Format, cells, number Format, cells, protection Format, cells, alignment ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Location tabs Position tabs Reference tabs Sheet tabs Location tabs Position tabs Reference tabs Sheet tabs ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS