Mlcak Microsoft EXCEL Ch 2 & Ch 3

Quiz
•
Computers
•
9th Grade
•
Medium
Alisha Mlcak
Used 22+ times
FREE Resource
35 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
___________________ allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value.
Conditional formatting
Number formats
arguments
Flash Fill
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Similar to charts, conditional formatting provides another way to _______________ and make worksheets easier to understand.
visualize data
Number formats
calculate data
Flash Fill
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
___________________ tell your spreadsheet exactly what type of data you're using, like percentages (%), currency ($), accounting, times, dates, and so on.
visualize data
Number formats
calculate data
Flash Fill
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value, you'll need to create a ____________________________.
What if Analysis
function
conditional formatting rule
Find / Replace
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The default number format for cells in a spreadsheet is _________________.
General
Percent
Mathematical
Currency
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A ___________________ is a predefined formula that performs calculations using specific values in a particular order.
What if Analysis
function
conditional formatting rule
Find / Replace
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
______________ includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Access
Create a free account and access millions of resources
Similar Resources on Wayground
31 questions
Microsoft Excel Review

Quiz
•
9th - 12th Grade
30 questions
SSNS Computer Center Online Assessment

Quiz
•
9th - 12th Grade
30 questions
Excel 2016 Certification Review Quiz

Quiz
•
9th Grade - University
40 questions
Quiz Excel

Quiz
•
3rd - 12th Grade
30 questions
Electronic Spreadsheet

Quiz
•
9th - 12th Grade
40 questions
Spreadsheet Quiz

Quiz
•
9th Grade - University
30 questions
ทดสอบความรู้ Excel สำหรับนักเรียน

Quiz
•
9th Grade
31 questions
Excel Module 3 Review

Quiz
•
9th Grade
Popular Resources on Wayground
50 questions
Trivia 7/25

Quiz
•
12th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Negative Exponents

Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions

Quiz
•
6th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"

Quiz
•
9th Grade