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 When a label is too long to fit within a worksheet cell, you typically must Increase the column width Adjust the row height Decrease the column width Shorten the label Increase the column width Adjust the row height Decrease the column width Shorten the label ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Location tabs Reference tabs Sheet tabs Position tabs Location tabs Reference tabs Sheet tabs Position tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: 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 Cell references but not values Values but not cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel To save a workbook, you: Click Save on the Windows Start button Select Edit > Save Click the save button on the standard toolbar from the menu Press Ctrl+ F5 Click Save on the Windows Start button Select Edit > Save Click the save button on the standard toolbar from the menu Press Ctrl+ F5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS