Excel Functions Quiz

Excel Functions Quiz

10th Grade

10 Qs

quiz-placeholder

Similar activities

Keyboard Shortcuts

Keyboard Shortcuts

9th - 12th Grade

9 Qs

INFORMATION TECHNOLOGY

INFORMATION TECHNOLOGY

6th - 10th Grade

10 Qs

Structura PC

Structura PC

5th - 12th Grade

15 Qs

LỚP 7.1_KTTX1_MÔN TIN HỌC 7

LỚP 7.1_KTTX1_MÔN TIN HỌC 7

7th - 12th Grade

15 Qs

Chromebook S3 Quiz

Chromebook S3 Quiz

6th - 10th Grade

9 Qs

Kuis Informatika - Data

Kuis Informatika - Data

10th Grade

10 Qs

Comandos y Extensiones de Archivos.

Comandos y Extensiones de Archivos.

9th - 12th Grade

10 Qs

Bilişim Teknolojileri

Bilişim Teknolojileri

5th - 12th Grade

10 Qs

Excel Functions Quiz

Excel Functions Quiz

Assessment

Quiz

Computers

10th Grade

Hard

Created by

Sasmita Mohapatra

Used 3+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Which option allows you to sort data in Excel?

a) Right-click and select "Sort"

b) Use the "Sort" option under the "Insert" tab

c) Press Ctrl + S

d) Shift +S

2.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

Press _______ to quickly open the "Format Cells" dialog box in Excel.

a) CTRL+1

b) CTRL+4

c) CTRL+F2

d) Shift+ 1

3.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

What is the shortcut key for opening the "Save As" dialog box in Excel?

a) Ctrl + S

b) Shift + S

c) Ctrl + O

d) Ctrl + Shift + F

4.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

To apply a filter to your data in Excel, you can click on the _______ button in the "Data" tab.

a) Paragraph

b) Format

c) Font

d) Filter

5.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

What is the key difference between Filter and Advanced Filter?

a) Advanced Filter allows complex criteria

b) Filter only works with text data

c) Filter is slower than Advanced Filter

d) There is no difference between Filter and Advanced Filter

6.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

To convert a range of cells into a table in Excel, go to the "______" tab and click on "Table."

a) Layout

b) View

c) Insert

d) Design

7.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

What are the benefits of using tables in Excel?

a) Automatic formatting and resizing

b) Easy data filtering and sorting

c) Structured references for formulas

d) All of the above

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?