Public Service Commission Preparation, Computer Operator, Blogspot and Wordpress Blogging, Qbasic Programming

MCQ SETms-excel-mcq-sets

Ms-Excel (Electronic Spreadsheet) Collections of questions from Computer Operator Papers (Pdf file)

Post Top Ad

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-Word

Practical Guides

Ms-Word

Asked Papers

Ms-Word

Practice Sets

Ms-Word

Tips & Tricks


Ms-Excel

Practical Guides

Ms-Excel

Asked Papers

Ms-Excel

Practice Sets

Ms-Excel

Tips & Tricks


Ms-Powerpoint

Practical Guides

Ms-Powerpoint

Asked Papers

Ms-Powerpoint

Practice Sets

Ms-Powerpoint

Tips & Tricks


Ms-Access

Practical Guides

Ms-Access

Asked Papers

Ms-Access

Practice Sets

Ms-Access

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.


Ms-Word

MCQ Sets

Ms-Excel

MCQ Sets

Ms-Powerpoint

MCQ Sets

Ms-Access

MCQ Sets


HTML

MCQ Sets

Operating System

MCQ Sets



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.


Wordpress

Tips

Blogging

Tips

Wordpress

New Strategies

Blogging

New Strategies


Blogging

Make Money

Wordpress

Make money

Blogging

Guide

Wordpress

Guide


Blogging

For Beginners

Wordpress

For Beginners

Blogging

Tutorials

Wordpress

Tutorials


Wordpress

How to start?

Blogging

How to start?

Blogging

Intermediate

Wordpress

Intermediate


Post Top Ad


ms+excel+icon

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

32 comments:

  1. blogger_logo_round_35

    Can you tell me the right ans of Q.154?

    ReplyDelete
  2. blogger_logo_round_35

    Can you tell me the right ans of Q.80?

    ReplyDelete
  3. blogger_logo_round_35
  4. blogger_logo_round_35
  5. 300x-20180528134951_1527495603
  6. blogger_logo_round_35

    Knowing 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

    ReplyDelete
  7. blogger_logo_round_35

    Print - Printing is a simple method to appropriate data from Excel. Excel spreadsheet consultant

    ReplyDelete
  8. blogger_logo_round_35

    I am thankful that I found this website , precisely the right info that I was searching for! . excel expert

    ReplyDelete
  9. blogger_logo_round_35

    Yasko answer sheet dinu paryo sir

    ReplyDelete
  10. blogger_logo_round_35

    Please provide me the answer sheet of the above all question sir plzzz

    ReplyDelete
  11. blogger_logo_round_35

    If you are looking for more information about flat rate locksmith Las Vegas check that right away. huawei screen repair

    ReplyDelete
  12. blogger_logo_round_35

    Wonderful 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

    ReplyDelete
  13. blogger_logo_round_35

    Yes 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

    ReplyDelete
  14. blogger_logo_round_35

    Levels 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

    ReplyDelete
  15. blogger_logo_round_35

    Mike 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

    ReplyDelete
  16. blogger_logo_round_35

    Great thanks for sharing this article post. Really thank you! Keep writing.
    China mosfet manufacturer

    ReplyDelete
  17. blogger_logo_round_35

    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.

    ReplyDelete
  18. blogger_logo_round_35

    https://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.

    ReplyDelete
  19. blogger_logo_round_35

    The 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

    ReplyDelete
  20. blogger_logo_round_35

    https://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.

    ReplyDelete
  21. blogger_logo_round_35

    A 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.

    ReplyDelete
  22. blogger_logo_round_35

    I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day! easybom

    ReplyDelete
  23. blogger_logo_round_35

    Meilleure 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

    ReplyDelete
  24. blogger_logo_round_35

    Days were filled with adventure, imagination, the impossible becoming possible and coming home when the lightning bugs were all caught.작업대출사이트

    ReplyDelete
  25. blogger_logo_round_35

    Melhor 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

    ReplyDelete
  26. blogger_logo_round_35

    I 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

    ReplyDelete
  27. blogger_logo_round_35

    In recent years sports fans have been revamped from what they were many years ago.먹튀검증

    ReplyDelete
  28. blogger_logo_round_35

    There you can download for free, see the first of these data. best Minecraft servers

    ReplyDelete
  29. blogger_logo_round_35

    This introduction brought about the first real signs of competition within computing history, which helped to spur faster and better development of computers. Computer

    ReplyDelete
  30. blogger_logo_round_35

    https://www.pschelper.com/2016/03/ms-excel-electronic-spreadsheet_2.html

    Jercy visits here!

    ReplyDelete
  31. blogger_logo_round_35

Post Bottom Ad