MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions ANSWER DOWNLOAD EXAMIANS APP
MS Excel Getting data from a cell located in a different sheet is called ___ Referencing Functioning Updating Accessing Referencing Functioning Updating Accessing ANSWER DOWNLOAD EXAMIANS APP
MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when There is not time to format the text There is no suitable abbreviation for the text Data will be entered in the adjacent cells No data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text Data will be entered in the adjacent cells No data will be entered in the adjacent cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel The chart wizard term data series refers to A chart legend A collection of chart data markers A set of values you plot in a chart A data label A chart legend A collection of chart data markers A set of values you plot in a chart A data label ANSWER DOWNLOAD EXAMIANS APP
MS Excel In help menu of Excel, which of the following tabs are found? All of these Answer Wizard tab Contents tab Index tab All of these Answer Wizard tab Contents tab Index tab ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS