The sample of an Excel worksheet on the screen can be seen by ………………..
- ✓Print preview
- BPrint
- CReview
- DNone of the above
Answer: A.
View full solution →Question types
MS-Excel 2007 question types
90 questions across 7 question groups — pick any mix to generate a Information Technology paper with step-by-step answer keys.
90
Questions
7
Question groups
5
Question types
01
MCQ
28 Q→02Fill in the blank
14 Q→03True-False
10 Q→04[1 Mark Questions]
19 Q→05[2 Mark Questions]
14 Q→06[3 Mark Questions]
3 Q→07[5 marks Questions]
2 Q→Sample Questions
MS-Excel 2007 questions
One sample from each question group in this chapter. Select any group above to see the full set with answer keys.
For selecting the entire worksheet in Excel, you need to press ……………….
- AAlt + Shift + eSpacebar
- ✓Ctrl + Shift + Spacebar
- CShift + Spacebar
- DNone of the above
Answer: B.
View full solution →For selecting a non-continuous range of cells, you need to do what?
- APress Alt key
- ✓Press Shift key
- CPress Esc key
- DPress Ctrl key
Answer: B.
View full solution →Which of the following shortcut keys brings the cursor to the last cell on the sheet that contains data?
- ACtrl+Home
- ✓Ctrl+End
- CCtrl + Page down
- DCtrl+down arrow
Answer: B.
View full solution →The another name for the XY chart is ……………….
- AColumn chart
- BNet chart
- CBar chart
- ✓Scatter chart
Answer: D.
View full solution →$…….....$ are text, number cell references enclosed within parenthesis in a formula.
View full solution →The range of cells containing data that makes a chart is termed as $…….....$ data.
View full solution →The $…….....$ tool is used in speadsheet that creates a growth series, wherein subseguent values follow an increasing or a decreasing geometric pattern.
View full solution →To specify the number of decimal places in a cell the $…….....$ tab of the Format cells dialog is used.
View full solution →If you enter 15 + 30 in a cell, Excel will display ……………..
The contents of a cell can be changed by pressing F2 key on keyboard.
A chart is a graphical representation of worksheet data.
The title of the chart tells the type of the chart.
The Insert button is found on Cells group under Home tab.
The Fill handle tool is used for labour intensive entering data in a spreadsheet.
What will be the column names of the below statement?
- 26th column
- 28th column
Write down the importance of legend in charts.
Why we cannot add titles to an embedded chart once chart is ready?
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?
State difference between COUNT() and COUNTA() function.
Neha Mittal wants to store data of her montly expenditure for a period of two year and also wants to perform some calculation and analysis. Which Microsoft application, will you suggest Neha should use for this purpose and why?
- 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 alongwith the relevant cell address:
- To calculate the Stock Value as product of ‘Quantity in Stock1 and ‘Rate’ for each item present in the spreadsheet.
- To calculate the ‘Quantity to Order’ as ‘Minimum Stock Quantity’-‘Quantity in Stock’ for each item.
- 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.
- Proprietor wants to graphically represent his stationery stock. Suggest him the most appropriate feature of MS-Excel.
- If Quantity in Stock’s value changes, will have to redo all the calculations for that particular column? Explain.
- Write command for the operations (i) to (iii) based on the spreadsheet below:
- To calculate the Amount as Unit Price*Qty for each item in Column F.
- To calculate the Rebate as 7% of Amount if Type is consumable, else calculate Rebate as 11% of Amount in Column G.
- To calculate total Rebate across all items in cell G6
Describe, how the owner of the restaurant could use the spreadsheet for financial modeling?
In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 is more than 300, the value in cell K15 would be 1.33 times the value of cell K12. Otherwise, the value in cell K15 would be 1.5 times the value in cell K12. Explain the formula that you use to achieve this.
How are charts created in Excel? Write the steps.
What are the various types of charts? Explain each.
Write down the name and purpose of various components of a chart.
Explain any five functions that can be used in a worksheet.
Explain the concept of cell referencing alongwith its various types.
Generate a MS-Excel 2007 paper free
Pick question groups from the list above, set marks and difficulty, and export a branded PDF with step-by-step answer keys. First 3 chapters free — no signup.