MS Excel When a label is too long to fit within a worksheet cell, you typically must Decrease the column width Shorten the label Adjust the row height Increase the column width Decrease the column width Shorten the label Adjust the row height Increase the column width ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Shift key and an arrow key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel An excel workbook is a collection of Workbooks Worksheets Charts Worksheets and charts Workbooks Worksheets Charts Worksheets and charts ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS