Deck 8: Formats, Functions, and Formulas

Question 1

The currency symbol is aligned to the left side of the cell in the ________ format.

A) General
B) Number
C) Currency
D) Accounting Number

Answer 1

D

Question 2

When someone is said to be color-blind,they have trouble distinguishing between ________.

A) reds and oranges
B) reds and greens
C) blues and greens
D) blues and oranges

Answer 2

B

Question 3

Approximately ________ of men of European descent are color-blind.

A) 3% - 6%
B) 10% - 12%
C) 8% - 12%
D) 10% - 15%

Answer 3

C

Question 4

Excel uses the ________ presentation of information via charts and graphs.

A) container
B) sectioned
C) graphical
D) tabular

Question 5

Which of the following is NOT true about formatting worksheets?

A) Background colors should be bright colors.
B) Use color only to assist in readability, categorization, or identification purposes.
C) Format for a reason, not just for appearances.
D) Special characters such as the dollar sign should be applied only as necessary.

Question 6

The format that organizes information in labeled columns and numbered rows is ________ format.

A) tabular
B) graphical
C) matrix
D) container

Question 7

To modify the border of a cell or cells,click the Borders button in the ________ group of the Home tab.

A) Font
B) Paragraph
C) Styles
D) Editing

Question 8

The base date for date and time data in Excel 2016 is ________.

A) January 1, 1000
B) January 1, 1900
C) December 31, 999
D) December 31, 1899

Question 9

There are ________ types of cell alignment in Excel.

A) six
B) seven
C) four
D) nine

Question 10

Which of the following is NOT true about the Accounting Number format?

A) The currency symbol is aligned to the left side of the cell.
B) Negative numbers are enclosed in parentheses.
C) Zero values are displayed as 0 with zeroes in each decimal place.
D) The decimal place is aligned.

Question 11

When applying a ________,it is best practice to use muted or pastel colors.

A) table style
B) theme
C) built-in cell style
D) fill color

Question 12

Which of the following is NOT true about using fill colors?

A) Fill color can be used to categorize information.
B) 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.
C) Fill color refers to the border color and style of a cell.
D) Fill color can be used to highlight values.

Question 13

The Comma Style is the ________ format without a monetary symbol.

A) General
B) Number
C) Currency
D) Accounting Number

Question 14

The keyboard shortcut for the Time format is ________.

A) Ctrl + Shift + #
B) Ctrl + Shift + @
C) Ctrl + Shift + -
D) Ctrl + Shift + %

Question 15

The keyboard shortcut for the Short Date format is ________.

A) Ctrl + Shift + #
B) Ctrl + Shift + @
C) Ctrl + Shift + -
D) Ctrl + Shift + %

Question 16

You should use at most ________ fonts in a worksheet.

A) two
B) three
C) four
D) five

Question 17

One of the useful features of a ________ is the ability to "band" rows and columns.

A) built-in function
B) table style
C) built-in cell style
D) fill color

Question 18

Excel stores time values as decimal portions of one ________.

A) second
B) minute
C) day
D) hour

Question 19

________ can set the font,font size and color,number format,background color,borders,and alignment.

A) A built-in function
B) Banding
C) A built-in cell style
D) The fill color

Question 20

The keyboard shortcut for the Comma format is ________.

A) Ctrl + Shift + #
B) Ctrl + Shift + @
C) Ctrl + Shift + C
D) Ctrl + Shift + !

Question 21

To have a better sense of how the worksheet is structured,you can ________.

A) hide columns
B) hide rows
C) unhide gridlines
D) show the formulas

Question 22

A ________ is a built-in program that performs operations on data.

A) parameter
B) subroutine
C) function
D) formula

Question 23

If you want to see which employee had the highest sale,you could use the ________ function.

A) COUNT
B) SUM
C) MIN
D) MAX

Question 24

A ________ cell is the cell that receive the result of an operation such as Paste or an AutoSum function.

A) active
B) source
C) destination
D) adjacent

Question 25

The order of operations that is used in Excel spells ________.

A) SPAMED
B) PEMDAS
C) EPDMSA
D) DEMAPS

Question 26

A ________ cell is the cell that contains the data supplied to a function.

A) active
B) source
C) destination
D) adjacent

Question 27

An important part of building a good worksheet is using ________.

A) calculations
B) documentation
C) conditional formatting
D) styles

Question 28

Which of the following is NOT true about the banding format of an Excel table?

A) Banding can be done either automatically or manually.
B) When a table style is applied, table banding is dynamic.
C) Banding helps visually track information.
D) As additions and deletions are made , banding will need to be updated manually.

Question 29

Formulas always begin with ________.

A) =
B) %
C) $
D) ~

Question 30

If you want to total a specified range,list of numbers,list of cells,or any combination,you would use the ________ function.

A) COUNT
B) AVERAGE
C) SUBTOTAL
D) SUM

Question 31

Excel is specifically designed to present information in tabular and graphical formats.

Question 32

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) Plain Formatting
B) Adjust
C) Hide
D) Filter

Question 33

The ________ function runs calculations only on the data that is in the subset when a filter is applied.

A) MAX
B) AVERAGE
C) SUBTOTAL
D) SUM

Question 34

To hide gridlines,uncheck the Gridlines box in the ________ tab.

A) Show group on the View
B) Format group on the View
C) Show group on the Home
D) Format group on the Home

Question 35

In Excel,there are ________ ways to use the AutoSum function.

A) two
B) three
C) four
D) five

Question 36

Which of the following is NOT true about working with formulas?

A) In Excel, formulas always begin with an equal sign.
B) 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.
C) 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.
D) Cells that contain formulas can be treated like any other worksheet cell.

Question 37

If you want to see how many cells in a specified range contain numbers,you would use the ________ function.

A) COUNT
B) AVERAGE
C) SUBTOTAL
D) SUM

Question 38

All of the following are valid cell ranges EXCEPT:

A) A1:B3
B) 12E
C) C2
D) C1:C25

Question 39

Excel has more than ________ functions organized into several categories.

A) 700
B) 1,000
C) 400
D) 600

Question 40

________ formatting is a way to dynamically change the visual presentation of information in a manner that adds information to the worksheet.

A) Default
B) Conditional
C) Graphical
D) Tabular

Question 41

The default theme for a workbook is the Excel theme.

Question 42

Fill color can be used to categorize information.

Question 43

Standard cell formatting is always in place unless another format is specified.

Question 44

Tables allow for calculations in a total row such as summations,averages,or counts.

Question 45

Formatting will change the value stored in a cell,as well as add information value.

Question 46

The Comma style is formatted as the Currency style without a monetary symbol.

Question 47

Approximately 6% to 10% of men of Asian descent are color-blind.

Question 48

When a cell is formatted as Currency,zero values are displayed as 0 with zeroes in each decimal place.

Question 49

The Accounting Number Format is formatted so the currency symbol is placed directly left of the value.

Question 50

Each table column in Excel must have a unique name.

Question 51

To make rapid and accurate changes to the appearance of a workbook with very little effort,you can use built-in cell styles.

Question 52

Cell banding allows cell content to be arranged horizontally as well as vertically.

Question 53

Excel presents information graphically via charts and graphs based on the tabular information in worksheets.

Question 54

In a function,arguments are included inside the parentheses following the function name.

Question 55

Only one style can be applied to a cell.

Question 56

A function is a built-in program that performs operations on data.

Question 57

The Accounting Number format structures a cell with a comma at the thousand and two decimal places.

Question 58

To paint a format to more than one nonadjacent cell,you can double-click Format Painter and then select nonadjacent cells.

Question 59

Excel stores time values as decimal portions of one day.

Question 60

When text and numbers are organized in labeled columns and numbered rows,they are in graphical format.

Question 61

There are more than ________ functions built into Excel.

Question 62

Cell ________ allows cell content to be arranged horizontally as well as vertically.

Question 63

________ is alternating the background color of rows and/or columns to assist in visually tracking information.

Question 64

The COUNT function returns the total number of cells in a cell range that are blank.

Question 65

________ color is the background color of a cell.

Question 66

On a worksheet,rows and columns can be hidden as long as they do not have functions in any of the cells.

Question 67

A(n)________ format is used to present information in charts,graphs,and pictures.

Question 68

A(n)________ is a collection of fonts,styles,colors,and effects applied to a worksheet.

Question 69

A constant is a value that never changes,such as months in a year.

Question 70

Documentation is an important part of building a good worksheet.

Question 71

The presentation of text and numbers in tables is called ________ format.

Question 72

A destination cell is the location cell to be modified by a move or paste operation.

Question 73

In Excel,a(n)________ is a built-in program.

Question 74

In Excel,formulas and functions always begin with equal sign.

Question 75

To hide gridlines,check the Gridlines box in the Show group on the View tab.

Question 76

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.

Question 77

Conditional formatting can be used to highlight information by changing formats such as cell fill color,font color,and font style.

Question 78

The values inside a function's parentheses are called ________.

Question 79

Cell formats that are automatically in place unless you specify otherwise are called ________ settings.

Question 80

A useful feature of a(n)________ style is the ability to "band" rows and columns.