MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Number format Font format All of above Border format Number format Font format All of above Border format ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Position tabs Location tabs Sheet tabs Reference tabs Position tabs Location tabs Sheet tabs Reference tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H 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 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 There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar 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 There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Paste Special > Transpose Both of above Cut and Paste None of above Paste Special > Transpose Both of above Cut and Paste None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Rows Group of Worksheets Group of Columns Group of Workbooks Group of Rows Group of Worksheets Group of Columns Group of Workbooks ANSWER DOWNLOAD EXAMIANS APP