,TESTBANK FOR GO! Microsoft 365 Excel 2025, 1st
edition Shelley Gaskin
Notes
1- The file is chapter after chapter.
2- We have shown you few pages sample.
3- The file contains all Appendix and Excel sheet
if it exists.
4- We have all what you need, we make update
at every time. There are many new editions
waiting you.
5- If you think you purchased the wrong file You
can contact us at every time, we can replace it
with true one.
Our email:
,GO! Microsoft 365: Excel 2025 (Gaskin)
Excel Chapter 1 Creating a Worksheet and Charting Data
1) The ________ view is the default view for all Excel worksheets.
A) A workbook is also called a spreadsheet.
B) A workbook contains pages called worksheets.
C) The default zoom level is set to 75%.
D) A workbook can contain only one worksheet.
Answer: B
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
2) The ________ view is the default view for all Excel worksheets.
A) Page Layout
B) Backstage
C) Print Preview
D) Normal
Answer: D
Diff: 2
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
3) The worksheet grid area displays the columns and rows that intersect to form the worksheet's
________.
A) ribbon
B) sheet tabs
C) cells
D) Name Box
Answer: C
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
4) In Excel, row headings are identified by ________.
A) numbers
B) Roman numerals
C) uppercase letters
D) lowercase letters
Answer: A
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
1
Copyright © 2026 Pearson Education, Inc.
,5) When you type data in a cell and select Enter, what cell becomes the active cell?
A) The cell to the left
B) The cell to the right
C) The cell above
D) The cell below
Answer: D
Diff: 2
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
6) A cell address is also referred to as a(n) ________.
A) label
B) cell reference
C) active cell
D) value
Answer: B
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
7) Using a touchscreen, which of the following actions is the same as selecting a range?
A) Slide right
B) Press and hold for a few seconds
C) Tap the first cell and drag
D) Touch the screen with two fingers
Answer: C
Diff: 1
Objective: E1.02. Enter Data in a Worksheet
8) A text value in Excel is also referred to as a ________.
A) label
B) formula
C) constant
D) cell address
Answer: A
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
9) When you type text in a cell it is ________.
A) left-aligned
B) fully justified
C) right-aligned
D) centered
Answer: A
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
2
Copyright © 2026 Pearson Education, Inc.
,10) Where is the fill handle located?
A) On the status bar
B) On the Formula Bar
C) In the lower right corner of a selected cell
D) In the top right corner of a selected cell
Answer: C
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
11) ________ is the keyboard shortcut for moving up one cell.
A) Shift+Enter
B) Home
C) Ctrl+Home
D) Page up
Answer: A
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
12) ________ is a procedure that determines which digit at the right of a number will be the last
digit displayed.
A) Auto Fill
B) Alignment
C) AutoComplete
D) Rounding
Answer: D
Diff: 1
Objective: E1.02. Enter Data in a Worksheet
13) A(n) ________ is prewritten in Excel to look at one or more values, perform an operation,
and then return a value.
A) constant
B) operator
C) function
D) formula
Answer: C
Diff: 1
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
14) All Excel formulas begin with a(n) ________ sign.
A) #
B) %
C) =
D) +
Answer: C
Diff: 1
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
3
Copyright © 2026 Pearson Education, Inc.
,15) Which of the following is not a way to create a formula?
A) By using a button on the status bar
B) By typing
C) By using the point and click method
D) By using a Function button on the ribbon
Answer: A
Diff: 2
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
16) A defined set of formatting characteristics such as font, font size, and font color are known
as a ________.
A) theme
B) cell style
C) label
D) series
Answer: B
Diff: 2
Objective: E1.04. Format Cells with Merge & Center, Cell Styles, and Themes
17) Hold down the ________ key to select nonadjacent cells or ranges.
A) Ctrl
B) Shift
C) F2
D) Alt
Answer: A
Diff: 2
Objective: E1.04. Format Cells with Merge & Center, Cell Styles, and Themes
18) Tiny charts embedded in cells that display a visual trend summary alongside your data are
called ________.
A) data series
B) data labels
C) sparklines
D) data markers
Answer: C
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
19) The value axis is also known as the ________.
A) category axis
B) legend
C) x-axis
D) y-axis
Answer: D
Diff: 3
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
4
Copyright © 2026 Pearson Education, Inc.
,20) Which of the following does not display to the right side of a selected chart?
A) Chart Styles button
B) Switch Row/Column button
C) Chart Filters button
D) Chart Elements button
Answer: B
Diff: 3
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
21) A chart value that originates in a worksheet cell is referred to as a ________.
A) data marker
B) data point
C) data series
D) legend
Answer: B
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
22) The keyboard shortcut for the Show Formulas command is ________.
A) Ctrl+Home
B) Shift+Enter
C) Ctrl+~
D) Alt+Backspace
Answer: C
Diff: 3
Objective: E1.06. Print a Worksheet, Display Formulas, and Close Excel
23) The ________ key is the keyboard shortcut for the Spelling command.
A) F7
B) F1
C) F2
D) F12
Answer: A
Diff: 3
Objective: E1.07. Check Spelling in a Worksheet
24) When you select a range of data, the ________ button displays.
A) Insert Options
B) Auto Fill Options
C) Quick Analysis
D) Warning
Answer: C
Diff: 2
Objective: E1.08. Enter Data by Range
5
Copyright © 2026 Pearson Education, Inc.
,25) Which of the following is an arithmetic operator?
A) $
B) >=
C) %
D) =
Answer: C
Diff: 2
Objective: E1.09. Construct Formulas for Mathematical Operations
26) The Comma Style format displays a number with ________ decimal place(s).
A) one
B) two
C) three
D) no
Answer: B
Diff: 1
Objective: E1.09. Construct Formulas for Mathematical Operations
27) The ________ visually displays which cells are included in a formula calculation.
A) displayed value
B) cell style
C) range finder
D) fill handle
Answer: C
Diff: 2
Objective: E1.09. Construct Formulas for Mathematical Operations
28) Which of the following is used to display the contents of a cell on multiple lines?
A) A theme
B) A label
C) The Wrap Text command
D) The AutoFit feature
Answer: C
Diff: 2
Objective: E1.11. Format a Worksheet
29) The Formula Bar displays the value or formula contained in the active cell.
Answer: TRUE
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
30) A cell that is outlined by a border in a worksheet is the active cell.
Answer: TRUE
Diff: 2
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
6
Copyright © 2026 Pearson Education, Inc.
,31) Auto Fill works only with text values.
Answer: FALSE
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
32) The fill handle is the small square in the lower right corner of a selected cell.
Answer: TRUE
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
33) When you select a range of data in a worksheet, the Quick Analysis tool displays in the
lower right corner of the selected range.
Answer: TRUE
Diff: 3
Objective: E1.02. Enter Data in a Worksheet
34) Center alignment is the default for all text entered into cells.
Answer: FALSE
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
35) Ctrl+= is a keyboard shortcut that starts the SUM function in a worksheet.
Answer: FALSE
Diff: 2
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
36) A relative cell reference is a reference based on the relative position of the cell that contains
the formula and the cells referred to in the formula.
Answer: TRUE
Diff: 3
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
37) After two or more cells are merged, each of the individual cells can still be selected.
Answer: FALSE
Diff: 1
Objective: E1.04. Format Cells with Merge & Center, Cell Styles, and Themes
38) A cell style includes font, font size, font color, cell borders, and cell shading.
Answer: TRUE
Diff: 1
Objective: E1.04. Format Cells with Merge & Center, Cell Styles, and Themes
39) Typically, you should include totals when creating a chart.
Answer: FALSE
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
7
Copyright © 2026 Pearson Education, Inc.
, 40) The category axis is also known as the x-axis.
Answer: TRUE
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
41) Recommended Charts is an Excel feature that displays a customized set of charts that,
according to Excel's calculations, will best fit your data.
Answer: TRUE
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
42) A data marker is a value that originates in a worksheet cell.
Answer: FALSE
Diff: 1
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
43) A data series is a collection of related data points.
Answer: TRUE
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
44) The Show Formulas button is a toggle button, meaning that it is either on or off.
Answer: TRUE
Diff: 2
Objective: E1.06. Print a Worksheet, Display Formulas, and Close Excel
45) When you enter a formula in a cell, the cell displays the result of the formula calculation.
Answer: TRUE
Diff: 1
Objective: E1.06. Print a Worksheet, Display Formulas, and Close Excel
46) Excel will check spelling in cells that contain formulas.
Answer: FALSE
Diff: 3
Objective: E1.07. Check Spelling in a Worksheet
47) Selecting the range before you enter data saves time because it confines the movement of the
active cell to the selected range.
Answer: TRUE
Diff: 2
Objective: E1.08. Enter Data by Range
48) The AutoCalculate feature displays three calculations in the status bar by default: Sum,
Minimum, and Maximum.
Answer: FALSE
Diff: 2
Objective: E1.09. Construct Formulas for Mathematical Operations
8
Copyright © 2026 Pearson Education, Inc.
edition Shelley Gaskin
Notes
1- The file is chapter after chapter.
2- We have shown you few pages sample.
3- The file contains all Appendix and Excel sheet
if it exists.
4- We have all what you need, we make update
at every time. There are many new editions
waiting you.
5- If you think you purchased the wrong file You
can contact us at every time, we can replace it
with true one.
Our email:
,GO! Microsoft 365: Excel 2025 (Gaskin)
Excel Chapter 1 Creating a Worksheet and Charting Data
1) The ________ view is the default view for all Excel worksheets.
A) A workbook is also called a spreadsheet.
B) A workbook contains pages called worksheets.
C) The default zoom level is set to 75%.
D) A workbook can contain only one worksheet.
Answer: B
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
2) The ________ view is the default view for all Excel worksheets.
A) Page Layout
B) Backstage
C) Print Preview
D) Normal
Answer: D
Diff: 2
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
3) The worksheet grid area displays the columns and rows that intersect to form the worksheet's
________.
A) ribbon
B) sheet tabs
C) cells
D) Name Box
Answer: C
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
4) In Excel, row headings are identified by ________.
A) numbers
B) Roman numerals
C) uppercase letters
D) lowercase letters
Answer: A
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
1
Copyright © 2026 Pearson Education, Inc.
,5) When you type data in a cell and select Enter, what cell becomes the active cell?
A) The cell to the left
B) The cell to the right
C) The cell above
D) The cell below
Answer: D
Diff: 2
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
6) A cell address is also referred to as a(n) ________.
A) label
B) cell reference
C) active cell
D) value
Answer: B
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
7) Using a touchscreen, which of the following actions is the same as selecting a range?
A) Slide right
B) Press and hold for a few seconds
C) Tap the first cell and drag
D) Touch the screen with two fingers
Answer: C
Diff: 1
Objective: E1.02. Enter Data in a Worksheet
8) A text value in Excel is also referred to as a ________.
A) label
B) formula
C) constant
D) cell address
Answer: A
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
9) When you type text in a cell it is ________.
A) left-aligned
B) fully justified
C) right-aligned
D) centered
Answer: A
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
2
Copyright © 2026 Pearson Education, Inc.
,10) Where is the fill handle located?
A) On the status bar
B) On the Formula Bar
C) In the lower right corner of a selected cell
D) In the top right corner of a selected cell
Answer: C
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
11) ________ is the keyboard shortcut for moving up one cell.
A) Shift+Enter
B) Home
C) Ctrl+Home
D) Page up
Answer: A
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
12) ________ is a procedure that determines which digit at the right of a number will be the last
digit displayed.
A) Auto Fill
B) Alignment
C) AutoComplete
D) Rounding
Answer: D
Diff: 1
Objective: E1.02. Enter Data in a Worksheet
13) A(n) ________ is prewritten in Excel to look at one or more values, perform an operation,
and then return a value.
A) constant
B) operator
C) function
D) formula
Answer: C
Diff: 1
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
14) All Excel formulas begin with a(n) ________ sign.
A) #
B) %
C) =
D) +
Answer: C
Diff: 1
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
3
Copyright © 2026 Pearson Education, Inc.
,15) Which of the following is not a way to create a formula?
A) By using a button on the status bar
B) By typing
C) By using the point and click method
D) By using a Function button on the ribbon
Answer: A
Diff: 2
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
16) A defined set of formatting characteristics such as font, font size, and font color are known
as a ________.
A) theme
B) cell style
C) label
D) series
Answer: B
Diff: 2
Objective: E1.04. Format Cells with Merge & Center, Cell Styles, and Themes
17) Hold down the ________ key to select nonadjacent cells or ranges.
A) Ctrl
B) Shift
C) F2
D) Alt
Answer: A
Diff: 2
Objective: E1.04. Format Cells with Merge & Center, Cell Styles, and Themes
18) Tiny charts embedded in cells that display a visual trend summary alongside your data are
called ________.
A) data series
B) data labels
C) sparklines
D) data markers
Answer: C
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
19) The value axis is also known as the ________.
A) category axis
B) legend
C) x-axis
D) y-axis
Answer: D
Diff: 3
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
4
Copyright © 2026 Pearson Education, Inc.
,20) Which of the following does not display to the right side of a selected chart?
A) Chart Styles button
B) Switch Row/Column button
C) Chart Filters button
D) Chart Elements button
Answer: B
Diff: 3
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
21) A chart value that originates in a worksheet cell is referred to as a ________.
A) data marker
B) data point
C) data series
D) legend
Answer: B
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
22) The keyboard shortcut for the Show Formulas command is ________.
A) Ctrl+Home
B) Shift+Enter
C) Ctrl+~
D) Alt+Backspace
Answer: C
Diff: 3
Objective: E1.06. Print a Worksheet, Display Formulas, and Close Excel
23) The ________ key is the keyboard shortcut for the Spelling command.
A) F7
B) F1
C) F2
D) F12
Answer: A
Diff: 3
Objective: E1.07. Check Spelling in a Worksheet
24) When you select a range of data, the ________ button displays.
A) Insert Options
B) Auto Fill Options
C) Quick Analysis
D) Warning
Answer: C
Diff: 2
Objective: E1.08. Enter Data by Range
5
Copyright © 2026 Pearson Education, Inc.
,25) Which of the following is an arithmetic operator?
A) $
B) >=
C) %
D) =
Answer: C
Diff: 2
Objective: E1.09. Construct Formulas for Mathematical Operations
26) The Comma Style format displays a number with ________ decimal place(s).
A) one
B) two
C) three
D) no
Answer: B
Diff: 1
Objective: E1.09. Construct Formulas for Mathematical Operations
27) The ________ visually displays which cells are included in a formula calculation.
A) displayed value
B) cell style
C) range finder
D) fill handle
Answer: C
Diff: 2
Objective: E1.09. Construct Formulas for Mathematical Operations
28) Which of the following is used to display the contents of a cell on multiple lines?
A) A theme
B) A label
C) The Wrap Text command
D) The AutoFit feature
Answer: C
Diff: 2
Objective: E1.11. Format a Worksheet
29) The Formula Bar displays the value or formula contained in the active cell.
Answer: TRUE
Diff: 1
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
30) A cell that is outlined by a border in a worksheet is the active cell.
Answer: TRUE
Diff: 2
Objective: E1.01. Create, Save, and Navigate an Excel Workbook
6
Copyright © 2026 Pearson Education, Inc.
,31) Auto Fill works only with text values.
Answer: FALSE
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
32) The fill handle is the small square in the lower right corner of a selected cell.
Answer: TRUE
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
33) When you select a range of data in a worksheet, the Quick Analysis tool displays in the
lower right corner of the selected range.
Answer: TRUE
Diff: 3
Objective: E1.02. Enter Data in a Worksheet
34) Center alignment is the default for all text entered into cells.
Answer: FALSE
Diff: 2
Objective: E1.02. Enter Data in a Worksheet
35) Ctrl+= is a keyboard shortcut that starts the SUM function in a worksheet.
Answer: FALSE
Diff: 2
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
36) A relative cell reference is a reference based on the relative position of the cell that contains
the formula and the cells referred to in the formula.
Answer: TRUE
Diff: 3
Objective: E1.03. Construct and Copy Formulas and Use the SUM Function
37) After two or more cells are merged, each of the individual cells can still be selected.
Answer: FALSE
Diff: 1
Objective: E1.04. Format Cells with Merge & Center, Cell Styles, and Themes
38) A cell style includes font, font size, font color, cell borders, and cell shading.
Answer: TRUE
Diff: 1
Objective: E1.04. Format Cells with Merge & Center, Cell Styles, and Themes
39) Typically, you should include totals when creating a chart.
Answer: FALSE
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
7
Copyright © 2026 Pearson Education, Inc.
, 40) The category axis is also known as the x-axis.
Answer: TRUE
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
41) Recommended Charts is an Excel feature that displays a customized set of charts that,
according to Excel's calculations, will best fit your data.
Answer: TRUE
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
42) A data marker is a value that originates in a worksheet cell.
Answer: FALSE
Diff: 1
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
43) A data series is a collection of related data points.
Answer: TRUE
Diff: 2
Objective: E1.05. Chart Data to Create a Column Chart and Insert Sparklines
44) The Show Formulas button is a toggle button, meaning that it is either on or off.
Answer: TRUE
Diff: 2
Objective: E1.06. Print a Worksheet, Display Formulas, and Close Excel
45) When you enter a formula in a cell, the cell displays the result of the formula calculation.
Answer: TRUE
Diff: 1
Objective: E1.06. Print a Worksheet, Display Formulas, and Close Excel
46) Excel will check spelling in cells that contain formulas.
Answer: FALSE
Diff: 3
Objective: E1.07. Check Spelling in a Worksheet
47) Selecting the range before you enter data saves time because it confines the movement of the
active cell to the selected range.
Answer: TRUE
Diff: 2
Objective: E1.08. Enter Data by Range
48) The AutoCalculate feature displays three calculations in the status bar by default: Sum,
Minimum, and Maximum.
Answer: FALSE
Diff: 2
Objective: E1.09. Construct Formulas for Mathematical Operations
8
Copyright © 2026 Pearson Education, Inc.
