Microsoft Excel Quiz Questions and Answers - MS Excel MCQ - Page 5

(Showing: 41 - 50 out of 125 MCQs)

Microsoft Excel Quiz Questions and Answers from MS Office topic. These MS Excel mcq are important for the banking examinations. Important MS Office Computer Awareness Questions Answers (mcq) listing for techincal aptitude for IBPS PO , MT Exam, Bank PO, Clerk, SBI, RBI and other competitive.

41. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
[A] Pie chart
[B] Row chart
[C] Line chart
[D] Column chart
42. Which of the following options is not located in the Page Setup dialog box?
[A] Page Break Preview
[B] Page Orientation
[C] Margins
[D] Headers and Footers
43. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
[A] Option buttons
[B] List boxes
[C] Text boxes
[D] Combo boxes
44. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
[A] None of these
[B] Select Format > Money from the menu
[C] Click the Currency Style button on the formatting toolbar
[D] You have to retype everything and manually add the dollar signs, commas, and decimals
45. The Paste Special command lets you copy and paste:
[A] Multiply the selection by a copied value
[B] Cell comments
[C] Formatting options
[D] The resulting values of a formula instead of the actual formula
46. Which of the following is not a term of MS-Excel?
[A] Cells
[B] Rows
[C] Columns
[D] Document
47. Which language is used to create macros in Excel?
[A] Visual Basic
[B] C
[C] Visual C++
[D] Java
48. How many worksheets can a workbook have?
[A] 3
[B] 8
[C] 255
[D] none of above
49. Excel displays the current cell address in the ........
[A] Formula bar
[B] Status Bar
[C] Name Box
[D] Title Bar
50. What is the correct way to refer the cell A10 on sheet3 from sheet1?
[A] sheet3!A10
[B] sheet1!A10
[C] Sheet3.A10
[D] A10
Are these questions helpful for you?

Comments: (Your feedback is valuable to us)