BUS 215 Final Exam Review BEST
STUDY GUIDE RATED A+
should utilize: - correct answer✅
To widen a column to fit the cell content of the widest cell in the column, the user
AutoFit
A text value is also known as a - correct answer ✅Label
If a column of data holds the letter grades for a class, the ________ function could
✅
be used to determine how many students had a grade of "A". - correct answer
COUNTIF
IF is an example of a ________ function - correct answer ✅ Logical
received to the total number of votes cast? - correct answer ✅
Which type of charter would be best to chart the number of votes each candidate
Pie Chart
✅
The individual pages of an Excel document are called - correct answer
Worksheets
- correct answer ✅
The action of placing cell contents that have been copied to the Office Clipboard is
Pasting
✅
On an Excel chart, the ________ identifies the patterns or colors that are assigned
to all the categories in the chart. - correct answer Legend
them into place. - correct answer ✅
Using ________ allows the user to select one or more rows or columns and lock
Freeze Panes
, BUS 215 Final Exam Review BEST
STUDY GUIDE RATED A+
✅
Values are compared by using ___________ operators - correct answer
Comparison
on a series of tests? - correct answer ✅
Which Excel function would be used to calculate the total points a student earned
SUM
instead of a table of numbers. - correct answer ✅
For data to be more easily understood, it can be presented in a ___________
Chart
displayed on the - correct answer ✅
The current cell mode, the page number, and the view and zoom buttons are
Status Bar
correct answer ✅
The small black square in the lower right corner of a selected cell is called the -
Fill handle
Excel displays a series of _______ symbols - correct answer ✅
If a cell's width is too narrow to properly display the numeric contents of the cell,
#
answer ✅
Excel uses __________ to perform basic mathematical operations - correct
Arithmetic operators
worksheet is called - correct answer ✅
The process of specifying the appearance of cells and the overall layout of a
Formatting
STUDY GUIDE RATED A+
should utilize: - correct answer✅
To widen a column to fit the cell content of the widest cell in the column, the user
AutoFit
A text value is also known as a - correct answer ✅Label
If a column of data holds the letter grades for a class, the ________ function could
✅
be used to determine how many students had a grade of "A". - correct answer
COUNTIF
IF is an example of a ________ function - correct answer ✅ Logical
received to the total number of votes cast? - correct answer ✅
Which type of charter would be best to chart the number of votes each candidate
Pie Chart
✅
The individual pages of an Excel document are called - correct answer
Worksheets
- correct answer ✅
The action of placing cell contents that have been copied to the Office Clipboard is
Pasting
✅
On an Excel chart, the ________ identifies the patterns or colors that are assigned
to all the categories in the chart. - correct answer Legend
them into place. - correct answer ✅
Using ________ allows the user to select one or more rows or columns and lock
Freeze Panes
, BUS 215 Final Exam Review BEST
STUDY GUIDE RATED A+
✅
Values are compared by using ___________ operators - correct answer
Comparison
on a series of tests? - correct answer ✅
Which Excel function would be used to calculate the total points a student earned
SUM
instead of a table of numbers. - correct answer ✅
For data to be more easily understood, it can be presented in a ___________
Chart
displayed on the - correct answer ✅
The current cell mode, the page number, and the view and zoom buttons are
Status Bar
correct answer ✅
The small black square in the lower right corner of a selected cell is called the -
Fill handle
Excel displays a series of _______ symbols - correct answer ✅
If a cell's width is too narrow to properly display the numeric contents of the cell,
#
answer ✅
Excel uses __________ to perform basic mathematical operations - correct
Arithmetic operators
worksheet is called - correct answer ✅
The process of specifying the appearance of cells and the overall layout of a
Formatting
