MS Excel A typical worksheet has ___ number of columns. 256 128 1024 16384 256 128 1024 16384 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Cell comments The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Formatting options Cell comments The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Formatting options ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? 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 set condition to look for Bold and apply Italics on them You can add more than one condition to check 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 set condition to look for Bold and apply Italics on them You can add more than one condition to check ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because You have to work hard to create it It can contain text and data It can contain many sheets including worksheets and chart sheets It can be modified You have to work hard to create it It can contain text and data It can contain many sheets including worksheets and chart sheets It can be modified ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool A cell that points to a drawing object ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS