Midterm Corrections

Front 1

Screenshot

Back 1

Which command on the Insert Ribbon
enables a user to insert a picture of a
program window into a worksheet?

Front 2

Find & Select

Back 2

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

Front 3

Margins

Back 3

Which term describes the blank portions of
a page that fall outside the main body of the
printed document?

Front 4

TODAY
- 9_12BEBM20-EXAM1 - Print Test https://elements.schools.nc.gov/iredell/display.asp?fo=search results&rm...
3

Back 4

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

Front 5

Design

Back 5

Joan has entered her name in the First
Name field in cell B2 of her table. What
does her First Name represent in the table?

Front 6

=MAX(D1:D13)

Back 6

Wendy has created a spreadsheet to keep
track of company sales. Sales for the East
region are located in cells D1 through D13.
Which function would she use to find the
highest sales for the East region?

Front 7

Workbook

Back 7

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

Front 8

Right-click on a style and choose
Duplicate

Back 8

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

Front 9

Format Cells

Back 9

Which dialog box contains the commands to
specify an exact date and time format to use
for a selected cell in a worksheet?

Front 10

Labels

Back 10

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

Front 11

Hot Keys

Back 11

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?

Front 12

Relative reference

Back 12

When copying values in Microsoft Excel,
which feature automatically adjusts cell
references for the new copy location?

Front 13

Tab Color

Back 13

Virgil wants to emphasize the sheet tabs in
his workbook. Which command should he
choose?

Front 14

Slicers

Back 14

What are graphical objects that contain
buttons a user can click to filter the data in
PivotTables and PivotCharts?

Front 15

Cut

Back 15

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

Front 16

Importing data

Back 16

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

Front 17

Hide

Back 17

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?

Front 18

Page Layout

Back 18

Which ribbon contains the command to
apply a theme to a worksheet in Microsoft
Excel?

Front 19

Numeric data and titles

Back 19

What is typically included in the range of
data selected to create a chart?

Front 20

Format

Back 20

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

Front 21

Ctrl + 1

Back 21

Joan wants to format the cells in her
spreadsheet. What is the shortcut that will
open the format dialog box?

Front 22

Values

Back 22

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?

Front 23

Cell reference and cell location are
outlined in matching colors

Back 23

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

Front 24

Sum

Back 24

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

Front 25

Row

Back 25

Joan has a table that includes demographic
information about her employees. What
does all the information about one employee
represent?

Front 26

Fill Series

Back 26

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

Front 27

Decrease Indent

Back 27

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

Front 28

Format

Back 28

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 worksheet?

Front 29

Row

Back 29

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

Front 30

Protect Workbook

Back 30

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