Worksheets3rd Nine Weeks Exam Review
Total questions: 30
Worksheet time: 10mins
In order for a cell to be a Absolute Cell Reference, what must appear before it?
= sign
+ sign
$ sign
# sign
In an Ascending Sort letters are arranged from (A to Z).
True
False
Filtering rearranges worksheet data in ascending or descending alphabetical, numerical, or chronological order.
True
False
This is an example of what type of cell reference?
$C$50
Mixed
Relative
Absolute
In a Descending Sort, letters are arranged from largest to smallest.
True
False
A graphical representation of data.
Table
Chart
Worksheet
A test or numbers that provides additional information about a data marker.
Data Label
Chart Element
Chart Layout
A chart layout identifies patterns, symbols, or colors used in a chart.
True
False
A chart that uses bars of varying heights to illustrate values in a worksheet.
Line Chart
Column Chart
Pie Chart
Displays a subset of data that meet certain criteria.
Conditional Formatting
Sorting
AutoFiltering
When performing a calculation with a function, the range does not have to be enclosed in parenthesis.
True
False
A shorthand way to write an equation that performs a calculation.
Fractions
Formulas
Decimals
Functions
This is an example of what type of cell reference?
=C$6*E$6
Relative
Mixed
Absolute
Formulas with function have 3 parts: a plus sign, a function name, and at least one argument.
True
False
What is the function name to add a range?
SOM
SUM
ADD
MIN
What is the function name to find the largest number in a range?
SUM
AVERAGE
MIN
Max
What type of border do you get when you copy or cut data?
Solid border
Green border
Flashing border
You forget to type a row of data in the middle of the worksheet.
Insert sheet column
Insert sheet row
Delete sheet row
You no longer need a certain column in the worksheet.
Delete sheet row
Delete sheet column
Insert sheet column
A page or worksheet rotated so it is taller than it is wide.
Portrait Orientation
Landscape Orientation
Horizontal Orientation
The Merge & Center button combines several cells into one cell and place the data in the center of the merged cell.
True
False
To rotate the position of that text/data to a selected angle in a cell.
Wrap Text
Orientation
Merge and Center
When you copy the format of a cell or range of cells you copy both the format and the content of the cell(s).
True
False
In Excel, the default number format is:
Number
Currency
General
To move data to a new line within the cell is when the cell is not wide enough to show all data.
Wrap Text
Fill Handle
Merge and Center
Equations used to calculate values in a cell.
Operands
Formulas
Functions
The operator for multiplication.
+
/
*
-
An operand is a constant or cell reference used in formula.
True
False
An absolute reference does not change if the formula is copied or moved.
True
False
If two or more operators have the same order of evaluation, the equation is evaluated from right to left.
True
False
