Excel Chapter 2: Testbank Quiz
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.
is alternating the background color of rows and/or columns to assist in visually tracking information.
banding
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
Excel stores time values as decimal portions of one ________. (1 point) a.hour b.day c.minute d.second
day
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
An important part of building a good worksheet is using ________. (1 point) a.conditional formatting b.styles c.calculations d.documentation
documentation
62) The COUNT function returns the total number of cells in a cell range that are blank. (1 point) True False
false
Approximately 6% to 10% of men of Asian descent are color-blind. (1 point) True False
false
Cell banding allows cell content to be arranged horizontally as well as vertically. (1 point) True False
false
Formatting will change the value stored in a cell, as well as add information value. (1 point) 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
Standard cell formatting is always in place unless another format is specified. (1 point) 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 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 text and numbers are organized in labeled columns and numbered rows, they are in graphical format. (1 point) True False
false
color is the background color of a cell.
fill
When applying a ________, it is best practice to use muted or pastel colors. (1 point) a.table style b.theme c.built-in cell style d.fill color
fill color
A ________ is a built-in program that performs operations on data. (1 point) a.function b.parameter c.formula d.subroutine
function
Match the following terms with their definition. (5 points) Function Variables or values a function requires in order to calculate a solution Argument Variables or values a function requires in order to calculate a solution Built-in function Variables or values a function requires in order to calculate a solution Cell reference Variables or values a function requires in order to calculate a solution Destination cell A preprogrammed formula
function:A preprogrammed formula argument:Variables or values a function requires in order to calculate a solution bulit in function: A function included in Excel that can be categorized as financial, statistical, mathematical, date and time, text, or so on cell reference:Placing a particular cell or cell range within a formula or function instead of a value destination cell:The cell that receives the result of an operations such as Paste or an AutoSum function
A(n) format is used to present information in charts, graphs, and pictures.
graphical
Excel uses the ________ presentation of information via charts and graphs. (1 point) a.graphical b.sectioned c.tabular d.container
graphical
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. (1 point) a.Hide b.Filter c.Plain Formatting d.Adjust
hide
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
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
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
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
There are ________ types of cell alignment in Excel. (1 point) a.six b.four c.nine d.seven
six
A ________ cell is the cell that contains the data supplied to a function. (1 point) a.active b.adjacent c.source d.destination
source
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
One of the useful features of a ________ is the ability to "band" rows and columns. (1 point) a.built-in function b.table style c.built-in cell style d.fill color
table style
The format that organizes information in labeled columns and numbered rows is ________ format. (1 point) a.graphical b.container c.tabular d.matrix
tabular
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 paste operation. (1 point) True False
true
A function is a built-in program that performs operations on data. (1 point) 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
Documentation is an important part of building a good worksheet. (1 point) True False
true
Each table column in Excel must have a unique name. (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
In Excel, formulas and functions always begin with equal sign. (1 point) True False
true
In a function, arguments are included inside the parentheses following the function name. (1 point) True False
true
Tables allow for calculations in a total row such as summations, averages, or counts. (1 point) 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, there are ________ ways to use the AutoSum function. (1 point) a.four b.three c.five d.two
two
All of the following are valid cell ranges EXCEPT: (1 point) a.C1:C25 b.12E c.A1:B3 d.C2
12E
Excel has more than ________ functions organized into several categories. (1 point) a.700 b.1,000 c.400 d.600
400
10) Approximately ________ of men of European descent are color-blind. (1 point) a.3% - 6% b.10% - 15% c.10% - 12% d.8% - 12%
8% - 12%
Formulas always begin with ________. (1 point) a.= b.$ c.~ d.%
=
________ 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 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.
Match the following format names with their example. (5 points) Comma ($1,234.00) Currency ($1,234.00) Number -1234.00 Accounting $ (1,234.00) General (1,234.00)
Comma (1,234.00) Currency ($1,234.00) Number -1234.00 Accounting $ (1,234.00) general ($1,234.00)
________ formatting is a way to dynamically change the visual presentation of information in a manner that adds information to the worksheet. (1 point) a.Default b.Tabular c.Conditional d.Graphical
Conditional
Constant How Excel processes calculations in a formula that contains more than one operator Formula How Excel processes calculations in a formula that contains more than one operator Mathematical operator How Excel processes calculations in a formula that contains more than one operator Order of operations Applies formatting to cells or specific controls as determined by the rule outcome Conditional formatting How Excel processes calculations in a formula that contains more than one operator
Constant :The cells in the worksheet that have been selected formula:Can contain cell references, constants, functions, and mathematical operators Mathematical operator:Parentheses, exponentiation, division, multiplication, addition, or subtraction Order of operations:How Excel processes calculations in a formula that contains more than one operator Conditional formatting:Applies formatting to cells or specific controls as determined by the rule outcome
There are more than functions built into Excel.
Correct Answer: 400
The function is used to find the mean value for a range of cells.(1 point)
Correct Answer: AVERAGE
The function returns the number of cells in a cell range that contain numbers
Correct Answer: COUNT
formatting allows the specification of rules that apply formatting to cells or specific controls, as determined by the rule outcome.
Correct Answer: Conditional
To find the greatest numerical value in a range of cells, you would use the function. (1 point)
Correct Answer: MAX
86)To find the smallest numerical value in a range of cells, you would use the function.
Correct Answer: MIN
When you filter table data, the values will automatically be recalculated.
Correct Answer: SUBTOTAL
83)The function is a commonly used function or totaling cell value.
Correct Answer: SUM
To hide gridlines, check the Gridlines box in the Show group on the tab.
Correct Answer: View
Cell allows cell content to be arranged horizontally as well as vertically.
Correct Answer: alignment
The values inside a function's parentheses are called
Correct Answer: arguments
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)
Correct Answer: cell style
A number that never changes is a(n)
Correct Answer: constant
Cell formats that are automatically in place unless you specify otherwise are called settings.
Correct Answer: default
The cell that receives the result of an operation such as Paste or the AutoSum function is the cell.
Correct Answer: destination cell
A(n) performs a mathematical calculation using information in the active worksheet and other worksheets to calculate new values. (1 point)
Correct Answer: formula
In Excel, a(n) is a built-in program.
Correct Answer: function
+, *, and ^ are examples of Excel(1 point)
Correct Answer: mathematical operators
If multiple mathematical operands are included in a function or formula, Excel processes the calculations based on the
Correct Answer: order of operations
C12 is an example of a cell
Correct Answer: reference
A useful feature of a(n) style is the ability to "band" rows and columns.
Correct Answer: table
The presentation of text and numbers in tables is called format.
Correct Answer: tabular
A(n) is a collection of fonts, styles, colors, and effects applied to a worksheet.
Correct Answer: theme
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 + @
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
Match the following terms with their definition. (5 points) Format Painter A predefined set of formatting properties that determine the appearance of a table Built-in cell style Predefined and named combination of cell and content formatting properties Banding Predefined and named combination of cell and content formatting properties Table A predefined set of formatting properties that determine the appearance of a table Table style Predefined and named combination of cell and content formatting properties
Format Painter A tool that allows you to copy a format and apply it to other selections Built-in cell style: Predefined and named combination of cell and content formatting properties banding: Alternating the background color of rows and/or columns to assist in tracking information table:An organized grid of information, arranged in rows and columns table style: A predefined set of formatting properties that determine the appearance of a table
Match the following terms with their definition. (5 points) Graphical format Position on the horizontal and vertical axes Tabular format The presentation of information such as text and numbers in tables Cell alignment A setting that is automatically in place unless you specify otherwise Default A setting that is automatically in place unless you specify otherwise Fill color The background hue of a cell
Graphical format:he presentation of information in charts, graphs, and pictures Tabular format: The presentation of information such as text and numbers in tables Cell alignment:Position on the horizontal and vertical axes Default A setting that is automatically in place unless you specify otherwise Fill color The background hue of a cell
The order of operations that is used in Excel spells ________. (1 point) a.DEMAPS b.SPAMED c.PEMDAS d.EPDMSA
PEMDAS
The ________ function runs calculations only on the data that is in the subset when a filter is applied. (1 point) a.MAX b.AVERAGE c.SUM d.SUBTOTAL
SUBTOTAL
To hide gridlines, uncheck the Gridlines box in the ________ tab. (1 point) a.Format group on the View b.Show group on the View c.Show group on the Home d.Format group on the Home
Show group on the View
Match the following functions with their description. (5 points) Sum Examines all numeric values in a specified range and returns the lowest value Average Returns the number of cells in a range of cells that contain numeric data Count Examines all numeric values in a specified range and returns the highest value Min Returns the number of cells in a range of cells that contain numeric data Max Returns a mean from a specified range of cells
Sum :Adds of all numeric information in a specified range, list of numbers, list of cells, or any combination average:Returns a mean from a specified range of cells count: Returns the number of cells in a range of cells that contain numeric data min:Examines all numeric values in a specified range and returns the lowest value max cells:Examines all numeric values in a specified range and returns the highest value
Which of the following is NOT true about working with formulas? (1 point) a.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. b.In Excel, formulas always begin with an equal sign. c.Cells that contain formulas can be treated like any other worksheet cell. d.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.
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.
To hide gridlines, check the Gridlines box in the Show group on the View tab. (1 point) True False
True
The Comma Style is the ________ format without a monetary symbol. (1 point) a.Number b.Currency c.General d.Accounting Number
accounting number