Comp II
page break preview
provides a quick and easy method change where pages break
A cell address is also called a cell _______.
reference
Drag the Zoom slider to the __________ to zoom in on the data.
right
To scroll down one screen of data at a time, click in the scroll bar below the ______.
scroll box
worksheets
sheets where data is entered in the Excel application
Microsoft Excel is a _________ program.
spreadsheet
The Microsoft Excel application is a _____ program.
spreadsheet
The Excel application is used to create ______.
spreadsheets
normal view
the most commonly used workbook view, which displays the cells continuously with no gaps
zoom level
tool used to zoom to an exact percentage level
How many workbook windows does the View Side by Side command allow you to view and compare at the same time?
two
The Split command splits a worksheet into _____________ panes.
two or four
The _____ is the area in Microsoft Excel where you can perform file commands such as Save, Open, and Print.
backstage view
To display the Format Comment dialog box, you must right-click on the _______ of the comment.
border
To move a comment, click on the ________ of the comment and drag.
border
The lines that can be formatted to display on the edges of cells are called _______.
borders
Create a/an _______ to create your own Auto Fill option.
custom list
The worksheet navigation tools are located in the ________ corner of the screen.
lower left-hand
page setup
options for page settings such as margins, page orientation, and paper size
One reason to use more than one worksheet in an Excel file is to ______ data.
organize
What indicator displays in a cell that contains a comment?
red indicator triangle
Double-click on a sheet tab to _______ the sheet.
rename
Which of the following characters is safe to use in a Microsoft Excel filename?
space
Fill tool
takes the data from the first cell in a selected range and copies it to all of the other cells in the selection
What type of file is a CSV file?
text
When entering numbers that start with a zero, apply the _______ number format.
text
footer
text and/or graphics that print at the bottom of each page
A CSV file is a _______.
text file
data entry
the act of entering data into cells in an Excel worksheet
backstage view
the area in Microsoft® Excel® that is used to manage files
Where do you point in a cell to fill cell data?
the bottom right corner
What does the mouse pointer look like when moving a cell?
white arrow
The copy mouse pointer looks like a _______.
white arrow with a small plus sign
What displays in a formatted cell when a number entered is too long to be displayed in the cell?
#######
To convert a number to text, which symbol do you type before it?
'
Which symbol do you type before a number to convert it to text?
'
When ______ is typed in a cell, it will be left-aligned.
'01254
What two symbols are safe to use in Microsoft Excel file names?
- _
To save data from Microsoft Excel to a text file, which file format should you choose when saving?
CSV
Use the _______ key on your keyboard to select multiple ranges of cells.
Ctrl
What key on your keyboard do you press and hold when dragging a cell to copy it?
Ctrl
What key on your keyboard do you use to select multiple ranges of cells?
Ctrl
The keyboard shortcut to hide a row is _______.
Ctrl+9
_____ are also known as metadata.
Document properties
Borders and fill colors can be removed from a cell by deleting the cell contents.
False
By default, comments print when a worksheet or workbook is printed.
False
Don needs to print his workbook. What tab should he click on to see the Print command?
File
The _________ tool is used to undo your Undo.
Redo
Orlando would like to compare data in two different areas of the same worksheet. He can use the _______ command to divide the worksheet in two panes.
Split
Once you select a text file to import, the _______ is automatically started to help import the data.
Text Import Wizard
When importing data using the Get External Data tools on the Data tab, what wizard is automatically started after selecting the file you want, to help import the data?
Text Import Wizard
_______ display information about a tool on the ribbon.
Tool tips
Rows are horizontal (up and down) in orientation.
True
The _____ command is used to fix a mistake immediately after you make it.
Undo
One way to access _________ is through Outlook.
a OneDrive®
Custom Lists
a feature that allows you to create your own Auto Fill lists for data that you frequently enter in worksheets
CSV
a file format that separates data with commas
template
a file format used to create new files that contain the same data as the template
print titles
a setting that repeats rows and/or columns on each page of a worksheet
format bar
a shortcut bar that contains tools for commonly used formats
share workbook
allows multiple people to open and edit a workbook at the same time
Where do you point in a cell to move the cell?
an edge
What is the file extension for a Microsoft Excel 2013 template file?
.xltx
When numbers are formatted in percent format, they are multiplied by _______ for display purposes.
100
Microsoft Excel file names can be __________ characters long.
255
The longest a Microsoft® Excel® file name can be is _______ characters long.
255
The maximum number of characters that a cell can contain is _____.
32,767
When _____ is typed in a cell, it will be right-aligned.
700.22
Common letter-sized paper used in the United States has what dimensions?
8.5" x 11"
_______ is used to create new files for files that you need to create over and over again.
A template
Sam wants to set custom document properties, so he should open the ________.
Advanced Document Properties
To set custom document properties, open the _____.
Advanced Document Properties
To set custom document properties from the backstage view, click on Properties, and choose ________.
Advanced Properties
The keyboard shortcut to force a new line break in a cell is _______.
Alt+Enter
Where do you point on a selected cell to move it?
Any edge
Tim has several workbooks open in the Excel application. He would like to view them all at the same time, so he should use the ______ command.
Arrange All
_______ is the feature that allows you to quickly advance cell data while filling a range of cells.
Auto Fill
_______ is displayed in the title bar of the Excel screen when starting Excel.
Book1
The three workbook views are Normal, Page Layout, and Page _____ Preview.
Break
_______ are pre-defined formats used to quickly format cells.
Cell styles
Use the _______ command to center worksheets vertically and/or horizontally on a page.
Center on Page
The ______ tool in the Editing group on the Home tab allows you to clear all options from a cell.
Clear
If you want to leave the content in selected cells but remove all of the formatting from the cells, use the _______ command.
Clear Formats
The keyboard shortcut to save a file is _______.
Ctrl-S
_______ on any one of the tabs of the ribbon hides the ribbon.
Double-clicking
The _______ tool allows you to change the shape of a comment.
Edit Shape
To change the shape of a comment, you must add the _______ tool to the Quick Access Toolbar.
Edit Shape
Harry has created a Microsoft Excel workbook that he wants only certain people to be able to open. He should use ________ under Protect Workbook on the File tab to set a password for the workbook.
Encrypt with Password
How often should you save your Microsoft Excel files while working in them?
Every five to ten minutes
workbooks
Excel files that contain all of the worksheets
The Switch Windows command is used to switch back and forth between open ______.
Excel windows
After inserting a comment in a cell, the comment displays even after clicking on a different cell.
False
The default page orientation in a Microsoft Excel worksheet is landscape
False
To find formatting commands that are not displayed on the Home tab, open the _______ dialog box.
Format Cells
The ______ shows what is truly in a cell.
Formula Bar
Where do you look on the Excel screen to see the formula that has been typed in a cell?
Formula Bar
Where do you look on the Excel screen to see what is truly in a cell?
Formula Bar
Martin is working in a large worksheet. As he scrolls down through the worksheet, he can no longer see the column titles, so it is difficult to tell what each column of numbers represents. He should turn on the _______ feature to make reading his data easier as he scrolls.
Freeze Panes
To lock rows at the top of the screen, use the _______ command.
Freeze Panes
When there are more columns or rows than you can view on one screen at a time, you can use the ______________ command to lock columns and rows on the screen.
Freeze Panes
Bobby needs to add keywords to his document properties. To display his document properties, he should click on the File tab and then the _________,
Info tab
When inserting a comment in a cell, the command on the Review tab is New Comment, but if you right-click in the cell, what command would you choose from the shortcut menu?
Insert Comment
Mary needs to create a budget for her department using the computer. Which program should she use?
Microsoft Excel®
The _____ command is used to open a worksheet of a workbook in a new window.
New Window
The _____ workbook view is the view that is used most often in the Excel application.
Normal
The ______ view is the most commonly used view.
Normal
Which workbook view is used most often in Excel?
Normal
The keyboard shortcut to move down one screen of data at a time is _______.
Page Down
Use the ________ options to change the margins, page orientation, and print titles in a worksheet.
Page Setup
The default print setting for worksheets is ________.
Print Active Sheets
If a worksheet is only printing a portion of the cells, a ________ has been set.
Print Area
To print only the cells that you have selected, use the ________ command on the Print tab.
Print Selection
When printing large worksheets with lots of rows, it's difficult to tell what the data represents on pages 2 and higher. Use the _______ command to set the row(s) that contain the column headings to print at the top of each page.
Print Titles
The Save command is found on the File tab. Another place to find the Save command is the _______.
Quick Access Toolbar
To use the shortcut for inserting a row, ______ on the row number and choose Insert.
Right-click
Mary has created a Microsoft Excel file to track work hours for her employees. She can use the _______ command to save a copy of the file to use for a new employee.
Save As
Use the _______ command to save a copy of a file.
Save As
The ______ command on the Fill tool is used to manually fill a series of numbers.
Series
To manually fill a series of numbers, use the ______ command on the Fill tool.
Series
Leonard wants to allow his coworkers to open and edit a Microsoft Excel workbook at the same time. He should apply the ________ command to the workbook.
Share Workbook
Which tool is used to set up a workbook to be used by multiple people at the same time?
Share Workbook
The keyboard shortcut to insert a comment is ________.
Shift+F2
To keep all comments on a worksheet visible, click on ________ on the Review tab.
Show All Comments
When the View Side by Side command is turned on, what other command is also active?
Synchronous Scrolling
When viewing workbooks side by side, the _______________ is automatically activated.
Synchronous Scrolling
________ is when viewing two workbooks side by side with the View Side by Side command, the workbooks scroll together.
Synchronous Scrolling
If Sara has a Microsoft Excel file that she uses over and over again by copying and pasting it, what file type could she use to save her file that will allow her to create new files from it instead of copying and pasting the file?
Template
Do not type commas and dollar signs when entering numbers in cells.
True
The automatically updated properties cannot be changed by a user.
True
When entering numbers in cells, type only the number and no symbols except for a preceding hyphen (-) if the number is negative.
True
When Kim was working in her Microsoft® Excel® spreadsheet, she accidentally placed her book on the spacebar and erased the contents of cell B12. What tool can she use to fix her error?
Undo
Bill has several workbooks open, and he would like to see them all side by side on the screen. Which option on the Arrange All menu should he use?
Vertical
Windows Live SkyDrive
a free cloud computing service from Microsoft for storing and sharing computer files that is accessed through Live, Hotmail®, Messenger®, or Xbox LIVE®
Clipboard
a holding place for cut or copied text
If the scroll box in a scroll bar is small, there is _________ data that cannot be seen in the current screen.
a lot of
cell
a rectangle in an Excel spreadsheet, where a column and row intersect
print area
a selected portion of the worksheet that will be printed
numerical series
a series of numbers that advance by a set amount
The document panel displays ______ the document.
above
scroll box
appears in a scroll bar and indicates the approximate location you are viewing in a worksheet
encrypt with password
applies a password to the workbook that must be entered when opening the workbook
Clicking on the File tab displays the _____.
backstage view
Go to the _______ to print files.
backstage view
What does the mouse pointer look like when filling a cell?
black cross
custom borders
borders with formats not found on the Border tool
Which one of the following is not a preset Auto Fill option?
colors
custom fill colors
colors and pattern formats that are not found on the Fill Colors tool
Use the horizontal scroll bar to navigate through the _______.
columns
center on page
command that centers worksheets horizontally and/or vertically on a page
Center Across Selection
command used to center data across selected cells without merging the cells
Delete Sheet Columns
command used to delete columns
Merge Across
command used to merge the selected cells into one cell for each row selected
undo
command used to undo the last command performed
The red indicator triangle in a cell indicates that the cell contains a _________.
comment
Mikala needs to put a note on the Average cell in her worksheet. She should use the ________ feature to insert the note.
comments
To insert notes into a worksheet, insert ________ in cells.
comments
The View Side by Side command is used to view and ________ two workbook windows at one time.
compare
Data bars are a form of ________.
conditional formatting
When you protect the structure of a workbook with the Protect Workbook command, which of the following is not something that is protected?
copying a workbook file
page layout view
displays the worksheet as it will print on paper
Sheet tabs can be renamed by _______ on them.
double-clicking
If the cell to the right of the cell you are typing in is _________, the data can "bleed" over that cell.
empty
If you type more data than can be displayed in a cell and the cell to the right of it is _________, the data can bleed over the cell.
empty
The first step to auto fill a series of numbers is to _______.
enter the first two numbers in separate cells
A CSV file is used to _______ data from Microsoft Excel files.
export
______ is the color displayed inside a cell.
fill color
The Microsoft® Excel® application has several preset Auto Fill options, but ______ is not one of the presets.
formats
number formats
formats that can be applied to numbers
font formats
formats you can apply to the data in cells
conditional formatting
formatting that is applied when cell data meets certain criteria
The _____ displays what's truly in a cell.
formula bar
Numbers are calculated in Excel using formulas and ______.
functions
rows
go across (horizontal)
To print the page numbers at the top of every page, insert the page number command in the ______.
header
Text and graphics inserted in this area print at the top of every page.
headers
To prevent certain columns from being displayed when printing a worksheet, _______ the columns.
hide
In the Page Layout view, the ruler measurement is displayed in _______.
inches
data
information you type in cells
When deleting cells, you need to decide whether the remaining cells will be shifted _______ or shifted _______.
left up
Microsoft SharePoint location
location for shared computer files that is accessed through Web pages
By default, all of the cells in a worksheet are _______.
locked
The white space around the top, bottom, left and right edges of a printed page are knows as the ________.
margins
Johnny uses Excel to check his ________ homework.
math
Excel workbooks can contain many worksheets, and the maximum number is limited only by the _____ of your computer.
memory limit
The Center Across Selection centers data across selected cells without _______ the cells.
merging
Details about a file are also known as ________.
metadata
To navigate to a specific cell, click in the _______ , type the cell address and hit Enter.
name box
Use the worksheet _____ tools in the lower left-hand corner of the Excel screen to scroll through the sheet tabs.
navigation
Which location for shared workbooks uses File Explorer to access the files?
network drives
Sidney is working in a workbook that contains three worksheets. She would like to view the worksheets side by side. To do so, first she must open each worksheet in a ______.
new window
comments
notes that can be attached to cells to add additional information that is not printed on the worksheet
Spreadsheets are used to calculate ______ formulas and manipulate data.
numerical
print settings
option to print the active sheets, print the entire workbook, or print the selected cells
When setting protection on a worksheet you may enter a _______, but be very careful to remember it, because Microsoft does not keep track of it for you.
password
cell styles
predefined formats used to quickly format cells
functions
preset calculations used for complex formulas in which you fill in the blanks with arguments
A PDF file is used to display a file as it will look when _______.
printed
When setting up Microsoft Excel workbooks for other people to use, you may want to ________ the worksheets for data entry.
protect
workbook protection
protects the structure of a workbook by not allowing worksheets to be moved, copied, deleted, or added
The command tools in Microsoft Excel are found on the ________.
ribbon
When inserting cells, you need to decide whether the remaining cells will be shifted ________ or shifted ________.
right down
To delete a comment, select the cell, _____ and choose Delete Comment.
right-click
_______ with the mouse on selected cells to initiate the shortcut for inserting or deleting cells.
right-click
scale to fit
scales worksheets to print smaller or larger than the actual font size
If a number entered in an unformatted cell is too long to be displayed in the cell, what will be displayed?
scientific notation
What displays in an unformatted cell when a number entered is too long to be displayed in the cell?
scientific notation
When there is too much data to view on one screen, use the _______ to navigate through the data with the mouse.
scroll bars
The ______ is used to change the date Auto Fill option.
smart tag
Microsoft Excel application
software used to create spreadsheets
headers
text and/or graphics that print at the top of each page
importing data
the act of adding data to an Excel worksheet from another software program or file
filling
the act of copying a cell or range of cells to adjacent cells (cells right next to the cell or range being copied)
save as
the act of saving a copy of a computer file with a different name
save
the act of storing a computer file
Point to _______ of a cell to fill the cell to the right or down.
the bottom right corner
document panel
the panel that can be displayed above a document to add and change the document properties
gridlines
the vertical and horizontal lines that display in a worksheet to outline the cells
margins
the white space left around the edges of the paper when a worksheet is printed
smart tag
tool that appears that allows you to choose options without using the tools on the ribbon
Clear tool
tool used to clear the contents, formats, comments, and/or hyperlinks from cells
Protecting a worksheet for data entry is a ______-step process.
two
arrange all
used to view multiple open Excel windows at the same time in one Excel screen
view side by side
used to view two Excel windows side by side
Text Import Wizard
used to walk you through importing data into an Excel worksheet
Wrap Text tool
used to wrap text in a cell and make the row taller
workbook views
view settings for the workbook
zoom slider
view settings for the workbook
What does the mouse pointer look like when selecting a cell in the worksheet area?
white plus sign
What two things can you do to display the entire contents of a cell?
widen the column set Wrap Text formatting
An Excel file is called a _______ because it can contain many worksheets.
workbook
Each ______ in an Excel file can contain 16,384 columns and 1,048,576 rows.
worksheet
What is the file extension for a Microsoft Excel 2010 file?
.xlsx
When ______ is typed in a cell, it will be right-aligned.
902.22
Callie is working in a large Excel worksheet with more than 110,000 rows. She needs to return to the beginning of the worksheet. What keyboard shortcut can she use to navigate to the beginning of the worksheet quickly?
Ctrl+Home
The keyboard shortcut to get to the beginning of a worksheet is _______.
Ctrl+Home
Connor is working in an extremely large Excel worksheet with more than 10,000 rows. He needs to return to the beginning of the worksheet. What keyboard shortcut can he use to navigate to the beginning of the worksheet quickly?
Ctrl-Home
Which key on your keyboard is used to delete the contents of selected cells all at once?
Delete
The Protect Workbook command is found in the ________ tab on the ribbon.
Review
If a worksheet has only a few columns that will print on a second page, change the Scale to Fit ________ command to 1 Page.
Width
In the Scale to Fit commands, set the _______ setting to 1 page to get all of the columns in a worksheet to print on one page.
Width
To Zoom in or out to an exact view percentage on an Excel worksheet, use the _______ tool.
Zoom level
a file format used to display a file as it will look when it prints
file name
a file name is given to each Microsoft Excel workbook you create to identify the file
range
a group of cells that are next to each other (adjacent) and form a rectangular shape
Auto Fill
allows you to quickly advance cell data while filling a cell or range of cells
The intersection of a column and row is called a ______.
cell
cell reference
cell address with column letter followed by row number
Cell addresses are also called ______.
cell references
To view data in a graphical format that is easier to understand, use Microsoft Excel _______.
charts
inspect document
checks a workbook file for any personally identifying and confidential information
fill color
color displayed inside a cell
Delete Sheet Rows
command used to delete rows
Delete Cells
command used to delete the selected cells
Insert Cells
command used to insert blank cells
Insert Sheet Columns
command used to insert blank columns
Insert Sheet Rows
command used to insert blank rows
Merge Cells
command used to merge selected cells into one cell
Merge and Center
command used to merge selected cells into one cell and center the data
Information typed in cells is known as _______.
data
alphabetical text
data made up of letters of the alphabet and symbols
alphanumerical text
data made up of the letters of the alphabet, symbols, and numbers
date/time
date and time data have numeric values
alignment formats
determine where data in cells will be aligned
page break
determines where a new page will start
page orientation
direction the text prints on the page
red indicator triangle
displays in a cell to indicate that it contains a comment
print preview
displays the worksheet as it will look when printed
These are the details about a file.
document properties
Text and graphics inserted in this area print at the bottom of every page.
footers
columns
go up and down (vertical)
Clicking on the sheet tab with the _______ adds another worksheet to an Excel file.
gold starburst
fill handle
green box in the bottom right corner of a cell or a range of cells
The ________ are the lines that display in a worksheet to mark the cells.
gridlines
To quickly return to the 100% view, click on the hash mark ______ of the Zoom slider tool.
in the middle
Sanford is creating an Excel spreadsheet and needs to insert many worksheets to organize his data. What is the limit of the number of worksheets Excel can contain?
limited to amount of memory in his computer
borders
lines that can be formatted to display on any edge of a cell
hyperlinks
links to Web pages or email addresses
Get External Data group
lists tools used to import data into an Excel worksheet
network drive
location at a workplace for storing computer files
noncalculated numbers as text
numbers that you won't calculate
The second step in protecting a worksheet for data entry is to ________.
protect the sheet with the Protect Sheet command
Merging cells can cause problems with commands such as _______ in worksheets.
sorting
selecting
the act of choosing cells
Point to _______ of a cell to select it.
the center
headings
the column letters and row numbers in the worksheet
document properties
the details about a file
When formatting numbers with the Accounting Number Format tool, the numbers are formatted with ______.
two decimal places
protecting a worksheet for data entry
unlocking cells that can be changed in a worksheet and protecting all of the other cells
formulas
used in the Excel application to create equations and usually contain cell addresses
advanced document properties
used to set all of the Document Properties in one place
Fill ______ skips the Saturday and Sunday dates in a date fill.
weekdays
To skip the Saturday and Sunday dates in a date Auto Fill, use the ______ option.
weekdays
When a workbook is encrypted with a password, when are you required to enter the password?
when opening the workbook
What does the mouse pointer look like when copying a cell with the drag method?
white arrow with a small plus sign
The move mouse pointer looks like a _______.
white arrow with black crosshairs
Text has a value of ______.
zero
The value of text is ______.
zero
The ______ view displays the worksheet the way it will look when it prints.
Page Layout
Which workbook view allows you to see how the worksheet will look when printed?
Page Layout
The scroll box is displayed outside of the scroll bars.
False
Tab name Group name Tool name
First step - Group name Second step - Tab name Third step - Tool name
The _______ workbook view displays blue lines that allow you to easily drag them to change the locations of page breaks in a worksheet.
Page Break Preview
Michael has created a worksheet that has one column overflowing onto a second page when it prints. Using what you learned in this lesson, what view could Michael switch to and quickly and easily change where the page breaks are to allow all of the columns to print on one page?
Page Break Preview view
Use the _______ Windows command to go back and forth between open workbooks.
Switch
The Arrange All command can arrange more than two Excel windows on a screen.
True
You can compare two open workbooks using the _____________ command.
View Side by Side
The _______________ tool is used to make data appear larger or smaller in a worksheet.
Zoom slider
cell address
another term for cell reference
One use of a spreadsheet is ______ to plan how to spend money.
budgeting
Which of the following is not a good use of a spreadsheet?
business letter
A simple way to think of the Excel application is as a giant ______.
calculator
Businesses use spreadsheets to keep track of financial________.
data
If you cannot find the command you need in a group on the ribbon, click on the _______ tool to display more options.
dialog box launcher
formula bar
displays what's truly in a cell
navigation keyboard shortcuts
key combinations on your keyboard used to quickly perform commands without using the mouse
Worksheet columns are labeled with ______.
letters
Microsoft Excel can be used to calculate _______ payments.
loan
Which of the following are good uses of a Microsoft Excel spreadsheet? Choose all that apply.
loan payments payroll math homework
Use the ______ to navigate quickly to a specific cell.
name box
Spreadsheets are used to calculate ______.
numbers
Worksheet rows are labeled with _____.
numbers
synchronous scrolling
used in conjunction with the Side by Side command to scroll through both windows at the same time
spreadsheets
used to calculate numerical formulas and manipulate data
freeze panes
used to freeze columns and rows on the screen
worksheet navigation tools
used to navigate through sheet tabs
new window
used to open a new window of the same workbook, allowing a user to view multiple worksheets from the same workbook at the same time
scroll bars
used to scroll through worksheets
split
used to split a worksheet into two or four window panes
switch windows
used to switch between open windows
Microsoft Excel charts give a _______ representation of data that can make the data easier to understand.
visual
page break
where data breaks and prints on the next page