Excel and Macros

rabi kr shaw
Quiz by rabi kr shaw, updated more than 1 year ago
rabi kr shaw
Created by rabi kr shaw about 4 years ago
783
3

Description

Dovetail Manual Testing

Resource summary

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)
Show full summary Hide full summary

Similar

Dovetail Manual Testing 1-60
Mike Owen
Dovetail Manual Testing 1-60
rabi kr shaw
Dovetail Manual Testing 1-60
Aniela Carolina Mindiola cuello
Dovetail Manual Testing 1-60
Archana Srinivasan
Biology Unit 4: Respiration and Photosynthesis
Charlotte Lloyd
Diagnostico Organizacional Mapa Conceptual
Andrea Varela
LOS IMPUESTOS
Maria Paula Cardona Aux
Mapa Conceptual
Brenda Ruiz
MACROECONOMIA
Einar Steven Ortega
Población y Condiciones Sociales
Fernando Ruiz