Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Which command path is normally used to insert a basic graphic shape such as a rectangle, arrow or callout in current desktop Microsoft Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel provides the Shapes gallery on the Insert tab.
• It can be used to insert rectangles, arrows, lines, callouts and other drawing objects onto a worksheet.
• After insertion, the shape can be resized, moved and formatted independently of ordinary cell contents.
• It can be used to insert rectangles, arrows, lines, callouts and other drawing objects onto a worksheet.
• After insertion, the shape can be resized, moved and formatted independently of ordinary cell contents.
వివరణ:
Question 2
ప్రశ్న 2
Which command path is appropriate for inserting a picture stored on the computer into a current desktop Excel worksheet?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Pictures stored on the local computer can be inserted through Insert > Pictures > This Device.
• The inserted picture becomes a graphic object that can be positioned and resized on the worksheet.
• Picture insertion is different from entering data into worksheet cells.
• The inserted picture becomes a graphic object that can be positioned and resized on the worksheet.
• Picture insertion is different from entering data into worksheet cells.
వివరణ:
Question 3
ప్రశ్న 3
A user has selected worksheet data and wants Excel to analyze that data and suggest suitable chart types. Which command is designed for this purpose?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Recommended Charts analyzes the selected data and suggests chart types that may represent it effectively.
• It is accessed from the Insert tab in current Excel versions.
• The user can preview the recommendations and select an appropriate chart before inserting it.
• It is accessed from the Insert tab in current Excel versions.
• The user can preview the recommendations and select an appropriate chart before inserting it.
వివరణ:
Question 4
ప్రశ్న 4
Which chart component normally states the overall subject or purpose of an Excel chart?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A Chart Title identifies what the chart represents and provides overall context for the viewer.
• It is normally positioned prominently in relation to the chart.
• Data labels identify individual plotted values, while gridlines and tick marks help interpret the axes.
• It is normally positioned prominently in relation to the chart.
• Data labels identify individual plotted values, while gridlines and tick marks help interpret the axes.
వివరణ:
Question 5
ప్రశ్న 5
In an Excel chart containing several data series, which component helps the reader identify what the different series, colours or markers represent?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The legend identifies the different data series represented in a chart.
• Its entries correspond to the series names and their visual representations.
• A chart title describes the overall chart rather than identifying each individual series.
• Its entries correspond to the series names and their visual representations.
• A chart title describes the overall chart rather than identifying each individual series.
వివరణ:
Question 6
ప్రశ్న 6
Which Excel chart component refers to the entire chart object, including elements such as the plot area, chart title and legend?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Chart Area represents the entire chart object and can contain the plot area, title, legend and other chart elements.
• The Plot Area is the region in which the chart's data series are actually plotted.
• Therefore the Chart Area has a broader scope than the Plot Area.
• The Plot Area is the region in which the chart's data series are actually plotted.
• Therefore the Chart Area has a broader scope than the Plot Area.
వివరణ:
Question 7
ప్రశ్న 7
Monthly electricity consumption for one office is recorded from January through December. Which chart type is generally most appropriate for showing how consumption changes over time?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A line chart is well suited to displaying trends or changes across an ordered sequence such as months or years.
• Connecting successive observations makes increases and decreases over time easy to recognize.
• A pie chart is intended primarily for part-to-whole comparisons rather than time trends.
• Connecting successive observations makes increases and decreases over time easy to recognize.
• A pie chart is intended primarily for part-to-whole comparisons rather than time trends.
వివరణ:
Question 8
ప్రశ్న 8
A worksheet contains the number of cases registered in five different districts for the same year. Which chart is generally suitable for comparing the magnitudes of these separate categories?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A column chart is commonly used to compare values across distinct categories.
• Each district can appear as a category with its value represented by a vertical column.
• This makes differences in magnitude between districts easy to compare.
• Each district can appear as a category with its value represented by a vertical column.
• This makes differences in magnitude between districts easy to compare.
వివరణ:
Question 9
ప్రశ్న 9
A department wants to show how four categories contribute to a single total budget of 100%. Which chart type is generally appropriate when there is one data series and only a few categories?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A pie chart is designed to show the proportion contributed by each category to a meaningful whole.
• Each slice represents the size or percentage of one data point relative to the entire pie.
• Pie charts are most effective when there is one data series and a limited number of categories.
• Each slice represents the size or percentage of one data point relative to the entire pie.
• Pie charts are most effective when there is one data series and a limited number of categories.
వివరణ:
Question 10
ప్రశ్న 10
A researcher wants to examine the relationship between each person's height and weight, where both variables are numerical measurements. Which Excel chart type is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An XY Scatter chart is designed to show relationships between two numerical variables.
• One numerical variable is plotted on the horizontal axis and the other on the vertical axis.
• The resulting point pattern can help reveal association, clustering or other relationships between the variables.
• One numerical variable is plotted on the horizontal axis and the other on the vertical axis.
• The resulting point pattern can help reveal association, clustering or other relationships between the variables.
వివరణ:
Question 11
ప్రశ్న 11
Which statement most accurately distinguishes an XY (Scatter) chart from a typical Line chart in Excel?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• XY Scatter charts treat both horizontal and vertical coordinates as numerical values.
• Typical Line charts use a category or ordered horizontal axis to display progression such as months, dates or categories.
• This difference is important when choosing a chart for numerical relationships versus ordered trends.
• Typical Line charts use a category or ordered horizontal axis to display progression such as months, dates or categories.
• This difference is important when choosing a chart for numerical relationships versus ordered trends.
వివరణ:
Question 12
ప్రశ్న 12
What is a data series in an Excel chart?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A data series is a set of related worksheet values plotted together in a chart.
• For example, quarterly profits for one year may form one data series.
• A chart can contain one or several data series depending on its source data and chart type.
• For example, quarterly profits for one year may form one data series.
• A chart can contain one or several data series depending on its source data and chart type.
వివరణ:
Question 13
ప్రశ్న 13
In an Excel chart, what does a data point represent?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A data point represents one individual value belonging to a data series.
• Depending on chart type, it can appear as a column, point, slice or another graphical marker.
• A collection of related data points forms a data series.
• Depending on chart type, it can appear as a column, point, slice or another graphical marker.
• A collection of related data points forms a data series.
వివరణ:
Question 14
ప్రశ్న 14
A chart has already been created, but the user wants worksheet rows to be plotted as series where columns are currently being treated as series. Which Excel command is intended for this change?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Switch Row/Column changes how Excel interprets the rows and columns of the source data for chart plotting.
• It can change which groups appear as data series and which appear as categories.
• It does not transpose the actual worksheet data itself.
• It can change which groups appear as data series and which appear as categories.
• It does not transpose the actual worksheet data itself.
వివరణ:
Question 15
ప్రశ్న 15
Which chart element can display an individual plotted value, series name, category name or similar information next to a data point?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Data labels display information directly beside or within plotted data points.
• Depending on chart type and settings, they can show values, category names, series names or related details.
• They can make a chart easier to interpret when precise values are important.
• Depending on chart type and settings, they can show values, category names, series names or related details.
• They can make a chart easier to interpret when precise values are important.
వివరణ:
Question 16
ప్రశ్న 16
What is the primary purpose of an axis title in an Excel chart that contains horizontal and vertical axes?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Axis titles provide descriptive information about what the horizontal or vertical axis represents.
• They are especially useful when the meaning or unit of the plotted values is not obvious from the chart alone.
• Axis titles are different from the overall Chart Title.
• They are especially useful when the meaning or unit of the plotted values is not obvious from the chart alone.
• Axis titles are different from the overall Chart Title.
వివరణ:
Question 17
ప్రశ్న 17
A column chart is based on worksheet cells B2:B6. One of those source values is changed from 50 to 80. What normally happens to the chart when it remains linked to those source cells?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Excel charts are associated with their worksheet source data.
• When a source value used by the chart changes, the corresponding plotted data normally updates automatically.
• Changing a source value does not automatically change the chart type or delete the chart.
• When a source value used by the chart changes, the corresponding plotted data normally updates automatically.
• Changing a source value does not automatically change the chart type or delete the chart.
వివరణ:
Question 18
ప్రశ్న 18
An existing Excel chart is a Line chart, but the user decides that a Column chart would represent the same source data more clearly. Which command is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Change Chart Type allows an existing chart to be converted to another available chart type.
• The command is available from the Chart Design tab when the chart is selected.
• This allows the source data to remain while changing how it is graphically represented.
• The command is available from the Chart Design tab when the chart is selected.
• This allows the source data to remain while changing how it is graphically represented.
వివరణ:
Question 19
ప్రశ్న 19
Assertion (A): A pie chart can be appropriate for displaying how a small number of categories contribute to one meaningful total.
Reason (R): Each pie slice represents the size or proportion of one data point relative to the whole pie.
Choose the correct answer.
Reason (R): Each pie slice represents the size or proportion of one data point relative to the whole pie.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A pie chart represents individual categories as slices of one complete whole.
• The relative size of each slice indicates the category's contribution to that total.
• Both statements are true, and the Reason directly explains why a pie chart can be appropriate for part-to-whole data.
• The relative size of each slice indicates the category's contribution to that total.
• Both statements are true, and the Reason directly explains why a pie chart can be appropriate for part-to-whole data.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Column chart
(b) Line chart
(c) Pie chart
(d) XY Scatter chart
List II
1. Shows the relationship between two numerical variables
2. Shows parts of one meaningful whole
3. Compares values across categories
4. Shows a trend across an ordered sequence such as time
Choose the correct matching code.
List I
(a) Column chart
(b) Line chart
(c) Pie chart
(d) XY Scatter chart
List II
1. Shows the relationship between two numerical variables
2. Shows parts of one meaningful whole
3. Compares values across categories
4. Shows a trend across an ordered sequence such as time
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A Column chart is suitable for category comparisons, giving (a)-3.
• A Line chart commonly shows an ordered trend, giving (b)-4, while a Pie chart shows parts of a whole, giving (c)-2.
• An XY Scatter chart displays relationships between two numerical variables, giving (d)-1.
• A Line chart commonly shows an ordered trend, giving (b)-4, while a Pie chart shows parts of a whole, giving (c)-2.
• An XY Scatter chart displays relationships between two numerical variables, giving (d)-1.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: C. Insert > Shapes సమాధానం: C.
-
Question 2 ప్రశ్న 2Answer: A. Insert > Pictures > This Device సమాధానం: A.
-
Question 3 ప్రశ్న 3Answer: D. Insert > Recommended Charts సమాధానం: D.
-
Question 4 ప్రశ్న 4Answer: B. Chart Title సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: B. Legend సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: D. Chart Area సమాధానం: D.
-
Question 7 ప్రశ్న 7Answer: A. Line chart సమాధానం: A.
-
Question 8 ప్రశ్న 8Answer: C. Column chart సమాధానం: C.
-
Question 9 ప్రశ్న 9Answer: C. Pie chart సమాధానం: C.
-
Question 10 ప్రశ్న 10Answer: B. XY (Scatter) chart సమాధానం: B.
-
Question 11 ప్రశ్న 11Answer: D. A Scatter chart uses numerical values on both axes, whereas a typical Line chart commonly uses categories or ordered labels on its horizontal axis and values on its vertical axis. సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: A. A group of related data points from a worksheet that are plotted together in a chart సమాధానం: A.
-
Question 13 ప్రశ్న 13Answer: A. An individual value from a data series represented graphically in the chart సమాధానం: A.
-
Question 14 ప్రశ్న 14Answer: D. Switch Row/Column సమాధానం: D.
-
Question 15 ప్రశ్న 15Answer: B. Data Label సమాధానం: B.
-
Question 16 ప్రశ్న 16Answer: C. To describe what an axis represents, including its variable or measurement where appropriate సమాధానం: C.
-
Question 17 ప్రశ్న 17Answer: B. The chart normally updates to reflect the changed source value. సమాధానం: B.
-
Question 18 ప్రశ్న 18Answer: C. Chart Design > Change Chart Type సమాధానం: C.
-
Question 19 ప్రశ్న 19Answer: A. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: D. (a)-3, (b)-4, (c)-2, (d)-1 సమాధానం: D.