Deck 7: Create, Navigate, Work With, and Print Worksheets

Question 1

When there are multiple worksheets,you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right.

A) Home
B) End
C) PgDn
D) PgUp

Answer 1

C

Question 2

The keyboard shortcut to move one column to the left is ________.

A) Shift + Tab
B) Ctrl + Tab
C) Tab
D) Ctrl + Home

Answer 2

A

Question 3

The file extension for Microsoft Excel 2016 workbooks is ________.

A) )xlx
B) )xlls
C) )xls
D) )xlsx

Answer 3

D

Question 4

A comment is indicated by the presence of a ________ in the upper-right corner of a cell.

A) red square
B) green square
C) red triangle
D) green triangle

Question 5

If you click ________,the insertion point is displayed in the formula bar.

A) in a cell
B) in the formula bar
C) a worksheet tab
D) the Home tab

Question 6

Which of the following is typically NOT contained in a separate documentation worksheet?

A) Modification dates
B) Author
C) Charts
D) Modification History

Question 7

A ________ application is a computer program has a user interface comprised of a grid of rows and columns.

A) database
B) spreadsheet
C) matrix
D) tabular

Question 8

Formulas and functions begin with a(n)________ sign.

A) #
B) =
C) @
D) &

Question 9

If you enter a date or time that is not recognized,Excel treats the information as ________ and left-aligns it in the cell.

A) Numeric
B) Text
C) Date
D) Time

Question 10

To move right one screen,you would use the keyboard shortcut ________.

A) PgDn
B) Shift + PgDn
C) Ctrl + PgDn
D) Alt + PgDn

Question 11

Which of the following data types is NOT automatically right-aligned by Excel?

A) Numeric
B) Date
C) Text
D) Time

Question 12

The intersection of a row and column is called a ________.

A) container
B) chamber
C) cubicle
D) cell

Question 13

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

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

Question 14

The keyboard shortcut for Undo is ________.

A) Ctrl + Y
B) Ctrl + W
C) Ctrl + U
D) Ctrl + Z

Question 15

The keyboard shortcut to move to cell A1 is ________.

A) Home
B) Shift + Home
C) Alt + Home
D) Ctrl + Home

Question 16

Which of the following is NOT an example of worksheet documentation?

A) Descriptive drop-down documentation menus
B) Descriptive worksheet names
C) Descriptive cell labels
D) Descriptive column titles

Question 17

A ________ is a grid of columns and rows in which data is entered.

A) database
B) presentation
C) document
D) worksheet

Question 18

To insert a line break or hard return in a cell,you would press ________.

A) Ctrl + Enter
B) Enter
C) Alt + Enter
D) Shift + Enter

Question 19

To insert a comment into a cell,you click New Comment in the:________ tab.

A) Comments group on the Review
B) Comments group on the Insert
C) Documentation group on the Review
D) Documentation group on the Insert

Question 20

Which of the following is NOT a type of data that can be contained in a cell?

A) Formulas
B) Functions
C) Text
D) Subroutines

Question 21

To change the width of a column,you click Column Width in the ________ tab.

A) Cells group on the Format tab.
B) Adjustment group on the Format tab.
C) Cells group on the Home tab.
D) Adjustment group on the Home tab.

Question 22

An example of a range of cells is ________.

A) A1:A3
B) A1&A3
C) A1+A3
D) A1-A3

Question 23

________ worksheet tabs identify inactive worksheets.

A) Green
B) Gray
C) White
D) Blue

Question 24

Headers and footers contain ________ section(s).

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

Question 25

You can copy a worksheet within a workbook,by ________,and then dragging a copy of the worksheet to its new location.

A) double-clicking the worksheet tab
B) clicking the worksheet tab, pressing and holding Ctrl
C) right-clicking the worksheet tab
D) clicking the worksheet tab, pressing and holding Shift

Question 26

To select several contiguous columns,click the header of the first column,________ the header of the last column.

A) then double-click
B) then right-click
C) press and hold Shift, and click
D) press and hold Ctrl, and click

Question 27

To AutoFit the width of a column,you click Format and then click AutoFit Column Width in the ________ tab.

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

Question 28

To select noncontiguous rows,click the header of the first row,________ the header of each additional row.

A) then double-click
B) then right-click
C) press and hold Shift, and
D) press and hold Ctrl, and click

Question 29

After selecting a row,pressing the shortcut key ________ will insert a new row above the selected row.

A) Ctrl + I
B) Ctrl + +
C) Ctrl + #
D) Ctrl + R

Question 30

Normal margins for Excel are ________ inch on the left and right sides of the page.

A) 0.3
B) 0.7
C) 0.75
D) 0.5

Question 31

The default print range in Excel is ________.

A) Print Selection
B) Print Entire Workbook
C) Print Active Print Areas
D) Print Active Sheets

Question 32

Worksheets can be oriented to print on paper in one of ________ ways.

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

Question 33

You can select a noncontiguous range of cells by pressing and holding the ________ key when using it in combination with other navigation keys and/or the mouse.

A) F7
B) F5
C) Alt
D) Ctrl

Question 34

In Excel,the height of the rows is measured in ________.

A) picas
B) points
C) pixels
D) ppm

Question 35

You can rename a worksheet by ________ its tab and then typing the new name.

A) right-clicking
B) double-clicking
C) pressing Ctrl and clicking
D) clicking

Question 36

When using a what-if analysis,you change values in spreadsheet cells to see the effects on calculated values of interest.

Question 37

A formula is a built-in program that would be used to find the average of a series of numbers.

Question 38

The file extension PDF stands for ________.

A) Portable Data File
B) Portable Document Format
C) Portable Data Format
D) Portable Document File

Question 39

If a numerical value is too narrow to be displayed in a cell,a series of ________ characters is displayed.

A) &
B) @
C) %
D) #

Question 40

The Merge & Center button is located in the ________ tab.

A) Alignment group on the Home
B) Styles group on the Home
C) Alignment group on the Layout
D) Styles group on the Layout

Question 41

A cell reference is a combination of a row number followed by a column letter such as 12C.

Question 42

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

Question 43

A noncontiguous cell range consists of multiple cells where all cells are directly adjacent to each other.

Question 44

To move up one screen,you use the Ctrl + PgUp keyboard shortcut.

Question 45

Keyboard shortcuts allow rapid navigation in a worksheet without having to use the mouse.

Question 46

A function is an equation that produces a result and may contain numbers,operators,text,and/or functions.

Question 47

By default,text data is center-aligned in a cell.

Question 48

A comment is a temporary storage location where information that was cut or copied is stored until you paste,move,or clear the information.

Question 49

When using a touch screen,the Excel 2016 commands on the ribbon and in shortcut menus are rearranged to accommodate the use of a fingertip.

Question 50

A worksheet is a file containing at least one workbook.

Question 51

By default,numeric data is right-aligned in a cell.

Question 52

A contiguous cell range consists of multiple cells where at least one cell is not directly adjacent to other cells.

Question 53

The dollar sign ($)and comma (,)are stored as part of a numeric cell value.

Question 54

In Excel,date and time data are special forms of numeric data.

Question 55

The Ctrl + S shortcut quickly saves your file to the same location as the last save.

Question 56

When collecting data in a spreadsheet,each row contains a record.

Question 57

In Microsoft Excel 2016,workbooks have a file extension of .xlsx.

Question 58

Data formatted as a date takes the form of a serial number,with the number 1 representing January 1,1900.

Question 59

A comment is added to an individual cell.

Question 60

The active worksheet has a white tab with bold letters and a thick bottom border.

Question 61

If you mistakenly delete a worksheet,you can recover it by pressing Undo.

Question 62

When collecting data in a spreadsheet,each ________ is a field in a record.

Question 63

Page Break Preview allows you to manually adjust the location of page breaks.

Question 64

One of the most efficient ways of moving data from oe cell to another is to drag and drop.

Question 65

A(n)________ is a horizontal set of cells that encompasses all the columns in a worksheet.

Question 66

Merge & Center can only be applied to horizontal cell ranges.

Question 67

A(n)________ is a built-in program that performs a task such as finding the sum of a series of numbers.

Question 68

Adobe System's PDF reader application CANNOT be used to edit a document that was saved with the pdf extension.

Question 69

The worksheet that is visible in the Excel application window is the ________ worksheet.

Question 70

A(n)________ is an equation that produces results such as numbers or text.

Question 71

White space refers to blank areas of a worksheet that do not contain data or documentation,regardless of the actual color.

Question 72

The AutoFill property adjusts the height of a row so that its cell contents fit in the row.

Question 73

In ________,the ribbon and shortcut menus are enlarged to make selecting commands with your fingertip easier.

Question 74

When using Excel,a spreadsheet is also referred to as a(n)________.

Question 75

Gray worksheet tabs identify inactive worksheets.

Question 76

A file that contains one or more worksheets is a(n)________.

Question 77

A(n)example of a cell ________ is K12.

Question 78

The intersection of each row and column is called a(n)________.

Question 79

The cell that receives an action,such as a click,calculation,or paste is the ________ cell.

Question 80

________ allows you to examine the outcome of the changes to values in a worksheet.