Who was the first Indian to win an Oscar award?
Who was the first Indian to win an Oscar award?
AA.R. Rahman
BResul Pookutty
CBhanu Athaiya
DAamir Khan
Saturday, January 4, 2020
You want to calculate the payment for a loan amount of INR 20,000 at 10% interest rate for a period of 2 years.
You want to calculate the payment for a loan amount of INR 20,000 at 10% interest rate for a period of 2 years. Which of the following excel formula would you use in cell E2 assuming the loan is compounded monthly?
A"=PMT(A2/C2,B2*C2,D2)"
B"=NPER(A2/C2,B2*C2,D2)"
C"=RATE(A2/C2,B2*C2,D2)"
D"=PV(A2/C2,B2*C2,D2)"
The MSExcel 2010 worksheet in the following figure contains large quantities ofdata.
The MSExcel 2010 worksheet in the following figure contains large quantities of data. You want to print only the data in the range A1 through D19. How would you achieve this?
A
Select the cells A1 through D19, click File, and then click Print. In the Printpanel, under Settings, click Print Selection and click the Print button.
BSelect the cells A1 through D19, click File, and then click Print. In the Printpanel, under Settings, click Print Active Sheets and click the Print button.
C
Select the cells D1 through D19, click File, and then click Print. In the Printpanel, under Settings, click PrintSelection and click the Print button.
D
Select the cells D1 through D19, click File, and then click Print. In the Printpanel, under Settings, click Print Active Sheets and click the Print button.
You want to find out the year wise total sales on different regions.
You want to find out the year wise total sales on different regions. Which of the following should you perform in MSExcel 2010 to achieve the same?
A
Sort the Year field from smallest to largest. Then, select the Data tab and click the Subtotal command to use it.
B
Sort the State field in ascending order. Then, select the Data tab and use the Group command to use it.
C
Sort the Year field from smallest to largest. Then, select the Data tab and clickthe Consolidate command to use it.
DSort the State field in ascending order. Then, select the Data tab and click the Subtotal command to use it.
Assume a product table in an Access database with the following fields
Assume a product table in an Access database with the following fields:
1.ProductID
2.Price
3.Quantity
Which of the following features in Access 2010 should you use to insert a Sales field in the Product table? The Sales field should hold the sales amount that can be calculated using the expression Price * Quantity.
ACalculated fields
BPivot tables
CDefault values
DExpressions
You are preparing a business presentation to discuss the market structure
You are preparing a business presentation to discuss the market structure ofbanking industry in the global scenario. You want to include a survey report in oneof your PowerPoint 2010 slides. The survey report is available in an MSExcel file.How will you insert a picture of the Excel file into your presentation?
Note: Any changes to the source Excel file should be reflected in the inserted Excelfile link in your presentation.
AClick the Insert tab and then in the Text group, click Object. In the Insert Object dialog box, click Create from file to browse and then select the Excelfile that contains the sales report and then click OK. Then, in the Insert Objectdialog box, select Link and click OK.
BClick the Insert tab and then in the Text group, click Object. In the InsertObject dialog box, browse to and then select the Excel file that contains thesales report and then click OK. Then, in the Insert Object dialog box, click OK.
CClick the Insert tab and then in the Links group, click Hyperlink. In theInsert Hyperlink dialog box, browse to and then select the Excel file thatcontains the sales report and then click OK. Then, in the Insert HyperLinkdialog box, click OK.
DClick the Insert tab and then in the Text group, click Object. In the InsertObject dialog box, browse to and then select the Excel file that contains thesales report and then click OK. Then, in the Insert Object dialog box, selectDisplay as Icon and click OK.
You are creating a presentation to discuss the sales targets with your sales team
You are creating a presentation to discuss the sales targets with your sales team.You want to add few slides to your presentation from another without having to open the other file. Which of the options should you click in the New Slide dropdown to achieve the same? Assume that you have clicked the desired location where you want to add the slides in the slide thumbnail pane on the left. The given figure shows the New Slide dropdown.
ADuplicate Selected Slides
BSlides from Outline
CReuse Slides
DBlank
