COMPUTER SCIENCE MCQs
COMPUTER SCIENCE MCQs
1. Which of the following format you can decide to apply or
not in AutoFormat dialog box?
A) Number format
B) Border format
C) Font format
D) All of above
Correct Answer: D
2. How can you remove borders applied in cells?
A) Choose None on Border tab of Format cells
B) Open the list on Border tool in Formatting toolbar then choose first tool (no border)
C) Both of above
D) None of above
Correct Answer: C
3. You can set Page Border in Excel from
A) From Border tab in Format Cells dialog box
B) From Border tool in Formatting toolbar
C) From Line Style tool in Drawing toolbar
D) You can not set page border in Excel
Correct Answer: D
4. You can check the conditions against __________ when applying conditional formatting
A) Cell value
B) Formula
C) Both of above
D) None of above
Correct Answer: C
5. When a range is selected, how can you activate the previous cell?
A) Press the Alt key
B) Press Tab
C) Press Enter
D) None of above
Correct Answer: D
6. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
A) work sheet
B) chart sheet
C) module sheet
D) data sheet
Correct Answer: D
7. Which of the following Excel screen components can NOT be turned on or off?
A) Formula Bar
B) Status Bar
C) Tool Bar
D) None of above
Correct Answer: D
8. Which of the following option is not available in Paste Special dialog box?
A) Add
B) Subtract
C) Divide
D) SQRT
Correct Answer: D
9. Which of the cell pointer indicates that you can fill series?
A) Doctor’s symbol (Big Plus)
B) small thin plus icon
C) Mouse Pointer with anchor at the tip
D) None of above
Correct Answer: C
10. Which of the following is an absolute cell reference?
a. !A!1
b. $A$1
c. #a#1
d. A1
Correct Answer: b
11. Which symbol must all formula begin with?
a. =
b. +
c. ( d. @
Correct Answer: a
12. Which of the following formulas is not entered correctly?
a. =10+50
b. =B7*B1
c. =B7+14
d. 10+50
Correct Answer: d
13. Which of the following formulas will Excel Not be able to calculate?
a. =SUM(Sales)-A3
b. =SUM(A1:A5)*.5
c. =SUM(A1:A5)/(10-10)
d. =SUM(A1:A5)-10
Correct Answer: a
14. A worksheet range is a
a. A command used for data modeling
b. A range of values such as from 23 to 234
c. A group of cells
d. A group of worksheets
Correct Answer: c
15. The auto calculate feature
a. Can only add values in a range of cells
b. Provides a quick way to view the result of an arithmetic operation on a range of cells
c. Automatically creates formulas and adds them to a worksheet
d. A and c
Correct Answer: b
16. Excel uniquely identifies cells within a worksheet with a cell name
a. Cell names
b. Column numbers and row letters
c. Column letters and row numbers
d. Cell locator coordinates
Correct Answer: c
17. To drag a selected range of data to another worksheet in the same workbook, use the
a. Tab key
b. Alt key
c. Shift key
d. Ctrl key
Correct Answer: D
18. Hyperlinks can be
a. Text
b. Drawing objects
c. Pictures
d. All of above
Correct Answer: d
19. To activate the previous cell in a pre-selected range, press
a. The Alt key
b. The Tab key
c. The Enter key
d. None of the above
Correct Answer: d
20. Which button do yu click to add up a series of numbers?
a. The autosum button
b. The Formula button
c. The quicktotal button
d. The total button
Correct Answer: a
21. When the formula bar is active, you can see
a. The edit formula button
b. The cancel button
c. The enter button
d. All of the above
Correct Answer: d
22. In a worksheet you can select
a. The entire worksheet
b. Rows
c. Columns
d. All of the above
Correct Answer: b
23. Which area in an excel window allows entering values and formulas
a. Title bar
b. Menu bar
c. Formula bar
d. Standard toolbar
Correct Answer: c
24. To edit in an embedded excel worksheet object in a word document
a. Use the excel menu bar and toolbars inside the word application
b. Edit the hyperlink
c. Edit the data in a excel source application
d. Use the word menu bar and toolbars
Correct Answer: a
25. To create a formula, you can use:
a. Values but not cell references
b. Cell references but not values
c. Values or cell references although not both at the same time
d. Value and cell references
Correct Answer: d
26. Status indicators are located on the
a. Vertical scroll bar
b. Horizontal scroll bar
c. Formula bar
d. Standard toolbar
Correct Answer: c
27. An excel workbook is a collection of
a. Workbooks
b. Worksheets
c. Charts
d. Worksheets and charts
Correct Answer: d
28. Excel files have a default extension of
a. Xls
b. Xlw
c. Wk1
d. 123
Correct Answer: a
29. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
a. IF
b. AND
c. OR
d. NOT
Correct Answer: a
30. Macros are “run” or executed from the ….. menu.
a. Insert
b. Frmat
c. Tools
d. Data
Correct Answer: c
31. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
a. Insert
b. Format
c. Tools
d. Data Correct
Answer: d
32. How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
Correct Answer: c
33. Gridlines
a. May be turned off for display but turned on for printing
b. May be turned on or off for printing
c. The be turned off for display and printing
d. a, b and c
Correct Answer: d
A) Number format
B) Border format
C) Font format
D) All of above
Correct Answer: D
2. How can you remove borders applied in cells?
A) Choose None on Border tab of Format cells
B) Open the list on Border tool in Formatting toolbar then choose first tool (no border)
C) Both of above
D) None of above
Correct Answer: C
3. You can set Page Border in Excel from
A) From Border tab in Format Cells dialog box
B) From Border tool in Formatting toolbar
C) From Line Style tool in Drawing toolbar
D) You can not set page border in Excel
Correct Answer: D
4. You can check the conditions against __________ when applying conditional formatting
A) Cell value
B) Formula
C) Both of above
D) None of above
Correct Answer: C
5. When a range is selected, how can you activate the previous cell?
A) Press the Alt key
B) Press Tab
C) Press Enter
D) None of above
Correct Answer: D
6. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
A) work sheet
B) chart sheet
C) module sheet
D) data sheet
Correct Answer: D
7. Which of the following Excel screen components can NOT be turned on or off?
A) Formula Bar
B) Status Bar
C) Tool Bar
D) None of above
Correct Answer: D
8. Which of the following option is not available in Paste Special dialog box?
A) Add
B) Subtract
C) Divide
D) SQRT
Correct Answer: D
9. Which of the cell pointer indicates that you can fill series?
A) Doctor’s symbol (Big Plus)
B) small thin plus icon
C) Mouse Pointer with anchor at the tip
D) None of above
Correct Answer: C
10. Which of the following is an absolute cell reference?
a. !A!1
b. $A$1
c. #a#1
d. A1
Correct Answer: b
11. Which symbol must all formula begin with?
a. =
b. +
c. ( d. @
Correct Answer: a
12. Which of the following formulas is not entered correctly?
a. =10+50
b. =B7*B1
c. =B7+14
d. 10+50
Correct Answer: d
13. Which of the following formulas will Excel Not be able to calculate?
a. =SUM(Sales)-A3
b. =SUM(A1:A5)*.5
c. =SUM(A1:A5)/(10-10)
d. =SUM(A1:A5)-10
Correct Answer: a
14. A worksheet range is a
a. A command used for data modeling
b. A range of values such as from 23 to 234
c. A group of cells
d. A group of worksheets
Correct Answer: c
15. The auto calculate feature
a. Can only add values in a range of cells
b. Provides a quick way to view the result of an arithmetic operation on a range of cells
c. Automatically creates formulas and adds them to a worksheet
d. A and c
Correct Answer: b
16. Excel uniquely identifies cells within a worksheet with a cell name
a. Cell names
b. Column numbers and row letters
c. Column letters and row numbers
d. Cell locator coordinates
Correct Answer: c
17. To drag a selected range of data to another worksheet in the same workbook, use the
a. Tab key
b. Alt key
c. Shift key
d. Ctrl key
Correct Answer: D
18. Hyperlinks can be
a. Text
b. Drawing objects
c. Pictures
d. All of above
Correct Answer: d
19. To activate the previous cell in a pre-selected range, press
a. The Alt key
b. The Tab key
c. The Enter key
d. None of the above
Correct Answer: d
20. Which button do yu click to add up a series of numbers?
a. The autosum button
b. The Formula button
c. The quicktotal button
d. The total button
Correct Answer: a
21. When the formula bar is active, you can see
a. The edit formula button
b. The cancel button
c. The enter button
d. All of the above
Correct Answer: d
22. In a worksheet you can select
a. The entire worksheet
b. Rows
c. Columns
d. All of the above
Correct Answer: b
23. Which area in an excel window allows entering values and formulas
a. Title bar
b. Menu bar
c. Formula bar
d. Standard toolbar
Correct Answer: c
24. To edit in an embedded excel worksheet object in a word document
a. Use the excel menu bar and toolbars inside the word application
b. Edit the hyperlink
c. Edit the data in a excel source application
d. Use the word menu bar and toolbars
Correct Answer: a
25. To create a formula, you can use:
a. Values but not cell references
b. Cell references but not values
c. Values or cell references although not both at the same time
d. Value and cell references
Correct Answer: d
26. Status indicators are located on the
a. Vertical scroll bar
b. Horizontal scroll bar
c. Formula bar
d. Standard toolbar
Correct Answer: c
27. An excel workbook is a collection of
a. Workbooks
b. Worksheets
c. Charts
d. Worksheets and charts
Correct Answer: d
28. Excel files have a default extension of
a. Xls
b. Xlw
c. Wk1
d. 123
Correct Answer: a
29. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
a. IF
b. AND
c. OR
d. NOT
Correct Answer: a
30. Macros are “run” or executed from the ….. menu.
a. Insert
b. Frmat
c. Tools
d. Data
Correct Answer: c
31. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
a. Insert
b. Format
c. Tools
d. Data Correct
Answer: d
32. How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
Correct Answer: c
33. Gridlines
a. May be turned off for display but turned on for printing
b. May be turned on or off for printing
c. The be turned off for display and printing
d. a, b and c
Correct Answer: d
No comments