INTRO TO SPREADSHEETS - D100 WGU NEWEST 2025
ACTUAL EXAM COMPLETE QUESTIONS AND - ANSWER-:
ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED A+
Section 1: Excel Fundamentals & Navigation (Questions 1-15)
1. You have a workbook with multiple worksheets. Which keyboard shortcut
allows you to move to the next worksheet?
A) Ctrl + Page Up
B) Ctrl + Page Down
C) Alt + Page Down
D) Shift + Tab
Rationale: (B) - answer-: . Ctrl + Page Down moves to the next worksheet. Ctrl +
Page Up (A) moves to the previous worksheet. Alt + Page Down (C) scrolls right
one screen. Shift + Tab (D) moves to the previous cell.
2. Which Excel feature allows you to view two different parts of the same
worksheet simultaneously?
A) Split
B) Freeze Panes
C) New Window
D) Arrange All
Rationale: (A) - answer-: . The Split feature divides the worksheet into separate
panes that can be scrolled independently. Freeze Panes (B) keeps rows/columns
visible while scrolling. New Window (C) creates another window of the same
workbook. Arrange All (D) organizes multiple workbook windows.
3. What is the maximum number of rows in an Excel worksheet?
A) 65,536
B) 1,048,576
C) 16,384
D) 1,073,741,824
Rationale: (B) - answer-: . Excel worksheets have 1,048,576 rows (2^20). 65,536
,(A) was the limit in Excel 2003 and earlier. 16,384 (C) is the number of columns
(2^14). 1,073,741,824 (D) is the total cells (rows × columns).
4. Which data type would Excel automatically align to the left side of a cell by
default?
A) Numbers
B) Dates
C) Currency
D) Text
Rationale: (D) - answer-: . Text is left-aligned by default. Numbers, dates, and
currency (A, B, C) are right-aligned by default.
5. You want to quickly select all cells that contain formulas in your worksheet.
Which feature should you use?
A) Find and Replace
B) Go To Special
C) Data Validation
D) Conditional Formatting
Rationale: (B) - answer-: . Go To Special → Formulas selects all cells containing
formulas. Find and Replace (A) can find formulas but is less efficient. Data
Validation (C) restricts data entry. Conditional Formatting (D) changes cell
appearance based on conditions.
6. Which of the following is NOT a valid cell reference in Excel?
A) $A$1
B) A$1
C) $A1
D) $A$1$
Rationale: (D) - answer-: . $A$1$ is invalid—the $ symbol can only appear before
the column letter and/or row number. $A$1 (A) is absolute reference. A$1 (B) is
mixed reference (column relative, row absolute). $A1 (C) is mixed reference
(column absolute, row relative).
7. You want to display the current date in a cell, and you want it to update
automatically each day. Which function should you use?
A) =DATE()
B) =NOW()
,C) =TODAY()
D) =CURRENTDATE()
Rationale: (C) - answer-: . =TODAY() returns the current date and updates
automatically. =DATE() (A) requires year, month, day arguments. =NOW() (B)
returns current date and time. =CURRENTDATE() (D) is not a valid Excel function.
8. Which feature allows you to see the results of a formula without permanently
changing the data?
A) Scenario Manager
B) Goal Seek
C) Data Table
D) Watch Window
Rationale: (A) - answer-: . Scenario Manager allows you to create and save
different sets of values and see the results without changing the actual data. Goal
Seek (B) finds input to achieve a desired result. Data Table (C) shows multiple
results for different inputs. Watch Window (D) monitors cell values.
9. You have a column of numbers and want to quickly identify the highest value.
Which feature provides the fastest solution?
A) Sort Descending
B) MAX function
C) Conditional Formatting → Top 10
D) AutoSum → Max
Rationale: (D) - answer-: . AutoSum → Max quickly inserts the MAX function and
selects the adjacent range. Sort Descending (A) reorganizes data. MAX function
(B) requires manual entry. Conditional Formatting (C) highlights but doesn't show
the value.
10. Which keyboard shortcut creates a new workbook?
A) Ctrl + N
B) Ctrl + W
C) Ctrl + O
D) Ctrl + S
Rationale: (A) - answer-: . Ctrl + N creates a new workbook. Ctrl + W (B) closes
the current workbook. Ctrl + O (C) opens an existing workbook. Ctrl + S (D) saves
the workbook.
, 11. You want to prevent users from editing cells containing formulas. Which
combination of features should you use?
A) Data Validation and Protect Worksheet
B) Format Cells → Locked and Protect Worksheet
C) Hide Formulas and Protect Workbook
D) Group and Outline and Protect Sheet
Rationale: (B) - answer-: . First, select formula cells and ensure Format Cells →
Protection → Locked is checked. Then use Protect Worksheet to enforce locking.
Data Validation (A) restricts data entry but doesn't prevent editing. Hide Formulas
(C) hides formulas but doesn't prevent editing. Group and Outline (D) organizes
data.
12. Which view shows how the worksheet will look when printed, including
page breaks?
A) Normal View
B) Page Layout View
C) Page Break Preview
D) Print Preview
Rationale: (C) - answer-: . Page Break Preview shows page breaks and allows
adjustment. Normal View (A) is the default editing view. Page Layout View (B)
shows individual pages. Print Preview (D) shows the final print appearance.
13. You have a list of 1,000 names in column A. You want to quickly navigate to
cell A1000. Which method is most efficient?
A) Press Page Down repeatedly
B) Use the scroll bar
C) Press Ctrl + End
D) Press Ctrl + G, then enter A1000
Rationale: (D) - answer-: . Ctrl + G (Go To) then entering A1000 is precise and
efficient. Ctrl + End (C) goes to the last used cell, which might not be A1000.
Scrolling (B) or paging (A) is slower.
14. Which feature allows you to create a dropdown list in a cell?
A) Conditional Formatting
B) Data Validation
C) Table Formatting
ACTUAL EXAM COMPLETE QUESTIONS AND - ANSWER-:
ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED A+
Section 1: Excel Fundamentals & Navigation (Questions 1-15)
1. You have a workbook with multiple worksheets. Which keyboard shortcut
allows you to move to the next worksheet?
A) Ctrl + Page Up
B) Ctrl + Page Down
C) Alt + Page Down
D) Shift + Tab
Rationale: (B) - answer-: . Ctrl + Page Down moves to the next worksheet. Ctrl +
Page Up (A) moves to the previous worksheet. Alt + Page Down (C) scrolls right
one screen. Shift + Tab (D) moves to the previous cell.
2. Which Excel feature allows you to view two different parts of the same
worksheet simultaneously?
A) Split
B) Freeze Panes
C) New Window
D) Arrange All
Rationale: (A) - answer-: . The Split feature divides the worksheet into separate
panes that can be scrolled independently. Freeze Panes (B) keeps rows/columns
visible while scrolling. New Window (C) creates another window of the same
workbook. Arrange All (D) organizes multiple workbook windows.
3. What is the maximum number of rows in an Excel worksheet?
A) 65,536
B) 1,048,576
C) 16,384
D) 1,073,741,824
Rationale: (B) - answer-: . Excel worksheets have 1,048,576 rows (2^20). 65,536
,(A) was the limit in Excel 2003 and earlier. 16,384 (C) is the number of columns
(2^14). 1,073,741,824 (D) is the total cells (rows × columns).
4. Which data type would Excel automatically align to the left side of a cell by
default?
A) Numbers
B) Dates
C) Currency
D) Text
Rationale: (D) - answer-: . Text is left-aligned by default. Numbers, dates, and
currency (A, B, C) are right-aligned by default.
5. You want to quickly select all cells that contain formulas in your worksheet.
Which feature should you use?
A) Find and Replace
B) Go To Special
C) Data Validation
D) Conditional Formatting
Rationale: (B) - answer-: . Go To Special → Formulas selects all cells containing
formulas. Find and Replace (A) can find formulas but is less efficient. Data
Validation (C) restricts data entry. Conditional Formatting (D) changes cell
appearance based on conditions.
6. Which of the following is NOT a valid cell reference in Excel?
A) $A$1
B) A$1
C) $A1
D) $A$1$
Rationale: (D) - answer-: . $A$1$ is invalid—the $ symbol can only appear before
the column letter and/or row number. $A$1 (A) is absolute reference. A$1 (B) is
mixed reference (column relative, row absolute). $A1 (C) is mixed reference
(column absolute, row relative).
7. You want to display the current date in a cell, and you want it to update
automatically each day. Which function should you use?
A) =DATE()
B) =NOW()
,C) =TODAY()
D) =CURRENTDATE()
Rationale: (C) - answer-: . =TODAY() returns the current date and updates
automatically. =DATE() (A) requires year, month, day arguments. =NOW() (B)
returns current date and time. =CURRENTDATE() (D) is not a valid Excel function.
8. Which feature allows you to see the results of a formula without permanently
changing the data?
A) Scenario Manager
B) Goal Seek
C) Data Table
D) Watch Window
Rationale: (A) - answer-: . Scenario Manager allows you to create and save
different sets of values and see the results without changing the actual data. Goal
Seek (B) finds input to achieve a desired result. Data Table (C) shows multiple
results for different inputs. Watch Window (D) monitors cell values.
9. You have a column of numbers and want to quickly identify the highest value.
Which feature provides the fastest solution?
A) Sort Descending
B) MAX function
C) Conditional Formatting → Top 10
D) AutoSum → Max
Rationale: (D) - answer-: . AutoSum → Max quickly inserts the MAX function and
selects the adjacent range. Sort Descending (A) reorganizes data. MAX function
(B) requires manual entry. Conditional Formatting (C) highlights but doesn't show
the value.
10. Which keyboard shortcut creates a new workbook?
A) Ctrl + N
B) Ctrl + W
C) Ctrl + O
D) Ctrl + S
Rationale: (A) - answer-: . Ctrl + N creates a new workbook. Ctrl + W (B) closes
the current workbook. Ctrl + O (C) opens an existing workbook. Ctrl + S (D) saves
the workbook.
, 11. You want to prevent users from editing cells containing formulas. Which
combination of features should you use?
A) Data Validation and Protect Worksheet
B) Format Cells → Locked and Protect Worksheet
C) Hide Formulas and Protect Workbook
D) Group and Outline and Protect Sheet
Rationale: (B) - answer-: . First, select formula cells and ensure Format Cells →
Protection → Locked is checked. Then use Protect Worksheet to enforce locking.
Data Validation (A) restricts data entry but doesn't prevent editing. Hide Formulas
(C) hides formulas but doesn't prevent editing. Group and Outline (D) organizes
data.
12. Which view shows how the worksheet will look when printed, including
page breaks?
A) Normal View
B) Page Layout View
C) Page Break Preview
D) Print Preview
Rationale: (C) - answer-: . Page Break Preview shows page breaks and allows
adjustment. Normal View (A) is the default editing view. Page Layout View (B)
shows individual pages. Print Preview (D) shows the final print appearance.
13. You have a list of 1,000 names in column A. You want to quickly navigate to
cell A1000. Which method is most efficient?
A) Press Page Down repeatedly
B) Use the scroll bar
C) Press Ctrl + End
D) Press Ctrl + G, then enter A1000
Rationale: (D) - answer-: . Ctrl + G (Go To) then entering A1000 is precise and
efficient. Ctrl + End (C) goes to the last used cell, which might not be A1000.
Scrolling (B) or paging (A) is slower.
14. Which feature allows you to create a dropdown list in a cell?
A) Conditional Formatting
B) Data Validation
C) Table Formatting
