CBSE-CLASS-XII SERIES Accountancy
Basic Knowledge Of Excel
8 previous year questions.
Volume: 8 Ques
Yield: Medium
High-Yield Trend
8
2025 Chapter Questions 8 MCQs
01
PYQ 2025
medium
accountancy ID: cbse-cla
As per the requirements of the user, Excel gives an option to change chart elements. State the options available to change the 'Shape Outline'.
Official Solution
Correct Option: (1)
In Microsoft Excel, when a chart element (such as a data series, axis, or shape) is selected, the Format tab provides customization options under the 'Shape Outline' dropdown. These options allow the user to format the appearance of outlines to meet presentation or report styling preferences.
Theme Colors: These are dynamic colors that change when a different document theme is selected. Useful for consistency.
Standard Colors: Basic fixed colors like red, blue, green that are not affected by theme changes.
No Outline: This removes the shape's border completely, which is useful for cleaner design.
More Outline Colors: Opens a dialog to choose from extended color options or even custom RGB/Hex values.
Weight: Changes the thickness of the line. Thicker lines may emphasize or highlight chart elements.
Dashes: Allows use of dotted or dashed lines instead of solid ones, helping distinguish between series or categories visually. These settings provide flexibility to visually enhance charts and make data representation more effective according to the needs of the user.
Theme Colors: These are dynamic colors that change when a different document theme is selected. Useful for consistency.
Standard Colors: Basic fixed colors like red, blue, green that are not affected by theme changes.
No Outline: This removes the shape's border completely, which is useful for cleaner design.
More Outline Colors: Opens a dialog to choose from extended color options or even custom RGB/Hex values.
Weight: Changes the thickness of the line. Thicker lines may emphasize or highlight chart elements.
Dashes: Allows use of dotted or dashed lines instead of solid ones, helping distinguish between series or categories visually. These settings provide flexibility to visually enhance charts and make data representation more effective according to the needs of the user.
02
PYQ 2025
medium
accountancy ID: cbse-cla
What is meant by 'Data Validation'? What is facilitated by 'Error Alert Tab'?
Official Solution
Correct Option: (1)
Data Validation allows you to control the type of data or values users enter into a cell. The Error Alert Tab in the Data Validation dialog helps customize alert messages to guide or warn users when incorrect data is entered.
03
PYQ 2025
easy
accountancy ID: cbse-cla
Explain the 'ROUND' function in Excel.
Official Solution
Correct Option: (1)
To solve the problem, we need to understand the usage of the ROUND function in Excel, which is used to round numbers to a specified number of digits.
1. Purpose of the ROUND Function:
The ROUND function is used to round a number to a specified number of digits. It can round both decimal and whole numbers.
2. Syntax of the ROUND Function:=ROUND(number, num_digits)
Where:
numberis the numeric value you want to round.num_digitsspecifies the number of digits to which you want to round the number.
3. Explanation with Examples:
=ROUND(12.3456, 2)returns 12.35 — rounds to 2 decimal places.=ROUND(12.3456, 0)returns 12 — rounds to nearest whole number.=ROUND(12.3456, -1)returns 10 — rounds to nearest 10.
4. Rounding Behavior:
If the digit following the rounding position is 5 or more, Excel rounds the number up. Otherwise, it rounds down.
Final Answer:
The ROUND function in Excel rounds a number to a specified number of digits, using the syntax:=ROUND(number, num_digits)
04
PYQ 2025
medium
accountancy ID: cbse-cla
State the advantages of 'Pivot Table' report.
Official Solution
Correct Option: (1)
To solve the problem, we need to understand the advantages of using a Pivot Table report in Excel, which is a powerful tool for summarizing and analyzing data.
1. Understanding Pivot Tables:
A Pivot Table is a dynamic reporting tool in Excel that allows users to reorganize and summarize selected columns and rows of data to obtain a desired report. It is used primarily for data analysis and decision-making.
2. Advantages of Pivot Table Reports:
- Summarizes Large Data Sets: Allows quick summarization of large volumes of data using totals, averages, counts, etc.
- Dynamic and Interactive: Enables users to change the view of the data by simply dragging and dropping fields.
- Data Analysis: Helps identify trends, patterns, and insights by grouping and filtering data.
- Easy to Use: Requires no complex formulas—drag-and-drop interface makes it user-friendly.
- Flexible Reporting: Offers multiple layout options such as tabular, outline, or compact views.
- Automatic Updates: Can be refreshed automatically when the source data changes.
- Supports Calculations: Allows insertion of calculated fields and custom formulas within the table.
- Drill Down Capability: Users can double-click summary values to see the detailed records.
Final Answer:
Pivot Table reports in Excel provide several advantages such as summarizing large data sets, offering interactive and flexible analysis, supporting custom calculations, and enabling users to easily explore and understand their data.
05
PYQ 2025
medium
accountancy ID: cbse-cla
Name the error which occurs when Excel doesn't recognize a Text formula. Give any two solutions to correct it.
Official Solution
Correct Option: (1)
To solve the problem, we need to identify the error that occurs when Excel doesn't recognize a text formula and then provide two possible solutions to correct it.
1. Identifying the Error:
The error that appears when Excel doesn't recognize a text formula is:#NAME?
This error typically means that:
- You have misspelled a function name.
- You have referenced a named range that doesn't exist.
- Text values in formulas are not enclosed in double quotes.
2. Solutions to Correct the Error:
- Check Spelling of Function Name:
Make sure that the formula uses the correct function name. For example, use=TEXT(A1,"mm/dd/yyyy")instead of a misspelled function like=TXET(A1,"mm/dd/yyyy"). - Enclose Text in Double Quotes:
When using text in formulas, ensure it is enclosed in quotation marks. For example,=IF(A1="Yes", "Approved", "Pending")instead of=IF(A1=Yes, Approved, Pending).
Final Answer:
The error that occurs is #NAME?. Two solutions to correct it are: (1) check for correct spelling of function names, and (2) make sure all text in formulas is enclosed in double quotation marks.
06
PYQ 2025
medium
accountancy ID: cbse-cla
State the steps in creating a pie chart using Excel.
Official Solution
Correct Option: (1)
Creating a pie chart in Microsoft Excel involves the following general steps: % Option
(A) Select Data: First, select the range of data you want to represent in the pie chart. For a pie chart, you typically select one column or row of numerical data, along with the corresponding column or row containing the category labels for each data point. Pie charts are suitable for showing parts of a whole, so ensure your data represents proportions of a total. % Option
(B) Go to Insert Tab: Click on the 'Insert' tab in the Excel ribbon. % Option
(C) Choose Pie Chart Type: In the 'Charts' group on the Insert tab, click on the icon for 'Pie or Doughnut Chart'. A drop-down menu will appear showing different types of pie charts (e.g., 2-D Pie, 3-D Pie, Pie of Pie, Bar of Pie, Doughnut). Select the desired pie chart subtype (e.g., 2-D Pie). % Option
(D) Chart Insertion: Excel will instantly insert the basic pie chart onto your worksheet based on the selected data. The numerical data determines the size of the slices, and the category labels are typically used in the legend. % Option
(E) Customize the Chart (Optional but Recommended): Once the chart is inserted, you can customize its appearance and elements using the 'Chart Tools' contextual tabs (Design and Format) that appear when the chart is selected: \begin{itemize}
% Option
(F) Chart Title: Add or edit the chart title to clearly describe what the chart represents. Click on the default title text box to modify it.
% Option
(G) Data Labels: Add data labels to show the actual values or percentages for each slice directly on the chart. Click the '+' button next to the chart (Chart Elements) or use the 'Add Chart Element' button on the 'Design' tab, then choose 'Data Labels' and select the desired position (e.g., Center, Outside End, Best Fit). You can further format labels to show category names or percentages. (H) Legend: Position or remove the legend as needed using the 'Chart Elements' (+) button or the 'Design' tab. (I) Chart Styles and Colors: Use the options on the 'Design' tab to quickly apply different visual styles or color schemes to the chart.
(J) Formatting Individual Slices: You can click on a specific slice once to select the whole series, and click again to select just that slice. Then, use the 'Format' tab or right-click options to change its fill color, add effects (like explosion), etc. \end{itemize} (K) Position and Resize: Click and drag the chart to move it on the worksheet. Drag the handles on the chart's border to resize it as needed.
07
PYQ 2025
medium
accountancy ID: cbse-cla
Explain 'ROUND' function of Excel.
Official Solution
Correct Option: (1)
The 'ROUND' function in Excel rounds a number to a specified number of decimal places, making it easier to handle numerical data. The syntax for the ROUND function is: \noindent where: - \texttt{number} is the number you want to round. - \texttt{num\_digits} is the number of digits to which you want to round the number. If \texttt{num\_digits} is greater than 0, the number is rounded to that many decimal places. If \texttt{num\_digits} is 0, the number is rounded to the nearest integer. If \texttt{num\_digits} is less than 0, the number is rounded to the left of the decimal point. \noindent \textbf{Example:} \texttt{=ROUND(12.567, 2)} will return 12.57. \texttt{=ROUND(12.567, 0)} will return 13.
08
PYQ 2025
medium
accountancy ID: cbse-cla
Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.
Official Solution
Correct Option: (1)
The error that occurs in Excel when it doesn't recognize text in a formula is the \#NAME? error. This error typically arises when:
\begin{itemize} \item A function name is misspelled (e.g., `=SUMM(A1:A5)` instead of `=SUM(A1:A5)`). \item A named range used in the formula does not exist or is misspelled. \item Text used in a formula is not enclosed in double quotation marks (e.g., `=IF(A1 10,Pass,Fail)` instead of `=IF(A1 10,"Pass","Fail")`). \item A function requires an add-in that is not installed or enabled.
\end{itemize} Two solutions to correct the \#NAME? error: (A) Check Spelling: Carefully verify the spelling of function names (e.g., `SUM`, `AVERAGE`, `VLOOKUP`) and any named ranges used in the formula. Correct any typos. Excel's Formula Auditing tools or formula suggestions can help. (B) Enclose Text in Quotes: If the formula intentionally uses text strings (like "Pass", "Fail", "Yes", "No"), ensure that the text is enclosed within double quotation marks (`"`). Numbers do not need quotes, but text does unless it's a defined name or function. *(Other possible solutions include: Defining the named range if it's missing, ensuring necessary add-ins are enabled, checking for incorrect range operators like using space instead of comma/colon).*