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 Ctrl + Home Press Shift + Home Press Alt + Home Press Home Press Ctrl + Home Press Shift + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? MOD ( ) ROUND ( ) FACT ( ) Div ( ) MOD ( ) ROUND ( ) FACT ( ) Div ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A group of worksheets A range of values such as from 23 to 234 A group of cells A command used for data modeling A group of worksheets A range of values such as from 23 to 234 A group of cells A command used for data modeling ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Complex Formulas Smart Formula Array formula Standard Formulas Complex Formulas Smart Formula Array formula Standard Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Page Orientation Page Break Preview Headers and Footers Margins Page Orientation Page Break Preview Headers and Footers Margins ANSWER DOWNLOAD EXAMIANS APP