MS Excel A circular reference is Always erroneous A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself Always erroneous A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of cell or range currently working on None of the listed here Shows the name of worksheet currently working on Shows the name of workbook currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of worksheet currently working on Shows the name of workbook currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Widen the columns Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered Widen the columns Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Row chart Column chart Line chart Pie chart Row chart Column chart Line chart Pie chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a valid data type in Excel ? Character Label Date/Time Number Character Label Date/Time Number ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP