Excel MOAC Lesson 6 Review – Flashcards
Unlock all answers in this set
Unlock answersquestion
When you use the Freeze command,
answer
The column and/or row headings remain visible as you scroll through the worksheet card.
question
A feature you can use to locate and replace specific data ina worksheet
answer
Search and Replace
question
To make a hidden workbook or worksheet visibile
answer
Unhide Command
question
Any sequence of letters or numbers that you type.
answer
String
question
To make a workbook or worksheet invisible.
answer
Hide command
question
A command you can use to locate blank cells in a worksheet.
answer
Go To Special
question
To make a worksheet appear larger on the screen
answer
Zoom In
question
To make a worksheet appear smaller on the screen.
answer
Zoom Out
question
To make certain rows and columns remain visible on your screen even when you scroll your worksheet.
answer
Freeze
question
Selecting multiple worksheets in which you enter and edit data
answer
Group worksheets
question
A feature that allows you to visually compare worksheets.
answer
Arrange All Command
question
If you want to magnify the data on the screen:
answer
increase zoom to more than 100%
question
To find data using the Find and Replace dialog box, you must enter a sequence of characters called a:
answer
string
question
You can tell that worksheets are grouped by
answer
the word "group" in the title bar.
question
When a worksheet is hidden:
answer
Unhide is active on the shortcut menu
question
To enter data in multiple worksheets at one time, you must
answer
group all worksheets and enter data in the open worksheet.
question
When Sheet1 has been copied, the new worksheet tab is named:
answer
Sheet 1 (2).
question
To insert multiple worksheets at one time, what action is needed in addition to selecting the same number of tabs as the number of sheets to insert?
answer
Press and hold Ctrl as you select the tabs
question
Which of the following is NOT a way to insert a new worksheet into a workbook?
answer
On the Insert tab, click New Sheet
question
To hide a workbook that has multiple worksheets:
answer
click Hide in the Window group on the View tab.
