MS Excel Which function is not available in the Consolidate dialog box ? Pmt Average Sum Max Pmt Average Sum Max ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Home Press Shift + Home Press Alt + Home Press Ctrl + Home Press Home Press Shift + Home Press Alt + Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete From Edit menu choose Clear and then Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel We can save and protect the workbook by Any of the above Write Reservation Password Protection Password Read-only Recommended Any of the above Write Reservation Password Protection Password Read-only Recommended ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Select Tools > Finder from the menu Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Select Tools > Finder from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the horizontal and vertical scroll bars to View different worksheets Split a worksheet into two panes Edit the contents of a cell View different rows and columns edit the contents of a cell View different worksheets Split a worksheet into two panes Edit the contents of a cell View different rows and columns edit the contents of a cell ANSWER DOWNLOAD EXAMIANS APP