Computer Operator

MCQ Practice

No.	Name
1.	Computer Fundamental Miscellaneous
2.	Operating System
3.	MS Word
4.	MS Excel
5.	Power Point

Computer Operator Written Exam First Paper Syllabus Topics
1. Computer Fundamental – 14 Questions
2. Operating System – 5 Questions
3. Word Processing – 10 Questions
4. Electronic Spreadsheet – 10 Questions
5. Database Management System – 5 Questions
6. Presentation System – 3 Questions
7. Web Page Designing- 3 Questions
Total Questions – 50

Computer Operator Practical Exam Syllabus Topics
1. Devnagari Typing – 15 Marks
2. English Typing – 5 Marks
3. Word Processing – 10 Marks
4. Electronic Spreadsheet – 10 Marks
5. Database Management System – 4 Marks
6. Presentation System – 3 Marks
7. Web page Designing – 3 Marks
Total Marks – 50

Highlight the full questions that are difficult to remember even after reading Computer fundamental MCQ for the third time.

1)     In which generation transistor is used?

a)     1st

b)     2nd

c)     3rd

d)     4th

2)     Which device cannot be shared in the network?

a)     Floppy

b)     Keyboard

c)     Computer

d)     Printer

3)     Which port does not exist in the computer?

a)     USB

b)     Parellel

c)     COM 1/ COM 2

d)     No one of the above

4)     1 nibble contains ………….. bit

a)     8 bits

b)     3 bits

c)     1 byte

d)     4 bits

5)     UNIVAC is 

a)     Universal Automatic Computer 

b)     Universal Array Computer 

c)     Unique Automatic Computer 

d)     Unvalued Automatic Computer  

6)      Integrated Circuits (ICs) are related to which generation of computers? 

a)     First generation  

b)     Second generation  

c)     Third generation  

d)     Fourth generation  

7)     The basic operations performed by a computer are

a)     Arithmetic operation  

b)     Logical operation  

c)     Storage and relative  

d)     All the above  

8)     The two major types of computer chips are 

a)     External memory chip  

b)     Primary memory chip  

c)     Microprocessor chip  

d)     Both b and c  

9)     Microprocessors as switching devices are for which  generation computers 

a)     First Generation  

b)     Second Generation  

c)     Third Generation  

d)     Fourth Generation  

10) Which device will process data?

a)     RAM

b)     Hard disk

c)     CPU

d)     None

11) Data store in…

a)     Floppy

b)     Hard disk

c)     Tape

12) All of the above

a)     One nanosecond means

b)     10-6 seconds

c)     10-9 seconds

d)     10-12 seconds

e)     10-15 seconds

13) The decimal equivalent of binary (1011) is….

a)     13

b)     10

c)     11

d)     14

14) The scanner is the …….. device of the computer system

a)     Input

b)     Output

c)     Input output

d)     Processing

15) Pentium means the ….. of the computer.

a)     ALU

b)     Microprocessor

c)     Monitor

d)     Memory

16) What is the name is given to the first generation of computer language?

a)     Binary language

b)     Machine language

c)     Primary language

d)     Natural language

17) Compiler and interpreters are themselves…….

a)     Hardware

b)     Program

c)     Virus

d)     No one of the above

18) Which of the following is a mass storage device?

a)     CDROM

b)     Hard disk

c)     Tape

d)     All of the above

19) A single byte consists of ……

a)     4bits

b)     16bits

c)     8bits

d)     7 bits

20) The main basic block of a computer system consists of……

a)     Input, output, CPU, and memory

b)     Input, output, storage, and user

c)     RAM, ROM, Floppy, and UPS

d)     RAM, hard disk, keyboard, and monitors

21) According to the working principle, the computer is divided as……

a)     Analog computer

b)     Digital computer

c)     Hybrid computer

d)     All of the above

22) What is modem?

a)     Analog and digital converter

b)     Modulator and demodulator

c)     Telephone switching

d)     None of the above

23) 1 MB corresponds to…

a)     1024 bytes

b)     1024 terabytes

c)     1024 kilobytes

d)     1024 GB

24) 1 GB corresponds to…

a)     1024 MB

b)     1024 byte

c)     1024 TB

d)     1024 GB

25) There are … types of language processor,

a)     1

b)     2

c)     3

d)     4

1-B	2-B	3-D	4-D	5-A	6-C	7-D	8-D	9-D	10-C
11-D	12-B	13-C	14-A	15-B	16-B	17-B	18-D	19-C	20-A
21-D	22-B	23-C	24-A	25-C

 

Fundamentals of Computer

(Multiple Choice Question with Solution)

1.                 Abacus was the first
A) electronic computer
B) mechanical computer
C) electronic calculator
D) mechanical calculator

2.                  If in a computer, 16 bits are used to specify address in a RAM, the number of addresses will be
A) 216
B) 65,536
C) 64K
D) Any of the above

3.                 Instructions and memory address are represented by
A) Character code
B) Binary codes
C) Binary word
D) Parity bit

4.                 People often call ______ as the brain of computer system
A) Control Unit
B) Arithmetic Logic Unit
C) Central Processing Unit
D) Storage Unit

5.                 Which is used for manufacturing chips?
A) Bus
B) Control unit
C) Semiconductors
D) A and b only

6.                  The value of each bead in heaven is
A) 1
B) 3
C) 5
D) 7

7.                 The first computer introduced in Nepal was
A) IBM 1400
B) IBM 1401
C) IBM 1402
D) IBM1402

8.                 Mnemonic a memory trick is used in which of the following language?
A) Machine language
B) Assembly language
C) High level language
D) None of above

9.                  Which generation of computer is still under development
A) Fourth Generation
B) Fifth Generation
C) Sixth Generation
D) Seventh Generation

10.             Which was the most popular first generation computer?
A) IBM 1650
B) IBM 360
C) IBM 1130
D) IBM 2700

11.            Which is considered a direct entry input device?
A) Optical scanner
B) Mouse and digitizer
C) Light pen
D) All of the above

12.            A set of information that defines the status of resources allocated to a process is
A) Process control
B) ALU
C) Register Unit
D) Process description

13.            Each set of Napier’s bones consisted of ______ rods.
A) 5
B) 9
C) 11
D) 13

14.            BCD is
A) Binary Coded Decimal
B) Bit Coded Decimal
C) Binary Coded Digit
D) Bit Coded Digit

15.            When was the world’s first laptop computer introduced in the market and by whom?
A) Hewlett-Packard, 1980
B) Epson, 1981
C) Laplink Traveling Software Inc, 1982
D) Tandy Model-200, 1985

16.            From which generation operating systems were developed?
A) First
B) Second
C) Third
D) Fourth

17.            The first firm to mass-market a microcomputer as a personal computer was
A) IBM
B) Super UNIVAC
C) Radio Shaks
D) Data General Corporation

18.            Properly arranged data is called
A) Field
B) Words
C) Information
D) File

19.             A computer consists of
A) A central processing unit
B) A memory
C) Input and output unit
D) All of the above

20.            Why are vacuum tubes also called valves?
A) Because they can amplify the weak signals and make them strong
B) Because they can stop or allow the flow of current
C) Both of above
D) None of above

21.            John Napier invented Logarithm in
A) 1614
B) 1617
C) 1620
D) None of above

22.            An integrated circuit is
A) A complicated circuit
B) An integrating device
C) Much costlier than a single transistor
D) Fabricated on a tiny silicon chip

23.            What type of control pins are needed in a microprocessor to regulate traffic on the bus, in order to prevent two devices from trying to use it at the same time?
A) Bus control
B) Interrupts
C) Bus arbitration
D) Status

24.            Where as a computer mouse moves over the table surface, the trackball is
A) Stationary
B) Difficult to move
C) Dragged
D) Moved in small steps

25.            Which of the following is used as a primary storage device?
A) Magnetic drum
B) Hard Disks
C) Floppy
D) All of above

26.             Multi user systems provided cost savings for small business because they use a single processing unit to link several
A) Personal computers
B) Workstations
C) Dumb terminals
D) Mainframes

27.            What are the three decisions making operations performed by the ALU of a computer?
A) Grater than
B) Less than
C) Equal to
D) All of the above

28.             The word processing task associated with changing the appearance of a document is
A) Editing
B) Writing
C) Formatting
D) All of above

29.            Nepal brought a computer for census of 2028 BS. This computer was of
A) first generation
B) second generation
C) third generation
D) fourth generation

30.            Algorithm and Flow chart help us to
A) Know the memory capacity
B) Identify the base of a number system
C) Direct the output to a printer
D) Specify the problem completely and clearly

31.             Which statement is valid about computer program?
A) It is understood by a computer
B) It is understood by programmer
C) It is understood user
D) Both a & b

32.             The difference between memory and storage is that memory is _____ and storage is __
A) Temporary, permanent
B) Permanent, temporary
C) Slow, fast
D) All of above

33.            When was Pascaline invented?
A) 1617
B) 1620
C) 1642
D) 1837

34.             Which of the following statement is valid?
A) Lady Augusta is the first programmer
B) Ada is the daughter of Lord Byron, a famous English poet
C) ADA is a programming language developed by US Defense
D) All of above

35.             A compiler is a translating program which
A) Translates instruction of a high level language into machine language
B) Translates entire source program into machine language program
C) It is not involved in program’s execution
D) All of above

36.            What is required when more than one person uses a central computer at the same time?
A) Light pen
B) Mouse
C) Digitizer
D) Terminal

37.            Which of the following is the first computer to use Stored Program Concept?
A) UNIVAC
B) ENIAC
C) EDSAC
D) None of above

38.             The term gigabyte refers to
A) 1024 bytes
B) 1024 kilobytes
C) 1024 megabytes
D) 1024 gigabyte

39.            Once you load the suitable program and provide required data, computer does not need human intervention. This feature is known as
A) Accuracy
B) Reliability
C) Versatility
D) Automatic

40.            What is a brand?
A) The name of companies that made computers
B) The name of product a company gives to identify its product in market
C) A name of class to indicate all similar products from different companies
D) All of above

41.            Machine language is
A) Machine dependent
B) Difficult to program
C) Error prone
D) All of above

42.             A byte consists of
A) One bit
B) Four bits
C) Eight bits
D) Sixteen bits

43.            Modern Computers are very reliable but they are not
A) Fast
B) Powerful
C) Infallible
D) Cheap

44.            What is the date when Babbage conceived Analytical engine
A) 1642
B) 1837
C) 1880
D) 1850

45.            UNIVAC is
A) Universal Automatic Computer
B) Universal Array Computer
C) Unique Automatic Computer
D) Unvalued Automatic Computer

46.             The two major types of computer chips are
A) External memory chip
B) Primary memory chip
C) Microprocessor chip
D) Both b and c

47.            Microprocessors as switching devices are for which generation computers
A) First Generation
B) Second Generation
C) Third Generation
D) Fourth Generation

48.            What is the main difference between a mainframe and a super computer?
A) Super computer is much larger than mainframe computers
B) Super computers are much smaller than mainframe computers
C) Supercomputers are focused to execute few programs as fast as possible while mainframe uses its power to execute as many programs concurrently
D) Supercomputers are focused to execute as many programs as possible while mainframe uses its power to execute few programs as fast as possible.

49.           Storage capacity of magnetic disk depends on
A) tracks per inch of surface
B) bits per inch of tracks
C) disk pack in disk surface
D) All of above

50.            The two kinds of main memory are:
A) Primary and secondary
B) Random and sequential
C) ROM and RAM
D) All of above

Microsoft Office Word

1.     How many different positions can you set for drop cap?
a. 1
b. 2
c. 4
d. 6

2.     How many ways you can save a document?
a. 3
b. 4
c. 5
d. 6

3.     What is the default number of lines to drop for drop cap
a. 3
b. 10
c. 15
d. 20

4.     What is the maximum number of lines you can set for a drop cap?
a. 3
b. 10
c. 15
d. 20

5.     In a document what is the maximum number of columns that can be inserted in MS Word Table?
a. 35
b. 15
c. 63
d. 65

6.     What is the maximum scale percentage available in Scale drop down box?
a. 500
b. 200
c. 100
d. 90

7.     What is the maximum font size you can apply for any character
a. 163
b. 1638
c. 16038
d. None of above

8.     Word, by default, places a tab stop at every _____ mark on the ruler.
a. .25″
b. .5″
c. .75″
d. 1″

9.     What is the default file extension for all Word documents?
a. .txts
b. .word
c. .docs
d. .docx

10.                  The file type _____ indicates the file is a Word document.
a. .msw
b. .wor
c. .wrd
d. .doc

11.                  How much space in minimum must be provided between columns?
a. 0″
b. 0.5″
c. 1″
d. 1.5″

12.                  What is the smallest width of a column?
a. 0″
b. 0.5″
c. 1″
d. 1.5″

13.                  What is the default left margin in Word 2003 document?
a. 1″
b. 1.25″
c. 1.5″
d. 2″

14.                  What is the smallest and largest font size available in Font Size tool on formatting toolbar?
a. 8 and 72
b. 8 and 64
c. 12 and 72
d. None of above

15.                  The Footnote Text style defines characters as _____.
a. 12-point Times New Roman and paragraphs as single-spaced and right-aligned
b. 10-point Times New Roman and paragraphs as double-spaced and left-aligned
c. 12-point Times New Roman and paragraphs as double-spaced and right-aligned
d. 10-point Times New Roman and paragraphs as single-spaced and left-aligned

16.                  The minimum number of rows and columns in MS Word document is
a. 1 and 1
b. 2 and 1
c. 2 and 2
d. None of above

17.                  How will MS Word will respond in repeated word.
a. A Red wavy line under the repeated word
b. A Green wavy line under the repeated word
c. A Blue wavy line under the repeated word
d. None of the above

18.                  In mail merge operation which of the following might represent the main document?
a. A sales brochure
b. A form letter
c. A database of Names and Addresses
d. All of above

19.                  Pressing F8 key for three times selects
a. a word
b. a sentence
c. a paragraph
d. entire document

20.                  What do you call ‘a collection of character and paragraph formatting commands’?
a. the defaults
b. a template
c. a style
d. a boilerplate

21.                  Ctrl + Z
a. Undo the last Action
b. Redo the last Action
c. Add the new page
d. Paste the contents from clipboard

22.                  What does Ctrl + =  key effect?
a. Superscript
b. Subscript
c. All Caps
d. Shadow

23.                  How can you make the selected character superscripted
a. Ctrl + =
b. Ctrl + Shift +  =
c. Alt + Ctrl + Shift + =
d. None of above

24.                  When typing in a word field manually, what must you press to insert the code’s braces?
a. Ctrl + F6
b. Ctrl + F9
c. Alt + F11
d. Shift + F12

25.                  What is the short cut key to open the Open dialog box?
a. F12
b. Shift F12
c. Alt + F12
d. Ctrl + F12

26.                  What is the shortcut key to split a table?
a. Ctrl + Alt + Enter
b. Ctrl + Shift + Enter
c. Alt + Shift + Enter
d. Alt + Space + Enter

27.                  Which key is used to increase left indent?
a. Ctrl+I
b. Ctrl+M
c. Alt+I
d. F10

28.                  How many different documents you can open at one time?
a. No more than three
b. Only one
c. As many as your computer memory will hold
d. As many as your taskbar can display

29. Which of the following is the second step in creating a macro?
a. Start recording
b. Using your mouse or keyboard, perform the task you want to automate
c. Assign a keyboard shortcut to the macro
d. Give the macro a name

30. Which feature is used to replace straight quotes with smart quotes as you type?
a. Auto Correct as you type
b. Auto Change as you type
c. Auto Format as you type
d. Smart Tags as you type

31. Which of the following command is not available in Tools menu?
a. Auto text
b. Autocorrect
c. Auto summarize
d. Macro

32. Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct.
a. AutoEntry
b. AutoCorrect
c. AutoAdd
d. AutoSpell

33. If you want to convert a symbol or several lines of text into an AutoCorrect entry, you should:
a. Insert the symbol or type the text in a Word document first. Then, select the text or symbol and go to the AutoCorrect dialog box.
b. Click the Tools menu and choose AutoCorrect Options. Then, click the Insert menu and choose Symbol (or click the Format menu and choose Paragraph) to add the symbol or paragraph to AutoCorrect.
c. AutoCorrect can only accommodate one line of text. It is not possible to convert a symbol or multiple lines of text into an AutoCorrect entry.
d. Insert the symbol or type the text in a Word document first. Then, select the text or symbol and click the Edit menu followed by Paste Special. Select New AutoCorrect Entry and then click OK.

34.                  Which option is not available in Insert Table Autofit behavior?
a. Fixed Column Width
b. AutoFit to Contents
c. Autofit to Window
d. Autofit to Column

35.                  When you click on File menu in Word 2010, it opens
a. File menu
b. File Commands
c. Backstage View
d. File Ribbon

36.                  Tabs stop position cannot be the following alignment
a. Decimal Alignment
b. Center Alignment
c. Bar Alignment
d. Justify Alignment

37.                  Ctrl + B
a. Search the selected text
b. Paste the selected text
c. Bold the selected text
d. Open the specified file

38.                  If the number of columns is selected 1 and the line between check box is marked, where is the line drawn?
a. in the left margin
b. in the right margin
c. both in left and right margin
d. None of Above

39.                  A feature of MS Word that saves the document automatically after certain interval is available on
a. Save tab on Options dialog box
b. Save As dialog box
c. Both of above
d. None of above

40.                  After typing header text, how can you quickly enter footer text?
a. Press Page Down key and type the text for footer
b. Click on Switch between Heeder & Footer then type the text
c. Both of above
d. None of above

41.                  To move the cursor page to page of document
a. Ctrl+PgDn
b. Ctrl+PgUp
c. Both of above
d. None of above

42.                  You can jump to the next column by
a. Clicking with your mouse on the next column
b. Press Alt + Down-arrow
c. Both of above
d. None of Above

43.                  Which of the following enables you to paste data multiple times?
a. Windows Clipboard
b. Office Clipboard
c. Both Windows & Office Clipboard
d. None of the all

44.                  In Word you can force a page break
a. By positioning your cursor at the appropriate place and pressing the F1 key
b. By using the Insert/Section break on the Insert tab
c. By positioning your cursor at the appropriate place and pressing Ctrl+Enter
d. By changing the font size of your document

45.                  How can you increase the font size of selected text by one point every time?
a. By pressing Ctrl + ]
b. By pressing Ctrl + [
c. By pressing Ctrl + }
d. By pressing Ctrl + {

46.                  How to use Format Painter multiple times
a. By Click on Lock Format Painter Icon
b. By Double Click on the Format Painter Icon
c. By Selecting Edit -> Format Painter -> Multiple Use
d. Format Painter cannot be use multiple times

47.                  What is the default font used in MS Word 2007 document?
a. Times New Roman
b. Arial
c. Calibri
d. Preeti

48.                  Word includes a series of predefined graphics called _____ that can be inserted into a Word document.
a. clip art
b. hyperlinks
c. captions
d. bookmarks

49.                  A (n) _____is a dot or other symbol positioned at the beginning of a paragraph.
a. bullet
b. logo
c. cell
d. target

50.                  Which of the following is not a type of page margin?
a. Left
b. Right
c. Center
d. Top

Microsoft Office Excel

1.      Which of the following methods cannot be used to enter data in a cell

a.       Pressing an arrow key

b.      Pressing the Tab key

c.       Pressing the Esc key

d.      Clicking on the formula bar

2.      Which of the following will not cut information?

a.      Pressing Ctrl + C

b.      Selecting Edit>Cut from the menu

c.       Clicking the Cut button on the standard

d.      Pressing Ctrl+X

3.      Which of the following is not a way to complete a cell entry?

a.       Pressing enter

b.      Pressing any arrow key on the keyboard

c.       Clicking the Enter button on the Formula bar

d.      Pressing spacebar

4.      How do you insert a row?

a.     Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

b.     Select the row heading where you want to insert the new row and select Edit >Row from the menu

c.   Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

d.  All of the above

5.      Which of the following is not a basic step in creating a worksheet?

a.      Save workbook

b.      Modify the worksheet

c.       Enter text and data

d.      Copy the worksheet

6.      How do you select an entire column?

a.       Select Edit > Select > Column from the menu

b.      Click the column heading letter

c.       Hold down the shift key as you click anywhere in the column.

d.      Hold down the Ctrl key as you click anywhere in the column

7.      How can you print three copies of a workbook?

a. Select File>Properties form the menu and type 3 in the Copies to print text box

b. Select File >Print from the menu and type 3 in the Number of copies text box

c.  Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made

d. Press Ctrl+P+3

8.      To create a formula, you first:

a.     Select the cell you want to place the formula into

b.     Type the equals sign (=) to tell Excel that you’re about to enter a formula

c.      Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d.     Choose the new command from the file menu

9.      How do you delete a column?

a.       Select the column heading you want to delete and select the Delete Row button on the standard toolbar

b.      Select the column heading you want to delete and select Insert Delete from the menu

c.       Select the row heading you want to delete and select Edit>Delete from the menu

d.      Right click the column heading you want to delete and select delete from the shortcut menu

10.  When integrating word and excel, word is usually the

a.       Server

b.      Destination

c.       Client

d.      Both b and c

11.  When a label is too long to fit within a worksheet cell, you typically must

a.       Shorten the label

b.      Increase the column width

c.       Decrease the column width

d.      Adjust the row height

12.  Comments put in cells are called

a.       Smart tip

b.      Cell tip

c.       Web tip

d.      Soft tip

13.  Which is used to perform what if analysis?

a.       Solver

b.      Goal seek

c.       Scenario Manager

d.      All of above

14.  Multiple calculations can be made in a single formula using

a.       standard formulas

b.      array formula

c.       complex formulas

d.      smart formula

15.  Hyperlinks can be

a.       Text

b.      Drawing objects

c.       Pictures

d.      All of above

16.  To activate the previous cell in a pre-selected range, press

a.       The Alt key

b.      The Tab key

c.       The Enter key

d.      None of the above

17.  Which button do you click to add up a series of numbers?

a.      The autosum button

b.      The Formula button

c.       The quickntotal button

d.      The total button

18.  When the formula bar is active, you can see

a.      The edit formula button

b.      The cancel button

c.       The enter button

d.      All of the above

19.  To copy formatting from one area in a worksheet and apply it to another area you would use:

a.       The Edit>Copy Format and Edit>Paste Format commands form the menu.

b.      The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.

c.       There is no way to copy and apply formatting in Excel – You have to do it manually

d.      The Format Painter button on the standard toolbar

20.  In a worksheet you can select

a.       The entire worksheet

b.      Rows

c.       Columns

d.      All of the above

21.  When you link data maintained in an excel workbook to a word document

a.       The word document cannot be edit

b.      The word document contains a reference to the original source application

c.       The word document must contain a hyperlink

d.      The word document contains a copy of the actual data

22.  Which area in an excel window allows entering values and formulas

a.       Title bar

b.      Menu bar

c.       Formula bar

d.      Standard toolbar

23.  To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a.       Unfreeze panes command on the window menu

b.      Freeze panes command on the window menu

c.       Hold titles command on the edit menu

d.      Split command on the window menu

24.  To edit in an embedded excel worksheet object in a word document

a.      Use the excel menu bar and toolbars inside the word application

b.      Edit the hyperlink

c.       Edit the data in a excel source application

d.      Use the word menu bar and toolbars

25.  To create a formula, you can use:

a.       Values but not cell references

b.      Cell references but not values

c.       Values or cell references although not both at the same time

d.      Value and cell references

26.  Which of the following is the oldest spreadsheet package?

a.      VisiCalc

b.      Lotus 1-2-3

c.       Excel

d.      StarCalc

27.  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.      When you show the results of formulas with different decimal places that the calculated results

28.  You can copy data or formulas

a.      With the copy, paste and cut commands on the edit menu

b.      With commands on the shortcut menu

c.       With buttons on the standard toolbars

d.      All of the above

29.  You cannot link excel worksheet data to a word document

a.       With the right drag method

b.      With a hyperlink

c.       With the copy and paste special commands

d.      With the copy and paste buttons on the standard toolbar.

30.  Which of the following is a popular DOS based spreadsheet package?

a.       Word

b.      Smart cell

c.       Excel

d.      Lotus 1-2-3

31.  An excel workbook is a collection of

a.       Workbooks

b.      Worksheets

c.       Charts

d.      Worksheets and charts

32.  Excel files have a default extension of

a.      Xls

b.      Xlw

c.       Wk1

d.      123

33.  You can use the format painter multiple times by…..

a.       You can use the format painter button on by one time when you click it

b.      Double clicking the format painter button

c.       Pressing the Ctrl key and clicking the format painter button

d.      Pressing the Alt key and clicking the format painter button

35.  A circular reference is

a.       Geometric modeling tool

b.      A cell that points to a drawing object

c.       A formula that either directly or indirectly depends on itself

d.      Always erroneous

36.   Which of following is Not one of Excel’s what-if function?

a.       Goal seek

b.      Solver

c.       Scenario manager

d.      Auto Outline

37.  When you insert an excel file into a word document. The data are

a.       Hyperlinked placed in a word table

b.      Linked

c.       Embedded

d.      Use the word menu bar and toolbars

38.   Each excel file is called a workbook because

a.       It can contain text and data

b.      It can be modified

c.       It can contain many sheets including worksheets and chart sheets

d.      You have to work hard to create it

39.  Excel probably considers the cell entry January 1, 2000 to be a

a.       Label

b.      Value

c.       Formula

d.      Text string

40.  You can enter which types of data into worksheet cells?

a.      Labels, values, and formulas

b.      Labe3ls and values but not formulas

c.       Values and formulas but not labels

d.      Formulas only

41.  You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

a. Pie chart

b. Row chart

c. Line chart

d. Column chart

42.  Excel uniquely identifies cells within a worksheet with a cell name

a.       Cell names

b.      Column numbers and row letters

c.       Column letters and row numbers

d.      Cell locator coordinates

43.  Getting data from a cell located in a different sheet is called …

a.       Accessing

b.      Referencing

c.       Updating

d.      Functioning

44. A worksheet can have a maximum of …. Number of rows

a. 256

b. 1024

c. 32000

d. 65535

45.  How many characters can be typed in a single cell in Excel?

a.       256

b.      1024

c.       32000

d.      65535

46.   Which of the following formulas will Excel Not be able to calculate?

a. =SUM(Sales)-A3

b. =SUM(A1:A5)*.5

c. =SUM(A1:A5)/(10-10)

d. =SUM(A1:A5)-10

47.  Which of the following formulas is not entered correctly?

a.       =10+50

b.      =B7*B1

c.       =B7+14

d.      10+50

48.  Which of the following is an absolute cell reference?

a. !A!1

b. $A$1

c. #a#1

d. A1

49.   to view a cell comment

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

50.  Which of the following methods cannot be used to edit the contents of a cell?

a.      Press the Alt key

b.      Clicking the formula bar

c.       Pressing the F2 key

d.      Double clicking the cell

Microsoft excel is a spreadsheet program that belongs to MS-Office group. It enables you to store, manipulate, and chart numeric data.

Spreadsheet is an Electronic sheet that allow you to enter the store data in a ‘grid’ format on your computer system.

Application file name: excel.exe

Extension file Name: .xls

List of Spreadsheet Package

·         Google Sheets – (online and free).

·         iWork Numbers – Apple Office Suite.

·         KSpread

·         Lotus 1-2-3 (discontinued).

·         Microsoft Excel.

·         OpenOffice ->Calc (free).

·         VisiCalc (discontinued).

Things to remember while entering formula

1.  First place at the required cell where you want to get result by using formula.

2.  Always, formula begins with = (is equal to) sign, however + (plus) sing can be used.

3.  To get result, Always Press Enter key.

Copying the formula

1.  First, place at the formula- containing cell. (at result cell)

2.  Then click on bottom of active cell.

3.  And drag it up to destination

4.  Action and replace it.

Some Logical Operators

1.  = (is equal to)

2.  > (Greater than)

3.  > = (Grater than and equal to)

4.  < (Less than)

5.  < = (less than and equal to)

6.     <> = not equal to.

Cell Address (cell Reference)

Each and Every cell has its own address. It is Denoted by column and row. Eg : A1, B2, C5………etc.

·        Relative Reference —-  A1

·        Absolute Reference —–$A$1

·   Mixed Reference ——-$G4

Limitation of Excel

Feature	Specification
Total number of rows and columns on a worksheet	1,048,576 rows by 16,384 columns
Column width	255 characters
Row height	409 points
Page breaks	1,026 horizontal and vertical
Total number of characters that a cell can contain	32,767 characters
Characters in a header or footer	255
Maximum number of line feeds per cell	253
Sheets in a workbook	Limited by available memory (default is 1 sheet)
Colors in a workbook	16 million colors (32 bit with full access to 24-bit color spectrum)
Named views in a workbook	Limited by available memory
Unique cell formats/cell styles	64,000
Fill styles	256
Line weight and styles	256
Unique font types	1,024 global fonts available for use; 512 per workbook
Number formats in a workbook	Between 200 and 250, depending on the language version of Excel that you have installed
Names in a workbook	Limited by available memory
Windows in a workbook	Limited by available memory
Hyperlinks in a worksheet	66,530 hyperlinks
Panes in a window	4
Linked sheets	Limited by available memory
Scenarios	Limited by available memory; a summary report shows only the first 251 scenarios
Changing cells in a scenario	32
Adjustable cells in Solver	200
Custom functions	Limited by available memory
Zoom range	10 percent to 400 percent
Reports	Limited by available memory
Sort references	64 in a single sort; unlimited when using sequential sorts
Undo levels	100
Fields in a data form	32
Workbook parameters	255 parameters per workbook
Items displayed in filter drop-down lists	10,000
Noncontiguous cells that can be selected	2,147,483,648 cells