NCVT ITI COPA Semester 1 Module 7 Previous Year Question Paper, Sample Paper, Model Paper 2022

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

Answer
C Alphanumerically

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


A 1084567
B 1048567
C 1048576
D 1084576

Answer
C 1048576

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


A 16384
B 16438
C 16843
D 16348

Answer
A 16384

Which bar lies top of the window in Excel Screen?


A Status Bar
B Ruler
C Title Bar
D Scroll Bar

Answer
C Title Bar

How rows are numbered in MS Excel?


A Alphabetically
B Numerically
C Alphanumerically
D Special characters

Answer
B Numerically

How columns are named in MS Excel?


A Alphabetically
B Numerically
C Alphanumerically
D Special characters

Answer
A Alphabetically

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


A Insert
B Page Layout
C Data
D Review

Answer
A Insert

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

Answer
B Data

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


A Formula
B Data
C Review
D View

Answer
C Review

What type of software is MS Office?


A Application Software
B Operating System
C Programming Language
D System Software

Answer
A Application Software

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


A Access
B Excel
C Power Point
D Word

Answer
B Excel

What is the file extension of Excel 2010?


A xls
B xlsb
C xlsm
D xlsx

Answer
D xlsx

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


A Cell
B Column
C Range
D Row

Answer
A Cell

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


A Range
B Union
C Formula
D General

Answer
A Range

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

Answer
B Alphabetic

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

Answer
C Status Bar

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


A F2
B F5
C F7
D F12

Answer
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

Answer
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

Answer
D Page Layout view

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


A Data
B Text
C Numbers
D Formulas

Answer
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

Answer
B Home

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


A Count ()
B Countif()
C Sum()
D Sumif()

Answer
A Count ()

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


A Count()
B Sum()
C ABS()
D Sumif()

Answer
B Sum()

which symbol is used to excute formulas in MS Excel?


A =
B ‘
C #
D “

Answer
A =

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


A Current Cell
B Next Cell
C Previous Cell
D Formula Bar

Answer
A Current Cell

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


A Ceiling
B DMAX
C LEN
D MAX

Answer
D MAX

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


A MID()
B NOW()
C COUNT()
D SIGN

Answer
A MID()

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


A FIND()
B MOD()
C NOW()
D MID()

Answer
C NOW()

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


A MEDIAN()
B MID()
C TRIM()
D MODE()

Answer
A MEDIAN()

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

Answer
B Moves cell pointer to next column

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

Answer
D Moves cell

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


A F2
B F5
C F7
D F11

Answer
B F5

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


A Find
B Filter
C Format
D Sort

Answer
B Filter

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

Answer
C Sort

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

Answer
A Mixed

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


A Now()
B Lower()
C Max()
D IF()

Answer
A Now()

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

Answer
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

Answer
A View→ 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

Answer
C Excel options Advance choose direction by clicking down arrow next to check box → →

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


A Alt+↵
B Tab+↵
C Ctrl+↵
D Shift+↵

Answer
A Alt+↵

Other Important Link

Share the love

Leave a Reply

Your email address will not be published.