Font size
WorksheetsLONG QUIZ 2
Total questions: 60
Worksheet time: 30mins
You need to prevent colleagues from making structural changes to a workbook, such as adding or deleting sheets. What feature should you use?
Protect Sheet
Protect Workbook
Allow Users to Edit Ranges
Track Changes
A manager wants to track all edits made to a shared workbook. What feature should you enable?
Comments
Protect Workbook
Track Changes
Shared Workbook
You need to leave feedback on a specific cell without affecting the data. What should you use?
Add a hyperlink
Insert a comment (Note in Excel 365)
Change the cell color
Protect the cell
A report contains text data, and you need to ensure there are no spelling errors. What feature will you use?
Thesaurus
Proofing
Spell Check
Comments
You want to allow specific users to edit only certain ranges in a protected sheet. What feature should you use?
Protect Workbook
Allow Users to Edit Ranges
Share Workbook
Data Validation
You need to keep the top row visible while scrolling through a long dataset. Which option should you use?
Split
Hide Rows
Freeze Panes > Freeze Top Row
Arrange All
You are working with a large dataset and want to compare data from two parts of the sheet simultaneously. What should you use?
Hide Columns
Split
Freeze Panes
New Window
You want to see how your spreadsheet will look when printed, including headers and margins. Which view should you select?
Normal View
Page Layout
Page Break Preview
Custom View
You frequently filter data in a specific way. How can you save the settings for quick access later?
Save As Template
Create a Custom View
Use Filters
Freeze Panes
You have multiple workbooks open and need to view them side by side. What should you use?
View Side by Side
New Window
Arrange All
Split
You need to automate a repetitive task in Excel. What feature should you use?
Data Validation
Form Controls
Macros
Conditional Formatting
You want to add a dropdown menu to a worksheet for selecting predefined options. Which feature should you use?
Data Validation
Combo Box (Form Control)
Spin Button
Check Box
A macro-enabled workbook is flagged as unsafe. Where can you adjust the security settings to allow it?
File > Save As
Review Tab
Developer Tab > Trust Center
View Tab
You need to write a custom script for advanced automation in Excel. Which tool should you use?
Macro Recorder
VBA Editor
Data Analysis ToolPak
Solver
You want to add an interactive button that executes a macro when clicked. Which control should you use?
Combo Box (Form Control)
Check Box
Button (ActiveX Control)
Option Button
You want to prevent unauthorized users from opening your workbook. What feature should you use?
Protect Workbook
Encrypt with Password
Allow Users to Edit Ranges
Track Changes
You want to adjust how your spreadsheet will split across pages when printed. Which feature is most useful?
Normal View
Page Break Preview
Print Preview
Split
You want to insert a scroll bar to adjust numerical values in a cell. Which control would you use?
Combo Box
Scroll Bar (Form Control)
Check Box
Spin Button
You are performing a task that you want Excel to replicate automatically in the future. What should you do first?
Open the VBA Editor.
Use the Record Macro feature.
Create a Pivot Table.
Use Conditional Formatting.
You are working on a large spreadsheet and need to focus on a specific section by magnifying it. Which feature should you use?
Zoom
Freeze Panes
Page Layout
Arrange All
What are the main advantages of using the INDEX and MATCH functions in Excel?
They can perform complex calculations
They can handle multiple criteria
They are faster than VLOOKUP
They create dynamic charts
When might you use the Index-Match combination instead of VLOOKUP?
When you need to perform calculations on the result
When you want to search in a single column
When you need to retrieve data from another worksheet
When working with text data only
What does VBA stand for in Excel?
Visual Basic for Application
Visual Basic for Analysis
Very Basic Automation
Virtual Business Applications
How can VBA be used in Excel for financial analysis?
To create pivot tables
To format cells
To automate repetitive tasks
To import data from external sources
What is the main benefit of using named ranges in Excel?
They make formulas more complex
They improve data accuracy
They slow down worksheet performance
They are used for text formatting
How can named ranges be used in financial modeling?
For creating custom charts
For speeding up data entry
For error reduction in formulas
For importing data from external sources
When might you use the CHOOSE function in financial modeling?
For sorting data
For performing complex calculations
For dynamic scenario analysis
For text manipulation
How can VBA be used to enhance financial reporting?
To create dynamic charts
To automate data cleansing
To calculate averages
To import data from external sources
What is one of the main benefits of using VBA in financial analysis workflows?
It requires no programming knowledge
It slows down data processing
It reduces customisation options
It allows for advanced scenario analysis and modeling
What is the purpose of VBA Basics in Excel?
The purpose of VBA Basics in Excel is to automate tasks and create custom functions and macros.
The purpose of VBA Basics in Excel is to analyze data and generate reports.
The purpose of VBA Basics in Excel is to create pivot tables and charts.
The purpose of VBA Basics in Excel is to format cells and apply conditional formatting.
What are VBA Variables and how are they used in Excel?
VBA variables are used to create macros in Excel.
VBA variables are used to format cells in Excel.
VBA variables are used to import data into Excel.
VBA variables are used to store and manipulate data in Excel.
How does VBA Error Handling help in Excel?
VBA Error Handling helps in Excel by slowing down the execution of code.
VBA Error Handling helps in Excel by ignoring all errors and continuing with the code execution.
VBA Error Handling helps in Excel by automatically fixing any errors in the code.
VBA Error Handling helps in Excel by managing errors and preventing code crashes.
How do you record a macro in Excel?
To record a macro in Excel, go to the 'Data' tab, click on 'Sort' in the 'Sort & Filter' group, and select 'Record Macro'.
To record a macro in Excel, go to the 'Insert' tab, click on 'Module' in the 'Code' group, and select 'Record Macro'.
To record a macro in Excel, go to the 'File' tab, click on 'Options' in the 'Customize Ribbon' section, and select 'Record Macro'.
To record a macro in Excel, go to the 'View' tab, click on 'Macros' in the 'Macros' group, and select 'Record Macro'.
What is the purpose of On Error Resume Next in VBA?
To ignore runtime errors and continue execution
To handle runtime errors and continue execution
To automatically fix runtime errors and continue execution
To display an error message and stop execution
Which format should be used for saving files with macros?
.html
.xlsx
.xlsm
.hwdp
an action or a set of actions that you can run as many times as you want. When you create a -------, you are recording your mouse clicks and keystrokes.
VBA
match index
Macro
Vlook up
Wrong code color is
Black
Blue
Red
Green
This is where the code that is generated with a macro recorder goes.
Code Window
Module
Immediate window
Properties Window
You can NOT edit macro after it has been recorded.
TRUE
FALSE
After a macro is recorded, you can play back those actions anytime you want.
TRUE
FALSE
You can NOT undo an Excel action after you run a macro.
TRUE
FALSE
What is the purpose of using macros in MS Excel?
To make the tasks more complicated
To automate routine tasks
To slow down the procedure
To limit the functionality of Excel
This is one of the options in the Macros command button dropdown menu. This opens the Macro dialog box where you can select a macro to run or edit.
Use Relative References
Record Macro
View Macros
Delete Macro
What is the purpose of protecting a worksheet in MS Excel?
To restrict access to the workbook
To make it easier to format cells
To prevent accidental deletion of critical data
To allow anyone to modify the data
What is the purpose of a data table in MS Excel?
To create a list of macros
To summarize data in a table format
To send emails from Excel
To protect the workbook
What does the Use Relative References option do in MS Excel?
Sorts the data in ascending order
Counts the number of cells in a range
Uses relative cell addresses when recording a macro
Uses absolute cell addresses when recording a macro
1. The programming environment which permits coding, compilation, running and debugging from a single window is called
Integrated Development Environment (IDE)
Editor
Highlighter
Compiler
4. VBA supports ready made user interface components like .
UserForm, CommandButton
Label, TextBox, ComboBox, ListBox
TabStrip, OptionButton, ToggleButton
all of them
6. VBA can be used to automate carried out through MS Excel.
data processing
graphing
accessing cell values
all of them
Which of the following statements is FALSE about the Data Validation function in Microsoft Excel?
Data validation enables users to select one or more cells to validate in the worksheet.
Data validation restricts data entry to a certain range of dates, limit choices by using a list, or allowing only positive whole numbers are entered by the user.
Data validation changes the appearance of a cell range based on a criterion. If the criteria is true, the cell range is formatted based on that criteria; if the criteria is false, the cell range is not formatted based on the given criteria.
Data validation provides immediate help to instruct users and clear messages when invalid data is entered in order to make the data entry experience go smoothly.
In what format can worksheets be saved to facilitate easy publishing on the Internet?
DOCX
HTML
TXT
Which of the following can be saved in a web page format?
Only entire workbooks
Only portions of workbooks
Only items in worksheets
Entire workbooks, portions of workbooks, and items in worksheets
To save a document as a web page, which option should you select in the Save As Type menu in the Save As dialog box?
Web Page
Word Document
Excel Spreadsheet
This is one of the options in the Macros command button dropdown menu. This opens the Macro dialog box where you can select a macro to run or edit.
Use Relative References
Record Macro
View Macros
Delete Macro
What does the VLOOKUP function do in MS Excel?
Sorts the data in ascending order
Counts the number of cells in a range
Searches for a value vertically
Searches for a value horizontally
What is the purpose of protecting a worksheet in MS Excel?
To restrict access to the workbook
To make it easier to format cells
To prevent accidental deletion of critical data
To allow anyone to modify the data
What is the purpose of using the macro recorder in MS Excel?
To manually perform routine tasks
To delete data from the workbook
To create pivot tables
To automate routine tasks
A features that displays only the data in column (s) according to specified criteria
Formula
Sorting
Filtering
Pivot
The computer processing requires_____, which is a collection of raw facts, figures, and symbols, such as numbers, words, images, video and sound, given to the computer during the input phase.
Data
Information
Input
Output
On which of these groups in the Data tab will you go if you wish to import data from .txt or .csv files?
Sort & Filter
Forecast
Get & Transform Data
Queries & Connections
