NEW
Font size
WorksheetsExcel - Cumulative
Total questions: 45
Worksheet time: 23mins
A single "page" in an Excel file
Worksheet
Workbook
Document
Page View
An Excel file
Workbook
Document
Section
Worksheet
More than one cell
Range
Section
Click-and-drag
Row
Text or numbers in the main body of a spreadsheet
data
header
title
information
Ability to view a row/column/range even when scrolling
Freeze
Header
Scroll
Hide
Only allowing text/numbers in a specific format
Data Validation
Freeze
Input
Numerical
Imaginary cell boundaries
Gridline
Borders
Cell margins
Format
Cell
Box
Selection
Table
Columns
Rows
Range
Table
Rows
Columns
Table
Label
Ways you can change an object or text visually
Format
Options
Size
Color
A set of styles applied to an entire Workbook
theme
format
WordArt
template
A view setting that displays two parts of the spreadsheet at the same time
Split Window
Split Table
Arrange
Print Preview
Locating terms, formulas, conditional formatting, etc.
Find (and select)
Replace
Search
Go To
A premade spreadsheet that you personalize by inputting data
template
theme
new file
open
Combine two (or more) cells into one cell
Merge
Paste
Shift
Select+All
Copies the characteristics of one cell into another cell
Format Painter
Autofill
Copy-Paste
Select
Where the text sits in a cell
Alignment
Merge
Wrap Text
Top
A generic term to refer to the changes you can make to a cell, text, or object
Format
Color
Style
Effect
Background color in a cell
Fill
Font
Background
Border
A set of formats that can be applied with one click
Style
Formatting
Effect
WordArt
To continue a sequence, such as date, numbers, or formulas
Autofill
Copy-Paste
Format Painter
Drag-and-Drop
What is the difference between these two cells?
Wrap Text
Alignment
Sentence Case
Column Width
What is the difference between these cells?
Number Format
Dates
Percentage
Currency
What is the difference between cells E1-G1 and cells H1-I1?
Tilt Orientation
Titles
Row Header
Data
The scale is placed along a(n)
axis
axis title
data label
legend
The main name for a graph
chart title
axis title
data label
gridline
Values on each bar, line point, or pie segment
data labels
gridlines
axis
scale
A summary of the data presented in rows and columns, separate from main chart
data table
data label
legend
chart title
The fine lines that allow a reader to judge where a bar or data point falls on the scale
guidelines
scale
line chart
legend
Shows the viewer what bar, line, or pie colors mean
legend
scale
data table
key
Which is NOT a chart type you can expect to see on Excel Certification?
Pivot Chart
line chart
bar chart
pie chart
Numbers presented at intervals along the axis
scale
axis title
data table
gridlines
Excel's term for "graph"
chart
bar graph
line graph
table
What is the answer to:
=B4-B5
150
600
1050
100
What is another way to write =Average(B4:G4)
=(B4+C4+D4+E4+F4+G4)/6
=B4+C4+D4+E4+F4+G4/6
=B4*G6
=Sum(B4:G4)
What is another way to write =B4+B5
=Sum(B4:B5)
=Average(B4:B5)
=SumIF(B4:B5)
=B4*B5
What is the answer to this function?
=COUNTIF(B4:G5,">500")
6
2
7
12
Which symbol means divide?
/
*
!
^
What does the exclamation point (!) signify in this function?
='Soda Machines'!B4*Sales!D11
Worksheet reference
Relative reference
Absolute reference
Cell reference
What changes when this formula is copied to another cell?
=B$4*3
Row only
Column only
Both row and column
Neither row or column
What symbol is missing in this function?
=COUNTaB4:m16
()
*
"
$
What does the green arrow point to?
Data label
Legend
Scale
Axis
What does the green arrow point to?
Legend
Chart Title
Axis Label
Data Table
Which function will insert a word (you choose) if the value in another cell meets a criteria?
IF
CRITERIA
COUNTBLANK
TEXT
