MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values None of the listed here Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values None of the listed here Addition and subtraction, positive and negative values, exponentiation ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Cell references but not values Values but not cell references Values or cell references although not both at the same time Value and cell references Cell references but not values Values but not cell references Values or cell references although not both at the same time Value and cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel In help menu of Excel, which of the following tabs are found? Index tab Answer Wizard tab Contents tab All of these Index tab Answer Wizard tab Contents tab All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS