Deck 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Question 1

What is an Excel table?

A)A series of rows and columns that contains related data that can be managed independently from other data in a worksheet
B)A series of rows and columns that has been assigned a name and can be used in a formula or function
C)A series of rows and columns that contain related data located on a minimum of two worksheets
D)A series of rows or columns on a separate worksheet that can be managed independently from other data in a worksheet

Answer 1

A

Question 2

How do you know if some rows of a table have been hidden from view when a filter is invoked?

A)Row numbers display is red
B)Row numbers are bolded
C)Row numbers display in blue
D)A number pertaining the number of hidden rows displays next to the funnel icon

Answer 2

C

Question 3

The COUNT function counts the number of cells in a range that ________.

A)contain a number or text
B)contain a number
C)contain text
D)match a given value

Answer 3

B

Question 4

The COUNTIF function has two arguments ________.

A)the range of cells to check and the criteria
B)the range of cells to check and the sum of the range
C)a value as the criteria and an average of a range of cells
D)the range of cells to sum and the criteria

Question 5

What is the keyboard shortcut for flash fill?

A)Alt + E
B)Ctrl + E
C)Ctrl + F
D)Ctrl + F2

Question 6

Which of the following Excel features recognizes a pattern in the data of a worksheet?

A)Find and Replace
B)Flash Fill
C)IF function
D)COUNTIF function

Question 7

Where does Excel's NOW function retrieve the date from?

A)The Internet
B)The Excel program
C)The computer's clock
D)The Office 2016 suite

Question 8

In a large worksheet,which two Excel commands help to make the worksheets attractive and easier to read?

A)Print Titles and Scale to Fit
B)Print Titles and Summary sheet
C)Detail sheet and Summary sheet
D)Print titles and Conditional format

Question 9

Where do sheet tabs display in a workbook?

A)Under the ribbon
B)On the status bar
C)Lower area of the workbook window
D)On the right side of the workbook window

Question 10

The <,>,and <> can be described as ________.

A)logical tests
B)comparison operators
C)criteria
D)arguments

Question 11

To rotate text in a worksheet,in the Format Cells dialog box,you can click and drag the ________.

A)red circle
B)blue diamond
C)red diamond
D)black,bold triangle

Question 12

Which of the following is FALSE about the NOW function?

A)It updates each time the workbook is opened.
B)It is a volatile function.
C)It remains constant even when the workbook is opened.
D)It uses the computer's calendar and clock to display the date and time.

Question 13

What is a pane bounded by?

A)A solid red line
B)Vertical or horizontal bars
C)The status bar
D)The ribbon

Question 14

When formatting a worksheet to be printed,________ show where page breaks are located.

A)red lines
B)blue lines
C)a solid bold line
D)dotted lines

Question 15

What does a data bar in a cell represent?

A)The value of a cell relative to other cells
B)The values in a range of cells
C)The values of the two cells to the left of the cell with the data bar
D)The sum of the values above the data bar cell

Question 16

How do banded rows display?

A)Even rows are formatted differently from odd rows
B)Even rows are bolded;odd rows are not
C)With a sold border around each row
D)Even rows are have a different background and font color than do odd rows

Question 17

Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result?

A)*
B)@
C)#
D)-

Question 18

The MEDIAN function finds ________.

A)the average value in a range of cells
B)the middle value in a range of cells
C)all numbers that correspond to an argument in the function
D)the one number that corresponds to an argument in the function

Question 19

The quickest way to repeat an action in Excel is the ________ function key.

A)F2
B)F4
C)F6
D)F11

Question 20

Which of the following is NOT a way to insert the SUM function into a cell?

A)Alt + =
B)Insert the AutoSum function from the Home tab
C)Insert the AutoSum function from the Formulas tab
D)Ctrl + =

Question 21

On your keyboard,which two symbols function identically in date formats?

A)The forward slash key and the period
B)The dollar sign and the ampersand
C)The comma and the forward slash key
D)The hyphen key and the forward slash key

Question 22

SUM,AVERAGE,and MIN are formats.

Question 23

If a cell is too narrow to display a result of a formula or function,the ##### message displays.

Question 24

When a new column is inserted into a worksheet,the remaining columns move to the right.

Question 25

The Find and Replace feature searches the cells in a worksheet-or in a selected range-for matches,and then replaces each match with a replacement value of your choice.

Question 26

The NOW function formats the result as a date and time.

Question 27

If the result of a logical test is false,Excel will always display YES in the cell.

Question 28

A logical test includes one of three values designated in three different cells.

Question 29

The SUM function adds all numbers in a selected range of cells.

Question 30

Which of the following is FALSE about worksheet tabs?

A)You can change the color of worksheet tabs.
B)You can rename a tab by double-clicking on it.
C)The active worksheet tab displays in red font.
D)A worksheet tab can be copied.

Question 31

Arguments are surrounded by brackets in a function.

Question 32

The Freeze Panes command enables you to select one or more rows or columns and then (lock)them into place.

Question 33

In the Excel window,where does [Group] display when worksheets are grouped?

A)On the status bar
B)On the ribbon
C)On the title bar
D)On the sheet tab

Question 34

The ________ is the temporary storage location for cell contents copied from a worksheet.

A)Clipboard
B)Office Pane
C)Paste area
D)Excel table

Question 35

What are the default names of worksheets?

A)Sheet1,Sheet2,etc.
B)Worksheet1,Worksheet2,etc.
C)Excel 1,Excel 2,etc.
D)1,2,3,etc.

Question 36

Sheet tab names are ________ when they are grouped.

A)underlined
B)bolded
C)italicized
D)in red

Question 37

When a cell has conditional formatting and the condition is false,the cell is formatted.

Question 38

The COUNTIF function counts the number of cells within a range that meet the criteria entered.

Question 39

If a sheet tab has ________ you know that it is not selected.

A)a dotted background
B)a background color
C)a bolded border
D)a red border

Question 40

What is a summary sheet?

A)A sheet with two panes: one with the data,the other with the summary
B)A worksheet where totals from other worksheets are displayed
C)A worksheet with data on the left side and the summary on the right
D)A worksheet with sheet names,sheet information,and sheet locations of all other worksheets

Question 41

You cannot clear an entire worksheet in Excel.

Question 42

The keyboard shortcut to enter the current date is Ctrl + #.

Question 43

The Unfreeze command locks columns and rows into place.

Question 44

You can leave the year off entirely when typing a date into a cell.

Question 45

Scaling reduces the width of a worksheet;it does not reduce the height.

Question 46

Clearing the contents of a cell deletes the value or formula,but does not clear the formatting applied to the cell.

Question 47

The paste area is the target destination for data that has been cut or copied using the Clipboard.

Question 48

You can sort a table in ascending or descending order.

Question 49

Excel's Scale to Fit commands enable you to stretch or shrink the width,height,or both of a printed page.

Question 50

A filter icon displays next to column headings when a sort is invoked in a table.

Question 51

A filter in Excel displays only a portion of the table data based on matching criteria.

Question 52

You can double-click a sheet tab to rename it.

Question 53

When a year value lower than 30 is entered in a cell,for example 2/12/18,Excel assumes that the date is in the 21ˢᵗ century.

Question 54

When excel enters a current date into a cell,it is accessed from your computer's internal calendar.

Question 55

When you select a single sheet that is part of a group,the grouping of the sheets is cancelled.

Question 56

Ctrl + P is the keyboard shortcut for Paste.

Question 57

A large + sign icon displays next to column headings when a filter is invoked in a table.

Question 58

Data can be edited on more than one worksheet at a time.

Question 59

The active worksheet tab displays in bold.

Question 60

Cell contents must always be a value,not a formula.

Question 61

The ________ function determines the largest value in a range of cells.

Question 62

An Excel ________ is a range of cells converted in Excel used to analyze a group of related data.

Question 63

When cell contents are copied or moved,they are placed on the ________.

Question 64

The ________ command allows you to select one or more rows or columns and lock them into place.

Question 65

The NOW function is ________,meaning that it will update automatically each time the workbook is opened.

Question 66

The ________ command enables you to specify rows and columns that will be duplicated on each printed page.

Question 67

Deleting the ________ of a cell deletes the value or formula,but does not clear formatting of that cell.

Question 68

The ________ command divides a window into multiple panes.

Question 69

The ________ function adds the values in a range of cells,and then divides the result by the number of values in the range.

Question 70

Sparklines are large charts stored on a separate worksheet that display a data trend of the adjacent worksheet.

Question 71

A(n)________ illustrates the value of a cell relative to other cells in the worksheet.

Question 72

Ctrl + F1 is the is the keyboard shortcut for Print Preview.

Question 73

A(n)________ is a predefined formula such as SUM or MEDIAN.

Question 74

All formulas start with + (a plus sign).

Question 75

The action of copying or moving cells contents to another location is called ________.

Question 76

The values in parentheses in the SUM function (and other functions)are known as ________.

Question 77

Each worksheet in a workbook can have different formatting.

Question 78

Hiding a worksheet prevents it from displaying,but the sheet is still part of the workbook.

Question 79

________ identify each worksheet in a workbook.

Question 80

You can group worksheets and format them simultaneously.