MS Excel Getting data from a cell located in a different sheet is called ___ Accessing Functioning Updating Referencing Accessing Functioning Updating Referencing ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will Open the font dialog box None of the listed here Apply double underline for the active cell Fill down in the selection Open the font dialog box None of the listed here Apply double underline for the active cell Fill down in the selection ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu All of above 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 Apply Conditional Formatting command on Format menu All of above Use =if() function to format the required numbers red 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? Both of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Both of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the format painter multiple times before you turn it off by Pressing the Alt key and clicking the format painter button Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Alt key and clicking the format painter button Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button You can use the format painter button on ly one time when you click it ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =B7*B1 =10+50 =B7+14 10+50 =B7*B1 =10+50 =B7+14 10+50 ANSWER DOWNLOAD EXAMIANS APP