Protec Computer Academy (An ISO 9001:2015 Certified Institute, Powered by E-Max Education, Branch Code EMAX/EK-80503, Registered by government of India.) is a best IT training center in Siwan with 100% Job placement assistance. Where you can learn Programming, WebDesigning, Hardware|Networking, Blogging, WordPress, Digitial marketing, English Speaking, And many more...| All certificates are valid in Government Jobs as well as in Private Companies. *** At Tara Market, Beside Vishal Mega Mart - Siwan*** +917541905230, Email- ahmad.irshad781@gmail.com *** Follow us on | | @welcome2protec

Sunday, June 6, 2021

MS Excel MCQ Quiz Set-1

MS Excel MCQ Quiz- Important MS Excel online MCQ test questions with answer to practice for interviews and competitive exams.

Are you finding the computer general knowledge questions for competitive exams? Here I am sharing computer general knowledge quiz questions and answers covering important topics in computer awareness, which is common for all the competitive exams.

These are the selective and important questions of the computer. You can increase your knowledge by learning these computer questions which help you while solving computer questions in SSC, Bank exams and many other competitive exams.

Learning Zone About us


1) What type of chart is useful for comparing values over categories_________?




...

Answer is B) Column Chart

Column Charts are useful to visually compare values a few categories or for showing data changes over a period of time. A Column Chart typically displays the categories along the horizontal (Category) axis and the values along the vertical (Value) axis.





2) Which function in excel tells how many numeric entries are there_________?




...

Answer is C) COUNT

Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A10 [=count(A1:A10)]. In this example, if five of the cells in the range contain numbers, the result will be 5.





3) Statistical calculations and prepration of tables and graphs can be done using_______?




...

Answer is A) Excel

EXCEL is typically use to organize data, perform financial analysis, statistical calculations, prepration of table and graph etc. It is used across all business functions and at companies from small to large.





4) A features that displays only the data in the column according to specified criteria____________?




...

Answer is D) Filter

Filter features enables you to view only data that meets certain criteria.





5) In Excel, Rows are labelled as______?




...

Answer is B) 1, 2, 3, etc.

By default, Row run horizontally across worksheet & ranges from 1 to 1048576. A row is generally identified by the number that is on the left side of the row from where the originates.





6) The basic unit of a worksheet into which you enter data in excel is called___________?




...

Answer is A) Cell

The basic unit of a worksheet into which you enter data in excel is called cell. A Cell is the intersection of rows and columns. Columns are identified by letters (A, B, C...), while rows are identified by numbers (1,2,3...). Each cell has its own name or cell address based on its colum and row.





7) Which Wizard do you use to create a chart__________?




...

Answer is D) Chart Wizard

The Chart wizard is a series of dialog boxes which lets you make decisions regarding the chart you want to create. There are four steps in the wizard which allow you to change the chart type, source data, chart options and location of your chart.





8) In a collection of data that is stored electronically as a series of records in a table_________?




...

Answer is C) Database

A Database is an organized collection of data, generally stored and accessed electronically from a computer system.





9) An Excel file is generally called a/an_________?




...

Answer is C) WorkBook

An excel file is generally called a workbook because like pages in the book, this also contains different sheets called worksheets and worksheets are stored in a file called a workbook.





10) By default, how many sheets are there when we create a new excel file________?




...

Answer is D) 3

When you open an excel workbook, there are three sheets by default, and the default name on the tabs are Sheet1, Sheet2, and Sheet3.










Protec Computer Academy (An ISO 9001:2015 Certified Institute, Powered by E-Max Education, Branch Code EMAX/EK-80503, Registered by government of India.) is a best IT training center in Siwan with 100% Job placement assistance. Where you can learn Programming, WebDesigning, Hardware|Networking, Blogging, WordPress, Digitial marketing, English Speaking, And many more...| All certificates are valid in Government Jobs as well as in Private Companies. *** At Tara Market, Beside Vishal Mega Mart - Siwan*** +966532621401, Email- ahmad.irshad781@gmail.com *** Follow us on | | @welcome2protec

Help others by sharing this page.

Ahmad Irshad

Author & Editor

I love blogging, teaching, learning computer science and sharing it to others. I've written and develped this site so that students may learn computer science related tutorials eaisly. MCA / MCITP

0 Comments:

Post a Comment

Please don't enter any spam link in the comment box.


Protec Computer Academy (An ISO 9001:2015 Certified Institute, Powered by E-Max Education, Branch Code EMAX/EK-80503, Registered by government of India.) is a best IT training center in Siwan with 100% Job placement assistance. Where you can learn Programming, WebDesigning, Hardware|Networking, Blogging, WordPress, Digitial marketing, English Speaking, And many more...| All certificates are valid in Government Jobs as well as in Private Companies. *** At Tara Market, Beside Vishal Mega Mart - Siwan*** +966532621401, Email- ahmad.irshad781@gmail.com *** Follow us on | | @welcome2protec
Protec Protec Protec Protec Protec Protec Protec Protec Protec Protec Protec Protec Protec Protec Protec Protec
Contact Us