Exam 1: Introduction to Excel

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

When you do not need the data on a worksheet you should ________ it to make the file smaller.

(Short Answer)
4.7/5
(91)

Which Paste option would you choose if you wanted to flip the rows and columns?

(Multiple Choice)
4.7/5
(79)

The ________ feature displays any values in the column that match what the user has typed so far.

(Short Answer)
5.0/5
(74)

Where would you find the command to center the printout both horizontally and vertically on your paper?

(Multiple Choice)
4.9/5
(81)

Where can you find more alignment options?

(Multiple Choice)
4.9/5
(86)
Match the following Excel Elements with their description or action:
Enter
Shows the contents of the active cell
Status bar
Reverts back to previous data
Zoom control
Displays information about a command or operation as it is being performed
Correct Answer:
Verified
Premises:
Responses:
Enter
Shows the contents of the active cell
Status bar
Reverts back to previous data
Zoom control
Displays information about a command or operation as it is being performed
Formula bar
Accepts the data
Cancel
Allows you to see more or less on the screen at one time
(Matching)
4.9/5
(68)

The ________ feature helps you complete an incremental series.

(Short Answer)
4.9/5
(84)

It is acceptable to use values in formulas when you know those values will never change.

(True/False)
4.8/5
(69)

You can move a range by using the cut and paste commands.

(True/False)
4.7/5
(85)

It is relatively easy to copy Excel cells into other Office programs.

(True/False)
4.9/5
(86)

You should use ________ in formulas whenever possible instead of static numbers.

(Short Answer)
4.8/5
(84)

One point is how big?

(Multiple Choice)
4.7/5
(75)

What is the best way to make sure your worksheet prints on only one page?

(Multiple Choice)
4.7/5
(91)
Match the following Paste options with their description:
Picture
Unformatted results of formulas
Paste Link
A reference to the cells not the cell contents
Linked Picture
Changes if the content changes
Correct Answer:
Verified
Premises:
Responses:
Picture
Unformatted results of formulas
Paste Link
A reference to the cells not the cell contents
Linked Picture
Changes if the content changes
Values
A non-editable copy of your data
Paste
Cell contents and all formatting
(Matching)
4.9/5
(88)

New workbooks typically contain how many worksheets?

(Multiple Choice)
4.8/5
(76)

When you copy and paste a range the relative references do not change.

(True/False)
4.7/5
(84)

What should you do if there are columns you need, but do not want to display?

(Multiple Choice)
4.8/5
(73)

What would not be a typical item to have in a header or footer?

(Multiple Choice)
4.8/5
(87)

You can ________ a cell's contents to the right or left to help it stand out from the row above or below.

(Short Answer)
4.8/5
(81)

You can add ________ color to a cell or range of cells for emphasis.

(Short Answer)
5.0/5
(83)
Showing 61 - 80 of 100
close modal

Filters

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