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