Each question in this quiz is timed.
Follow the code and identify the output Private Sub WrokBookOpen() Sheets(“sheet1”).Range(“A1”)=Date End Sub
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
Find the no of working days between two given days using excel Function
All
DateDiff(Start Date, End Date)
Days 360(Start Date, End Date)
Network days(Start Date, End Date, Holidays) or work day()
To Create a Macro Enabled Workbook, save the workbook as:
Excel 972003 workbook
Excel Macro Enabled workbook
Excel Binary workbook
Excel workbook
To highlight interesting cells, emphasize unusual values and repetitive data using scales
Data valid
Pivot table
Conditional formating
What if analysis
You can also run your tests from your own code?
True
False
Unprotecting the macros is done by file recovery
Macro allows below for programming….
Pivots
Spread sheets
Charts
Important is a cell formatting type on excel
Forms and ActiveX controls cannot be added in an excel sheet and tagged to a macro code.
Follow the code and identify the output Private Sub WrokBookOpen() Sheets (“sheet1”).Range(“A1”)=Date End Sub
Opens an excel sheet 1, and assigns current date in cell A1
If we give a number from 1 to 7 function returns a number representing the day of a week
weeknum
weekend
weekday
weekof
To Open workbook in current application path in folder macros
Open filename:=Activeworkbook.path&” \\folder name\filename.xls “
open filename:=Activeworkbook.path &” \\folder name & “\filename.xls”
none
all
What is the function to check day of a week?
workday
networkdays
The statement used when multiple IF statements are to written in VBA
For next
While next
Select case
It is possible to set or reset the filter option in a sheet through macro code?
Which of the following code snippets return the address of the current cell to the variable CellAddress.
CellAddress = Activecell.Address(True, True)
CellAddress = Activecell.Address(False, False)
CellAddress = ActiveSheet.Activecell.address(x!A1)
CellAddress = Activecell.Address(False, False, x!R1C1)
Pivot table data gets updated, whenever data gets changes or refreshed
How to protect Excel sheet by the password “something” .
ActiveWorkbook.Password:=”Something”
ActiveWorkbook.Protect (Password:=”Something”)
ActiveWorkbook.Protect (Password:==”Something”)
Predefined the customizable Table and PivotTable styles in Light, Medium and Dark are to be applied to data ranges in a worksheet
What does ActiveX control.
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
IF error function in excel is supported in the version(s):
2007
2003
both 2007 and 2003
Select the count of cells with value between 15 and 26
Countif(val>15 &val< 26)
Countits(val>=15 &val<= 26)
Countif(val>=15 &val<= 26)
