Excel Chapter 2

Quiz
•
Computers
•
Professional Development
•
Medium

Alejandro Hidalgo
Used 2+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the keyboard shortcut for Flash Fill?
Alt + E
Ctrl + E
Ctrl + F
Ctrl + F2
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The MEDIAN function finds ________.
the average value in a range of cells
all numbers that correspond to an argument in the function
the one number that corresponds to an argument in the function
the middle value in a range of sorted values
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To rotate text in a worksheet, in the Format Cells dialog box, you can click and drag the ________.
red diamond
red circle
blue diamond
black, bold triangle
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The COUNTIF function has two arguments: ________.
the range of cells to check and the criteria
a value as the criteria and an average of a range of cells
the range of cells to check and the sum of the range
the range of cells to sum and the criteria
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is not a proper comparison operator?
=>
>=
<>
<
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When using the Freeze Panes feature, what is a pane bounded by?
The ribbon
A solid red line
Vertical or horizontal bars
The status bar
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you know if some rows of a table have been hidden from view when a filter is applied?
Row numbers display in red
Row numbers display in blue
Row numbers appear in bold
The number of hidden rows displays next to the funnel icon.
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Microsoft Excel Home Tab

Quiz
•
Professional Development
10 questions
Data Analytics Quiz-TMK DPA2022

Quiz
•
Professional Development
13 questions
Excel: basic understanding

Quiz
•
3rd Grade - Professio...
10 questions
SPREADSHEET . PART 1.

Quiz
•
Professional Development
15 questions
Excel Quiz

Quiz
•
Professional Development
15 questions
JSKBS - Computer Applications for Business

Quiz
•
Professional Development
14 questions
Microsoft Excel Basics - Video 2

Quiz
•
6th Grade - Professio...
10 questions
Vlookup Formula in Excel

Quiz
•
Professional Development
Popular Resources on Wayground
18 questions
Writing Launch Day 1

Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade