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