MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + F Ctrl + Shift + R Ctrl + R Ctrl + H Ctrl + F Ctrl + Shift + R Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values but not cell references Value and cell references Cell references but not values Values or cell references although not both at the same time Values but not cell references Value and cell references Cell references but not values Values or cell references although not both at the same time ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Source None of these Client Server Source None of these Client ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can check the conditions against ____ when applying conditional formatting Formula None Both Cell value Formula None Both Cell value ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? Sheet tabs can be colored Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Sheet tabs can be colored Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Click the formula bar Press the F2 key Press the Alt key Double click the cell Click the formula bar Press the F2 key Press the Alt key Double click the cell ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS