Mastering Excel Basics

What is the primary function of Excel?

• Data organization and analysis

• Designing graphics

• Writing code

• Creating presentations

How do you create a new worksheet in Excel?

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

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

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

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

What formula would you use to add numbers in Excel?

• =SUM()

• =ADD()

• =SUMIF()

• =TOTAL()

What is a cell in Excel?

• A cell in Excel is a graphic element.

• A cell in Excel is a type of formula.

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

• A cell in Excel is a programming function.

How can you format text in a cell?

• Insert images to replace text in the cell.

• Change the background color of the cell only.

• Use formatting options in the toolbar or menu to change text style, size, and color.

• Use a formula to format text automatically.

What does the SUM function do?

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

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

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

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

How do you create a chart in Excel?

• Click on 'File' and select 'New'

• Go to 'View' tab and select 'Zoom'

• Right-click on the chart area and choose 'Delete'

• Select data, go to 'Insert' tab, choose chart type, and customize.

What is the purpose of the 'AutoFill' feature?

• To suggest data based on internet searches.

• To automatically fill in data based on prior entries.

• To manually enter data for each field.

• To delete previous entries automatically.

How can you sort data in Excel?

• Use the 'Home' tab to change font size.

• Right-click the data and select 'Delete'.

• Select the data range, go to the 'Data' tab, and use the 'Sort' option.

• Copy the data to a new sheet.

What is a formula bar in Excel?

• A tool for creating charts in Excel.

• A section for saving files in Excel.

• A feature that displays the history of cell changes.

• The formula bar in Excel is a feature that shows the contents of the selected cell and allows for editing.