FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

Download GTU BE/B.Tech 2019 Winter 5th Sem Old 150706 Visual Basic Application And Programming Question Paper

Download GTU (Gujarat Technological University) BE/BTech (Bachelor of Engineering / Bachelor of Technology) 2019 Winter 5th Sem Old 150706 Visual Basic Application And Programming Previous Question Paper

This post was last modified on 20 February 2020

This download link is referred from the post: GTU BE/B.Tech 2019 Winter Question Papers || Gujarat Technological University


FirstRanker.com

GUJARAT TECHNOLOGICAL UNIVERSITY
BE - SEMESTER-V (Old) EXAMINATION — WINTER 2019

--- Content provided by FirstRanker.com ---

Subject Code: 150706 Date: 06/12/2019
Subject Name: Visual Basic Application & Programming
Time: 10:30 AM TO 01:00 PM Total Marks: 70

Instructions:

  1. Attempt all questions.
  2. --- Content provided by FirstRanker.com ---

  3. Make suitable assumptions wherever necessary.
  4. Figures to the right indicate full marks.

Q.1 (a) List various advantages and disadvantages of Visual Basic programming. 07
(b) Explain all VBA operators, its precedence in details with examples. 07

Q.2 (a) How do you declare variables in VBA? Explain scope and lifetime of variables. 07

--- Content provided by FirstRanker.com ---

(b) Write a VBA code which accepts percentage from the user and displays the grade based on following conditions. 07

  1. percentage >=70 Grade is “Distinction”
  2. percentage >=50 and <70 Grade is “First class”
  3. percentage >=40 and <50 Grade is “Second class”
  4. percentage<40 Grade is “Fail”
  5. --- Content provided by FirstRanker.com ---

OR

(b) What is a Macro? Give applications of macros with example. 07

Q.3 (a) Explain Following terms: Breakpoint, immediate window, code window, object browser, block commenting (Any Three). 07
(b) Explain syntax of select...case statement with example. 07

OR

--- Content provided by FirstRanker.com ---

Q.3 (a) What is the difference between list box, check box and combo box? Give an example of list box and combo box. 07
(b) How can we handle runtime errors in VB? Explain with suitable example. 07

Q.4 (a) Compare procedure and function. How can we create them in VB? 07
(b) Write a VBA code for storing and adding 10 numbers in an array. 07

OR

--- Content provided by FirstRanker.com ---

Q.4 (a) Explain fixed arrays and dynamic arrays with example. 07
(b) Write a short note on Digital signature. 07

Q.5 (a) What is a database? Which control is used to access database in VBA. Give properties of this control. 07
(b) Write the steps for creating ActiveX Control and how to use in ActiveX in a new project. 07

OR

--- Content provided by FirstRanker.com ---

Q.5 (a) Explain msgbox and inputbox with suitable example. 07
(b) Explain different types of Resume statements with example. 07

FirstRanker.com


--- Content provided by FirstRanker.com ---


This download link is referred from the post: GTU BE/B.Tech 2019 Winter Question Papers || Gujarat Technological University