MS Excel In the formula, which symbol specifies the fixed columns or rows ? & $ * % & $ * % ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? All of above Border format Font format Number format All of above Border format Font format Number format ANSWER DOWNLOAD EXAMIANS APP
MS Excel The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this? None of the listed here Select Format > Money from the menu Click the Currency Style button on the formatting toolbar You have to retype everything and manually add the dollar signs, commas, and decimals None of the listed here Select Format > Money from the menu Click the Currency Style button on the formatting toolbar You have to retype everything and manually add the dollar signs, commas, and decimals ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red All of above Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Getting data from a cell located in a different sheet is called ___ Referencing Updating Accessing Functioning Referencing Updating Accessing Functioning ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS