# Excel and Macros

Quiz by rabi kr shaw, updated more than 1 year ago
 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
• 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
• 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:
• 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
• Data valid
• Pivot table
• Conditional formating
• What if analysis

### Question 5

Question
You can also run your tests from your own code?
• True
• False

### Question 6

Question
Unprotecting the macros is done by file recovery
• True
• False

### Question 7

Question
Macro allows below for programming….
• Pivots
• Charts

### Question 8

Question
Important is a cell formatting type on excel
• True
• False

### Question 9

Question
Forms and ActiveX controls cannot be added in an excel sheet and tagged to a macro code.
• True
• False

### Question 10

Question
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
• 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
• weeknum
• weekend
• weekday
• weekof

### Question 12

Question
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

### Question 13

Question
What is the function to check day of a week?
• weekday
• workday
• weeknum
• networkdays

### Question 14

Question
The statement used when multiple IF statements are to written in VBA
• 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?
• True
• False

### Question 16

Question
Which of the following code snippets return the address of the current cell to the variable CellAddress.

### Question 17

Question
Pivot table data gets updated, whenever data gets changes or refreshed
• True
• False

### Question 18

Question
How to protect Excel sheet by the 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
• True
• False

### Question 20

Question
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

### Question 21

Question
IF error function in excel is supported in the version(s):
• 2007
• 2003
• none
• both 2007 and 2003

### Question 22

Question
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)

### Similar

Dovetail Manual Testing 1-60
Dovetail Manual Testing 1-60
Dovetail Manual Testing 1-60
Dovetail Manual Testing 1-60
Biology Unit 4: Respiration and Photosynthesis
Diagnostico Organizacional Mapa Conceptual
LOS IMPUESTOS
IMPERIO ROMANO
Mapa Conceptual
MACROECONOMIA
Población y Condiciones Sociales