Bihar Polytechnic SBTE Diploma CSE 3 Sem Dec 2019 ISP Paper
| Sr. No. | Questions with options |
| 1 | MS Excel is used for creating
(a) Presentation (b) Documents (c) Sending Mails (d) Spreadsheets |
| 2 | In Excel, Charts are creating using
(a) Pie chart (b) Pivot chart (c) Bar chart (d) Chart wizard |
| 3 | All macro, keyboard shortcuts include the ____key
(a) Alt (b) Ctrl (c) F11 (d) Shift |
| 4 | MS-Excel is a ____
(a) Language (b) System software (c) Package (d) None |
| 5 | A worksheet can have a maximum of ____number of rows in MS Excel 2000.
(a) 256 (b) 1024 (c) 32000 (d) 65535 |
| 6 | Short cut key to save a spread sheet?
(a) Ctrl+S (b) Alt+S (c) F11+S (d) Shift +S |
| 7 | Which tool bar allows changing of fonts and their size in MS Word
(a) Standard (b) Formatting (c) Print preview (d) None of these |
| 8 | From which menu you can insert Header and Footer?
(a) Insert Menu (b) View Menu (c) Format Menu (d) Tools Menu |
| 9 | What is the shortcut key you can press to create a copyright symbol?
(a) Alt+Ctrl+C (b) Alt+C (c) Ctrl+C (d) Ctrl+Shift+C |
| 10 | What is the smallest and largest font size available in font size tool on formatting tool bar?
(a) 8 and 72 (b) 8 & 62 (c) 12 & 72 (d) None of the above |
| 11 | Which of the following is NOT a valid data type in excel?
(a) Number (b) Character (c) Label (d) Date/Time |
| 12 | To drag a selected range of data to another worksheet in the same workbook, use the _____
(a) Tab key (b) Alt key (c) Shift key (d) Ctrl key |
| 13 | In a worksheet you can select ____
(a) The entire worksheet (b) Rows (c) Columns (d) All of the above |
| 14 | An excel workbook is a collection of
(a) Workbooks (b) Works sheets (c) Charts (d) Work sheets and charts |
| 15 | Excel files have a default extension of ?
(a) xls (b) xlw (c) wki (d) 123 |
| 16 | Which of the following is NOT one of power points view?
(a) Slide show view (b) Slide view (c) Presentation view (d) Outline view |
| 17 | Which short cut key inserts a new slide in current presentation?
(a) Ctrl + N (b) Ctrl + M (c) Ctrl + S (d) All of above |
| 18 | From which menu you can access picture, Test, Box, Chart etc?
(a) File (b) Edit (c) Insert (d) View |
| Data Collected By – K. Jeyanthi | |
| Published On – 22nd April 2022 | |
Leave a Reply