NCERT solutions for अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ chapter 2 - Spreadsheet [Latest edition]

The best way to get started in Excel 2007 is to click the ______.

Which key combination collapses the ribbon?

Which view shows margins and the rulers?

As you type a number in a cell, what mode appears in the status bar?

Where is the address of the active cell displayed?

Which command reverses the last action performed in the worksheet?

When navigating in a workbook, which command is used to move to the beginning of the current row?

Which key, when pressed, displays the access keys?

Which command allows you to reverse an Undo command?

Which function results can be displayed in Auto Calculate?

Which cell alignment is assigned to most values by default?

Which function automatically totals a column or row of values?

Which mathematical operator is represented by an asterisk (*)?

Which step completes an entry and moves the pointer to the cell to the right?

How many blank worksheets are shown when a new workbook is created?

Define spreadsheet.

Give salient features of a spreadsheet.

Write any five advantages using electronic spreadsheet in place of manual spreadsheet.

Define workbook.

Define worksheet.

What is the difference between a workbook and a worksheet?

Explain the active worksheet.

Using the Fill: Series command in Excel, write down the steps to fill data from 120,320…..2300 in Column A.

Define Data Range.

Name Range and how these are created and selected?

Write down the steps for the use of Custom Lists.

Explain the purpose of Format.

Explain the purpose of Conditional Formatting.

Explain the purpose of Auto Format.

What is the Wrap Text feature of Excel?

What is the merging of cells?

What will be the cell address of the merged cells?

Explain the purpose of using Print Preview?

Explain the difference between relative reference and absolute reference.

Discuss the IF function, giving an example.

Discuss nested IF functions, giving an example.

Write down examples for any two financial functions you know with their proper syntax.

What is the use of the PMT function?

How many ways is data entry possible in a spreadsheet?

Define a one-variable table. Explain with examples.

Define a two-variable table. Explain these with examples.

Define Pivot Table.

Explain the usage of Pivot Table.

What are formulas?

How are formulas created?

Write down the differences between a formula and a function.

You had started your own online business to sale and find out the sales for the first week is as follows:

Use a function to work out how much you earned, on average, each day.

Use a Days 360 function to work out how many days are left before your next birthday. Instead of typing out the current date in, say, cell A2, you can use this built-in function:

=Now ( )

The Now function doesn’t need anything between the round brackets. Once you have today’s date, you can enter your birthday in, say, cell B2.

Create an Activity Report (Weekly) for a Sales Representative working in a reputed home appliances manufacturing company. Details recorded should contain Date of Visit, Day of Visit, Name of Shop/Dealer Visited, Address, Phone Number, Name of Product (Dealing), Type of Response (by the Dealer), Demand of Product and Duration Spent (in hrs)..

1. Fill data in Date of Visit and Day of Visit using Fill Series.
2. Name the worksheet created above as Weekly Visit Report.
3. Create a product-wise, Dealer-wise Monthly Report which should include Total Hours Spent.
4. Count the total number of dealers visited and dealers who gave a positive response.

Create a worksheet to record sales of home appliances sold by M/s Home Maker Ltd. In the following format:

The product lists includes Television sets, Refrigerators, Micro wave ovens, Water Coolers, Air Coolers, Geezers and Air conditioners of different Makes (and models). The cost of price of television is ranging from Rs. 10,000 to Rs. 56,000; refrigerator is Rs. 13,000 to Rs. 45,000, micro wave ovens, water coolers, geezers and air coolers are from Rs. 8,000 to Rs. 25,000 and Air Conditioners are from Rs. 18,000 to Rs. 55,000. The shopkeeper sells these products, adding 17.25% more on the cost price. He provides a discount of 4.35% on the total amount if any customer purchases two products on the same date. Enter 30 records of different dates (for a month) and different customers accordingly. Calculate the following:

1. Product-wise weekly sales and discount.
2. Calculate the profit of the shopkeeper.
3. Product-wise total sales of the month and discount offered.

Create a worksheet to keep track of revenue collected and expenses done in conducting tour programs at different tourist places during 2004 to 2008. Format the numeric data in currency format, prepare year-wise columns for revenue and expenses for each tourist place and calculate the difference. The calculated difference may be negative; the format of negative balance may be red coloured. Use conditional formatting for higher and lower values of revenue and expenses. Align the entire text in the centre. The font of tourist place is Arial with 14 point while the font of year is Times Roman with 14 points.