
Y6 Excel Basics Quiz

Quiz
•
Computers
•
5th Grade
•
Medium
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
Similar Resources on Wayground
13 questions
Mail Merge

Quiz
•
5th Grade
12 questions
Tables and Mail Merge 5

Quiz
•
4th - 6th Grade
10 questions
Open office writer - I

Quiz
•
5th Grade
12 questions
Excel Basics

Quiz
•
5th - 10th Grade
14 questions
5th class December test 2020

Quiz
•
5th Grade
10 questions
Teknologi Informasi - Kelas 5 - Penilaian Harian 3

Quiz
•
1st - 5th Grade
15 questions
Working with Tables (WORD)

Quiz
•
5th Grade
12 questions
Review of L#6

Quiz
•
5th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade