METHOD MEDIA COMPUTER ACADEMY PRIVATE LIMITEDProfessor Colony, Garhpar, Biharsarif-1, Nalanda, Bihar, India, 803101SET 2 |
|
Question : 15 | Duration : 6 Minutes |
1. An Excel is ---------------- program | |
A: Spreadsheet | |
B: Document | |
C: Presentation | |
D: Spreadsheet | |
Answer: A | |
| |
2. Which of the following format you can decide or not in Auto format dialog box | |
A: Number format | |
B: Border format | |
C: Font format | |
D: Number format | |
Answer: D | |
| |
3. What is the maximum number of rows in excel 2007 worksheet | |
A: 1028176 | |
B: 1048576 | |
C: 1045876 | |
D: 1028176 | |
Answer: B | |
| |
4. ____ appear at the bottom of the Excel window. | |
A: Title bar | |
B: Formula bar | |
C: Work sheet tabs | |
D: Title bar | |
Answer: C | |
| |
5. What are the basic rectangular building blocks of a spreadsheet? | |
A: Cells | |
B: Zoom slider | |
C: Help button | |
D: Cells | |
Answer: A | |
| |
6. Another name for a pre-programmed formula in Excel is | |
A: Cell | |
B: Graph | |
C: Function | |
D: Cell | |
Answer: C | |
| |
7. ____ is a powerful tool used to create and format spreadsheets. | |
A: Adobe Photoshop CS | |
B: Mozilla Firefox | |
C: Microsoft Office PowerPoint | |
D: Adobe Photoshop CS | |
Answer: D | |
| |
8. Workbook is a collection of | |
A: Worksheets | |
B: Page set-up | |
C: Buttons | |
D: Worksheets | |
Answer: A | |
| |
9. The result of a formula in a cell is the | |
A: Displayed value | |
B: Range | |
C: Value | |
D: Displayed value | |
Answer: C | |
| |
10. ___ is the intersection of a row with a column. | |
A: Cell | |
B: Rows | |
C: Columns | |
D: Cell | |
Answer: A | |
| |
11. To select the entire column, press | |
A: Tab + C | |
B: Tab + E | |
C: Alt + Space | |
D: Tab + C | |
Answer: D | |
| |
12. In A3 cell edit = A1 + A2 refers to | |
A: Addition of A1 and A3 will display in A2 | |
B: Addition of A1 and A2 will display in A3 | |
C: Addition of A1 and A2 will not display in A3 | |
D: Addition of A1 and A3 will display in A2 | |
Answer: B | |
| |
13. When you enter text in a cell in Excel. It also appears in the | |
A: Status bar | |
B: Formula bar | |
C: Row heading | |
D: Status bar | |
Answer: B | |
| |
14. How many rows are there in old version of MS Excel? | |
A: 65536 | |
B: 65538 | |
C: 65534 | |
D: 65536 | |
Answer: A | |
| |
15. ____ was the first spreadsheet on a microcomputer. | |
A: VisiCalc | |
B: Excel | |
C: Lotus 1-2-3 | |
D: VisiCalc | |
Answer: A | |
|