MS Excel Concatenation of text can be done using Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell locator coordinates Column numbers and row letters Cell names Column latters and row numbers Cell locator coordinates Column numbers and row letters Cell names Column latters and row numbers ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Number format All of above Border format Font format Number format All of above Border format Font format ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Workbooks Group of Worksheets Group of Columns Group of Rows Group of Workbooks Group of Worksheets Group of Columns Group of Rows ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Dragging over the desired cells Pressing the Ctrl key while 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 Dragging over the desired cells Pressing the Ctrl key while 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