Ms-Excel (Electronic Spreadsheet)
Collections of
questions from Computer Operator Papers (PSC)
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
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
ReplyDelete