Excel Basics for PYP 4

What is the first step to create a bar graph in Excel?

• Select the data for the graph.

• Adjust the axis titles before selecting data.

• Choose a chart type from the menu.

• Enter data labels for the graph.

How do you enter data into a cell in Excel?

• Drag and drop the data from another cell into the selected cell.

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

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

• Double-click the cell and write the data without pressing Enter.

Which tab do you use to insert a bar graph?

• View

• Data

• Insert

• Format

What type of data can you enter in Excel?

• Images and videos

• Web links

• Audio files

• Text, numbers, dates, formulas, boolean values

How do you select multiple cells in Excel?

• Right-click and select 'Format Cells'

• Click and drag or hold 'Ctrl' and click individual cells.

• Use the 'Select All' button in the toolbar

• Press 'Alt' and click on each cell

What is the shortcut to save your Excel file?

• Alt + S

• Ctrl + P

• Ctrl + S

• Shift + S

How can you change the color of a bar in a graph?

• Remove the bar from the graph.

• Change the font size of the graph.

• Modify the color property in the graphing library or tool.

• Add a legend to the graph.

What is the purpose of the formula bar in Excel?

• To create charts and graphs directly.

• The purpose of the formula bar in Excel is to enter and edit formulas and data for the selected cell.

• To save the Excel file automatically.

• To display the current cell's formatting options.

How do you delete data from a cell?

• Select the cell and press the 'Delete' key.

• Drag the cell content to the trash bin.

• Right-click the cell and select 'Remove' from the menu.

• Highlight the cell and press 'Ctrl + Z'.

What happens when you click on a cell in Excel?

• The cell is deleted from the spreadsheet.

• The clicked cell becomes active for data entry or editing.

• The cell displays a pop-up message.

• The cell opens a new Excel window.