MS Excel A numeric value can be treated as a label value if it precedes with Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Macro sheet Data sheet Chart sheet Work sheet Macro sheet Data sheet Chart sheet Work sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Sum Max Pmt Average Sum Max Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address 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 Alt + Home Press Home Press Shift + Home Press Ctrl + Home Press Alt + Home Press Home Press Shift + Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Edit > Delete command Deletes Formats of cell Deletes the comment of cell Deletes the content of a cell Deletes selected cells Deletes Formats of cell Deletes the comment of cell Deletes the content of a cell Deletes selected cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS