MS Excel In the formula, which symbol specifies the fixed columns or rows ? * & $ % * & $ % ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + Shift + R Ctrl + R Ctrl + H Ctrl + F Ctrl + Shift + R Ctrl + R Ctrl + H ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can enter which types of data into worksheet cells? Formulas only Labels, values, and formulas Values and formulas but not labels Labels and values but not formulas Formulas only Labels, values, and formulas Values and formulas but not labels Labels and values but not formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel An excel workbook is a collection of Worksheets and charts Worksheets Workbooks Charts Worksheets and charts Worksheets Workbooks Charts ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A command used for data modeling A range of values such as from 23 to 234 A group of worksheets A group of cells A command used for data modeling A range of values such as from 23 to 234 A group of worksheets A group of cells 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 The Format Painter button on the standard toolbar 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 Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar 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 ANSWER DOWNLOAD EXAMIANS APP