WorksheetsExcel Basics for PYP 4
Total questions: 20
Worksheet time: 12mins
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.
How do you add a title to your bar graph?
You cannot add a title to a bar graph.
Titles are automatically generated based on data.
Use the title option in your graphing software to add a title.
Add a title by clicking on the graph itself.
What is the maximum number of rows in an Excel worksheet?
1048576
2000000
1000000
500000
How can you copy data from one cell to another?
Use the 'Delete' function on the source cell.
Drag the cell to the target location.
Right-click the target cell and select 'Insert'.
Select the cell, copy it, then paste it into the target cell.
What is the function of the 'Insert' menu in Excel?
To delete elements from a worksheet.
To add elements like charts, tables, and images to a worksheet.
To save the current worksheet as a PDF.
To change the color scheme of the workbook.
Which option allows you to change the chart style of a bar graph?
Chart Design
Format
Insert
Data
Which column shows the number of Dolphins?
A
B
C
D
Which cell has the data for bears in June?
B7
B6
A7
C7
Which cell represents the data for Whales in March?
C4
D4
B4
D3
Which animal has got the highest count in the given data?
Bear
Fox
Wolf
Mink
Which animal has got the lowest count in the given data?
Bear
Fox
Wolf
Mink
