Deck 10: More Functions and Excel Tables

Question 1

The prebuilt function COUNT is in the ________ category of the More Functions option in the Function Library group of the Formulas tab.

A) Cube
B) Engineering
C) Statistical
D) Information

Answer 1

C

Question 2

The functions TODAY and NOW are in the ________ category in the Function Library group of the Formulas tab.

A) Date & Time
B) Lookup & Reference
C) Math & Trig
D) More Functions

Answer 2

A

Question 3

The Text That Contains dialog box can be accessed by clicking the ________ button.

A) Quick Access Lens
B) Options
C) Quick Analysis Lens
D) Conditional Formatting

Answer 3

C

Question 4

The prebuilt Excel function ________ counts the number of cells that are in the entered range and contain numeric values.

A) NOW
B) COUNT
C) COUNTA
D) COUNTIF

Question 5

The ________ dialog box is where the user enters cell addresses, cell ranges, or constants to complete a function.

A) Input
B) Function Arguments
C) Data
D) Parameter

Question 6

The Unfreeze Panes option appears when the ________ button is clicked.

A) New Window
B) Freeze Panes
C) Arrange All
D) Full Screen

Question 7

A(n) ________ function applies a logical test to see if a specific condition is met.

A) Statistical
B) engineering
C) logical
D) text

Question 8

The Freeze Panes command is useful in working with ________.

A) short worksheets
B) large worksheets
C) multiple worksheets
D) multiple workbooks

Question 9

Options to rotate and angle text appear when the ________ button in the Alignment group on the Home tab is clicked.

A) Wrap Text
B) Merge & Center
C) Cell Styles
D) Orientation

Question 10

The ________ key can be used to move from one input box to another in a dialog box.

A) Enter
B) Tab
C) F4
D) Page Down

Question 11

The Logical test in the function IF function must contain a(n) ________.

A) arithmetic operator
B) reference operator
C) comparison operator
D) precedence operator

Question 12

Arguments in a function are separated by a(n) ________.

A) colon
B) comma
C) semi-colon
D) exclamation point

Question 13

Which is NOT a text rotation or angle option in the Orientation list?

A) Angle Clockwise
B) Angle Counterclockwise
C) Vertical Text
D) Reverse Vertical Text

Question 14

The ________ option in the Find and Replace dialog box replaces only the highlighted occurrence of the search string.

A) Find Next
B) Find All
C) Replace
D) Replace All

Question 15

What is applied to a cell when the value of the cell meets a specified condition?

A) Logical formatting
B) Conditional formatting
C) Criteria formatting
D) Provisional formatting

Question 16

The ________ chart type is NOT a sparkline option.

A) line
B) column
C) win/loss
D) pie

Question 17

That Freeze Panes is being used in a worksheet is indicated by ________.

A) a border
B) an error indicator
C) sizing handles
D) the range finder

Question 18

The prebuilt Excel function ________ returns the serial number of the current date and time.

A) TODAY
B) COUNT
C) DATE
D) NOW

Question 19

The function IF can have a maximum of ________ argument(s).

A) no
B) one
C) two
D) three

Question 20

When the Markers option in the Design contextual tab is checked, ________.

A) a mark for each data value is placed on the sparklines
B) a mark for only the high data value is placed on the sparklines
C) a mark for only the low data value is placed on the sparklines
D) marks for the first and last data values are placed on the sparklines

Question 21

What values does the user need to input or confirm in the Format as Table dialog box?

A) cell range and worksheet tab name
B) cell range and "My table has headers" option
C) worksheet tab name and range of cells containing table headers
D) range of table column headers and range of table row headers

Question 22

Only text values can be rotated and angled.

Question 23

Which is NOT a Total row summary function?

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

Question 24

A ________ is an Excel table feature that takes a formula in a column and automatically adjusts cell references for each row in the table.

A) calculated row
B) calculated column
C) calculated total
D) calculated summary

Question 25

The combination of using the Merge Cells feature, increasing font size, and adding borders gives a worksheet row a banner-like appearance.

Question 26

The function IF is a logical function.

Question 27

The ________ button is the arrow to the right of a header row label in a table.

A) edit
B) sort
C) analyze
D) filter

Question 28

Borders are always black.

Question 29

All prebuilt Excel functions are volatile.

Question 30

The ________ tab in the Page Setup dialog box has options for keeping rows at the top of, and columns at the left of, each printed page of a large worksheet.

A) Page
B) Margins
C) Header/Footer
D) Sheet

Question 31

The function COUNT returns the number of cells that are in the user selected range and have a number as the displayed value.

Question 32

When a range of cells is converted to a table, the default setting in the Filter gallery is ________.

A) Select All
B) Sort by Color
C) Sort Smallest to Largest
D) Sort Largest to Smallest

Question 33

The functions TODAY and NOW have no arguments.

Question 34

The ________ group on the Page Layout tab includes options for adjusting worksheet column width and worksheet row height to fit a maximum number of pages.

A) Sheet Options
B) Scale to Fit
C) Page Setup
D) Arrange

Question 35

When a Total row summary function is inserted at the bottom of a table column and the summary function COUNT is selected, the displayed value of the COUNT function represents the number of ________.

A) cells in the entire table
B) cells in the column that contain a text value
C) the number of cells in the column that contain a number value
D) rows in the entire table

Question 36

The functions TODAY and NOW are volatile.

Question 37

A comparison operator returns a value of yes or no.

Question 38

In a table with manual or conditional formatting, a column can be sorted only by ________.

A) color
B) smallest to largest value
C) largest to smallest value
D) style

Question 39

When the Sort Smallest to Largest option is selected from the Filter gallery, the Filter button displays ________.

A) in green
B) in red
C) another up-arrow icon
D) another down-arrow icon

Question 40

The AutoFill method of copying the underlying value of a cell can be used on cells containing the function IF.

Question 41

The first option that appears with the Format as Table command is Table style selection.

Question 42

No more than one row and one column can be frozen using the Freeze Panes feature.

Question 43

Find and Replace can be used on selected cells and on the entire worksheet.

Question 44

When a table is filtered, the rows that do not match the filtered criteria are permanently removed from the table.

Question 45

Various points (e.g., High Point, Low Point, First Point, Last Point) can be marked on a sparkline.

Question 46

Filters can be applied to more than one column in a table.

Question 47

When content of a cell is rotated or angled, the row height is automatically increased.

Question 48

No more than one row and one column can be in the Freeze panes.

Question 49

In large worksheets, scrolling down 50 rows causes the labels above the columns to disappear from view.

Question 50

Formatting options in the Format Cells dialog box are NOT available for conditional formatting.

Question 51

Two worksheets can have the same sheet tab name.

Question 52

If no cells are selected before the Find and Replace dialog box is opened, an error message prompts for the search range.

Question 53

When conditional formatting is applied to a cell and the value of that cell changes, the logical condition is reevaluated, and, if necessary, the formatting changed.

Question 54

Orientation and scaling CANNOT be applied to grouped worksheets.

Question 55

Converting a range of cells in a worksheet to an Excel table is done primarily to have a larger selection of styles.

Question 56

A data bar is a format that quickly identifies higher and lower numbers in a large group of data.

Question 57

Once a column adjacent to a table becomes a calculated column, it also becomes part of the table.

Question 58

Data in an Excel table can be sorted in a variety of ways.

Question 59

There is NO Style gallery for a sparkline chart.

Question 60

More than one column in a table can have the Sort Arrow icon on its filter button.

Question 61

Select the ________ of the single occurrence you want to replace in the Find All list of the Find and Replace dialog box to change just that one occurrence.

Question 62

A function is said to be ________ when its displayed value automatically updates.

Question 63

Sparklines are used to show ________.

Question 64

What conditional formatting option is useful in identifying higher and lower numbers in a large group of data?

Question 65

When a large worksheet is to take up more than one printed page, Page Setup options can be set to make row and column headings appear on each printed page.

Question 66

What is the comparison operator for not-equal?

Question 67

Cell references in a function or formula do NOT change when the cell is moved by ________.

Question 68

When a cell containing a sparkline is selected, the Sparkline Tools ________ contextual tab appears on the Ribbon.

Question 69

The default chart type for a sparkline is ________.

Question 70

The Find and Select button is located in the ________ group on the Home tab.

Question 71

In ________, the selected format is applied to a cell if the cell content makes the specified condition true.

Question 72

The function COUNT counts the number of cells that are in the entered range and contain ________.

Question 73

The symbols >, <, >=, <=, =, and <> are ________.

Question 74

Pressing ________ repeats the previous command performed.

Question 75

The Replace All option, in the Find and Replace dialog box, should be used only when the search string is ________.

Question 76

In function arguments, text values are surrounded by ________.

Question 77

The condition specified in a logical test is the ________.

Question 78

The underlying value that appears in the formula bar for the function TODAY is ________.

Question 79

Row and column headings that are set to print on each printed page, do NOT appear on each page in Print Preview.

Question 80

The ________ is the first argument of the function IF.