Microsoft Excel MCQs Test

Enter to Study the Microsoft Excel MCQs for FPSC, PPSC, SPSC, KPSC, BPSC, NTS, and PTS Job Test Preparation.

Microsoft Excel MCQs Test. Microsoft Excel is a spreadsheet software designed by Microsoft. In this test we added important MCQs related to MS Excel Application. This MS Excel MCQs Online Test will be helpful for competitive exams like FPSC, PPSC, SPSC, KPSC, BPSC, NTS, and PTS. Most of the MCQs will be applicable to Office XP, Office 97-2003, Office 2010, Office 2013, Office 2016, and other versions of MS Office. MS Office is a collection of application programs developed by Microsoft corporation that includes MS Word, MS Excel, PowerPoint and MS Access.
  • [message]
    • Instructions:
      • Choose your answer carefully on the basis of previous knowledge. Click on the Option (A, B, C, D) to Choose your Answer. Then Click on Show Answer for Correct Option.

Q. How many sheets are there, by default, when we create a new Excel file ?

A.
1
B.
3

C.
5
D.
10


Show Answer

Q. In Excel, which one denoted a range from B1 through E5

A.
B1 - E5
B.
B1:E5

C.
B1 to E5
D.
B1$E5


Show Answer

Q. An Excel file is generally called a / an :

A.
E-Spreadsheet
B.
Woorksheet

C.
Workbook
D.
Sheet


Show Answer

Q. It is a collection of data that is stored electronically as a series of records in a table.

A.
spreadsheet
B.
presentation

C.
database
D.
MS Word


Show Answer

Q. What type of chart will you use to compare performance of sales of two products ?

A.
Column Chart
B.
Line Chart

C.
Pie Chart
D.
Both A and B


Show Answer

Q. The Greater Than sign (>) is an example of _____ operator.

A.
Arithmatic
B.
Logical

C.
Conditional
D.
Greater


Show Answer

Q. What type of chart is useful for showing trends or changes over time ?

A.
Pie Chart
B.
Column Chart

C.
Line Chart
D.
Dot Graph


Show Answer

Q. The process of arrenging the items of a column in some sequence or order is known as :

A.
Arrengin
B.
Autofill

C.
Sorting
D.
Filtering


Show Answer

Q. The ____ feature of MS Excel quickly completes a series of data

A.
Auto Complete
B.
Auto Fill

C.
Fill Handle
D.
Sorting


Show Answer

Q. What type of chart is useful for comparing parts of a whole ?

A.
Pie Chart
B.
Column Chart

C.
Line Chart
D.
Dot Graph


Show Answer

Q. What is the intersection of a column and a row on a worksheet called ?

A.
Column
B.
Value

C.
Address
D.
Cell


Show Answer

Q. What type of chart is useful for comparing values over categories ?

A.
Pie Chart
B.
Column Chart

C.
Line Chart
D.
Dot Graph


Show Answer

Q. Which functionin Excel tells how many numeric entries are there ?

A.
NUM
B.
COUNT

C.
SUM
D.
CHKNUM


Show Answer

Q. A features that displays only the data in column (s) according to specified criteria

A.
Formula
B.
Sorting

C.
Filtering
D.
Pivot


Show Answer

Q. Statistical calculations and preparation of tables and graphs can be done using

A.
Adobe Photoshop
B.
Excel

C.
Notepad
D.
Power Point


Show Answer

Q. In Excel, Rows are labelled as ______

A.
A, B, C, etc
B.
1,2,3 etc

C.
A1, A2, etc.
D.
$A$1, $A$2, etc.


Show Answer

Q. What do you use to create a chart?

A.
Pie Wizard
B.
Excel Wizard

C.
Data Wizard
D.
Chart Wizard


Show Answer

Q. How will you graphically represent expenditure in different departments ?

A.
Column Chart
B.
Line Chart

C.
Pie Chart
D.
Dot Chart


Show Answer

Q. What type of chart is good for single series of data ?

A.
Column Chart
B.
Line Chart

C.
Pie Chart
D.
Cone Chart


Show Answer

Q. The basic unit of a worksheet into which you enter data in Excel is called a

A.
cell
B.
table

C.
box
D.
column


Show Answer

Q. What type of chart will you use to compare performance of two employees in the year 2016 ?

A.
Column Chart
B.
Line Chart

C.
Pie Chart
D.
Dot Chart


Show Answer

Q. Which one is not a Function in MS Excel ?

A.
SUM
B.
AVG

C.
MAX
D.
MIN


Show Answer

Q. Functions in MS Excel must begin with ___

A.
An () sign
B.
An Equal Sign

C.
A Plus Sign
D.
A > Sign


Show Answer

Q. Which functionin Excel checks whether a condition is true or not ?

A.
SUM
B.
COUNT

C.
IF
D.
AVERAGE


Show Answer

Q. In Excel, Columns are labelled as ___

A.
A, B, C, etc
B.
1,2,3 etc

C.
A1, A2, etc.
D.
$A$1, $A$2, etc.


Show Answer

COMMENTS

Name

Biology 10th,9,Biology 9th,9,Blog,27,Career Development,4,Chemistry 10th,8,Chemistry 9th,8,Classroom Management,2,Computer,17,Computer 9th,8,Current Affairs,7,Education News,13,English,12,Everyday Science,14,General Knowledge,25,General Science,6,Intelligence Tests,2,Interview,2,IQ Tests,5,Islamic Studies,10,Mathematics,8,Mathematics 10th,7,Mathematics 9th,18,PAF Cadet College Lower Topa,10,Pakistan Studies,5,Past Papers,9,Physics 10th,9,Physics 9th,9,Programming,1,Student Counseling,12,Urdu,6,Verbal Aptitude Tests,2,Verbal Reasoning Tests,2,Video,5,
ltr
item
Enter To Study: Microsoft Excel MCQs Test
Microsoft Excel MCQs Test
Enter to Study the Microsoft Excel MCQs for FPSC, PPSC, SPSC, KPSC, BPSC, NTS, and PTS Job Test Preparation.
Enter To Study
https://www.entertostudy.com/2018/12/microsoft-excel-mcqs-test.html
https://www.entertostudy.com/
https://www.entertostudy.com/
https://www.entertostudy.com/2018/12/microsoft-excel-mcqs-test.html
true
1254132765608278196
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy