Midterm

Front 1

Which of the following is the default method
for summarizing data in a PivotTable?

Back 1

Sum

Front 2

David wants to change all occurrences of
"North Carolina" to "NC" in his
spreadsheet. What command should he use
to complete this task?

Back 2

Find and Replace

Front 3

What command do you use to increase or
decrease the view of a selected cell or range
of cells to fill the Excel Window area for
better visibility?

Back 3

Zoom to Selection

Front 4

Which tab in the PivotChart Tools Ribbon
allows a user to apply chart titles to the
PivotChart?

Back 4

Layout

Front 5

In a worksheet, which command suggests
other words with a similar meaning that
can be used?

Back 5

Thesaurus

Front 6

Larkeysha has created a spreadsheet
containing student grades. Which function
would she use to return the current date in
cell A1?

Back 6

TODAY

Front 7

Jim would like to print only the cell range
A1:F20. What page setup option should he
change?

Back 7

Print Area

Front 8

How do you quickly modify a table style to
meet user preferences

Back 8

Right-click on a style and choose
Duplicate

Front 9

John notices that column D is not showing
on his spreadsheet. What action does he
need to take to view column D

Back 9

Unhide

Front 10

Which tab do you use to display the area
that contains the print command?

Back 10

File

Front 11

Jennifer is calculating her GPA. If she uses
"=(A1+A2+A3+A4)/4", this is an example
of which type of entry?

Back 11

formulas

Front 12

What is the process of viewing a PivotTable
report for a subset that meets the criterion
only?

Back 12

Filtering

Front 13

Which Chart Tools Ribbon tab enables a
user to apply a style to the selected chart?

Back 13

Format

Front 14

Which is an interactive view of worksheet
data that gives a user the ability to
summarize the data by selecting categories
in which to group the data?

Back 14

PivotTable

Front 15

Gabriel needs to create a shortcut formula
in cell B40 to calculate total sales located in
cells B1 through B39. Which function
should he create?

Back 15

=SUM(B1:B39)

Front 16

Which ribbon is visible when a PivotTable is
selected, and allows a user to apply various
styles to the PivotTable?

Back 16

Design

Front 17

John wants to identify the exact value that
each column in his chart represents. Which
option should he choose?

Back 17

Labels

Front 18

Sharon's spreadsheet contains information
about the number of music downloads in
F25. "25" identifies the:

Back 18

Row

Front 19

John would like to display the count of
employees last name on the Y-axis. What
area would he drag this information to in
order to display correctly?

Back 19

Values

Front 20

Dorothy designed a column chart and
would like to change the background color
to yellow. Which chart feature should she
modify?

Back 20

Plot Area

Front 21

Which command on the Fill options dialog
box is the default option?

Back 21

Fill Series

Front 22

Trey would like to outline the cell range
A1:F20. Which formatting style should he
select?

Back 22

Borders

Front 23

What Home Ribbon group contains the
command used for quickly converting
selected cells to a table by choosing a table
style?

Back 23

Styles

Front 24

Which group on the View Ribbon enables a
user to show or hide the ruler, gridlines,
Formula Bar, or headings?

Back 24

Show

Front 25

What command limits structural changes,
such as adding, deleting, or moving sheets,
that can be made in a workbook?

Back 25

Protect Workbook

Front 26

Joyce needs to access a spreadsheet she
saved yesterday. Which command would
she select?

Back 26

Open

Front 27

What occurs when the cursor is moved over
a cell and a user clicks?

Back 27

The cell is selected

Front 28

What ribbon contains the commands for
creating charts in Microsoft Excel?

Back 28

Insert

Front 29

Alicia needs to move the data in cell B5 to
cell E5. Which command would she select?

Back 29

Cut

Front 30

What feature was created for users who
prefer to use the keyboard rather than the
mouse, and provides keyboard code icons
that may be used in conjunction with the
ALT key?

Back 30

Hot Keys

Front 31

Jennifer needs to identify the values in
column B for a statistics report. Which type
of entry should she use in the column
header?

Back 31

labels

Front 32

John wants to change the chart style on his
Pivot table. Which Pivot Table chart tools
tab would he create?

Back 32

Design

Front 33

How would you move sheet tabs to a new
position in the workbook

Back 33

Click and drag the sheet tab to the new
location

Front 34

Which ribbon contains commands to add a
comment about a selected cell in a
worksheet?

Back 34

Review

Front 35

Joan is showing her spreadsheet to a
customer and does not want the customer to
be able to see the wholesale prices column.
What option should she choose?

Back 35

Hide

Front 36

Which command on the Home Ribbon joins
selected cells into one and centers that
content into a larger single cell?

Back 36

Merge & Center

Front 37

What command do you use to apply a
background color to cells in a worksheet?

Back 37

Fill Color

Front 38

Which area, on the left side of the formula
bar, can you look at to determine the cell
address of a selected cell?

Back 38

Name box

Front 39

Which command do you use to reduce the
margin between the border and the text in
an indented cell?

Back 39

Decrease Indent

Front 40

What is the name of the list of frequently
used Excel commands available when a user
right-clicks an item in the worksheet?

Back 40

Shortcut Menu

Front 41

Which command on the Home Ribbon do
you use to format row height and column
width, organize sheets, and protect or hide
cells in a workshee

Back 41

Format

Front 42

Edward would like to create a chart that
shows the trend in iPod sales over the past 2
years. Which chart type should he create

Back 42

Line

Front 43

How is an exact copy of a worksheet
created within the same workbook?

Back 43

Right-click the sheet tab, then choose
Move or Copy from the Shortcut Menu

Front 44

What is the process of bringing data
containing text fields separated by commas
into Excel called?

Back 44

Importing data

Front 45

Which of the following notebook- like
features organizes the sheets for use in
Excel?

Back 45

Workbook

Front 46

Which is the name of an interactive
graphical representation of data that allows
a user to change the groupings?

Back 46

PivotChart

Front 47

Which command on the Home Ribbon do
you use to replace information in a selected
cell with new information or new
formatting?

Back 47

Find & Select

Front 48

How is a cell reference in a formula and its
corresponding location in a worksheet
identified?

Back 48

Cell reference and cell location are
outlined in matching colors 67