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 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 Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Increase the column width Shorten the label Adjust the row height Decrease the column width Increase the column width Shorten the label Adjust the row height Decrease the column width ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Square Divide Percentage Goal seek Square Divide Percentage Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many characters can be typed in a single cell in Excel? 65535 1024 32767 256 65535 1024 32767 256 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Column numbers and row letters Cell locator coordinates Column letters and row numbers Cell names Column numbers and row letters Cell locator coordinates Column letters and row numbers ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? None of above Select the sheet then choose Format > Sheet > Hide Both of above Select the sheet, then choose Edit > Delete Sheet None of above Select the sheet then choose Format > Sheet > Hide Both of above Select the sheet, then choose Edit > Delete Sheet ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS