Y6 Excel Basics Quiz

Y6 Excel Basics Quiz

5th Grade

12 Qs

quiz-placeholder

Similar activities

Working with tables

Working with tables

5th - 12th Grade

10 Qs

WORD PROCESSOR- CLASS 4

WORD PROCESSOR- CLASS 4

4th - 5th Grade

8 Qs

Insert Tab in Microsoft Word

Insert Tab in Microsoft Word

5th Grade

10 Qs

H.W. L-3 and L-4 M.S. Word

H.W. L-3 and L-4 M.S. Word

5th Grade

10 Qs

Using Tables in Word

Using Tables in Word

5th - 8th Grade

15 Qs

ICT - GRADE 5 - 25TH AUGUST 2021

ICT - GRADE 5 - 25TH AUGUST 2021

5th Grade

10 Qs

8. หน่วยการเรียนรู้ที่ 4 การประยุกต์ใช้โปรแกรมประมวลผลคำ (หลังเรียน)

8. หน่วยการเรียนรู้ที่ 4 การประยุกต์ใช้โปรแกรมประมวลผลคำ (หลังเรียน)

5th Grade

10 Qs

Taste speciale

Taste speciale

5th - 8th Grade

12 Qs

Y6 Excel Basics Quiz

Y6 Excel Basics Quiz

Assessment

Quiz

Computers

5th Grade

Medium

Created by

Odelia Khei

Used 1+ times

FREE Resource

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using Auto Fill in Excel?

To quickly copy formulas or patterns across cells.

To calculate data automatically.

To delete unnecessary rows.

To format the cells automatically.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you insert a new row in Excel?

Go to the 'Insert' tab and select 'New Sheet'.

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

Click on the cell and press Enter.

Use Auto Fill to add a new row.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you apply a border to cells in Excel?

Click the cell, go to the 'Insert' tab, and select 'Border'.

Right-click the cell and select 'Format Cells'.

Select the cells, go to the 'Home' tab, click on 'Borders', and choose a border style.

Go to the 'View' tab and select 'Borders'.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you format headers with bold text and a fill color?

Select the header, apply bold from the 'Home' tab, and choose a fill color.

Right-click on the header, select 'Format Cells', and change the alignment.

Use the 'Insert' tab to apply bold formatting.

Use Auto Fill to format the header row.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you calculate Profit in Excel when given Sales and Expenses?

Use the formula Sales - Expenses.

Use the formula =Sales - Expenses.

Use the formula =Expenses * Sales.

Use the formula Sales * Expenses.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Why would you rename Sheet1 in Excel?

To make it easier to identify and organize your data.

To delete the data in Sheet1.

To merge multiple sheets.

To insert a new chart.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens when you use the Auto Fill handle to drag down a formula?

It copies the exact value to all cells.

It copies the formula and adjusts references based on the new row or column.

It only copies the text, not the formula.

It deletes the formula from the first cell.

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?