Excel and Macros

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)

Next up

Excel and Macros

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Similar

	Created by rabi kr shaw about 4 years ago