Deck 1: Navigate, manipulate, and Print Worksheets

Question 1

Which of the following is NOT a cell range?

A)A single cell
B)Noncontiguous cells
C)A table
D)Contiguous cells

Answer 1

C

Question 2

The keyboard shortcut to move to cell A1 is ________.

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

Answer 2

C

Question 3

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

A)Comments group on the REVIEW tab
B)Comments group on the INSERT tab
C)Documentation group on the REVIEW tab
D)Documentation group on the INSERT tab

Answer 3

A

Question 4

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

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

Question 5

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

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

Question 6

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

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

Question 7

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)Alt
B)Ctrl
C)F5
D)F7

Question 8

The keyboard shortcut for Undo is ________.

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

Question 9

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

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

Question 10

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 11

An example of a range of cells is ________.

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

Question 12

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

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

Question 13

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 14

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

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

Question 15

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

A)Page Down
B)Shift + Page Down
C)Ctrl + Page Down
D)Alt + Page Down

Question 16

Which of the following is NOT contained in a cell?

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

Question 17

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

A)Page Down
B)Page Up
C)Home
D)End

Question 18

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

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

Question 19

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

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

Question 20

The extension for Microsoft Excel 2013 workbooks is ________.

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

Question 21

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

Question 22

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 23

To select several contiguous columns,you ________.

A)click the header of the first column, then double-click the header of the last column
B)click the header of the first column, then right-click the header of the last column
C)click the header of the first column, press and hold Shift, and click the header of the last column
D)click the header of the first column, press and hold Ctrl, and click the header of the last column

Question 24

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

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

Question 25

The keyboard shortcut for inserting today's date is ________.

A)Ctrl + T
B)Ctrl + D
C)Ctrl + ;
D)Ctrl + :

Question 26

To select noncontiguous rows,you ________.

A)click the header of the first row, then double-click the header of each additional row
B)click the header of the first row, then right-click the header of each additional row
C)click the header of the first row, press and hold Shift, and click the header of each additional row
D)click the header of the first row, press and hold Ctrl, and click the header of each additional row

Question 27

The Merge & Center button is located in the ________.

A)Alignment group on the HOME tab
B)Styles group on the HOME tab
C)Alignment group on the PAGE LAYOUT tab
D)Styles group on the LAYOUT tab

Question 28

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

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

Question 29

A worksheet is a file containing at least one workbook.

Question 30

The keyboard shortcut to display the Save As dialog box is ________.

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

Question 31

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

Question 32

The file extension PDF stands for ________.

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

Question 33

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

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

Question 34

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

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

Question 35

To print headings on multiple pages,you click Print Titles in the ________.

A)Headings group on the PAGE LAYOUT tab
B)Page Setup group on the PAGE LAYOUT tab
C)Headings group on the PAGE VIEW tab
D)Page Setup group on the PAGE VIEW tab

Question 36

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

Question 37

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

A)Cells group on the VIEW tab.
B)Format group on the VIEW tab
C)Cells group on the HOME tab
D)Format group on the HOME tab

Question 38

Headers and footers contain ________ section(s).

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

Question 39

Which of the follow is NOT a worksheet view?

A)Normal view
B)Page Layout view
C)Spreadsheet Preview
D)Page Break Preview

Question 40

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

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 41

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

Question 42

A comment is added to an individual cell.

Question 43

When cutting and pasting the contents of a cell,everything in the cell,including formatting,is moved.

Question 44

To edit the contents of a cell,you right-click the cell to enter edit mode.

Question 45

Information such as the modification history of a workbook would be found in a separate documentation worksheet.

Question 46

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

Question 47

Clicking a cell and then right-clicking in the formula bar displays the insertion point in the formula bar.

Question 48

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

Question 49

To make a different worksheet active,you click Change Worksheet in the Selection group on the HOME tab.

Question 50

Dragging and dropping is an effective method for moving the contents of a cell or a range of cells to others cells.

Question 51

To select a column,click the letter in the header.

Question 52

The default time interval for automatically saving Excel files is every five minutes.

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

When copying and pasting the contents of one cell into another,the destination cell has a dashed border.

Question 59

To make a different worksheet active,you right-click the worksheet scroll arrows and select the worksheet in the Activate dialog box.

Question 60

By default,Excel places all information in a single line in a cell.

Question 61

The keyboard shortcut for quickly saving files is ________.

Question 62

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

Question 63

Documentation such as the author and modification history are contained a separate documentation ________.

Question 64

When printing a workbook,the default print range is Print Active Sheets.

Question 65

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

Question 66

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

Question 67

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

Question 68

The width of columns is defined in points.

Question 69

The normal page margins are 0.5 inches top,bottom,left,and right.

Question 70

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

Question 71

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

Question 72

To remove a cell from a worksheet,you select the cell and press the Delete key.

Question 73

You can move a worksheet within a workbook,by clicking and holding on the worksheet tab and dragging the worksheet to its new location.

Question 74

When you insert a new worksheet,it is inserted to the right of the active worksheet.

Question 75

To move up one row,you would use the ________ + Enter keyboard shortcut.

Question 76

Headings place information at the top of each printed page.

Question 77

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

Question 78

In Page Layout,default page breaks are indicated by dashed blue lines.

Question 79

A red triangle in the upper-right corner of a cell indicates the existence of a(n)________.

Question 80

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