Practice Ms excel - computer mcq Online Quiz (set-1) For All Competitive Exams
Q-1) In Excel which symbol must all formula begin with?
(a)
(b)
(c)
(d)
Q-2) All formula in Excel start with
(a)
(b)
(c)
(d)
Q-3) In Excel if you press …….., the cell accepts your typing as its contents.
(a)
(b)
(c)
(d)
Q-4) In Excel default header for a worksheet is
(a)
(b)
(c)
(d)
Q-5) In Excel you can open the Sort dialog box by choosing Sort from the ….. menu
(a)
(b)
(c)
(d)
Q-6) To select an entire column in MS-EXCEL, press?
(a)
(b)
(c)
(d)
(e)
Q-7) What will be the output If you format the cell containing 5436.8 as '#,##0.00'?
(a)
(b)
(c)
(d)
(e)
Q-8) Which elements of worksheet can be protected from accidental modification
(a)
(b)
(c)
(d)
(e)
Q-9) In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a
(a)
(b)
(c)
(d)
(e)
Q-10) In Excel to add two cells (A1 and A2) together you use the following formula
(a)
(b)
(c)
(d)
Q-11) All worksheet formula
(a)
(b)
(c)
(d)
Q-12) Which of the following is not the correct method of editing the cell content?
(a)
(b)
(c)
(d)
(e)
Q-13) When a range is selected, how can you activate the previous cell?
(a)
(b)
(c)
(d)
(e)
Q-14) Which of the following methods can not be used to edit the contents of a cell?
(a)
(b)
(c)
(d)
(e)
Q-15) In Excel when a label is too long to fit within a worksheet cell, you typically must
(a)
(b)
(c)
(d)
Q-16) In Excel A data map is helpful
(a)
(b)
(c)
(d)
Q-17) A data map is helpful
(a)
(b)
(c)
(d)
(e)
Q-18) How can you delete a record?
(a)
(b)
(c)
(d)
(e)
Q-19) What happens when dollar signs (S) are entered In a cell address?
(a)
(b)
(c)
(d)
(e)
Q-20) Hyperlinks cannot be
(a)
(b)
(c)
(d)
(e)