MS Excel Question & Answer MCQ SET 5
41.Excel is a
A) Graphic program
B) Word Processor
C) A spreadsheet
D) None of these
ANSWER: OPTION D
42.One can find “Merge & Center” option under
A) View tab
B) Review tab
C) Home tab
D) Review
ANSWER: OPTION C
43.Which tab is used to set a picture as a sheet background
A) INSERT
B) PAGE LAYOUT
C) HOME
D) REVIEW
ANSWER: OPTION B
44.How does a reference to a range appear in the Consolidate dialog box?
A) Sheet Name!B3!:D7!
B) Sheet Name$B3$:D7
C) Sheet Name!$B3$:$D$7
D) Sheet Name!B3:D7
ANSWER: OPTION C
45.What is the shortcut key to insert new sheet in current workbook?
A) F11
B) Alt + F11
C) Ctrl + F11
D) Shift + F11
ANSWER: OPTION D
46.The Software which contains rows and columns is called______
A) Database
B) Drawing
C) Spreadsheet
D) Work processing
ANSWER: OPTION C
47.An excel workbook is a collection of
A) Workbooks
B) Worksheets
C) Charts
D) Worksheets and charts
ANSWER: OPTION D
48.Which one is the last column header in Excel 2007?
A) XFD
B) XFX
C) XFL
D) XFT
ANSWER: OPTION A
49.Which of the following is true about Find and Replace in Excel
A) Ctrl + H
B) Ctrl + P
C) Ctrl + K
D) Ctrl + M
ANSWER: OPTION A
50.Which menu option can be sued to split windows into two
A) Format > window
B) View > window > split
C) Window > split
D) View > split
ANSWER: OPTION C
51. To protect a worksheet, you can choose Protection and the Protect Sheet from
the _____tab
A) Home
B) Formula
C) Review
D) Data
ANSWER: OPTION C
52. How do you rearrange the data in ascending or descending order?
A) Data>>Sort
B) Data>>Subtotals
C) Data, Form
D) Data>> Table
ANSWER: OPTION A
53. Formatting a cell in Number format you can’t set
A) Use 1000 separator
B) Currency Symbol
C) Negative numbers
D) Decimals Places
ANSWER: OPTION D
0 Comments