PS Exam

MCQ Set 4:- MS-Excel - A set of Objective Questions or Multiple Choice Questions (MCQs) suitable for Computer Jobs Exam such as computer operator conducted by Public Service Commission (PSC) - Lok Sewa Ayog.

60. You can select a single range of cells by

a.   Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b.   Pressing the Ctrl key while dragging over the desired cells

c.   Pressing the Shift key and an arrow key

d.   Dragging over the desired cells

61. Which of these will not select all the cells in a document?

a.   Clicking three times with the right mouse button in the spreadsheet

b.   Using the Edit – Select All menu

c.   Pressing Ctrl + A on the keyboard

d.   Pressing Ctrl + A on the keyboard

62. The default style for new data keyed in a new workbook is

a.   Comma

b.   Currency

c.   Normal

d.   Percent

63. The LEN function does what?

a.   Compares the content in two cells

b.   Counts the numbers of characters in a cell

c.   Deletes extra space in text

d.   All of above

64. Which function converts miles to kilometers, kilograms to pounds, and so on?

a.   Convert

b.   Product

c.   Change

d.   All of above

65. You can use the drag and drop method to

a.   Copy cell contents

b.   Delete cells contents

c.   Add cell contents

d.   All of above

66. To balance your checkbook in Excel, your best method is

a.   Copy your check amounts into Excel so that you’ll have a neat printout to work on

b.   Use Excel to check your arithmetic

c.   Download the Checkbook register templates from Templates on Microsoft Office Online

d.   All of above

67. Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a differene cell

a.   Count

b.   Average

c.   Sum

d.   None of above

68. To name a constant, you use the …… dialog box

a.   Create names

b.   Define name

c.   Paste name

d.   Format cells

69. To cancel the marquee, press

a.   Ctrl + End

b.   End

c.   Esc

d.   Shift + Esc

70. To access the Go To Special feature, you can press

a.   Ctrl + G

b.   Ctrl + O

c.   Ctrl + Shift + G

d.   Ctrl + 1

false false false EN-US X-NONE NE MicrosoftInternetExplorer4

71. which do you press to enter the current date in a cell?

a.   Ctrl + Shift + :

b.   Ctrl + ;

c.   Ctrl + F10

d.   All of above

72. It is acceptable to let long text flow into adjacent cells on a worksheet when

a.   Data will be entered in the adjacent cells

b.   No data will be ente4red in the adjacent cells

c.   There is no suitable abbreviation for the text

d.   There is not time to format the text

73. Which function calculates depreciation at the same amount each year over an asset’s useful life?

a.   DB (fixed-declining balance)

b.   SLN (straight line)

c.   DDB (double-declining)

d.   All of above

74. Documentations should include

a.   Destination and users of the output data

b.   Source of input data

c.   Information on the purpose of the workbook

d.   All of above Correct Answer:  

75. Which of the following is not an underline option in the format cells dialog box?

a.   Double

b.   Single Engineering

c.   Single Accounting

d.   Double Accounting

76. To select a column the easiest method is to …

a.   Double click any cell in the column

b.   Drag from the top cell in the column to the last cell in the column

c.   Click the column heading

d.   Click the column label

77. To select an individual data marker or data label, you must

a.   Double click the data series

b.   Right click selected marker

c.   Click once to select the series markers or labels and click the desired marker or label again

d.   Double click the marker or label

78. To delete and embedded object, first

a.   Double click the object

b.   Select the object by clicking it

c.   Press the Shift + Delete keys

d.   Select it and then press Delete key

79. This type of software contains rows and columns.

a.   Drawing

b.   Spreadsheet

c.   Database

d.   Word processing

80. To open an existing workbook, you can click the Open button on the …… toolbar.

a.   Drawing

b.   Formatting

c.   Forms

d.   Standard