MS Excel Which of the following is an absolute cell reference? A1 $A$1 !A!1 #a#1 A1 $A$1 !A!1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Copy handle Border Fill handle Insert handle Copy handle Border Fill handle Insert handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Columns Group of Worksheets Group of Rows Group of Workbooks Group of Columns Group of Worksheets Group of Rows Group of Workbooks ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing any arrow key on the keyboard Clicking the Enter button on the Formula bar Pressing spacebar Pressing enter Pressing any arrow key on the keyboard Clicking the Enter button on the Formula bar Pressing spacebar Pressing enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can set condition to look for Bold and apply Italics on them 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 add more than one condition to check You can set condition to look for Bold and apply Italics on them 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 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 Dragging over the desired cells Pressing the Ctrl key while dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP