Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Fun for Year 7 Students

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

What is the main purpose of Microsoft Excel?

a)

The main purpose of Microsoft Excel is to organize and analyze data.

b)

The main purpose of Microsoft Excel is to manage email communications.

c)

The main purpose of Microsoft Excel is to edit images.

d)

The main purpose of Microsoft Excel is to create presentations.

2.

How do you start a new Excel workbook?

a)

Open Excel, go to File > New, and select 'Blank Workbook'.

b)

Launch Excel, click on File > Open, and choose 'Recent Workbook'.

c)

Start Excel, select File > Save As, and pick 'New Document'.

d)

Open Excel, navigate to Home > New, and click on 'Template'.

3.

What is a cell in Excel?

a)

A cell in Excel is a type of formula used for calculations.

b)

A cell in Excel is a single data point in a spreadsheet.

c)

A cell in Excel is a collection of multiple spreadsheets.

d)

A cell in Excel is a graphical representation of data.

4.

What does the formula bar do?

a)

The formula bar displays and allows editing of cell contents and formulas.

b)

The formula bar is used to format the entire spreadsheet.

c)

The formula bar only shows the cell's background color.

d)

The formula bar provides a summary of all formulas in the sheet.

5.

How can you enter data into a cell?

a)

Right-click the cell and select 'Insert'.

b)

Double-click the cell and paste the data.

c)

Drag and drop the data into the cell.

d)

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

6.

What is a spreadsheet?

a)

A spreadsheet is a physical book for writing notes and calculations.

b)

A spreadsheet is a digital tool for organizing and analyzing data in tabular form.

c)

A spreadsheet is a tool for editing images and graphics.

d)

A spreadsheet is a type of software for creating presentations.

7.

How do you save an Excel file?

a)

Select 'Home', then 'Export', choose format and click 'Download'.

b)

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

c)

Click 'Edit', then 'Save As', select a template and confirm.

d)

Go to 'View', then 'Close', and the file will be saved automatically.

8.

What is a row in Excel?

a)

A row in Excel is a vertical line of cells identified by a letter.

b)

A row in Excel is a horizontal line of cells identified by a number.

c)

A row in Excel is a collection of formulas arranged in a column.

d)

A row in Excel is a single cell that contains data.

9.

What is a column in Excel?

a)

A column in Excel is a horizontal series of cells identified by numbers.

b)

A column in Excel is a vertical series of cells identified by letters.

c)

A column in Excel is a grid of cells arranged in a square format.

d)

A column in Excel is a collection of cells that can only contain text.

10.

How do you format text in a cell?

a)

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

b)

Adjust the cell borders and shading options.

c)

Change the cell background color only.

d)

Insert images or shapes into the cell.

11.

What is a chart in Excel?

a)

A chart in Excel is a list of formulas used in calculations.

b)

A chart in Excel is a graphical representation of data.

c)

A chart in Excel is a text-based report.

d)

A chart in Excel is a table of numerical values.

12.

How can you add numbers in Excel?

a)

Use the AVERAGE function to add numbers in Excel.

b)

Click on the cell and type the numbers directly.

c)

Select the cells and press the Add button in the toolbar.

d)

Use the SUM function to add numbers in Excel.

13.

What is a function in Excel?

a)

A function in Excel is a type of data entry method.

b)

A function in Excel is a predefined formula that performs calculations or operations on data.

c)

A function in Excel is a visual representation of data trends.

d)

A function in Excel is a tool for creating charts and graphs.

14.

How do you create a simple table?

a)

Draw a table on paper and scan it.

b)

Create a table using JavaScript functions.

c)

Use CSS styles to design a table layout.

d)

Use HTML

tags or Markdown syntax to create a table.

15.

What does the 'Undo' button do?

a)

Saves the current document.

b)

Cancels the current operation.

c)

Redoes the last action performed.

d)

Reverses the last action taken.

16.

How can you change the color of a cell?

a)

Select the cell, then use the fill color option in the formatting toolbar.

b)

Right-click the cell and choose the border style.

c)

Use the cell's context menu to change the font size.

d)

Double-click the cell to edit its text color.

17.

What is a worksheet?

a)

A worksheet is a type of spreadsheet for data analysis.

b)

A worksheet is a document with exercises or tasks for completion.

c)

A worksheet is a software application for coding.

d)

A worksheet is a presentation tool for visual aids.

18.

How do you print an Excel document?

a)

Open the document, navigate to Home > Print, and press Print.

b)

Open the Excel file, go to File > Print, and click Print.

c)

Select the Excel file, click on Share > Print, and choose Print.

d)

Load the Excel sheet, go to Edit > Print, and hit Print.

19.

What is the purpose of the 'Sort' feature?

a)

To display data in a graphical format.

b)

To organize data in a specified order.

c)

To delete unwanted data entries.

d)

To filter data based on specific criteria.

20.

How can you insert a new row in Excel?

a)

Click on the cell and press 'Enter'.

b)

Select the entire column and delete it.

c)

Right-click on the row number and select 'Insert'.

d)

Use the 'File' menu to save the document.