MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Percentage Divide Square Goal seek Percentage Divide Square 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 + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel B7:B9 indicates: None of these Cells B7 through B9 Cell B8 only Cells B7 and cell B9 only None of these Cells B7 through B9 Cell B8 only Cells B7 and cell B9 only ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because 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 You have to work hard to create it ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To insert a background To add shading or color to a cell range To add borders To select a distribution of figures To insert a background To add shading or color to a cell range To add borders To select a distribution of figures ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is 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 A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS