Comp II

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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

PDF

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


Ensembles d'études connexes

Geometry Chapter 1: Perimeter and Area Formulas

View Set

N300 Exam 2: Lower Respiratory Infections

View Set

Exam 2: Assignments & Test Questions

View Set

Chapter 42 #2 - Upper GI Bleeding

View Set

Chapter 20 Management of Patients with Chronic Pulmonary Disease PrepU

View Set

Organizational Communication Exam 1

View Set

Urinary Elimination practice quiz

View Set

Characteristics of Living Organisms (from Holt Biology)

View Set