MS Excel Which function is not available in the Consolidate dialog box ? Pmt Max Average Sum Pmt Max Average Sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the oldest spreadsheet package? VisiCalc Excel StarCalc Lotus 1-2-3 VisiCalc Excel StarCalc Lotus 1-2-3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool A cell that points to a drawing object ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Hold down the shift key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the Ctrl key as you click anywhere in the column Hold down the shift key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the Ctrl key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS