Exploring MS Excel Basics

What is MS Excel used for?

• MS Excel is used for data organization, analysis, and visualization.

• Writing code

• Creating presentations

• Editing images

How do you create a new worksheet in Excel?

• Click the '+' icon next to the worksheet tabs or use 'Insert' from the 'Home' tab.

• Right-click on the worksheet and select 'New Sheet'

• Use the 'File' menu and select 'New' to create a worksheet

• Press 'Ctrl + N' to create a new worksheet

What is a cell in Excel?

• A cell in Excel is a chart element.

• A cell in Excel is a basic unit of a spreadsheet where data is entered.

• A cell in Excel is a type of formula.

• A cell in Excel is a type of software update.

How do you enter data into a cell?

• Right-click the cell and select 'Insert Data'.

• Click on the cell, type the data, and press Enter.

• Drag and drop the data into the cell.

• Double-click the cell and paste the data.

What is a formula in Excel?

• A formula in Excel is an expression that calculates values.

• A formula in Excel is a tool for creating slides.

• A formula in Excel is a way to format text.

• A formula in Excel is a type of chart.

How do you save an Excel file?

• Click 'Edit', then 'Save Changes'.

• Press 'Ctrl + P' to print the file.

• Select 'File', then 'Export' to save.

• Click 'File', then 'Save' or 'Save As', choose location and name, and click 'Save'.

What does the SUM function do?

• The SUM function finds the average of a set of numbers.

• The SUM function counts the number of entries in a dataset.

• The SUM function sorts a list of numbers in ascending order.

• The SUM function calculates the total of a set of numbers.

How can you change the font size in a cell?

• Use the 'Insert' menu to modify font size.

• Select the cell, then adjust the font size from the toolbar.

• Right-click the cell and select 'Resize'.

• Change the cell color to adjust the font size.

What is a chart in Excel?

• A chart in Excel is a type of formula.

• A chart in Excel is a text document.

• A chart in Excel is a database table.

• A chart in Excel is a graphical representation of data.

How do you format a cell to show currency?

• Select the cell, right-click, choose 'Format Cells', select 'Currency', and click 'OK'.

• Highlight the cell, go to 'Home', and click 'Currency Style' in the toolbar.

• Select the cell, click 'Edit', choose 'Currency Format', and press 'Apply'.

• Right-click the cell, select 'Cell Options', and choose 'Monetary'.