MS Excel Which of the following is a popular DOS based spreadsheet package? Excel Word Smart cell Lotus 1-2-3 Excel Word Smart cell Lotus 1-2-3 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 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 contains a copy of the actual data The word document must contain a hyperlink The word document cannot be edit The word document contains a reference to the original source application The word document contains a copy of the actual data The word document must contain a hyperlink The word document cannot be edit ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Exclamation (!) Ampersand (&) Hash (#) Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number 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 Shift + Home Press Ctrl + Home Press Alt + Home Press Home Press Shift + Home Press Ctrl + Home Press Alt + Home Press Home ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS