MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? 8 none of above 255 3 8 none of above 255 3 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 From Edit menu choose Delete From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? Press Enter Press Tab Press the Alt key None Press Enter Press Tab Press the Alt key None ANSWER DOWNLOAD EXAMIANS APP
MS Excel Status indicators are located on the Standard toolbar Horizontal scroll bar Vertical scroll bar Formula bar Standard toolbar Horizontal scroll bar Vertical scroll bar Formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Max Sum Pmt Average Max Sum Pmt ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS