Excel Graphing Techniques and Concepts

This tutorial from Just Biotic Geeks demonstrates how to create a cell viability dose response curve using Microsoft Excel. It covers data selection, graph creation, and customization, including setting graph titles, adjusting axes, and adding error bars. The tutorial is recorded on a Mac version of Excel, but similar options are available on Windows. Viewers are encouraged to watch previous tutorials for prerequisite knowledge and to subscribe for more content.

What is the main focus of this tutorial?

• Creating a pie chart in Excel

• Calculating standard deviation

• Using Excel on Windows

• Creating a cell viability dose response curve

What platform is mentioned for additional resources?

• WhatsApp

• Telegram

• Facebook

• Instagram

Which menu option is used to insert a 2D bar graph in Excel?

• View

• Data

• Insert

• File

What should the maximum value on the y-axis be changed to?

• 120

• 150

• 100

• 80

How should the x-axis be labeled?

• Percentage cell viability

• Concentration micromolar

• Standard deviation

• Dose response

What is the purpose of adding error bars to the graph?

• To enhance the visual appeal

• To adjust the axis titles

• To indicate data variability

• To change the graph type

Which option should be selected to customize error bars?

• Automatic

• Custom

• Fixed

• Standard

What values are used for the positive and negative error bars?

• Minimum values

• Mean values

• Standard deviation values

• Maximum values

What is the final step after adding error bars to the graph?

• Change the graph type

• Save the file

• Delete the graph

• Press OK

What action is encouraged at the end of the video?

• Attend a live session

• Download the Excel file

• Subscribe to the channel

• Share the graph