MOST IMPORTANT MS EXCEL MCQ. PLEASE SHARE
MS Excel Questions Answers
· 1. With which of the following all formulas in excel starts ?
A. /
B. *
C.
$
D. =
Answer: Option D
Explanation:
·
2. On an excel sheet the active cell in indicated by ?
A. A dotted border
B. A dark wide border
C.
A blinking border
D. By italic text
Answer: Option B
Explanation:
·
3. What term describes explanatory text attached to a cell ?
A. Context
B. Callout
C.
Comment
D. Dialog
Answer: Option C
Explanation:
·
4. How we can view a cell comment ?
A. position the mouse pointer over
the cell
B. click the comment command on
the view menu
C.
click the edit comment commands on the Insert menu
D. click the Display comment
command on the window menu
Answer: Option A
Explanation:
·
5. Which of these will not select all the cells in a document ?
A. Using the Edit – Select All
menu
B. Pressing Ctrl + A on the
keyboard
C.
Clicking three times with the right mouse button in the
spreadsheet
Answer: Option C
Explanation:
·
6. The default style for new data keyed in a new workbook is ?
A. Comma
B. Normal
C.
Currency
D. Percent
Answer: Option B
Explanation:
·
7. If you press ___, the cell accepts your typing as its
contents ?
A. Tab
B. Ctrl+Enter
C.
Enter
D. Alt+Enter
Answer: Option C
·
8. Which of the following keyboard shortcut can be used for
creating a chart from the selected cells ?
A.
F11
B.
F10
C.
F4
D.
F2
Answer: Option A
Explanation:
·
9. Formula palette is used to ?
A. format cells containing numbers
B. create and edit formulas
containing functions
C.
entered assumptions data
D. copy all cells
Answer: Option B
Explanation:
·
10. A value used in a formula that does not change is called a ?
A. Constant
B. Cell address
C.
Varaible
D. Static
Answer: Option A
Explanation:
·
11. A Spreadsheet contains ?
A. columns
B. rows
C.
rows and columns
D. None of above
Answer: Option C
Explanation:
·
12. To open an existing workbook, click the Open button on the
___ toolbar ?
A. Form
B. Standard
C.
Drawing
D. Formatting
Answer: Option B
Explanation:
·
13. Which among following is not associated with spelling
dialogue box ?
A. Edit
B. Ignore
C.
Ignore All
D. Change
Answer: Option A
Explanation:
·
14. what term describes a background that appears as a grainy,
non smooth surface ?
A. Pattern
B. Gradient
C.
Texture
D. Velvet
Answer: Option B
·
15. Which among following is associated with excel ?
A.
Graphic program
B.
Word Processor
C.
Presentation
D.
Spreadsheet
Answer: Option D
Explanation:
·
16. The cell reference for a range of cells that starts in cell
C1 and goes over to column H and down to row 10 is ?
A. C1:10H
B. C1:H10
C.
C1:H-10
D. C1:H:10
Answer: Option B
Explanation:
·
17. You can convert existing Excel worksheet data and charts to
HTML document by using the ?
A. Internet Assistant Wizard
B. Intranet Wizard
C.
Import Wizard
D. Export Wizard
Answer: Option A
Explanation:
·
18. To create an interactive Pivot Table for the web, you use a
Microsoft Office Web component called ?
A. HTML
B. Pivot Table Field List
C.
Pivot Table Report
D. Pivot Table List
Answer: Option C
Explanation:
·
19. What function displays row data in a column or column data
in a row ?
A. Transpose
B. Index
C.
Rows
D. Hyperlinks
Answer: Option A
Explanation:
·
20. Except which of the following function, a formula with a
logical function shows the word "TRUE" or "FALSE" as a result
?
A. NOT
B. OR
C.
IF
D. AND
Answer: Option C
Explanation:
·
21. Macros can be executed from the which of the following menu
?
A. Format
B. Home
C.
Insert
D. Tools
Answer: Option D
·
22. Protection and the Protect Sheet options can be selected
from ?
A.
Data
B.
Tools
C.
Edit
D.
Format
Answer: Option B
Explanation:
·
23. Which of the following is not a valid Zoom percentage in
Excel ?
A. 10
B. 100
C.
300
D. 500
Answer: Option D
Explanation:
·
24. You can check the conditions against ____ when applying
conditional formatting ?
A. Cell Value
B. Formula
C.
Both of above
D. None of above
Answer: Option C
Explanation:
·
25. How can we set Page Border in Excel ?
A. From Edit menu
B. From Home
C.
You can not set page border in Excel
D. From Tools menu
Answer: Option C
Explanation:
·
26. Which function calculates your monthly mortage payment ?
A. PV
B. NPER
C.
PMT
D. All of above
Answer: Option C
Explanation:
·
27. Which types of charts can excel produce ?
A. Line graphs and pie charts only
B. Bar charts, line graphs and pie
charts
C.
Bar charts and line graphs only
D. Only line graphs
Answer: Option B
Explanation:
·
28. How is data organized in a spreadsheet ?
A. Rows and columns
B. Layers and planes
C.
Lines and spaces
D. Height and width
Answer: Option A
·
29. VLOOKUP function used to ?
A.
Finds related records
B.
Looks up text that contain "v"
C.
Check if two cells are identical
D.
None of above
Answer: Option A
Explanation:
·
30. Gridlines may be turned off for display but turned on for
printing.
A. True
B. False
Answer: Option A
Explanation:
·
31. How do you change column width to fit the contents ?
A. Single-click the boundary to
the left to the column heading
B. Double click the boundary to
the right of the column heading
C.
Press Alt and single click anywhere in the column
D. All of above
Answer: Option B
Explanation:
·
32. To insert three columns between columns A and B you would
A. Select column A
B. Select A and B
C.
Select B
D. All of above
Answer: Option C
Explanation:
·
33. To drag a selected range of data to another worksheet in the
same workbook, use the ?
A. Ctrl key
B. Shift key
C.
Alt key
D. Tab key
Answer: Option A
Explanation:
·
34. You can activate a cell by ?
A. Pressing the Tab key
B. Clicking the cell
C.
Pressing an arrow key
D. All of above
Answer: Option D
Explanation:
·
35. A function inside another function is known as ?
A. Round function
B. Sandwich function
C.
Switch function
D. Nested function
Answer: Option D
·
36. What excel feature can you use if you want to work with one
record at a time ?
A.
Auto Complete
B.
Data Form
C.
Set Form
D.
Auto Text
Answer: Option B
Explanation:
·
37. Which function is used for creating a data table ?
A. Sum
B. Table
C.
Add
D. Count
Answer: Option B
Explanation:
·
38. The accounting style shows negative numbers in ?
A. Bold
B. Italics
C.
Parentheses
D. Quotes
Answer: Option C
Explanation:
·
39. 3-D reference in a formula ?
A. Spans worksheets
B. Can not be modified
C.
Only appears on summary worksheets
D. Limits the formatting options
Answer: Option A
Explanation:
·
40. Auto calculate feature provides a quick way to view the
results of an arithmetic operation on a range of cells.
A. True
B. False
Answer: Option A
Explanation:
o
No comments:
Post a Comment