MS Excel Which of the following is an absolute cell reference? #a#1 $A$1 !A!1 A1 #a#1 $A$1 !A!1 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet can have a maximum of ________ number of rows. 1048576 65535 1024 256 1048576 65535 1024 256 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date and time in MS Excel ? Date () Time() Today () Now () Date () Time() Today () Now () 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
MS Excel When you link data maintained in an excel workbook to a word document The word document contains a reference to the original source application The word document cannot be edit The word document must contain a hyperlink The word document contains a copy of the actual data The word document contains a reference to the original source application The word document cannot be edit The word document must contain a hyperlink The word document contains a copy of the actual data ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS