12- How to create a macro?
(A). View-Macro-Record
(B). View-Macro-View Macro
(C). Review-Macro-Record Macro
(D). Insert-Macro
13- Under the mailing tab envelopes and labels contained in which menu?
(A). Envelopes
(B). Create
(C). Insert field
(D). References
14- The command insert caption is found in which group of references tab?
(A). Table of contents
(B). Footnotes
(C). Captions
(D). Index
15- Orientation command is included in which group
(A). Page setup group
(B). Page preview group
(C). Portrait Group
(D). Paragraph group
16- The intersection point of row and column in Excel is known as ________
(A). Cell
(B). Area
(C). Range
(D). Sheet
17- The basic arrangement for a spreadsheet is ________
(A). Row
(B). Cell
(C). Grid
(D). Column
18- How many worksheets are there in a workbook by default?
(A). 1
(B). 3
(C). 5
(D). 7
19- Where do the ‘Protect sheet’ options appear in Excel?
(A). Home-style
(B). Home-Editing
(C). Home-Cell-Format
(D). Home-Clipboard-Paste
20- Which chart is used to show what percent of a particular item represents a data series?
(A). Pie chart
(B). Bar chart
(C). Line graph
(D). Scatter plot
21- What is the shape of the mouse pointer when it is moved to the bottom right corner of the cell?
(A). —
(B). +
(C). *
(D). ↑
22- Which one is useful for speedy data analysis in MS Excel?
(A). Macros
(B). Data forms
(C). Pivot table
(D). Data validation
ANSWERS:
12-(A), 13-(B), 14-(C), 15-(A), 16-(A), 17-(C), 18-(B), 19-(C), 20-(A), 21-(B), 22-(C)