Exploring Microsoft Office 365: Excel 2025 (Poatsy)
Chapter 1 Introduction to Excel: Workbook and Worksheet Basics
1) New workbooks typically contain how many worksheets?
A) 0
B) 1
C) 2
D) 3
Answer: B
Diff: 2
Objective: E1.01 Explore the Excel Window
2) What is the small green square in the bottom right of a cell called?
A) Sizing handle
B) Fill handle
C) Copy/Paste handle
D) Move Cell handle
Answer: B
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
3) What feature in Excel allows you to begin with a 1 in A1 and a 2 in A2 and complete the
sequence through the number 30 in A30 without having to type in the entire sequence?
A) Auto Copy
B) There is no such feature in Excel.
C) Auto Complete
D) Auto Fill
Answer: D
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
4) What do you adjust if you see ###### displayed in a cell?
A) Number format
B) Row height
C) Formula in the cell
D) Column width
Answer: D
Diff: 3
Objective: E1.04 Manage Columns and Rows
1
Copyright © 2026
,5) Which of the following is not true about a Fill color?
A) It is color that displays behind the data in the cell.
B) It can help the data stand out.
C) It cannot be applied to an entire row or column.
D) It should contrast with the font color.
Answer: C
Diff: 2
Objective: E1.06 Apply Cell Styles, Cell Alignment, and Font Options
6) Which of the following would not be considered text?
A) Phone number (111.111.1111)
B) Social Security number (111-11-1111)
C) Part number (PT111)
D) =2*2
Answer: D
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
7) What does pressing the Enter key while in a cell, do?
A) The current active cell remains the active cell
B) The cell to the right becomes the active cell
C) The cell below becomes the active cell
D) The action is the same as pressing the Tab key
Answer: C
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
8) Which keyboard shortcut puts the user in cell edit mode?
A) F2
B) Shift F2
C) F3
D) Shift F3
Answer: A
Diff: 3
Objective: E1.02 Enter and Edit Cell Data
9) Which of the following is not true of the Formula bar?
A) You can edit cell contents there.
B) It is to the right of the Insert Function command.
C) It allows you to pick from an assortment of formulas.
D) It displays the contents stored in the active cell.
Answer: C
Diff: 2
Objective: E1.01 Explore the Excel Window
2
Copyright © 2026
,10) How is text aligned by default?
A) Left
B) Center
C) Right
D) Decimal
Answer: A
Diff: 1
Objective: E1.02 Enter and Edit Cell Data
11) Which of the following is not a valid formula?
A) =D3
B) =2*2
C) =sum(1,2,3,4,5)
D) =#12/31/2018#-#12/31/2019#
Answer: D
Diff: 3
Objective: E1.03 Create Formulas
12) What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?
A) How to do date calculations
B) Order of operations
C) Naming convention for cell ranges
D) The various printing options available in Excel
Answer: B
Diff: 3
Objective: E1.03 Create Formulas
13) In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?
A) 5/6
B) 1+
C) (2-3)
D) 6^2
Answer: C
Diff: 3
Objective: E1.03 Create Formulas
14) In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate second?
A) 5/6
B) 1+
C) (2-3)
D) 6^2
Answer: D
Diff: 3
Objective: E1.03 Create Formulas
3
Copyright © 2026
, 15) What is the true about an input area?
A) It is used when certain values are used repeatedly throughout the worksheet.
B) It is useful when your values change frequently throughout the worksheet.
C) It should be located below the rest of your data.
D) It should only contain one input cell.
Answer: A
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
16) What should you do if there are columns you need, but do not want to display?
A) Delete the columns you do not want to display then undo your action when finished.
B) Move the columns you want to see so that they are together then move them back to their
original locations with finished.
C) Cut and paste the columns you do not want to display to another area of the worksheet.
D) Hide the columns you do not want to display, then unhide them when finished.
Answer: D
Diff: 2
Objective: E1.04 Manage Columns and Rows
17) What does it mean when you see ####### in a cell?
A) Your formula is incorrect.
B) At least one of the cell references in your formula is pointing to an empty cell.
C) Your column is not wide enough.
D) Your row is not tall enough.
Answer: C
Diff: 2
Objective: E1.04 Manage Columns and Rows
18) One point is how big?
A) 1/72 of an inch
B) 1/36 of an inch
C) The same as a pixel
D) The same as one character
Answer: A
Diff: 3
Objective: E1.04 Manage Columns and Rows
19) Which of the following is not a way to widen a column?
A) Drag the line between the column headings to the desired size
B) Click on the Column label and drag it to the right
C) Double-click the line between the column headings
D) Right-click a column heading and select Column Width
Answer: B
Diff: 3
Objective: E1.04 Manage Columns and Rows
4
Copyright © 2026
Chapter 1 Introduction to Excel: Workbook and Worksheet Basics
1) New workbooks typically contain how many worksheets?
A) 0
B) 1
C) 2
D) 3
Answer: B
Diff: 2
Objective: E1.01 Explore the Excel Window
2) What is the small green square in the bottom right of a cell called?
A) Sizing handle
B) Fill handle
C) Copy/Paste handle
D) Move Cell handle
Answer: B
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
3) What feature in Excel allows you to begin with a 1 in A1 and a 2 in A2 and complete the
sequence through the number 30 in A30 without having to type in the entire sequence?
A) Auto Copy
B) There is no such feature in Excel.
C) Auto Complete
D) Auto Fill
Answer: D
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
4) What do you adjust if you see ###### displayed in a cell?
A) Number format
B) Row height
C) Formula in the cell
D) Column width
Answer: D
Diff: 3
Objective: E1.04 Manage Columns and Rows
1
Copyright © 2026
,5) Which of the following is not true about a Fill color?
A) It is color that displays behind the data in the cell.
B) It can help the data stand out.
C) It cannot be applied to an entire row or column.
D) It should contrast with the font color.
Answer: C
Diff: 2
Objective: E1.06 Apply Cell Styles, Cell Alignment, and Font Options
6) Which of the following would not be considered text?
A) Phone number (111.111.1111)
B) Social Security number (111-11-1111)
C) Part number (PT111)
D) =2*2
Answer: D
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
7) What does pressing the Enter key while in a cell, do?
A) The current active cell remains the active cell
B) The cell to the right becomes the active cell
C) The cell below becomes the active cell
D) The action is the same as pressing the Tab key
Answer: C
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
8) Which keyboard shortcut puts the user in cell edit mode?
A) F2
B) Shift F2
C) F3
D) Shift F3
Answer: A
Diff: 3
Objective: E1.02 Enter and Edit Cell Data
9) Which of the following is not true of the Formula bar?
A) You can edit cell contents there.
B) It is to the right of the Insert Function command.
C) It allows you to pick from an assortment of formulas.
D) It displays the contents stored in the active cell.
Answer: C
Diff: 2
Objective: E1.01 Explore the Excel Window
2
Copyright © 2026
,10) How is text aligned by default?
A) Left
B) Center
C) Right
D) Decimal
Answer: A
Diff: 1
Objective: E1.02 Enter and Edit Cell Data
11) Which of the following is not a valid formula?
A) =D3
B) =2*2
C) =sum(1,2,3,4,5)
D) =#12/31/2018#-#12/31/2019#
Answer: D
Diff: 3
Objective: E1.03 Create Formulas
12) What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?
A) How to do date calculations
B) Order of operations
C) Naming convention for cell ranges
D) The various printing options available in Excel
Answer: B
Diff: 3
Objective: E1.03 Create Formulas
13) In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?
A) 5/6
B) 1+
C) (2-3)
D) 6^2
Answer: C
Diff: 3
Objective: E1.03 Create Formulas
14) In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate second?
A) 5/6
B) 1+
C) (2-3)
D) 6^2
Answer: D
Diff: 3
Objective: E1.03 Create Formulas
3
Copyright © 2026
, 15) What is the true about an input area?
A) It is used when certain values are used repeatedly throughout the worksheet.
B) It is useful when your values change frequently throughout the worksheet.
C) It should be located below the rest of your data.
D) It should only contain one input cell.
Answer: A
Diff: 2
Objective: E1.02 Enter and Edit Cell Data
16) What should you do if there are columns you need, but do not want to display?
A) Delete the columns you do not want to display then undo your action when finished.
B) Move the columns you want to see so that they are together then move them back to their
original locations with finished.
C) Cut and paste the columns you do not want to display to another area of the worksheet.
D) Hide the columns you do not want to display, then unhide them when finished.
Answer: D
Diff: 2
Objective: E1.04 Manage Columns and Rows
17) What does it mean when you see ####### in a cell?
A) Your formula is incorrect.
B) At least one of the cell references in your formula is pointing to an empty cell.
C) Your column is not wide enough.
D) Your row is not tall enough.
Answer: C
Diff: 2
Objective: E1.04 Manage Columns and Rows
18) One point is how big?
A) 1/72 of an inch
B) 1/36 of an inch
C) The same as a pixel
D) The same as one character
Answer: A
Diff: 3
Objective: E1.04 Manage Columns and Rows
19) Which of the following is not a way to widen a column?
A) Drag the line between the column headings to the desired size
B) Click on the Column label and drag it to the right
C) Double-click the line between the column headings
D) Right-click a column heading and select Column Width
Answer: B
Diff: 3
Objective: E1.04 Manage Columns and Rows
4
Copyright © 2026
