
MOAC Excel 2016 Lesson 09
Authored by Sarah Benes
Computers
9th - 12th Grade
Used 27+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following procedures is not a way to sort a table by the contents of one column?
Click the Sort button in the Sort & Filter group of the Data tab.
Click an AutoFilter button in the total row.
Click an AutoFilter button in the field names row.
Click the Filter button in the Sort & Filter group of the Data tab.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following are valid reasons for converting a table to a range?
To clear the sorting criteria and start over.
To prepare for deleting a column.
To prepare for importing new data form a non-Excel file.
to prepare to change its conditional formatting.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups?
There is no difference between an Auto Outlined worksheet and a worksheet and a worksheet with multiple groups.
Only an Auto Outlined worksheet may contain total rows.
An Auto Outlined worksheet contains only one button for collapsing and expanding.
Only a multi-grouped worksheet can cluster rows and columns.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items?
Table[Auction Items(Total Sale)]
Auction Item (Total Sale)
Auction Item [#Totals]
#Totals[Total Sale]
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following procedures is not a way to filter a table by the contents of one column?
Click the criterion button on the slicer.
Right-click the cell whose contents you want for the criterion and click Filter in the menu.
Click the Filter button in the Sort & Filter group of the Data tab.
Click the AutoFilter button in the total row at the bottom
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following attributes is not a potential criterion for an AutoFilter sort?
Font color
Font style
Cell color
Cell icon
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table?
There is no difference between an AutoFiltered range of records in a list and a table.
A table maintains its sort order after you close and then open it again.
A table given a title enables its field names to be used in formulas in place of cell references.
A table enables special subtotal functions for total rows.
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
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Cyber Security
Quiz
•
1st - 10th Grade
15 questions
After Effect Intoduction
Quiz
•
10th Grade - University
10 questions
Inspire - AI Trivia
Quiz
•
11th Grade
15 questions
tik kelas 7
Quiz
•
1st Grade - University
10 questions
Empowerment Technologies Quiz 2
Quiz
•
11th Grade
15 questions
PRUEBA CORTA I - SISTEMA E INSTALACIÓN DE SOFTWARE I - U4
Quiz
•
9th - 12th Grade
10 questions
Unit 4 Advanced AP CSP
Quiz
•
9th - 12th Grade
10 questions
BÀI 8. SẮP XẾP VÀ LỌC DỮ LIỆU
Quiz
•
1st - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
14 questions
[AP CSP] JavaScript Programming Quiz
Quiz
•
9th - 12th Grade
10 questions
Understanding Computers and Computer Engineering
Interactive video
•
7th - 12th Grade
37 questions
Python - Tuples, Lists, and List Methods
Quiz
•
9th - 12th Grade
60 questions
MOS Word Home, Insert, Reference Ribbon Basics
Quiz
•
9th Grade