WorksheetsBasics of Microsoft Excel and Understanding Demand and Supply
Total questions: 20
Worksheet time: 15mins
What type of software is Microsoft Excel?
Presentation software
Document Software
Spreadsheet Software
None of the above
Grid like area where you can enter and word with data is called?
Workbook
Worksheet
Cell
Range
What is the intersection of a row and a column in Excel called?
Quick Access Toolbar
Row
Column
Cell
Row headings start with alphabets. True or False?
True
False
Name Box displays the location of the cell pointer. True or False?
True
False
Identify the cell address that contains number of units for copy?
C3
C4
B4
A4
How do you enter data into an Excel spreadsheet?
Double-click on a cell to open a new window.
Copy and paste data from a Word document.
Click on a cell, type the data, and press Enter.
Use the 'Insert' menu to add data.
How can you change the color of a line in a graph?
Change the line color in the graph settings or properties menu.
Select a different graph type to change colors.
Adjust the graph's background color.
Change the line thickness in the graph settings.
How do you create a line graph in Excel?
Highlight your data, click on 'Data' > 'Chart Options', and pick a design.
Choose your data, navigate to 'View' > 'Graph', and select a format.
Select your data, go to 'Insert' > 'Line Chart', and choose a style.
Select your data, go to 'File' > 'New Chart', and choose a type.
What happens to demand when prices increase?
Demand remains unchanged when prices increase.
Demand fluctuates randomly with price changes.
Demand decreases when prices increase.
Demand increases when prices increase.
What happens to supply when prices decrease?
Supply decreases when prices decrease.
Supply becomes more volatile when prices decrease.
Supply remains unchanged when prices decrease.
Supply increases when prices decrease.
What tool in Excel helps you create charts?
Home tab
Data tab
Insert tab
View tab
What is the purpose of naming X and Y axes in a graph?
To make the graph look more colorful.
To confuse the reader about the data.
To provide context and clarity about the data being represented.
To fill space on the graph.
How can you add a title to your line graph in Excel?
Use the 'Format' tab to change the graph's background color instead of adding a title.
Click on the chart, go to 'Chart Design' > 'Add Chart Element' > 'Chart Title' to add a title.
Double-click the graph to automatically generate a title.
Right-click on the graph and select 'Insert Title' from the menu.
What does it mean if demand is greater than supply?
It indicates a surplus of goods in the market.
It means there is a shortage, leading to potential price increases.
It means that supply is perfectly balanced with demand.
It suggests that prices will decrease significantly.
What is the value written in the cell D2?
Total Price
50
It's an empty cell
10
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
What is the icon of Microsoft Excel?
The ................................. feature of MS Excel quickly completes a series of data.
Cell
Range
Auto fill
