What does the AVERAGE function do?

Returns the sum divided by the count

What is one of the key benefits of using Office 365 Excel compared to traditional Excel versions?

Regular updates with new features

No need for an internet connection

How do you access an Office 365 Excel file from another device?

Log in to OneDrive or SharePoint

When the mouse pointer changes to a black plus (+) sign at the bottom-right of a cell, what does it indicate?

Autofill handle for dragging values

The worksheet is in protected mode

What does the four-headed arrow pointer indicate in Excel?

Moving a selected cell or range

What does the double-headed arrow indicate when placed on a column or row border?

It duplicates the column or row

What happens when you hover over a hyperlink in Excel?

The mouse pointer changes to a hand icon

What is Autofill used for in Excel?

Automatically filling a series of values based on a pattern

Applying conditional formatting

How can you activate the Autofill feature?

Drag the fill handle at the bottom-right of the cell

Use the Find and Replace option

If you enter 'Monday' in a cell and drag the Autofill handle, what happens?

It fills the series with days of the week

It repeats 'Monday' in all selected cells

It fills in 'Monday, Monday, Monday...'

How can you fill a column with a continuous sequence of numbers (1,2,3,4…)?

Type the first number and use the Autofill handle

What is a worksheet in Excel?

A collection of rows and columns

How can you rename a worksheet?

Right-click the sheet tab and select 'Rename'

Double-click on the formula bar

What is a 'Record' in an Excel table?

A single row containing related data fields

The sum of all values in a column

What is the default table style in Excel?

Light formatting with alternating row colors

Dark background with white text

What is a primary key in an Excel table?

A unique identifier for each record

Excel Basics Quiz

Authored by Dim Sian Lun undefined

Computers

6th Grade

Used 5+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

32 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the default file extension of an Excel?

.xls

.xlsx

.docx

.csv

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, a worksheet is composed of...

Rows and columns

Tables and charts

Cells and formulas

Pages and paragraphs

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the intersection of a row and a column called?

Field

Cell

Box

Grid

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used to start a formula in Excel?

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the function of the SUM formula?

Counts the number of cells

Adds up values in a range

Finds the highest value

Calculates the average

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the shortcut key for saving a workbook in Excel?

Ctrl + S

Ctrl + P

Ctrl + X

Ctrl + V

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you merge multiple cells into one?

Use the Merge & Center button

Press Delete

Use the SUM function

Press Ctrl + M

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

31 questions

Word Processing Review A

Quiz

•

5th - 9th Grade

32 questions

On-tap-GK2-Tin6

Quiz

•

6th Grade

30 questions

Algebra Terminology

Quiz

•

6th - 9th Grade

30 questions

Computer Storage and Adapter Card

Quiz

•

5th - 12th Grade

27 questions

cs:go

Quiz

•

KG - Professional Dev...

28 questions

SOFTWARE MICROSOFT OFFICE POWERPOINT

Quiz

•

6th - 11th Grade

28 questions

Microsoft 365

Quiz

•

4th - 6th Grade

31 questions

Google

Quiz

•

6th - 10th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

10 questions

Introduction to Coding

Interactive video

•

3rd - 6th Grade

Excel Basics Quiz

What is the default file extension of an Excel?

In Excel, a worksheet is composed of...

What is the intersection of a row and a column called?

Which symbol is used to start a formula in Excel?

What is the function of the SUM formula?

What is the shortcut key for saving a workbook in Excel?

How do you merge multiple cells into one?

Which Excel function counts the number of numeric values in a range?

What is the default alignment for text in an Excel cell?

Which function returns the largest value in a range?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers