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 Which of the following is an absolute cell reference? $A$1 #a#1 !A!1 A1 $A$1 #a#1 !A!1 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? None of above Both of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet None of above Both of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Is defined by a bold border around the cell Only A and B It is the formula bar Receives the data the user enters Is defined by a bold border around the cell Only A and B It is the formula bar Receives the data the user enters ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values or cell references although not both at the same time Values but not cell references Cell references but not values Value and cell references Values or cell references although not both at the same time Values but not cell references Cell references but not values Value and cell references ANSWER DOWNLOAD EXAMIANS APP