COPA Mock Test 1st Year

COPA Mock Test 1st Year NIMI

NIMI Mock Test is an online mock testing website used for testing the skills of trainees using mock tests. Trainees can generate their own question paper for their trade and attend the timed mock test. At the end of the test the score obtained as well as the answer sheet is displayed.

nimi mock test 2022, copa mock test-2, copa mock test-4, copa mock test-10, nimi copa question bank, copa mock test-3, nimi mock test questions and answers pdf download, iti copa online test in english, copa online test 2022, copa online test in hindi, copa mock test-10, nimi mock test, copa pdf, copa mock test 2021, copa mock test-3, nimi mock test 2022, copa mock test-5

0 votes, 0 avg

3547

Created by

ITI Question Bank

COPA 1st Year

COPA Mock Test -01

ITI Question Bank

1 / 15

What should be done, if the pen drive is not deducted?

a) Device Manger → right click on USB root hub → disable device

b) Device Manger → right click on USB root hub → enable device

c) Device Manger → right click on USB root hub → scan for hardware changes

d) Device Manger → right click on USB root hub → Update drives

2 / 15

What steps should be taken, if windows not updated automatically?

a) start - control panel - settings - add programs - enable automatic update

b) start - setting - control panel - system - enable automatic updated

c) re- install windows Os

d) restart windows

3 / 15

Where does the pinned application stayed in Windows Os?

a) Desktop

b) Notification Area

c) Start Button

d) Task Bar

4 / 15

Which is the order of files and directories in Windows Explore?

a) Serially

b) Sequentially

c) hierarchically

d) Aplhabtically

5 / 15

Which shortcut key is used to refresh windows desktop?

a) F1

b) F2

c) F5

d) F12

6 / 15

Which shortcut key is used to copy and paste a file folder?

a) Ctrl+ X and Ctrl + V

b) Ctrl + A and Ctrl + V

c) Ctrl + Z and Ctrl + V

d) Ctrl + C and Ctrl + V

7 / 15

What is the extension of applet files in control panel?

a) Ctl

b) Cpl

c) Cal

d) Csl

8 / 15

Which control panel applet gives the information of computer?

a) System and security

b) Hardware and sound

c) Programs

d) Appearance and personalization

9 / 15

Which tool in control panel is used to adjust your computer setting to control computer with voice command?

a) System and security

b) Appearance and personalization

c) Hardware and sound

d) Ease of access

10 / 15

Where does the minimized application reside in windows?

a) My computer

b) Task bar

c) My Document

d) Recent documents

11 / 15

What is the function of OS?

a) process & memory management

b) word processing

c) drawing pictures

d) calculation

12 / 15

Which acts as an intermediate between a user and a computer?

a) Macros

b) Antivirus

c) MS Office

d) Operating system

13 / 15

Which one is an example for OS ?

a) Antivirus

b) Windows

c) MS Office

d) Macromedia

14 / 15

How many pins are there in SIMMs ?

a) 32 - 72

b) 42 - 82

c) 52 - 92

d) 62 -102

15 / 15

How many pins are there in DIMM?

a) 138

b) 168

c) 148

d) 158

Your score is

The average score is 60%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

2147

Created by

ITI Question Bank

COPA 1st Year

COPA Mock Test -02

ITI Question Bank

1 / 15

What is the purpose of memory unit in a computer?

a) Accepts data

b) Displays data

c) Process data

d) Stores data

2 / 15

What is the purpose of expansion slot in mother board ?

a) To insert the RAM

b) To insert the mouse

c) To insert the keyboard

d) To insert the additional peripherals

3 / 15

Which is an internal power supply units of CPU?

a) CVT

b) UPS

c) SMPS

d) Stablizer

4 / 15

How does the parallel port transfer a byte?

a) Bit by bit

b) 2 bits at a time

c) 4 bits at a time

d) 8 bits at a time

5 / 15

What is the main electronic component of the first generation computer?

a) Integrated circuit

b) Microprocess

c) Transistors

d) Vacuum tube

6 / 15

Who invented Analytical engine?

a) Charles Babbage

b) John Lickert

c) John Mauchy

d) M.V Wilkes

7 / 15

Who is considered as father of computer?

a) Charles Babbage

b) John Lickert

c) John Mauchy

d) M.V Wilkes

8 / 15

What type of device is computer?

a) Electrical device

b) Electronic device

c) Electro magnetic

d) Electro mechanical

9 / 15

Which is the first general purpose programmable electronic computer?

a) ENIAC

b) EDVAC

c) EDSAC

d) UNIVAC

10 / 15

Which is the sequence, in which computer operates?

a) Input, output, process

b) Input, process, output

c) Process, input, output

d) Output, process, input

11 / 15

What is the extension of applet files in control panel?

a) Ctl

b) Cpl

c) Cal

d) Csl

12 / 15

Which tool in control panel is used to adjust your computer setting to control computer with voice command?

a) System and security

b) Appearance and personalization

c) Hardware and sound

d) Ease of access

13 / 15

Which one is an example for OS ?

a) Antivirus

b) Windows

c) MS Office

d) Macromedia

14 / 15

How many pins are there in SIMMs ?

a) 32 - 72

b) 42 - 82

c) 52 - 92

d) 62 -102

15 / 15

Which shortcut key is used to refresh windows desktop?

a) F1

b) F2

c) F5

d) F12

Your score is

The average score is 74%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

1826

Created by

ITI Question Bank

COPA 1st Year

COPA Mock Test -03

ITI Question Bank

1 / 15

What is the another name of web address?

a) URL

b) Html

c) Http

d) Webpage

2 / 15

What are the two main parts, available in html document?

a) Title and Body

b) Head and title

c) Head and Body

d) Head and document

3 / 15

Which html tag is used to add a row in a table?

a) <tr> and </tr>

b) and

c) <th> and </th>

d) <td> and </td>

4 / 15

Which html tag is used to divide a row into data cells?

a) <tr> and </tr>

b) and

c) <th> and </th>

d) <td> and </td>

5 / 15

Which is the correct syntax for adding alternate text for image, if the image cannot be displayed?

a) <img src="“boat.gif”" alt="“big" />

b) <img src="“boat.gif”" alt />

c) <img src="“boat.gif”" />

d) <img src="“boat.gif”" />

6 / 15

Which is the correct H1 tag for right alignment?

a) <h1 align="“right”">.....</h1>

b) <h1 align="“right”">.....</h1>

c) <h1 align="“r”">.....</h1>

d) <h1>.....</h1>

7 / 15

What is the use of forms in HTML?

a) To display a table

b) To display a list

c) To send the data to server

d) To display email contents

8 / 15

What is the correct syntax for making a hyperlink?

a) <http: // nimi.gov.in”</a>

b) nimi

c) <a href="//">nimi</a>

d) <a>nimi</a>

9 / 15

Which is the correct css syntax?

a) body: color = black;

b) body { color; black}

c) {body: color : black;}

d) {body : color = black;}

10 / 15

Which web language give more control over the HTML elements and allows them to change at any time without returning to the Web server?

a) BML

b) XML

c) HTML

d) DHTML

11 / 15

What is the output of the following html?
<html>
<body>
<h2>NIMI<small>CHENNAI</small>
formatting</h2>
</body>
</html>

a) NIMI chennai

b) NIMI CHENNAI

c) NIMI chennaiformatting

d) NIMICHENNAIformatting

12 / 15

Which topology combines characteristics of linear bus and star topologies?

a) Bus

b) Star

c) Tree

d) Mesh

13 / 15

What is the abbreviation of OSI?

a) Open Source Internet

b) Open System Interaction

c) Open Source Interconnection

d) Open System Interconnection

14 / 15

Which layer in OSI model performs network routing, flow control and error control function?

a) Network layer

b) Session layer

c) Physical layer

d) Data link layer

15 / 15

What is the output when the data “FOREIGN key’ is set to the text format > in Access?

a) foreign key

b) FOREIGN KEY

c) Foreign Key

d) Foreign key

Your score is

The average score is 55%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

1213

Created by

ITI Question Bank

COPA 1st Year

COPA Mock Test -04

ITI Question Bank

1 / 15

Which web language give more control over the HTML elements and allows them to change at any time without returning to the Web server?

a) BML

b) XML

c) HTML

d) DHTML

2 / 15

What is the output of the following html?
<html>
<body>
<h2>NIMI<small>CHENNAI</small>
formatting</h2>
</body>
</html>

a) NIMI chennai

b) NIMI CHENNAI

c) NIMI chennaiformatting

d) NIMICHENNAIformatting

3 / 15

What is the output of the following html code?
<html>
<body>
<p>NIMI<sup>CHENNAI</sup></p>
</body>
</html>

a) NIMI chennai

b) NIMI chennai

c) NIMI chennai

d) NIMI - CHENNAI

4 / 15

How will the following html code appear in the browser?
<html>
<body>
<h1> my first heading</h1>
<p>my first paragraph</p>
</body>
</html>

a) My first heading My first paragraph

b) My first heading My first paragraph

c) My first heading My first paragraph

d) My first heading My first paragraph

5 / 15

What is the correct syntax for making a hyperlink?

a) <http: // nimi.gov.in”</a>

b) nimi

c) <a href="//">nimi</a>

d) <a>nimi</a>

6 / 15

What is the full form of CSS?

a) Computer style sheet

b) Cascading style sheet

c) Cascading system style

d) Customized style sheet

7 / 15

what is the full form of HTTP?

a) Hyper text testing protocol

b) Hyper text transfer protocol

c) Hyper test transfer protocol

d) Hyper text transfer program

8 / 15

Which layer of OSI Model, transfer data between network entities?

a) Layer 1

b) Layer 2

c) Layer 3

d) Layer 4

9 / 15

Which device is installed in a subscriber’s telephone line to allow both ADSl and regular voice (telephone) services to be used at the same time?

a) Hub

b) Switch

c) MODEM

d) Micro filter

10 / 15

What is the purpose ‘Tab’ key in MS Excel?

a) Moves cell pointer to previous column

b) Moves cell pointer to next column

c) Moves cell pointer previous row

d) Moves cell pointer next row

11 / 15

Which option in MS Excel is used to display the rows that meet certain conditions?

a) Find

b) Filter

c) Format

d) Sort

12 / 15

Which function in Excel is used to find the biggest value in a range?

a) Ceiling

b) DMAX

c) LEN

d) MAX

13 / 15

Which view in Excel displays the pages exactly as they appear when printed?

a) Custom View

b) Full screen View

c) Page Break View

d) Page Layout view

14 / 15

Which tab is used to change the display of worksheet area and the data it contains?

a) Page Layout

b) Data

c) Review

d) View

15 / 15

Which type of key should combine with ctrl key to create a macro key in Excel?

a) Numeric

b) Alphabetic

c) Alphanumeric

d) Special characters

Your score is

The average score is 53%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

1019

Created by

ITI Question Bank

COPA 1st Year

COPA Mock Test -05

ITI Question Bank

1 / 15

Which of the following cable transmits messages in the form of light waves?

a) STP cable

b) UTP cable

c) Co-axial cable

d) Optical fibre cable

2 / 15

What is the maximum speed supported by category 5 UTP cable?

a) 1mbps

b) 10mbps

c) 100mbps

d) 1000mbps

3 / 15

How many pairs of wires contains in category 5 UTP cable?

a) 3

b) 4

c) 5

d) 6

4 / 15

Which topology combines characteristics of linear bus and star topologies?

a) Bus

b) Star

c) Tree

d) Mesh

5 / 15

What is called the interconnected computer systems located at different places?

a) internet

b) computer layout

c) computer network

d) connectivity of computer

6 / 15

Which is a reference tool for understanding data communication between any two network system?

a) LAN

b) WAN

c) ISO model

d) OSI model

7 / 15

Which is the layer 3 in OSI model?

a) Network layer

b) Session layer

c) Physical layer

d) Data link layer

8 / 15

What is the full form of ADSL?

a) Asymmetrical Digital System Line

b) Automatic Digital Subscriber Line

c) Asymmetrical Digital Subscriber Line

d) Asynchronous Digital Subscriber Line

9 / 15

Which is an example for WAN?

a) Ethernet

b) Home network

c) Campus network

d) Bluetooth network

10 / 15

What is the full form of EFT?

a) Electronic Form Transfer

b) Electronic Fund Transfer

c) Electronic Field Transfer

d) Electronic Format Transfer

11 / 15

What is the abbreviation of OSI?

a) Open Source Internet

b) Open System Interaction

c) Open Source Interconnection

d) Open System Interconnection

12 / 15

Which is the 6th layer in OSI communication model?

a) Session layer

b) Network layer

c) Application layer

d) Presentation layer

13 / 15

Which layer is the layer 4 in OSI model?

a) Session layer

b) Network layer

c) Data link layer

d) Transport layer

14 / 15

Which layer is the layer 2 in OSI network model?

a) Session layer

b) Physical layer

c) Data link layer

d) Transport layer

15 / 15

What is the full form of TCP?

a) Test Control Protocol

b) Transfer Control Protocol

c) Transport Control Protocol

d) Transmission Control Protocol

Your score is

The average score is 56%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

790

Created by

ITI Question Bank

COPA 1st Year

COPA Mock Test -06

ITI Question Bank

1 / 15

What is the full form of IP?

a) internet protect

b) intranet protocol

c) internet protocol

d) international protocol

2 / 15

Which layer in OSI model performs network routing, flow control and error control function?

a) Network layer

b) Session layer

c) Physical layer

d) Data link layer

3 / 15

What is the reason for not accepting zero in the fields of Access tables?

a) Fields is set with is Null or > 0

b) Fields is set with is Null or < = 0

c) Fields is set with is Null or! [0]

d) Fields is set with is Null or like “?”

4 / 15

What is the output when the data “FOREIGN key’ is set to the text format > in Access?

a) foreign key

b) FOREIGN KEY

c) Foreign Key

d) Foreign key

5 / 15

Write the output when the data ‘Primary Key’ is set to the text < in Access?

a) Primary key

b) primary key

c) PRIMARY KEY

d) Primary Key

6 / 15

Which of the following is a valid time format is Access?

a) hh:mm:ss AM/PM

b) hh.mm.ss AM/PM

c) hh-mm-ss AM/PM

d) hh/mm/ss AM/PM

7 / 15

What is the output when the data ‘1678.95’ is set to the number format ‘###0.00’ in Access?

a) 1670.00

b) 1670.95

c) 1678.00

d) 1678.95

8 / 15

Which validation rule allows exactly digits for number fields in Access?

a) Is Null or Between 100000 and 99999

b) Is Null or Like “????”

c) Is Null or >= 0 AND< = 99999

d) Is Null or < = 99999

9 / 15

What is allowed the input mark symbol # in Access?

a) Letter or digit

b) Letter A through Z

c) A digit 0 - 9 with +/- sign

d) A digit 0 - 9 without +/- sign

10 / 15

Which validation rule allows only positive numbers for fields in?

a) Is Null or > = 0

b) Is Null or Positive

c) Is Null or < 0

d) Is Null or = “+”

11 / 15

Which validation rule allows only 0 - 9 for fields in Access?

a) Is Null or Not Like “*[ ! 0 - 9 ]*”

b) Is Null or Not Like “[! 0 - 9]”

c) Is Null or Not Like “*[0 - 9]*”

d) Is Null or Not Like “*[!0-9]*”

12 / 15

Which validation rule accepts only a - z letters for fields in Access?

a) Is null or NOT like “*[! a - z]*”

b) Is null or NOT like “*[a - z ]*”

c) Is null or NOT like “*![a - z]*”

d) Is null or NOT like “[! a - z]”

13 / 15

Which technique prevents invalid data being saved in Access table?

a) Index

b) Filter

c) Validation rule

d) Input mark

14 / 15

Which command quickly locates the data is Access table?

a) Find

b) Locate

c) Search

d) Edit

15 / 15

Which combination of key allows user to move to the first field in the first record in Access table?

a) Ctrl + Tab

b) Shift +Tab

c) Shift + Home

d) Ctrl + Home

Your score is

The average score is 51%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

600

Created by

ITI Question Bank

COPA 1st Year

COPA Mock Test -07

ITI Question Bank

1 / 15

Which validation rule allows only 0 - 9 for fields in Access?

a) Is Null or Not Like “*[ ! 0 - 9 ]*”

b) Is Null or Not Like “[! 0 - 9]”

c) Is Null or Not Like “*[0 - 9]*”

d) Is Null or Not Like “*[!0-9]*”

2 / 15

Which validation rule accepts only a - z letters for fields in Access?

a) Is null or NOT like “*[! a - z]*”

b) Is null or NOT like “*[a - z ]*”

c) Is null or NOT like “*![a - z]*”

d) Is null or NOT like “[! a - z]”

3 / 15

Which technique prevents invalid data being saved in Access table?

a) Index

b) Filter

c) Validation rule

d) Input mark

4 / 15

Which command quickly locates the data is Access table?

a) Find

b) Locate

c) Search

d) Edit

5 / 15

Which combination of key allows user to move to the first field in the first record in Access table?

a) Ctrl + Tab

b) Shift +Tab

c) Shift + Home

d) Ctrl + Home

6 / 15

Which combination of key zooms the content of active cell in Access table?

a) Ctrl + F2

b) Ctrl + F5

c) Shift + F2

d) Shift + F5

7 / 15

Which key stoke moves the active cell towards left in Access table?

a) F2

b) F5

c) Tab

d) Shift + Tab

8 / 15

Which key stoke is used to move the active cell towards right, in access table?

a) Ctrl + Tab

b) Alt + Tab

c) Tab

d) Shift + Tab

9 / 15

Which object stores information about related data?

a) Document

b) Table

c) Page

d) Screen

10 / 15

Which view allows to modify table’s structure in Access?

a) Design view

b) Datasheet view

c) Pivot table view

d) Pivot shart view

11 / 15

Which view is used to arrange table data in different graphical layouts to summarize data?

a) Table view

b) Design view

c) Data sheet view

d) Pivot chart view

12 / 15

What is the maximum length of the field name in Access?

a) 16 characters

b) 32 characters

c) 64 characters

d) 128 characters

13 / 15

What is the expansion of OLE in Access?

a) object linking and embedding

b) object linking and encrypting

c) object linking and editing

d) objet linking

14 / 15

What is the maximum number of characters allowed in text field is access?

a) 255

b) 256

c) 64000

d) 65000

15 / 15

Which combination of key is used to show the laser pointer during slide show?

a) Alt + left mouse button

b) Alt + right mouse button

c) Ctrl + left mouse button

d) Ctrl + right mouse button

Your score is

The average score is 54%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

557

Created by

ITI Question Bank

COPA 1st Year

COPA Mock Test -08

ITI Question Bank

1 / 15

Which one of the following is a effect option in power point presentation?

a) Diamond

b) Fade

c) Push

d) Reveal

2 / 15

Which option is used to display the selected slides only for presentation?

a) From Beginning

b) From current slide

c) Broadcast slide show

d) Custom slide show

3 / 15

Which view hides the hidden slides in Power Point?

a) Normal

b) Notes Page

c) Reading view

d) Slide Sorter

4 / 15

Which combination of key is used to select all slides from current slide to first slide?

a) Alt + Home

b) Ctrl + Home

c) Shift + Home

d) Tab + Home

5 / 15

Which option is used to insert the related hints of a slide?

a) Note Master

b) Presentation Master

c) Slide Master

d) Hints Master

6 / 15

Which one of the following is extension of power point 2010 presentation file?

a) .potx

b) .pptx

c) .ppsx

d) .thmx

7 / 15

Which holder holds text, title and picture in power point?

a) Contemt Holder

b) Image Holder

c) Place Holder

d) Slide Holder

8 / 15

Which shortcut key is used to create a new slide in power point?

a) Ctrl + C

b) Ctrl + N

c) Ctrl + M

d) Ctrl + S

9 / 15

Which function key is used to run a powerpoint presentation?

a) F3

b) F5

c) F7

d) F9

10 / 15

Which option offers a built in design through a dialog box?

a) Auto content wizard

b) Blank Presentation

c) Standard tool bar

d) Template

11 / 15

Which option is used to create a presentation automatically in Power Point?

a) Template

b) Blank Presentation

c) Auto content wizard

d) Standard test bar

12 / 15

Which shortcut key is used to invoke thesaurus dialog box in Power Point?

a) Shift+F7

b) Ctrl+F7

c) Alt+F7

d) Ctrl+Alt+F7

13 / 15

Which dialog box in Power Point allows to change slides automatically in a period of time?

a) Action setting

b) Slide transition

c) Slide animation

d) Custom animation

14 / 15

Which template makes specify common design elements in all slides in the presentation?

a) Fax template

b) User template

c) Data template

d) Master template

15 / 15

Which menu is used to select a predefined chart style?

a) Animation

b) Design

c) Slide show

d) Transitions

Your score is

The average score is 52%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

507

Created by

ITI Question Bank

COPA Mock Test -09

ITI Question Bank

1 / 15

Which menu is used to apply various visual effects to the slide in power point?

a) Animation

b) Design

c) Slide show

d) Transitions

2 / 15

Which menu is used to apply various effects to the text in a slide?

a) Animation

b) Design

c) Transitions

d) Slide show

3 / 15

How many panes are these in backstage view in power point 2010?

a) 3

b) 5

c) 7

d) 9

4 / 15

Which shortcut key is used to create new presentation in powerpoint?

a) Ctrl + P

b) Ctrl + N

c) Ctrl + M

d) Ctrl + X

5 / 15

Which key is used to stop a power point presentation?

a) ESC

b) Tab

c) Ctrl

d) Enter

6 / 15

Which tool allows user to select different layout for slide?

a) Apply design

b) Bullets

c) New slide

d) Slide Layout

7 / 15

What type of software program is power point?

a) Word Processor

b) Spread Sheet

c) Presentation Graphics

d) Database Management

8 / 15

Which button is used to add instant animation to the presentation and helps interactive presentation?

a) Add button

b) Start button

c) Insert button

d) Action button

9 / 15

Which contains miniature representation of slides?

a) Slides

b) Handout

c) Template

d) Slide master

10 / 15

Which item, contains text graphics, charts, sound, video, etc., in power point

a) Slides

b) Folder

c) Handouts

d) Desktop screen

11 / 15

Which key is used to make multiple line in a single cell?

a) Alt+↵

b) Tab+↵

c) Ctrl+↵

d) Shift+↵

12 / 15

Which option is used to change the direction where the cursor moves when you press the enter key in Excel?

a) Excel options Advance Enable auto complete for cell values → →

b) Excel options Advance→Extend data range formats →

c) Excel options Advance choose direction by clicking down arrow next to check box → →

d) Excel options Advance→Enable fill handle and cell drag and drop →

13 / 15

Which sequence of operation is used to insert the hidden formula bar in Excel worksheet?

a) View→ Show/hide→ Formula bar

b) Insert→ show/hide→ Formula bar

c) Data→ show/hide→ Formula bar

d) Home→ show/hide→ formula bar

14 / 15

Which key is used to move the insertion point to the beginning of the current sheet?

a) Pageup

b) Home

c) Ctrl + pageup

d) Ctrl + Home

15 / 15

Which one of the following is ‘no argument’ function?

a) Now()

b) Lower()

c) Max()

d) IF()

Your score is

The average score is 40%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

405

Created by

ITI Question Bank

COPA Mock Test -10

ITI Question Bank

1 / 15

Which type of addressing is used to keep rows constant and column changes and vice versa while copying a formula from one area of the worksheet to another in Excel?

a) Mixed

b) General

c) Relative

d) Absolute

2 / 15

Which option in Excel is used to rearrange the rows base on the content of a particular column?

a) Find

b) Filter

c) Sort

d) Format

3 / 15

Which option in MS Excel is used to display the rows that meet certain conditions?

a) Find

b) Filter

c) Format

d) Sort

4 / 15

Which function key is used to open goto dialogue box in MS Excel?

a) F2

b) F5

c) F7

d) F11

5 / 15

What is the purpose of ‘Enter Key’ in MS Excel?

a) Moves cell pointer to previous column

b) Moves cell pointer to next column

c) Moves cell pointer to previous row

d) Moves cell pointer to next row

6 / 15

What is the purpose ‘Tab’ key in MS Excel?

a) Moves cell pointer to previous column

b) Moves cell pointer to next column

c) Moves cell pointer previous row

d) Moves cell pointer next row

7 / 15

Which function is used to find the middle number in a range?

a) MEDIAN()

b) MID()

c) TRIM()

d) MODE()

8 / 15

Which one of the following is a ‘Date & Time’ function in Excel?

a) FIND()

b) MOD()

c) NOW()

d) MID()

9 / 15

Which one of the following is a text function in MS Excel?

a) MID()

b) NOW()

c) COUNT()

d) SIGN

10 / 15

Which function in Excel is used to find the biggest value in a range?

a) Ceiling

b) DMAX

c) LEN

d) MAX

11 / 15

Where does the result displays when a formula is entered in Excel?

a) Current Cell

b) Next Cell

c) Previous Cell

d) Formula Bar

12 / 15

which symbol is used to excute formulas in MS Excel?

a) =

b) ‘

c) #

d) “

13 / 15

Which function is used to add the values in a range?

a) Count()

b) Sum()

c) ABS()

d) Sumif()

14 / 15

Which function is used to count the number of cells that contain numbers, in a range?

a) Count ()

b) Countif()

c) Sum()

d) Sumif()

15 / 15

Which tab is used for creating, formatting and editing a spreadsheet?

a) Data

b) Home

c) Insert

d) Review

Your score is

The average score is 44%

LinkedIn Facebook Twitter VKontakte

0 votes, 0 avg

332

Created by

ITI Question Bank

COPA 1st Year

COPA Mock Test -11

ITI Question Bank

1 / 15

Which one of the following will starts with “=” sign in Excel 2010?

a) Data

b) Text

c) Numbers

d) Formulas

2 / 15

Which view in Excel displays the pages exactly as they appear when printed?

a) Custom View

b) Full screen View

c) Page Break View

d) Page Layout view

3 / 15

Which tab is used to change the display of worksheet area and the data it contains?

a) Page Layout

b) Data

c) Review

d) View

4 / 15

Which function key is used to open save as dialogue box in MS Excel?

a) F2

b) F5

c) F7

d) F12

5 / 15

Which bar is used to display the sheet information and insertion point location in MS Excel?

a) Ruler

b) Scroll Bar

c) Status Bar

d) Title Bar

6 / 15

Which type of key should combine with ctrl key to create a macro key in Excel?

a) Numeric

b) Alphabetic

c) Alphanumeric

d) Special characters

7 / 15

What do you mean by A3, B13: B20, C7 reference in Excel?

a) Range

b) Union

c) Formula

d) General

8 / 15

How does the single element in a worksheet known as in Excel?

a) Cell

b) Column

c) Range

d) Row

9 / 15

What is the file extension of Excel 2010?

a) xls

b) xlsb

c) xlsm

d) xlsx

10 / 15

Which tool in Ms office is best for organizing data and making lists?

a) Access

b) Excel

c) Power Point

d) Word

11 / 15

What type of software is MS Office?

a) Application Software

b) Operating System

c) Programming Language

d) System Software

12 / 15

Which tab in Excel is used for proofing, protecting, and marking up a spread sheet?

a) Formula

b) Data

c) Review

d) View

13 / 15

Which tab in Excel is used when importing, querying, outlining and subtotaling the data placed into a worksheet’s data list?

a) Formula

b) Data

c) Review

d) Insert

14 / 15

Which tab is used to include pivot table, charts, hyperlinks to a spread sheet?

a) Insert

b) Page Layout

c) Data

d) Review

15 / 15

How columns are named in MS Excel?

a) Alphabetically

b) Numerically

c) Alphanumerically

d) Special characters

Your score is

The average score is 60%

LinkedIn Facebook Twitter VKontakte