Practice Ms excel - computer mcq Online Quiz (set-2) For All Competitive Exams
Q-1) Excel uses the …. Function when creating a data table
(a)
(b)
(c)
(d)
Q-2) In Excel….. is a group of cells that form a rectangle on the screen.
(a)
(b)
(c)
(d)
Q-3) In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu
(a)
(b)
(c)
(d)
Q-4) In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu
(a)
(b)
(c)
(d)
Q-5) In Excel accounting style shows negative numbers in
(a)
(b)
(c)
(d)
Q-6) Which elements of a worksheet can be protected from accidental modification?
(a)
(b)
(c)
(d)
(e)
Q-7) You can add an image to a template by clicking the Insert Picture From File button on the .... Toolbar.
(a)
(b)
(c)
(d)
(e)
Q-8) In Excel you can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
(a)
(b)
(c)
(d)
Q-9) What symbol is used before a number to make it a label?
(a)
(b)
(c)
(d)
(e)
Q-10) To add two cells (A1 and A2) together you use the following formula
(a)
(b)
(c)
(d)
(e)
Q-11) Excel is a good application for What IF analysis. Which of the following tool help you for this?
(a)
(b)
(c)
(d)
(e)
Q-12) Which of the following will not cut information?
(a)
(b)
(c)
(d)
(e)
Q-13) In Excel on an Excel sheet the active cell in indicated by
(a)
(b)
(c)
(d)
Q-14) Which button do you click to add up a series of numbers?
(a)
(b)
(c)
(d)
(e)
Q-15) If you want all of the white cats grouped together In the database, you need to sort by__.
(a)
(b)
(c)
(d)
(e)
Q-16) In Excel Hyperlinks cannot be
(a)
(b)
(c)
(d)
Q-17) Merge cells option can be applied from
(a)
(b)
(c)
(d)
(e)
Q-18) In Excel using the AutoSum button will replace in the selected cell
(a)
(b)
(c)
(d)
Q-19) The advantage of using a spreadsheet is :
(a)
(b)
(c)
(d)
(e)
Q-20) In Excel Tab scrolling button
(a)
(b)
(c)
(d)