Excel Functions Quiz

Quiz
•
Computers
•
10th Grade
•
Hard
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
Similar Resources on Wayground
10 questions
PowerPoint

Quiz
•
1st - 12th Grade
10 questions
MOAC Excel 2016 Lesson 03

Quiz
•
8th - 12th Grade
15 questions
Power Point

Quiz
•
10th Grade
10 questions
大君老師到底有沒有教好之快捷鍵

Quiz
•
10th - 12th Grade
8 questions
soal Ms. Word

Quiz
•
9th - 12th Grade
15 questions
Blender 9 клас

Quiz
•
9th - 12th Grade
13 questions
Inkscape Glossaries

Quiz
•
7th - 10th Grade
12 questions
Excel Basics

Quiz
•
5th - 10th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade