Related InterviewSolutions

• The default alignment of text in a cell is(a) Left (b) Right(c) Centered (d) Justified
• Word wrapping means(a) the text remains in the straight line(b) the text distributed in multiple lines(c) displays text vertically within a cell(d) displays the selected text in a different font style
• What will be the column names of the below statement?1. 26th column2. 28th column
• Excel is a ………………. software package.
• The default page orientation in Excel is(a) Landscape (b) Horizontal(c) Portrait (d) None of these
• Why we cannot add titles to an embedded chart once chart is ready?
• Arihant stationery keeps stock of various stationeries in his shop. The proprietor wants to maintain a stock value and reorder level for following items as given in a spreadsheet. Write formulas for the operations (i) to (iii) and answer the questions (iv) and (v) based on the spreadsheet given below along with the relevant cell address:1. To calculate the Stock Value as product of ‘Quantity in Stock1 and ‘Rate’ for each item present in the spreadsheet.2. To calculate the ‘Quantity to Order’ as ‘Minimum Stock Quantity’-‘Quantity in Stock’ for each item.3. To calculate the ‘Order Value’ as product of ‘Quantity to Order’ and ‘Rate’ for the items if ‘Quantity to Order’>=0, else assign the value as 0.4. Proprietor wants to graphically represent his stationery stock. Suggest him the most appropriate feature of MS-Excel.5. If Quantity in Stock’s value changes, will have to redo all the calculations for that particular column? Explain.
• Write down the name and purpose of various components of a chart.
• Hansika wants to apply MIN function on a cell range, but all the values in that range are of Boolean. What value will be returned by the MIN function?
• Write down the significance of electronic spreadsheets.