Quiz Con Macros De Excel
Boost your chances to become a professional take MCQ for Linux and Windows Integration with MCQ on X Windows, Linux Backups & Deployment, Linux. Excellence with Excel - Quiz Questions. Module 7: Introduction to VBA, Macros, and User-Defined Functions. For which of the following scenarios is it the. Microsoft excel has given a lot of people sleepless nights trying to figure it out and some give up on it completely. Do you want to test your basic knowledge on excel sheet? Let’s play this excel practice quiz and prove yourself. This is not for the weak, good luck!
Success! A copy of this quiz is in your dashboard.
MicrosoftExcel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on excel sheet? Let’s play this excel practice quiz and prove yourself. This is not for the weak, good luck!
- A.
- B.
- C.
- D.
- 2.
- A.
- B.
- C.
- D.
- E.
- F.
- G.
- 3.
- A.
- B.
- C.
- D.
- 4.True or False. If you choose a larger font size, the height of the row is automatically made taller.
True
False
- Which button allows you to copy cell formats from one cell to another?
Enter
Autofit
Format painter
Esc
- A.
- B.
- C.
- D.
- E.
- 7.
- A.
- B.
- C.
The data changes to Bold to let me know it's active.
I'm psychic & I just Know!
- True or False. A range has an address called a range address.
True
False
- A.
- B.
- C.
- D.
- E.
- 10.When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a ________________.
Cell selector
Cell cross
Selection pointer
Range selector
Quiz Con Macros De Excel En Espanol
Success! A copy of this quiz is in your dashboard.
- Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
- Which menu option can be used to split windows into two In Excel 2007?
Format -> Window
View -> Window-> Split
Window -> Split
View –> Split
- Difference between iserror and iserr
Iserr excludes #n/A and returns the value
Both are same
Iserror excludes #n/A and returns the value
Iserr returns when the value is #value
- A.
= VLOOKUP(lookup_value, table_array, col_index_num, [not_exact_match],[range_lookup])
= VLOOKUP(lookup_value, table_array, col_index_num, [exact_match],[range_lookup])
= VLOOKUP(lookup_value, table_array, range_lookup, [col_index_num])
= VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
- What happens when dollar signs ($) are entered in a cell address? (eg. $A$2:$A$10)
The sheet tab is changed.
An absolute cell address is created.
Cell address will change when it is copied to another cell.
The status bar does not display the cell address.
- The lookup value must always be located in the first column of the lookup table
True
False
- VBA Object hierarchy?
Objects, Methods, Properties and Variables
Objects,Properties,Methods and variables
Methods,Objects,Properties and variables
Variables,Objects,Methods and Properties
- What is Default in VBA among the Following?
Pass By Address
Pass By Reference
Pass By Value
None Of the Above
- Declaration Make mandatory with the use of Option Implicit
True
False
- A.
Deletes Entire Rows from 1 to10 in the worksheet 'Data'
Deletes contents from Rows 1 to 10 in the worksheet 'Data'
Deletes Entire Columns from 1 to10 in the worksheet 'Data'
Incorrect Statement
- How to Hide a Sheet using VBA code?
Sheets('Sheet1').Visible = True
Sheets(1).Visible = xlSheetVeryHidden
Sheets('Sheet1').Visible = False
None of the Above
- What is the Use of OPTION EXPLICIT
It Make the Declaration of Variable Optional
It Make the Declaration of Variable Unnecessary
It Make the Declaration of Variable Mandatory
It Declares the Default Lower Bound for Arrays
- Private Procedure can be called from anywhere in the project
True
False
- TODAY() is Volatile functions?
True
False
- A.
Double-click the sheet tab, type a name, and press Enter.
Click the sheet tab, type a name, and Press Enter.
Right-click the sheet tab, choose Rename, type a name, and press Enter.
Home --> Cells Group --> Format --> Rename