Random 1
Random 2
Random 3
Random 4
Random 5
100
The way text is positioned between margins.
What is Alignment
100
this feature highlights cells based on conditions
What is conditional formatting
100
Technique by which you change certain conditions in a worksheet to see how the changes affect the results of your spreadsheet output.
What is What-If Analysis
100
This tab contains the comments button
What is Review Tab
100
This button allows you to subtotal a section
What is Subtotal Button
200
To save your spreadsheet where must you go?
What is the File tab or Backstage view
200
For Excel to recognize you are entering a formula you must first type this into the cell
What is = (equals sign)
200
What tab will allow you to enter formulas?
What is Formulas Tab
200
The easiest way to add a range of cells is to click on
What is autosum
200
What tab contains the ClipArt Button
What is Insert Tab
300
A graphic representation of values and their relationships: pie, line, column, bar, scattered
What is Chart/graph
300
A chart that uses points connected by a line to illustrate values in a worksheet
What is Line Chart
300
To change the color of the worksheet tab you would
What is right click the sheet tab
300
To apply conditional formatting you must be in this tab
What is the Home Tab
300
Returns the smallest value in a set of values
What is Min
400
Returns the largest value in a set of values
What is Max
400
Adds all the numbers in a range of cells
What is Sum
400
A chart that shows the relationship of a part to a whole
What is Pie chart
400
An equation that calculates a new value using values currently on a worksheet
What is Formula
400
Returns the number of cells in a range that contains number
What is Count
500
Returns the average (arithmetic means) of its arguments
What is Average
500
Value, cell reference, range, or text that acts as an operand in a function formula
What is Argument
500
A chart that uses bars of varying height to illustrate values in a worksheet
What is Column chart
500
A prewritten formula that makes it easy to perform common calculations
What is Function
500
Arranging the shape, size, type, and general makeup of a cell or group of cells
What is Format
Continue
ESC
Reveal Correct Response
Spacebar
M
e
n
u
Team 1
0
+
-
CBA Unit 3 Spreadsheet - Round 2
No teams
1 team
2 teams
3 teams
4 teams
5 teams
6 teams
7 teams
8 teams
9 teams
10 teams
Custom
Press
F11
Select menu option
View > Enter Fullscreen
for full-screen mode
Edit
•
Print
•
Download
•
Embed
•
Share
JeopardyLabs