291. In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. A. AutoFill B. Auto correct C. Auto sum D. Auto format ✅ The correct answer is option C.
292. Which of the cell pointer indicate that you can move the content to other cell? A. Doctor’s symbol (Big Plus) B. Small thin plus icon C. Mouse Pointer with anchor at the tip D. None of above ✅ The correct answer is option C.
293. How do you display current date and time in MS Excel? A. Date () B. Today () C. Now () D. Time () ✅ The correct answer is option C.
294. It is acceptable to let long text flow into adjacent cells on a worksheet when A. Data will be entered in the adjacent cells B. No data will be entered in the adjacent cells C. There is no suitable abbreviation for the text D. There is not time to format the text ✅ The correct answer is option B.
295. Long text can be broken down into many lines within a cell. You can do this through A. Wrap Text in Format > Cells B. Justify in Edit > Cells C. Text Wrapping in Format > Cells D. All of above ✅ The correct answer is option A.
296. MS Excel provides the default value for step in Fill Series dialog box A. 0 B. 1 C. 5 D. 10 ✅ The correct answer is option B.
297. Which of the following is not true regarding Conditional Formatting? A. You can add more than one condition to check B. You can set condition to look for Bold and apply Italics on them C. You can apply Font, border and pattern formats that meets the specified conditions D. You can delete any condition from Conditional Formatting dialog box if it is not requried ✅ The correct answer is option B.
298. What 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 clipboard B. The cells selected are marked for cutting C. The selected cells are deleted and the cells are shifted left D. The selected cells are deleted and cells are shifted up ✅ The correct answer is option B.
299. The Name box on to the left of formula bar A. Shows the name of workbook currently working on B. Shows the name of worksheet currently working on C. Shows the name of cell or range currently working on D. None of above ✅ The correct answer is option C.
300. Which command will you choose to convert a column of data into row? A. Cut and Paste B. Paste Special > Transpose C. Both of above D. None of above ✅ The correct answer is option B.