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