Bihar SBTE Diploma CSE 3 Sem Dec 2019 ISP Paper

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
   
   

Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *