MS-EXCEL is based on ……….?a. WINDOWSb. DOSc. UNIXd. OS/2In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?a. AutoFillb. Auto correctc. Auto sumd. Auto formatTo select an entire column in MS-EXCEL, press?a. CTRL + Cb. CTRL + Arrow keyc. CTRL + Sd. None of the aboveTo return the remainder after a number is divided by a divisor in EXCEL we … [Read more...]

Which menu option can be used to split windows into two?a. Format -> Windowb. View -> Window-> Splitc. Window -> Splitd. View –> SplitGetting data from a cell located in a different sheet is called….a. Accessingb. Referencingc. Updatingd. FunctioningWhich of the following is not a valid data type in Excel?a. Numberb. Characterc. Labeld. Date/TimeWhich elements of … [Read more...]

The Delete key of keyboard is assigned to which command in Excel?a. Edit >> Clear >> Contentsb. Edit >> Clear >> Allc. Edit >> Deleted. All of aboveIf you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you musta. From Edit menu choose Clear and then Formatsb. From Edit menu choose … [Read more...]

MS Excel provides the default value for step in Fill Series dialog boxa. 0b. 1c. 5d. 10When a row of data is to be converted into columnsa. Copy the cells in row, select the same number of cells in row and pasteb. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OKc. Copy the cells then go to Format >> Cells then on Alignment tab … [Read more...]

Which of the following Excel screen components can NOT be turned on or off?a. Formula Barb. Status Barc. Tool Bard. None of aboveWhat happens when you press Ctrl + X after selecting some cells in Excel?a. The cell content of selected cells disappear from cell and stored in clipboardb. The cells selected are marked for cuttingc. The selected cells are deleted and the cells are … [Read more...]