Insert Tab

Total Questions: 14

1 - In MS Excel, Data series is related to?

A ) Collection of meta data
B ) Collection of formula
C ) Collection of series data ✅
D ) All of these

2 - A---- is a representation of a frequency distribution by means of rectangles whose widths represent class intervals and whose areas are proportional to the corresponding frequencies

A ) Histogram ✅
B ) Pie chart
C ) Bar chart
D ) Pictograph

3 - In MS Excel chart wizard term data series refers to----:
A ) A set of values you plot
B ) A chart legend
C ) A collection of chart data markers ✅
D ) A data label

4 - Which feature in Excel is used to summarize, analyze, explore, and presence data in a report format?

A ) Pivot Table ✅
B ) Pivot Field
C ) Pivot Filter
D ) Pivot Chart

5 - What is the first step in creating a pivot chart in Excel?

A ) Prepared your data ✅
B ) Customize the chart
C ) Add fields to the pivot Table
D ) Insert a pivot chart

6 - If you want to compare the performance of two employees in 2016 which chart will you use?

A ) Pie chart
B ) Line chart
C ) Column chart ✅
D ) Pivot chart

7 - To insert a blank embedded word object in excel?

A ) Click the link button standard toolbar
B ) Click the object command on the insert menu ✅
C ) Click the link button on the format painter
D ) None of these

8 - In MS Excel, on the insert tab includes:
A ) Alignment
B ) Style
C ) Chart ✅
D ) All of these

9 - The chart wizard term data categories refers to:
A ) A horizontal axis ✅
B ) A chart plot area
C ) The data range that supply chart data
D ) The organization of the individual values with a chart's data series

10 - Graphical representation of data is called:
A ) Line chart
B ) Bar chart ✅
C ) Scatter plot
D ) Pie Chart

11 - In Excel the graph that is shaped like Pai chart and used to arrange data intuitively is called ------:
A ) Bar graph
B ) Scatter plot ✅
C ) Chart
D ) Line Graph

12 - Which type of chart is best for categorical data:
A ) Histogram
B ) Maps
C ) Vertical bar
D ) Pie chart ✅

13 - The graph used to show data on nominal scale is called:
A ) Speed graph
B ) Line graph
C ) Pie graph ✅
D ) None of these

14 - In Excel the chart wizard -----?
A ) Can only place a chart on a new blank worksheet
B ) Can only be used to create embedded charts
C ) Can place a chart on a new chart sheet or on any sheet in the workbook ✅
D ) Can only place a chart on a new chart sheet
Past Papers
PPSC 2025 Past Papers
PPSC Past Papers
NTS Past Papers
FPSC Past Papers
Lecture PPSC Past Papers
Punjab Police PPSC Past Papers
PMS Past Papers
IB Past Papers
Junior Clerk PPSC Past Papers
PPSC 2024 Past Papers
PPSC 2023 Past Papers
Pakistan Study Past Paper 2024
Geography Past Paper 2024
Ziladar Past Papers
Assistant Past Papers
OTS Past Papers
MCQs
Current Affairs MCQs
General Knowledge MCQs
English MCQs
Computer MCQs
Biology MCQs
Physics MCQs
Chemistry MCQs
Pak Study MCQs
Geography Topic Wise MCQ
Pakistan Study Topic Wise MCQ
General Knowledge Topic Wise MCQ
Everyday Science Topic Wise MCQ
Computer Science Topic Wise MCQ
English Topic Wise MCQ
Electrical Engineering MCQs
History of Pakistan MCQs
Sports MCQs
Economics MCQs
Abbreviation MCQs
World Record MCQs
Everyday Science MCQs
Urdu MCQs
Pedagogy MCQs
Educators
General Knowledge MCQs for Educators
Pakistan Affairs MCQs for Educators
Geography MCQs for Educators
Islamic Studies MCQs for Educators
Everyday Science MCQs for Educators
Computer MCQs for Educators
English MCQs for Educators
Current Affair MCQs for Educators
Mathematics MCQs for Educators
Urdu MCQs for Educators
Pedagogy MCQs for Educators
Head Teacher Preparation SED