**NCVT ITI COPA SEMESTER 1 MODULE 7 Previous Year Question Paper, Sample Paper, Model Paper**

**How Cells are named in MS Excel?**

A Alphabetically

B Numerically

C Alphanumerically

D Special Character

**What is the maximum limit of rows in MS Excel 2010?**

A 1084567

B 1048567

C 1048576

D 1084576

**What is the maximum limit of column in MS Excel 2010?**

A 16384

B 16438

C 16843

D 16348

**Which bar lies top of the window in Excel Screen?**

A Status Bar

B Ruler

C Title Bar

D Scroll Bar

**How rows are numbered in MS Excel?**

A Alphabetically

B Numerically

C Alphanumerically

D Special characters

**How columns are named in MS Excel?**

A Alphabetically

B Numerically

C Alphanumerically

D Special characters

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

A Insert

B Page Layout

C Data

D Review

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

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

A Formula

B Data

C Review

D View

**What type of software is MS Office?**

A Application Software

B Operating System

C Programming Language

D System Software

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

A Access

B Excel

C Power Point

D Word

**What is the file extension of Excel 2010?**

A xls

B xlsb

C xlsm

D xlsx

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

A Cell

B Column

C Range

D Row

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

A Range

B Union

C Formula

D General

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

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

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

A F2

B F5

C F7

D F12

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

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

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

A Data

B Text

C Numbers

D Formulas

**NCVT ITI COPA SEMESTER 1 MODULE 7 Previous Year Question Paper, Sample Paper, Model Paper**

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

A Data

B Home

C Insert

D Review

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

A Count ()

B Countif()

C Sum()

D Sumif()

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

A Count()

B Sum()

C ABS()

D Sumif()

**which symbol is used to excute formulas in MS Excel?**

A =

B ‘

C #

D “

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

A Current Cell

B Next Cell

C Previous Cell

D Formula Bar

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

A Ceiling

B DMAX

C LEN

D MAX

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

A MID()

B NOW()

C COUNT()

D SIGN

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

A FIND()

B MOD()

C NOW()

D MID()

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

A MEDIAN()

B MID()

C TRIM()

D MODE()

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

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

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

A F2

B F5

C F7

D F11

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

A Find

B Filter

C Format

D Sort

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

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

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

A Now()

B Lower()

C Max()

D IF()

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

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

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

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

A Alt+↵

B Tab+↵

C Ctrl+↵

D Shift+↵

**Other Important Link**

**NCVT ITI COPA Semester 1 Module 1 & 2****NCVT ITI COPA Semester 1 Module 3****NCVT ITI COPA Semester 1 Module 4****NCVT ITI COPA Semester 1 Module 5****ITI Electrician Semester 1 Module 3****NCVT ITI COPA Semester 1 Module 6****NCVT ITI Electrician Question Paper****ITI Electrician Basic Workshop Practice First Semester Module Second****NCVT ITI Fitter Question Paper****UP ITI Question Paper****Official Website**