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

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

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

(Multiple Choice)
4.8/5
(35)

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

(True/False)
4.9/5
(29)

A comment is added to an individual cell.

(True/False)
4.9/5
(39)

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

(Short Answer)
4.8/5
(36)

The default print range in Excel is ________.

(Multiple Choice)
4.7/5
(32)

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

(True/False)
4.9/5
(33)

________ worksheet tabs identify inactive worksheets.

(Multiple Choice)
4.9/5
(35)

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

(True/False)
4.8/5
(30)

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

(Multiple Choice)
4.9/5
(29)

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

(Short Answer)
4.9/5
(36)

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

(True/False)
4.8/5
(38)

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

(True/False)
4.8/5
(33)
Match the following terms with their definition.
Page Layout view
Shows page margins:print headers and footers:and page breaks
Page Break Preview
Does not show page margins:headers:or footers
Normal view
The Backstage View of a workbook
Correct Answer:
Verified
Premises:
Responses:
Page Layout view
Shows page margins:print headers and footers:and page breaks
Page Break Preview
Does not show page margins:headers:or footers
Normal view
The Backstage View of a workbook
Print Preview
Only the cells in the worksheet are visible
Orientation
Layout of how the workbook will print on paper
(Matching)
4.8/5
(30)
Match the following terms with their definition.
Column
Performs a mathematical calculation
Field
A vertical set of cells that encompasses all the rows in a worksheet
Function
The intersection of a row and a column in a table or worksheet
Correct Answer:
Verified
Premises:
Responses:
Column
Performs a mathematical calculation
Field
A vertical set of cells that encompasses all the rows in a worksheet
Function
The intersection of a row and a column in a table or worksheet
Formula
An item of information in a worksheet column that is associated with something of interest
Cell
A built-in formula
(Matching)
4.8/5
(28)

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

(Multiple Choice)
4.9/5
(43)
Match the following terms with their definition.
Active worksheet
An Excel file that contains one or more worksheets
Active cell
Identified by the thick green border
Cell reference
Eliminates the need to use a mouse
Correct Answer:
Verified
Premises:
Responses:
Active worksheet
An Excel file that contains one or more worksheets
Active cell
Identified by the thick green border
Cell reference
Eliminates the need to use a mouse
Keyboard shortcut
A reference within a formula or function instead of a value
Workbook
Has a white background with bold letters and a thick bottom border
(Matching)
4.8/5
(31)

________ is a file type that preserves most formatting attributes of a source document regardless of the software in which the document was created.

(Short Answer)
4.9/5
(28)

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

(True/False)
4.9/5
(38)

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

(Multiple Choice)
4.9/5
(32)
Showing 81 - 99 of 99
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)