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