Ms-Office Practical Guides
In this section, we present the learning materials for your computer practical exam especially in Ms-Office. Most important, frequently asked Questions, Practical Guides, Practice Sets, and Tips & Tricks from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the practical exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's started to learn.
Ms-Powerpoint
Practical Guides
Ms-Powerpoint
Asked Papers
Ms-Powerpoint
Practice Sets
Ms-Powerpoint
Tips & Tricks
Multiple Choice Questions Sets
Here we presents the selected, Most important, frequently asked Multiple Choice Questions from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the written exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's Get started to learn.
Interviews Preparations
The most important part of preparing for an Interview is practice. Preparation is the key to a successfull interview so take a look at Preparations Questions and Tips & Tricks how to answer them. Let's Get started to learn.
Interview Questions
Asked Before
Tips & Tricks
Based on Experience
Question Papers
I knew its hard to find the right question papers in internet from one website. But it's good to say here i collects questions papers sets that are previously asked from psc exams. These questions will be helpful for the final preparation of your exam. Let's start to expand your knowledge.
Section Officer
Asked Before
Computer Officer
Asked Papers
Nayab Subba
Asked Papers
Computer Operator
Asked Papers
Kharidar
Asked Papers
Asst. C.O.
Asked Papers
Modal Practice Paper Sets
Here we have writes some sample practical paper sets for your exam. Try to solve these questions within time at home frequently. If you solve this within time you will cover almost every quetions in exam hall. These questions will be helpful for the final preparation of your exam. Let's start to practice.
Section Officer
Modal Sets
Computer Officer
Asked Papers
Nayab Subba
Modal Sets
Computer Operator
Modal Sets
Kharidar
Modal Sets
Asst. C.O.
Modal Sets
Tutorials & Courses
In this section, we presents the learning materials for your Public Service Commission exam, bank exam, Nea exam, institutional exan etc. This section contains chapters with solutions, cources, or any thing that helps for your written exam, practical exam & interview based on curriculam. Let's start to prepare for your exam.
Section Officer
Tutorials
Computer Officer
Tutorials
Nayab Subba
Tutorials
Computer Operator
Tutorials
Kharidar
Tutorials
Asst. C.O.
Tutorials
Blogging & Wordpress Tutorials, Courses
In this place, you will find blogging tips, new strategies, and will teach you how to be a bogger with just the most basic computer skills. Everything you need to know to start blogging-we'll show you how step by step for blogging and wordpress. Let's Get started to learn.
Post Top Ad
MCQ SETms-excel-mcq-sets
Ms-Excel (Electronic Spreadsheet) Collections of questions from Computer Operator Papers (Pdf file)
Q.1
What is the shortcut key for row hide?
a. Ctrl + 9 b. Ctrl +
F9 c. Shift + F9 d. Ctrl + shift + 9
Q.2
Which is not spreadsheet package?
a.
Lotus b. Excel c. Quatro Pro d. All of the above
Q.3
What will do by filter?
a. Displays the records that meet the criteria b. Displays only one
record to delete
c.
Modify all the records at once d. All
of the above
Q.4
How many sheets are there in excel?
a.
3 b. Many c.
2 d. 1
Q.5
What happen when selecting record pressing delete key?
a.
Row will be deleted b. Content will be deleted
c.
Row moves one step up d.
None of the above
Q.6
What is the name of Excel File?
a. Workbook b. Worksheet c. Spread Sheet d. Spread Book
Q.7
What is the function of workspace?
a.
Contain multiple workbooks. b.
Contain multiple worksheets
c.
Spread Sheet d.
Spread Book
Q.8
Category's written in
a.
X-axis b. Y-axis c. Both d. None
Q.9
What is there in Record?
a.
Collection of Fields b. Collection of
Number c. Collection of Rows d. All
Q.10
What happen when you cut in excel
a.
The content of cell will be removed after paste
b.
The value of cell will be remained after paste
c.
The content of cell will not be removing d.
None of the above
Q.11
You can create only a horizontal page break by first selecting
a.
A row below the row where you want the page break to occur
b.
A cell in Row 1 c. A
cell in Column A d. Both a. and b.
Q.12
How many sheets will open when excel is loaded?
a.
3 b. 5 c. 7 d. Unlimited
Q.13
While typing, number in cell margin is
a.
Right align b. Justify c. Left align d. Center align
Q.14
Workspace is a
a.
collection of workbook b. collection
of sheet c. collection of documents d. all
Q.15
Which character fixes row or column?
a.
& b. $ c. = d. @
Q.16
What is integer value of 3/2+5*0.5+A1 where A1=0.75
a.
4.75 b. 5 c. = d. 6
Q.17
What would be content of A8 if A4 has count (A1:A7) and if A1=1, A2=2, A3=4,
A11=12, A6=Blank, A7=Text
a.
7 b. 5 c. 17 d. 29
Q.18
To delete cell contents
a.
Ctrl + d b. Alt + d c.
Delete d. Esc
Q.19
Where is Merge Cell Tab allocated?
a.
Alignment b. Font c.
Border d. Number
Q.20
The box which is appear right side of chart is called
a.
Legend b. Label c. Series d.
Data marker
Q.21
Function of filter in excel programming is on
a.
Select special character b. Selecting no. c.
Select character d. All
Q.22
When you insert a column in excel when does the previous column moves?
a.
Left side b. Left most
side c. Right side d. Right most side
Q.23
Filter is available on
a.
Tools menu b. Record menu c. Edit menu d. View menu
Q.24
Table is
a.
Row & Column b. Field/Column c. Row & Chart d. None of above
Q.25
The information of cell gives on
a.
Formula bar b. Name bar c. Name box d. Formatting bar
Q.26
Charts holds all the information except
a.
Legend b. Data table c. Axis d. Data label
Q.27
Merge is the process of
a.
Combing b. Splitting c. Sending d. Receiving
Q.28
Which formula returns multiple calculations to a single formula?
a.
Smart formula b. Standard
formula c. Array formula d. Complex formula
Q.29
Types of filter are
a.
Auto filter b. Advanced filter c.
Standard filter d. Both a and b
Q.30
Function of Goal Seek
a.
Method of finding input value b. Method of finding input value to meet
target
c.
Method of accumulating data d. All of the above
Q.31
To arrange Name list in sequential order is
a.
Format b. Sorting c. Order d. List
Q.32
Which of the following operation cannot do in standard toolbar?
a.
Formatting b. Editing c. Wizard d. File management
Q.33
The cell level F5 levels to
a.
Function key F5 b. Row F Column 5 c. Column 5 Rows 5 d. Function available in cell
Q.34
Which is an example of a formula in Ms-Excel?
a.
Sum(A1:A2) b. =A1+A2 c. A1+A2 d. =add(A1:A2)
Q.35
How do you display current date and time in Ms Excel?
a.
Time () b. Date () c. Today () d. Now ()
Q.36
In Ms-Excel B7:B9 indicates
a.
Cell B8 only b. Cell B7 and
B9 only c. Cell B7 through B9 d. None
Q.37
Which of the following is a popular DOS based spreadsheet package?
a.
Lotus 1-2-3 b. Word c. Smart
Cell d. Excel
Q.38
The intersection of row and column is called
a.
An equation b. Data c. A field d. A cell
Q.39
In MS Excel, what happens when dollar sign ($) are entered in a cell address? (ex $B$2:
$B$10)
a.
The status bar does not display the cell address
b.
An absolute cell address in created c.
The Sheet tab is changed
d.
Cell address will change when it is copied to another cell
Q.40
Which operator will combine text from two cells into one cell?
a.
Space b. & (ampersand) c. = (equal) d. None of the above
Q.41
An excel workbook is a collection of
a.
Worksheets and charts b. Workbook c. Worksheets d. Charts
Q.42
The default header for a worksheet is
a.
The sheet tab name b. Your name c. The date and time d. None of these
Q.43
Which of the following is an absolute cell reference?
a.
A1 b. !A!1 c. $A$1 d. #a#1
Q.44
Which symbol must all formula begin with
a.
@ b. = c. + d. (
Q.45
To add two cells (A1 and A2) together you use the following formula
a.
A1 plus A2 b. =A1+A2 c. =add (A1+A2) d. =together (A1:A2)
Q.46
In an excel sheet the active cell is indicated by
a.
A blinking border b. A dark wide
border c. A dotted border d. None
Q.47
You can create hyperlinks from the Excel workbook to
a.
A webpage on company internet b.
A webpage on the internet
c.
Other office 97 application documents d.
All of above
Q.48
The advantage of using a spreadsheet is
a.
Calculations can be done automatically b. More flexibility
c.
Changing data automatically updates calculations d.
All of the above
Q.49
There as three types of data found in a spreadsheet
a.
Numbers, formulas, labels b.
Data, words, numbers
c.
Equations, data, numbers d.
Words, numbers, labels
Q.50
To merge the cells which tab do you use from the format, cells menu?
a.
Merge tab b. Number tab c. Alignment tab d. Font tab
Q.51
How do you rearrange the data in ascending or descending order?
a.
Data, subtotals b. Data, sort
c. Data, form d. Data, table
Q.52
The default row height in a MS Excel worksheet is _________ points
a.
10.75 b. 12.7 c. 13.75 d. 15.75
Q.53
Which of following formula is true in MS Excel?
a.
B6+C6 b. =B6+C6 c. A6+B6 d. A6+C6=
Q.54
Which of the following is not a valid data type in Ms Excel?
a.
Number b. Character c. Label d. Date/time
Q.55
In MS Excel, comments put in cells are called
a.
Smart tip b. Cell tip c. Web tip d.
Soft tip
Q.56
Shortcut key to bring format cells dialog box is
a.
Ctrl + F b. Ctrl + E c. Ctrl + 1 d. Ctrl + D
Q.57
The cell reference $A$5 is
a.
Relative cell reference b. Absolute cell reference c. Mixed cell reference d.
None
Q.58
'OR' operator shows 'True' value when
a.
all conditions are false b.
any one condition is true
c.
both conditions are true d.
both b & c
Q.59
Which of the following methods cannot be used to enter data in a cell?
a.
Clicking the enter button on the formula bar b.
pressing an arrow key
c.
Pressing the Tab key d.
Pressing the Esc key
Q.60
Which of the following keystrokes lets you recalculate the formula?
a.
F9 b. F2 c. F7 d. F3
Q.61
To return the remainder after a number is divided by a divisor in Excel we use
the function
a.
DIV ( ) b. ROUND ( ) c. FACT ( ) d.
MOD ( )
Q.62
What will be the output if you format the cell containing 5436.8 as '#,##0.00'?
a.
6.8 b. 5,430.00 c. 5,436.80 d. 5,436.8
Q.63
Excel displays the current cell address in the
a.
Title bar b. Formula bar c. Status bar d.
Name box
Q.64
Which language is used to crate macros in excel?
a.
Java b. Visual Basic c. Access d.
Visual C++
Q.65
You can delete text by
a.
Selecting the text and pressing the Ext key
b. Selecting the text and pressing the Ctrl key
c.
Selecting the text and pressing the Delete key
d.
Selecting the text and pressing the Alt + Page up key
Q.66
Getting data from a cell located in a different sheet is called
a.
Functioning b. Accessing c. Referencing d. Updating
Q.67
A numeric value can be treated as a label value if it precedes with
a.
Ampersand (&) b. Apostrophe
(') c. Exclamation (!) d. Hash
Q.68
Each excel file is a workbook that contains different sheets. Which of the following cannot
be sheet in a workbook?
a.
Work Sheet b. Chart Sheet c. Module Sheet d. Data Sheet
Q.69
You can auto fit the width of column by
a.
Double clicking on the column name on column header
b.
Double click on the cell pointer in worksheet
c.
Double clicking on column right border on column header
d.
Double clicking on the column left border of column header
Q.70
What is the shortcut key to replace a data with another in sheet?
a.
Ctrl + R b. Ctrl + Shift + R c. Ctrl + H d. Ctrl + F
Q.71
If you need a text to show vertically in a cell. How will you achieve this?
a.
Choose vertical on text alignment in format cells dialog box
b.
Choose 90 degrees in orientation of format cells dialog box
c.
Choose distributed from the vertical drop down list of format cells dialog box
d.
Choose center across selection from horizontal combo box in format cells dialog
box
Q.72
Formatting a cell in number format you can't set
a.
Decimal places b. Use 1000 separator c.
Negative numbers d. Currency symbol
Q.73
Where can you set the shedding color for a range of cells in excel?
a.
Choose required color from patterns tab of format cells dialog box
b.
Choose required color on fill color tool in formatting toolbar
c.
Choose required color on fill color tool in drawing toolbar d. All
Q.74
Which of the following is invalid regarding the protection in Excel?
a.
Protect Sheet b. Protect Workbook c. Protect Workspace d. All
of above
Q.75
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 the above
Q.76
Which
of the following option is not available in Paste Special Dialog box?
a.
Add b. Subtract c. Divide d. SQRT
Q.77
Which one is the last column?
a.
II b. IV c. IX d. VI
Q.78
How many row in MS-Excel?
a.
65535 b. 65636 c. 66535 d. 66536
Q.79
Which shortcut key is used to insert chart?
a.
F10 b. F11 c. F2 d. F8
Q.80
Which one is easiest way to insert a chart?
a.
Select data and go to chart wizard b.
By using shortcut key
c.
By clicking on insert menu d.
None of the above
Q.81
Which is the correct cell address
a.
1A b. $A c. 1#A d. A1
Q.82
Which of the following is/are available in consolidate dialog box?
a.
Sum b. Add c. Both d. None of the above
Q.83
How can you format the cell?
a.
Cell command b.
Font command
c.
Alignment command d.
Conditional formatting command
Q.84
Hyperlink Function in excel is
a.
Links between different cells b.
Link with chart
c.
Creates a shortcut to open document d.
All of the above
Q.85
How to keep border in excel data range?
a.
Click Border button from standard toolbar
b.
Border tab from format cell dialog box c. Both of the above d. None of the above
Q.86
Which of the following menus do not appear in Ms excel menu bar?
a.
Table b. Tools c. Insert d. Window
Q.87
To paste range names into worksheet, choose
a.
Insert, Name, Paste b.
Insert, Name, Define
c.
Edit, Name, Paste d. Edit,
Name, Define
Q.88
What is the function of [∑] tool in Excel Sheet?
a.
AutoFormat b. AutoText c. AutoSum d. AutoCorrect
Q.89
To round a number down to a nearest integer, choose
a.
ABS function b. INT function c. ABC function d. INTEGER function
Q.90
Which of the following is relative cell reference?
a.
$C7 b. C7 c. C$7 d.
$C$7
Q.91
To filter the records, choose
a.
Data, auto filter, filter b.
Tools, auto filter, filter
c.
Data, filter, auto filter d.
Tools, filter, auto filter
Q.92
Which of the following functions is a string function?
a.
IF function b. MAX function c. DATE function d.
MID function
Q.93
What is the short cut key to insert current date in a cell?
a.
Ctrl + * b. Ctrl +: c. Ctrl +; d. Ctrl + Shift +;
Q.94
Which of the following tabs is not available in Format Cells Dialog box in
Excel?
a.
Shading b. Border c. Fonts d. Protection
Q.95
Function to get sum of the contents of the cells A1, A2, B1, and B2 is
a.
=SUM (A1+A2+B1+B2) b. =SUM (A1:B2) c. =TOTAL (A1..B2) d. =SUM (A1, B2)
Q.96
To edit the contents of cell
a.
Press F2 b. Double click on cell c. Click on formula bar d. All of the above
Q.97
Graphical representation of worksheet data
a.
Pivot table b. Goal seek c. Graph d.
Scenario
Q.98
The formula =IF (A1>B1, A1-B1, B1-A1) gives
a.
Larger one from cell A1 and B1 b.
Positive difference of A1 and B1
c.
Contents of A1 d.
Contents of B1
Q.99
What is the shortcut key to select entire row in Excel sheet?
a.
Ctrl + Spacebar b. Alt + Spacebar c.
Shift + Spacebar d. Ctrl + Shift + Spacebar
Q.100
In Excel worksheet the Name box
a.
Appears to the right of the menu bar b.
Appears to the bottom of the menu bar
c.
Appears to the left of the formula bar d.
Appears with status bar
Q.101
Shortcut key Ctrl + Shift +; inserts ________ at the current cell
a.
Current date b.
Current time
c.
Current date that get updated d.
Current time that get updated
Q.102
A box that identifies the patterns or colors that are assigned to the data
series or categories in chart?
a.
Data label b. Title c. Data series d. Legend
Q.103
When the formula bar is activated, you can see
a.
The Edit Formula button b. The
Cancel button c. The Enter button d. All
Q.104
You can add a hyperlink to your worksheet by pressing
a.
Alt + K b. Ctrl + H c. Ctrl + K d. Ctrl + Shift + K
Q.105
Which command will you choose to convert a column of data into row?
a.
Cut and Paste b.
Edit>>Paste Special>>Transpose c.
Both d. None
Q.106
Which of the following action removes a sheet from workbook?
a.
Select the sheet, then choose Edit>>Delete Sheet
b.
Select the sheet, then choose Format>>Sheet>>Hide
c.
Both of the above d. None of the above
Q.107
To remove the content of selected cells you must issue _____ command
a.
Edit >> Delete b.
Edit>>Clear>>Contents c. Edit>>Clear>>All d. Data>>Delete
Q.108
In a worksheet you can select
a.
The entire worksheet b. Rows c. Columns d. A, B and C
Q.109
Which of the following is extension of excel?
a.
exl b. xcl c. xls d. exe
Q.110
In order to add comment in cell one can use following steps
a.
edit>comment b. Comment>edit c. insert>comment d. comment>insert
Q.111
Electronic spreadsheet is also known as
a.
Data processor b. Word processor c. Presentation package
d. None
Q.112
Type of data in a cell of a worksheet
can be of
a.
label b. value c. formula d. all of the above
Q.113
What do you use to create a chart?
a.
chart wizard on toolbar b.
insert>chart on menu bar
c.
insert>diagram on menu bar d.
both a and b
Q.114
Multiple calculations can be made in a single formula by using
a.
complex formula b. array formula c. composite formula d. All
Q.115
How do you protect your excel sheet?
a.
Tool>option>password b.
Tools>protection>protect sheet>password
c. both a
and b d. none of
the above
Q.116
What happen when selecting record presses delete key?
a.
Row will be deleted b.
Content will be deleted
c.
Row moves one step up d. None of
the above
Q.117
While typing, number in cell margin is
a.
Right align b.
Left align
c.
Justify d.
Center align
Q.118
When insert a column in excel previous column moves on
a.
Left side b.
Left most side
c.
Right side d.
Right most side
Q.119
To rename sheet
a.
Format/Rename sheet b.
View/Rename sheet
c.
Insert/Rename sheet d. All of
the above
Q.120
Which is not consolidation?
a.
Sum b. Average c. Count d. PMT
Q.121
How do you keep border in cell?
a.
Click to border button in standard toolbar b.
Edit>cells>border page tab
c.
Format>cells>border page tab d.
All of the above
Q.122
Hyperlink function in excel
a.
Links between different cells b.
Links with chart
c.
Creates a shortcut to open document stored on disk d. All of the above
Q.123
The function of Count A( ) is
a.
Counts the number of empty cells b.
Counts the number of non empty cells
c.
Counts the number of cells contains number d.
All of the above
Q.124
In excel first two lines are fixed to every page is from
a.
Print b. Page setup c. Print preview d. None of above
Q.125
Which is not valid reference in Excel?
a.
Relative reference b. Mixed
reference c. Absolute reference d. Join
reference
Q.126
If a1=5, b2=6, c2=10.5 then what will be output of =int (sum (a1, b2, c2))
a.
21 b. 22 c. 21.5 d. None
Q.127
When you cut the text what will happen in excel?
a.
Remove the text after the paste b.
Removes the text before paste
c.
Does not do anything paste d.
Creates multiple copies without paste
Q.128
Shortcut key to move into the next sheet?
a.
Page up b. Ctrl + Page Up c. Ctrl + Page Down d. Page Down
Q.129
Graphic object is used in chart for?
a.
Emphases the data b. High light
data c. Entertainment d. All of the above
Q.130
What is the value of mod ((D3/10) + int (D3/10), D3) where D3 = 67
a.
13 b. 12 c. 75 d. 86
Solution: =mod (number, divisor)
=mod ((D3/10) + int (D3/10),
D3)
=mod ((67/10) + int (67/10), 67)
=mod (6.7 + 6, 67)
=mod (12.7, 67)
=12.7 because number is smaller than divisor
Q.131
Fill series command is used for
a.
To fill the series of data b. Fill
the same data repeatedly
c.
Fill with text data d.
All of the above
Q.132
=Sum (A1 + A3) is equivalent with
a.
= A1 + A3 b. A1 + A2 + A3 c. = A1 + A2 + A3 d. =Sum (A1:A3)
Q.133
The shortcut key to fill down
a.
F2 b. Ctrl + F, D c. Ctrl + D d. Edit>Fill>Down
Q.134
What will happen if you drag downward for cell containing date?
a.
Auto increment by day b. Auto
increment by month
c.
Auto increment by year d. Copy
same thing
Q.135
Summary function of Excel
a.
Stdv b. Num c. Sum d. All
Q.136
In Ms Excel, to delete an embedded object, first
a.
Select it and then press the delete key b.
Double click the object
c.
Select the object by clicking it d.
Press the shift + Delete keys
Q.137
In Ms Excel, when integrating word and excel, word is usually the
a.
Client and destination b.
Server c. Source d. All of the above
Q.138
The type of Excel application is
a.
Spreadsheet b. Word processor c. Accounting d. All
Q.139
All option found in Menu except
a.
Page number b. Break c. Format Painter d. All
Q.140
What type of chart can be creating?
a.
Bar only b. Column only c. Bar & Column d. None
Q.141
For Excel, data sources can be
a.
dBase b. Excel c. Text file d. All
Q.142
Worksheet is compose of
a.
Row & row b. Column
& column c. Row & column d. None
Q.143
To make a number in cell C1 10% smaller than the number in C3 you enter
a.
=C3*1.10 b. C3*110 c. C3%10 d. =C3*.90
Q.144
To select several cells or ranges that are not touching each other, you would
_____ while selecting
a.
Hold down the Ctrl key b. Hold
down the Shift key
c.
Hold down the Alt key d.
Hold down Ctrl + Shift key
Q.145
What term describes explanatory text attached to a cell?
a.
Callout b. Comment c. Dialog d. Extension
Q.146
Where cannot export from excel file?
a.
.doc b. .csv c. .html d. .xml
Q.147
Count command is used to
a.
Count the number of data fields in an active database file
b.
Count the number of data files which are active
c.
Count the records which are updated
d.
Count the number of records in an active database file
Q.148
In Excel, when a result is too long to fit in a cell what will be displayed?
a.
#N/A b. #Num c. Err d. ####
Q.149
To organize data in a list alphabetically, numerically or chronologically is
known as
a.
filter b. sort c. match d. drag
Q.150
You can type formula in excel from
a.
Menu Bar b. Standard
Toolbar c. Formula Toolbar d. All
Q.151
In Excel, type = if (23<2, 1, 2), what is the cell value?
a.
23 b. 2 c. 1 d. false
Q.152
How do you select a column in excel?
a.
Click on column header b. Click on row
header c. Press Ctrl + Tab d. None
Q.153
How do you put comments in cell?
a.
Edit b. View c. Insert d. Format
Q.154
In excel do not short for
a.
Integer b. Character c. String d. None
Q.155
Ms Excel is popular for
a.
Data Entry b. Document
c. Small calculation d. Presentation
Q.156
False for Excel is
a.
Workbook protect by password b.
Worksheet protect by password
c.
A part of worksheet is protect by password d.
None
Q.157
In Excel "Shrink to fit" does:
a.
Increase/Decrease Font size to fit with cell size
b.
Increase/Decrease cell size to fit with font size
c.
Decrease the font size to fit with cell width
d.
None
Q.158
Which is not text function?
a.
Len b. Count c. Upper d. Proper
Q.159
Arrange the information in the row and column is called
a.
Table b. Field c. Record d. Database
Q.160
The active cell is identified with the
a.
Black border b. Cell pointer c. Cross line
d. White border
Q.161
What is B2 in excel?
a.
=add (A1 + B1) b. = (A2, B1)
c. =A1 + B1 d. together
(A1 +B1)
Q.162
From which menu, you can hide sheet?
a.
View b. Insert c. Format d. Window
Q.163
Which of the following is not related to Ms. Excel?
a.
Row b. Column c. Lookup d. Cell
Q.164
The formula: left ("examination", 4) will result
a.
tion b. error c. exam d. mina
Q.165
3-D reference in a formula in Ms Excel
a.
Spans worksheets b. Array Formula c. Complex Formulas d. Smart Formula
Q.166
What does it mean by Goal seek in spread sheet?
a.
To draw the curve for given cell value
b.
To determine the value of cell for given result
c.
To omit the cell data for given graph
d.
None of the above
Q.167
Which of the following is not provided by standard toolbar in spreadsheet?
a.
File Management b.
Editing commands
c.
Special features such as wizard d.
Cell formatting commands
Q.168
Which facility is not available in Ms Excel?
a.
Graphs b. Database c. Scheduler d. Statistical functions
Q.169
If formula "=SUM ($A$1 + B1)" in cell C1 is copied to cell C2 what
will be the resulting formula in the cell C2
a.
=SUM ($A$1 + B2) b.
=SUM ($A1 + $B1)
c.
=SUM ($A$2 + B1) d.
=SUM ($A$2 + B2)
Q.170
What is wrong with formula=E1 ……. A1 in cell E1 in Excel?
a.
Circular Reference b. Wrong Format c. Invalid cell d. Wrong Operator
Q.171
What will be the output of the following Ms Excel formula = (2^2+4/2*2)
a.
5 b. 16 c. 8 d. 2
Q.172
Which of the following is an example of text in a spreadsheet?
a.
2763 b. Sales 1994 1995 c. =A1 + A2 + A3 d. =SUM (A1+A2+A3)
Q.173
The advantage of using a spreadsheet is
a.
calculations can be done automatically
b.
changing data automatically updates calculations
c.
more flexibility
d.
All of the above
Q.174
How do you display current date and time in Ms excel?
a.
date () b. today () c. now () d. time ()
Q.175
In Ms Excel, B7:B9 indicates
a.
cell B7 and cell B9 only b. cells
B7 through B9 c. cell B8 only d. None
Q.176
Which of the following is a popular DOS based spreadsheet package?
a.
Word b. smart cell c. excel d.
lotus 1-2-3
Q.177
The intersection of a row and column is called
a.
data b. a field c. a cell d. an equation
Q.178
Which of the following is concatenating (adding) operator in excel?
a.
' b. ! c. & d. #
Q.179
When you create two or four separate windows containing part of the spreadsheet that can
be viewed, you have created
a.
sections b. panes c. sub sheets d. views
Q.180
A template file is
a.
A special kind of workbook that provides basic tools for shaping a final work
book
b.
A special work book you can use as a pattern to create other work books of the
same type
c.
A blueprint for the text, graphics & formatting of a work book
d.
All of the above
Q.181
Rounding errors can occur
a.
When you use multiplication, division or exponentiation in a formula
b.
When you use addition and subtraction in a formula
c.
Because excel uses hidden decimal places in computation
d.
None of the above
Q.182
To view a cell comment in Excel
a.
click the edit comment command on the insert menu
b.
click the display comment command on the window menu
c.
position the mouse pointer over the cell
d.
click the comment command on the view menu
Tags: MCQ SET
, ms-excel-mcq-sets

Hey there, i am trying to provide you the new way to learn PSC. I am working hard and pushing the boundaries of possibilities to widen the horizon of the regular tutorials and provide high quality learning materials to all hardworking learners!
Subscribe to:
Post Comments (Atom)
Can you tell me the right ans of Q.154?
ReplyDeleteCan you tell me the right ans of Q.80?
ReplyDeleteanswer sheet dinu n sir
ReplyDeleteOk I will provide
Deleteanswer seet dinu paryo sirv
ReplyDeleteI will provide
ReplyDeleteKnowing every single function and formula in Excel does not make one an expert user of Excel. As observed so often, many Excel users who claim knowing everything about Excel are still spending a lot of time on their spreadsheets. excel expert
ReplyDeletePrint - Printing is a simple method to appropriate data from Excel. Excel spreadsheet consultant
ReplyDeleteI am thankful that I found this website , precisely the right info that I was searching for! . excel expert
ReplyDeleteYasko answer sheet dinu paryo sir
ReplyDeletePlease provide me the answer sheet of the above all question sir plzzz
ReplyDeleteIf you are looking for more information about flat rate locksmith Las Vegas check that right away. huawei screen repair
ReplyDeleteWonderful article. Fascinating to read. I love to read such an excellent article. Thanks! It has made my task more and extra easy. Keep rocking. check this link
ReplyDeleteYes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!Thanks broken screen repair
ReplyDeleteLevels of excellence in business separate the successful and struggling businesses. Excellence is a decision you make internally and run by it. It is an intentional process. It begins at an individual level before is spreads to the organization. It takes excellence in all business systems to bring out excellence in the whole organization's processes. In this article I explore steps you need to take to deliberately exude excellence. word translator
ReplyDeleteMike chose to compose books as he suspected he could contact a larger number of individuals this way rather than preparing individuals in classes. His first books turned out to be smash hits and his books have beaten blockbusters records from that point onward.placement cells database
ReplyDeleteGreat thanks for sharing this article post. Really thank you! Keep writing.
ReplyDeleteChina mosfet manufacturer
https://www.visualaidscentre.com/service/eyes-specialist-delhi/ Mario, being one of the most loved characters of all times, is also the one most played. Over the internet, it could be the most downloaded too. And because of those reasons, it is now possible to play Mario games using an internet browser.
ReplyDeletehttps://www.buyyoutubesubscribers.in/2021/11/20/how-to-earn-money-from-youtube-views/ Knowing how to get more views on YouTube is critical. If you don't have the views, your competitors get them. There are hundreds of ways to get more views on YouTube, however some of them require a team of people or outsourcers or specialized and expensive software and are not feasible for a small business. There are some very easy ways to get more views on YouTube videos that anybody can implement which is what we will talk about here.
ReplyDeleteThe secret in making big profits in the drop shipping of electronic items is to know where to source them at prices that are really cheap. But this is not difficult to do as electronic firms now can afford to give you cheap electronics, as they have learned to outsource their jobs to countries where labor is cheap. Antminer for sale
ReplyDeletehttps://dynamichealthstaff.com/jobs-in-dubai-for-nurses This article explains the need for SEO for SMB's and how it could help them grow their online presence. Search Engine Optimisation is a powerful tool for small / medium sized businesses if used correctly and by the correct people.
ReplyDeleteA lot of people are using computers nowadays for laptop repair and work. Since they were first built, computers have been extremely complex machines. Being so complex, computers are inevitably prone to various errors and problems.
ReplyDeleteI really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day! easybom
ReplyDeleteMeilleure usine d'adhésif et de colle conductrice et conductrice en Chine, colle étanche pour plastique, métal, verre et caoutchouc, spécialisée dans les adhésifs pour semi-conducteurs, appareils ménagers et applications de montage électronique et matériaux de protection de surface pour emballages et tests de copeaux. adhésifs imperméables Chine
ReplyDeleteDays were filled with adventure, imagination, the impossible becoming possible and coming home when the lightning bugs were all caught.작업대출사이트
ReplyDeleteMelhor fábrica de adesiva e colagem não condutora e condutora na China, cola impermeável para plástico, metal, vidro e borracha, especializada em adesivos para semicondutores, eletrodomésticos e aplicações de montagem eletrônica e materiais de proteção de superfície para embalagens e testes de chips. Adesivo de Cura UV para Plástico
ReplyDeleteI haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. ms27467t9b98s
ReplyDeleteIn recent years sports fans have been revamped from what they were many years ago.먹튀검증
ReplyDeleteThere you can download for free, see the first of these data. best Minecraft servers
ReplyDeleteThis introduction brought about the first real signs of competition within computing history, which helped to spur faster and better development of computers. Computer
ReplyDeletehttps://www.pschelper.com/2016/03/ms-excel-electronic-spreadsheet_2.html
ReplyDeleteJercy visits here!
Thanks For sharing! https://castaictree.com/index.html
ReplyDelete