Excel Chapter 2: Testbank Quiz
To hide a row or column in Excel, click the row or column heading, point to the selected row or column heading(s), right-click, and then select ________ on the displayed shortcut menu. a. Filter b. Hide c. Plain Formatting d. Adjust
b. Hide
A(n) ________ cell reference is the default reference in a formula to a cell address will automatically adjust when the formula is copied or extended to other cells. a. absolute b. relative c. mixed d. All cell references do this
b. relative
A function included in Excel that can be categorized as financial, statistical, mathematical, date and time, text, or so on
built in function
refers to a particular cell or range instead of a value
cell reference
A built-in _________________ is a predefined and named combination of cell-formatting and content-formatting that can be applied to a cell or range of cells. (1 point)
cell style
If you want to see how many cells in a specified range contain numbers, you would use the ________ function. (1 point) a.COUNT b.SUM c.SUBTOTAL d.AVERAGE
count
Returns the number of cells in a range of cells that contain numeric dat
count
To hide gridlines, uncheck the ______________ box in the Show group on the view tab. (1 point) a. Formula Bar b. Ruler c. Headings d. Gridlines
d. Gridlines
_________________ color is the background color of a cell.
fill
A(n) _________________ performs a mathematical calculation using information in the active worksheet and other worksheets to calculate new values. (1 point)
formula
Can contain cell references, constants, functions, and mathematical operators
formula
A(n) _________________ format is used to present information in charts, graphs, and pictures.
graphical
The vertical and horizontal lines on a worksheet that help define a cell's boundaries are called
gridlines
The base date for date and time data in Excel 2016 is ________. (1 point) a.January 1, 1000 b.January 1, 1900 c.December 31, 1899 d. December 31, 999
janurary 1, 1900
+, *, and ^ are examples of Excel _________________ (1 point)
mathematical operators
Examines all numeric values in a specified range and returns the highest value
max
If you want to see which employee had the highest sale, you could use the ________ function. (1 point) a.SUM b.COUNT c.MIN d.MAX
max
Examines all numeric values in a specified range and returns the lowest value
min
When applying a fill color, it is best practice to use ______________ colors. (1 point) a. bright b. muted or pastel c. monochromatic d. grayscale
muted or pastel
If multiple mathematical operands are included in a function or formula, Excel processes the calculations based on the _________________
order of operations
To have a better sense of how the worksheet is structured, you can ________. (1 point) a.unhide gridlines b.hide rows c.hide columns d.show the formulas
show the formulas
A ________ cell is the cell that contains the data supplied to a function. (1 point) a.active b.adjacent c.source d.destination
source
The cell that contains data supplied to a function is the _________________ cell.
source
The format that organizes information in labeled columns and numbered rows is ________ format. (1 point) a.graphical b.container c.tabular d.matrix
tabular
The presentation of text and numbers in tables is called _________________ format.
tabular
A(n) _________________ is a collection of fonts, styles, colors, and effects applied to a worksheet.
theme
You should use at most ________ fonts in a worksheet. (1 point) a.four b.three c.five d.two
three
A constant is a value that never changes, such as months in a year. (1 point) True False
true
A destination cell is the location cell to be modified by a move or Autosum operation. True False
true
A function is a built-in program that performs operations on data. True False
true
A relative cell reference is the default reference in a formula to a cell address. True False
true
Color should be used only to assist in readability, categorization, or identification purposes. True False
true
Conditional formatting can be used to highlight information by changing formats such as cell fill color, font color, and font style. (1 point) True False
true
In a function, arguments are included inside the parentheses following the function name. True False
true
PDF can be viewed in many different applications. True False
true
accounting
$ (1,234.00)
currency
($1,234.00)
All of the following are valid cell ranges EXCEPT: (1 point) a.C1:C25 b.12E c.A1:B3 d.C2
12E
There are more than _________________ functions built into Excel.
400
________ can set the font, font size and color, number format, background color, borders, and alignment. (1 point) a.Banding b.A built-in cell style c.The fill color d.A built-in function
A built-in cell style
The _________________ function is used to find the mean value for a range of cells.(1 point)
AVERAGE
The _________________ function returns the number of cells in a cell range that contain numbers
COUNT
Position on the horizontal and vertical axes
Cell alignment
a number that never changes
Constant
The keyboard shortcut for the Comma format is ________. (1 point) a.Ctrl + Shift + ! b.Ctrl + Shift + # c.Ctrl + Shift + C d.Ctrl + Shift + @
Ctrl + Shift + !
The keyboard shortcut for the Short Date format is ________. (1 point) a.Ctrl + Shift + - b.Ctrl + Shift + # c.Ctrl + Shift + @ d.Ctrl + Shift + %
Ctrl + Shift + #
he keyboard shortcut for the Time format is ________. (1 point) a.Ctrl + Shift + # b.Ctrl + Shift + % c.Ctrl + Shift + - d.Ctrl + Shift + @
Ctrl + Shift + @
The background hue of a cell
Fill color
Which of the following is NOT true about using fill colors? (1 point) a.Fill color can be used to categorize information. b.Fill color can be used to highlight values. c.Fill color refers to the border color and style of a cell. d.Fill color can be used to band rows or columns as a means of assisting the reader to follow information across or down a worksheet.
Fill color refers to the border color and style of a cell.
To modify the border of a cell or cells, click the Borders button in the ________ group of the Home tab. (1 point) a.Styles b.Font c.Paragraph d.Editing
Font
the presentation of information in charts, graphs, and pictures
Graphical format
How Excel processes calculations in a formula that contains more than one operator
Order of operations
Adds of all numeric information in a specified range, list of numbers, list of cells, or any combination
Sum
To hide gridlines, check the Gridlines box in the Show group on the _________________ tab.
View
Which of the following is NOT true about working with formulas? a. To copy a formula and not change relative references, select the formula in the formula bar, click Shift + Esc, select the destination cell, and then click Insert. b. In Excel, formulas always begin with an equal sign. c. When a formula that contains cell references is copied to another cell, the cell reference will change to reflect the destination cell relative to the original cell. d. Cells that contain formulas can be treated like any other worksheet cell.
a. To copy a formula and not change relative references, select the formula in the formula bar, click Shift + Esc, select the destination cell, and then click Insert.
The Comma Style is the ________ format without a monetary symbol. (1 point) a.Number b.Currency c.General d.Accounting Number
accounting number
Cell _________________ allows cell content to be arranged horizontally as well as vertically.
alignment
Variables or values a function requires in order to calculate a solution
argument
comma
(1,234.00)
general
-1234
number
-1234.00
The presentation of information such as text and numbers in tables
Tabular format
The variables or values a function requires to calculate a solution are called _________________
arguments
Returns a mean from a specified range of cells
average
Which of the following is NOT true about the Accounting Number format? (1 point) a.The currency symbol is aligned to the left side of the cell. b.Zero values are displayed as 0 with zeroes in each decimal place. c.Negative numbers are enclosed in parentheses. d. The decimal place is aligned.
b.Zero values are displayed as 0 with zeroes in each decimal place.
Excel has more than ________ functions organized into several categories. a. 1,000 b. 700 c. 400 d. 600
c. 400
Which of the following is NOT true about the Currency Number format? a. Zero values are displayed as 0 with zeroes in each decimal place. b. Negative numbers can be identified with a dash or parentheses or displayed in red. c. The decimal place is left-aligned. d. The currency symbol is placed directly left of the value.
c. The decimal place is left-aligned.
A ________ is a built-in program that performs operations on data. a. subroutine b. parameter c. function d. formula
c. function
Formulas in Excel are created by using basic mathematical ________. a. routines b. references c. operators d. MAX
c. operators
Applies formatting to cells or specific controls as determined by the rule outcome
conditional formatting
To hide gridlines, check the Gridlines box in the Show group on the View tab. (1 point) True False
false
When text and numbers are organized in labeled columns and numbered rows, they are in graphical format. (1 point) True False
false
In Excel, a(n) _________________ is a built-in program.
function
built-in program that performs operations on data
function
Excel uses the ________ presentation of information via charts and graphs. (1 point) a.graphical b.sectioned c.tabular d.container
graphical
Documentation is an important part of building a good worksheet. (1 point) True False
true
Excel is specifically designed to present information in tabular and graphical formats. (1 point) True False
true
Excel presents information graphically via charts and graphs based on the tabular information in worksheets. (1 point) True False
true
Excel stores time values as decimal portions of one day. (1 point) True False
true
Fill color can be used to categorize information. (1 point) True False
true
Formulas always begin with ________. a. % b. ~ c. = d. $
=
The currency symbol is aligned to the left side of the cell in the ________ format. (1 point) a.Accounting Number b.Currency c.Number d.General
Accounting Number
Which of the following is NOT true about formatting worksheets? (1 point) a.Use color only to assist in readability, categorization, or identification purposes. b.Format for a reason, not just for appearances. c.Special characters such as the dollar sign should be applied only as necessary. d.Background colors should be bright colors.
Background colors should be bright colors.
_________________ formatting allows the specification of rules that apply formatting to cells or specific controls, as determined by the rule outcome.
Conditional
A setting that is automatically in place unless you specify otherwise
Default
Press the ________ key to begin to spell check a worksheet. a. F12 b. F7 c. F4 d. F1
F7
To find the greatest numerical value in a range of cells, you would use the _________________ function. (1 point)
MAX
To find the smallest numerical value in a range of cells, you would use the _________________ function.
MIN
Parentheses, exponentiation, division, multiplication, addition, or subtraction
Mathematical operator
The _________________ function is a commonly used function or totaling cell value.
SUM
A number that never changes is a(n)
constant
_________ formatting is a way to dynamically change the visual presentation of information in a manner that adds information to the worksheet. a. Default b. Tabular c. Graphical d. Conditional
d. Conditional
The order of operations that is used in Excel spells ________. a. SPAMED b. DEMAPS c. EPDMSA d. PEMDAS
d. PEMDAS
Excel stores time values as decimal portions of one ________. (1 point) a.hour b.day c.minute d.second
day
Cell formats that are automatically in place unless you specify otherwise are called _________________ settings.
default
A ________ cell is the cell that receive the result of an operation such as Paste or an AutoSum function. (1 point) a.source b.destination c.adjacent d.active
destination
The cell that receives the result of an operation such as Paste or the AutoSum function is the _________________ cell.
destination
cell The cell that receives the result of an operations such as Paste or an AutoSum function
destination
An important part of building a good worksheet is using ________. (1 point) a.conditional formatting b.styles c.calculations d.documentation
documentation
Approximately 6% to 10% of men of Asian descent are color-blind. (1 point) True False
false
By default, Number formats are left-aligned. True False
false
Formatting will change the value stored in a cell. True False
false
On a worksheet, rows and columns can be hidden as long as they do not have functions in any of the cells. (1 point) True False
false
Only one style can be applied to a cell. (1 point) True False
false
Since an image CANNOT be resized in Excel, it must be done prior to inserting it into a worksheet. True False
false
The Accounting Number Format is formatted so the currency symbol is placed directly left of the value. (1 point) True False
false
The COUNT function returns the total number of cells in a cell range that are blank. True False
false
The Comma style is formatted as the Currency style without a monetary symbol. (1 point) True False
false
The default theme for a workbook is the Excel theme. (1 point) True False
false
When someone is said to be color-blind, they have trouble distinguishing between ________. (1 point) a.blues and oranges b.reds and oranges c.reds and greens d.blues and greens
reds and greens
C12 is an example of a cell
reference
There are ________ types of cell alignment in Excel. (1 point) a.six b.four c.nine d.seven
six
If you want to total a specified range, list of numbers, list of cells, or any combination, you would use the ________ function. (1 point) a.COUNT b.AVERAGE c.SUM d.SUBTOTAL
sum
Show Formulas can aid in correcting errors or updating the function of a worksheet. True False
true
The Accounting Number format structures a cell with a comma at the thousand and two decimal places. (1 point) True False
true
To make rapid and accurate changes to the appearance of a workbook with very little effort, you can use built-in cell styles. (1 point) True False
true
To paint a format to more than one nonadjacent cell, you can double-click Format Painter and then select nonadjacent cells. (1 point) True False
true
When a cell is formatted as Currency, zero values are displayed as 0 with zeroes in each decimal place. (1 point) True False
true
in Excel, formulas and functions always begin with equal sign. True False
true
In Excel, there are ________ ways to use the AutoSum function. (1 point) a.four b.three c.five d.two
two
