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