What is the new name for central board of excise

Assignment Help HR Management

Reference no: EM132944403

PART 1

Q. Which are the three locations identified by India to set up 'water aerodromes' in India where amphibian planes can land ?

Q. After GST , what is the new name for Central Board of Excise and Customs, (CBEC) ?

Which AMC's CEO Leo Puri has quit due to differences between the foreign shareholder T.Rowe Price and the govt of India institutions ?

Which private equity firm has acquired a 60 % stake in Ramky Enviro Engineers for $ 530 million ?

Q. Name the business leader who is being accused, wrongly perhaps, of idol theft from temples in South India. His family is known for restoring temples as philanthropy.

Q. Which well known cinema theatre in Chennai is part of SPI Cinemas now being acquired by PVR Ltd ?

Q. Anant Bajaj RIP. With which company was Anant Bajaj associated with ?

Q. Which industrialist has been arrested recently for the first time on the basis of a crime investigated by Serious Fraud Investigation Office ( SFIO) in its 15 year history ?

Q. News of which industrialist's passing away began as "Shweta Bachchan Nanda's father-in-law and Chairman of ______ Group, _______ Nanda, passed away " in Business Standard today. Fill in the blanks.

Q. J.Paul Getty , at that time the richest man in the world , what device did he instal in his office so that the visitors did not use his phone to make free calls ?

Please answer all the question

1. The large toolbar that stretches across the top of the Excel window is known as the Excel bar.

True
False

2. If the Ribbon is not visible, double-click (single-click for Mac) on one of the Ribbon Tabs to maximise or restore it.

True
False

3. Columns are referenced using numbers.

True
False

4. Rows are referenced using numbers.

True
False

5. The first cell (top-left) in a standard Excel spreadsheet is known as 1A.

True
False

6. Cell B2 is below cell B3.

True
False

7. Cells D1, D2, D3, ..., D20 are all in the same column.

True
False

8.The Quick Access toolbar can be customised to show the tools you use most often.

True
False

9. Clicking on cell C3 and clicking Freeze Panes will freeze the top 3 rows and the first 3 columns.

True
False

10. You can navigate to the right of your spreadsheet by scrolling the scroll wheel of your mouse.

True
False

11. If you notice an error in a cell, you can correct it by typing over the error.

True
False

12. If text has already been entered in a column and you start typing in the same column, Excel will suggest existing values that begin with what you have typed.

True
False

13. You cannot copy and paste text into Excel from another Office software such as Microsoft Word.

True
False

14. If you want to remove some information from your spreadsheet, you can highlight this information and press Delete.

True
False

15. If you want to reverse most previously conducted tasks, you can click the Undo button at the top left of the Excel window.

True
False
Taking Charge of Excel: Test your skills, Part 2

1. How many rows in an Excel spreadsheet (version 2007 and later)?

Infinite (no limit)

50,000
16,348
More than 1 million
2. In a blank Excel workbook, go to the Insert tab on the ribbon. Which of the following is NOT available?

Table
Pictures
Rows
Shapes
3. In cell A1 type in the heading Date then press Enter. In cell A2 type in the following: 20-Jan-20. Use the fill handle to drag the date you have just typed down to row 20. What is the date in A15? Enter as shown or use Year-Month-Day format if you are not using an English version of Excel (for example 2020-01-20).

4. In cells B1 to B3 enter the following:

Select cells B2 and B3 then use the fill handle to drag down to row 20. What is the value in B15?

5.Close your workbook without saving and open the attached workbook. What value is in cell Q83 on the Orders sheet?

6. How many worksheets are there in this workbook?

7. Go to the Sales 2016 worksheet. Which cell contains the heading Qtr2?

8. Still in Sales 2016, select the range B8:E10. Look at the status bar at the bottom of the screen. You should see Sum followed by a number. What is the number?

(Hint: the range B8:E10 means to select all of the cells between B8 and E10. We go into this in more detail next week. Please use the number format #####.##)

9. Select the two non-contiguous ranges (not next to each other) B4:B7 and D14:D17. What is the Average showing on your status bar for the two ranges?

10.Change the value in C13 to be 4675.24. What is the new value in C18?

Week-2 (Performing calculations)

Taking Charge of Excel: Test your skills, Part 3

1. Open the attached workbook. In F7 calculate Base Pay by multiplying the Hours by the Rate. Copy the formula down to F12. What is Sandy Smith's Base Pay for the week?