MS Excel Which function is not available in the Consolidate dialog box ? Pmt Sum Max Average Pmt Sum Max Average ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Both of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Both of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a worksheet design criterion? Clarity Description Aditibility Efficiency Clarity Description Aditibility Efficiency ANSWER DOWNLOAD EXAMIANS APP
MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Esc key Shift key Ctrl key End key Esc key Shift key Ctrl key End key 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