7340284
Description
Quiz by rabi kr shaw, updated more than 1 year ago
|
Created by rabi kr shaw
over 7 years ago
|
|
Question 1
Question
Follow the code and identify the output
Private Sub WrokBookOpen()
Sheets(“sheet1”).Range(“A1”)=Date
End Sub
Answer
-
Assigns the value when the workbook is Opens an excel sheet 1, and assigns current date in cell A1
-
Assigns the value when the workbook is closed
-
Assigns the value when the workbook is saved
Question 2
Question
Find the no of working days between two given days using excel Function
Answer
-
All
-
DateDiff(Start Date, End Date)
-
Days 360(Start Date, End Date)
-
Network days(Start Date, End Date, Holidays) or work day()
Question 3
Question
To Create a Macro Enabled Workbook, save the workbook as:
Answer
-
Excel 972003 workbook
-
Excel Macro Enabled workbook
-
Excel Binary workbook
-
Excel workbook
Question 4
Question
To highlight interesting cells, emphasize unusual values and repetitive data using scales
Answer
-
Data valid
-
Pivot table
-
Conditional formating
-
What if analysis
Question 5
Question
You can also run your tests from your own code?
Answer
-
True
-
False
Question 6
Question
Unprotecting the macros is done by file recovery
Answer
-
True
-
False
Question 7
Question
Macro allows below for programming….
Answer
-
Pivots
-
Spread sheets
-
Charts
Question 8
Question
Important is a cell formatting type on excel
Answer
- True
- False
Question 9
Question
Forms and ActiveX controls cannot be added in an excel sheet and tagged to a macro code.
Answer
- True
- False
Question 10
Question
Follow the code and identify the output
Private Sub WrokBookOpen()
Sheets (“sheet1”).Range(“A1”)=Date
End Sub
Answer
-
Opens an excel sheet 1, and assigns current date in cell A1
-
Assigns the value when the workbook is closed
-
Assigns the value when the workbook is saved
Question 11
Question
If we give a number from 1 to 7 function
returns a number representing the day of a week
Answer
-
weeknum
-
weekend
-
weekday
-
weekof
Question 12
Question
To Open workbook in current application path in folder macros
Answer
-
Open filename:=Activeworkbook.path&” \\folder name\filename.xls “
-
open filename:=Activeworkbook.path &” \\folder name & “\filename.xls”
-
none
-
all
Question 13
Question
What is the function to check day of a week?
Answer
-
weekday
-
workday
-
weeknum
-
networkdays
Question 14
Question
The statement used when multiple IF statements are to written in VBA
Answer
-
For next
-
While next
-
Select case
Question 15
Question
It is possible to set or reset the filter option in a sheet through macro code?
Answer
- True
- False
Question 16
Question
Which of the following code snippets return the address of the current cell to the variable CellAddress.
Answer
-
CellAddress = Activecell.Address(True, True)
-
CellAddress = Activecell.Address(False, False)
-
CellAddress = ActiveSheet.Activecell.address(x!A1)
-
CellAddress = Activecell.Address(False, False, x!R1C1)
Question 17
Question
Pivot table data gets updated, whenever data gets changes or refreshed
Answer
- True
- False
Question 18
Question
How to protect Excel sheet by the password “something” .
Answer
-
ActiveWorkbook.Password:=”Something”
-
ActiveWorkbook.Protect (Password:=”Something”)
-
ActiveWorkbook.Protect (Password:==”Something”)
Question 19
Question
Predefined the customizable Table and PivotTable styles in Light, Medium and Dark are to be applied to
data ranges in a worksheet
Answer
- True
- False
Question 20
Question
What does ActiveX control.
Answer
-
Cannot be modified to run Web scripts on Web pages
-
Cannot be added to chart sheets from the user interface or to XLM macro sheets
-
Can be used on worksheet forms, with or without the use of VBA code, and on VBA User form
Question 21
Question
IF error function in excel is supported in the version(s):
Answer
-
2007
-
2003
-
none
-
both 2007 and 2003
Question 22
Question
Select the count of cells with value between 15 and 26
Answer
-
Countif(val>15 &val< 26)
-
Countits(val>=15 &val<= 26)
-
Countif(val>=15 &val<= 26)
Want to create your own Quizzes for free with GoConqr? Learn more.