WGU C268 Spreadsheets OA ACTUAL
EXAM 2025/2026 COMPLETE QUESTIONS
WITH CORRECT DETAILED ANSWERS ||
100% GUARANTEED PASS
<BRAND NEW VERSION>
1. Workbook - ANSWER ✓ an Excel file that stores all the information,
previous calculations, and analyses that you may have already completed
2. Worksheet - ANSWER ✓ contains the actual data and calculations
3. Cells - ANSWER ✓ store individual pieces of data or calculations
4. File Menu - ANSWER ✓ menu used to manipulate workbooks
5. Home - ANSWER ✓ area includes items used in formatting the appearance
of data in cells
6. Insert Area - ANSWER ✓ include features that allow you to place
specialized elements into your workbooks, such as charts, pictures, and
shapes
7. Page Layout Menu - ANSWER ✓ menu items are used to format the
appearance of worksheets
8. Formulas Menu - ANSWER ✓ menu items aid in performing calculations
using Excel's built-in functions
,9. Data Area - ANSWER ✓ used to aid in importing and working with large
amounts of data
10.Review Menu - ANSWER ✓ menu items help in sharing an Excel workbook
with colleagues
11.View Menu - ANSWER ✓ menu items are used to change how a worksheet
is displayed on the screen
12.Info portion of the File - ANSWER ✓ menu displays information about the
current workbook and the users who have contributed to the file
13.New portion of the File - ANSWER ✓ menu contains features related to
creating a new workbook
14.Templates - ANSWER ✓ can be particularly useful because they often
contain data, formatting and calculations that relate to common spreadsheet
tasks
15.Open - ANSWER ✓ used to select a different workbook that you want to be
opened in Excel or select a workbook that has been saves on Skydive or
locally on your computer
16.Save and Save As Functions - ANSWER ✓ allow you to (1) save the current
workbook, (2) save a copy of the current workbook with a new name or
location, or (3) save a copy of the current workbook as a different file type.
17.Print Area - ANSWER ✓ menu area contains items related to printing a
worksheet
18.Print Area - ANSWER ✓ area displays a preview of how a particular
worksheet will look once printed.
19.Share Area - ANSWER ✓ area used make the workbook available for
colleagues
20.SECOND function
, (define) - ANSWER ✓ function behaves like the HOUR and MINUTE
functions. It returns a number between 0 and 59 that represents the second
portion of a time.
21.LEN (text)
(define) - ANSWER ✓ function returns the length, in number of characters,
of a block of text
SEARCH (find_text,within_text, [start_num])
22.(define) - ANSWER ✓ function returns the position of a specific character,
word, or phrase within a block of text
23.LEFT (text,[num_chars])
(define) - ANSWER ✓ function returns a specified number of characters
starting from the beginning of a block of text
24.MID(text,start_num,num_chars)
(define) - ANSWER ✓ function returns a specified number of character
from the middle of a block of text
25.RIGHT(text,[num_chars])
(define) - ANSWER ✓ function returns a specified number of characters
starting from the end of a block of text
26.UPPER (text)
(define) - ANSWER ✓ function converts a block of text to all upper-case
characters
27.LOWER (text)
(define) - ANSWER ✓ function converts a block of text to all lower-case
characters
28.PROPER (text)
(define) - ANSWER ✓ function converts a block of text to title-case (the
first letter of each new word is capitalized)
29.CONCATENATE (text1,[text2],...)
(define) - ANSWER ✓ function combines blocks of text
, 30.SUBSTITUTE (text,old_text,new_text,[instance_num])
(define) - ANSWER ✓ function replaces specified characters, words, or
phrases within a block of text with new characters, words, or phrases
31.PMT function - ANSWER ✓ calculates the periodic payment for a loan with
a fixed interest rate and fixed term
=PMT(rate,nper,pv)
Interest rate (divided by 12 months), the number of payments to be made to
pay off the loan, the original loan amount.
32.HLOOKUP function - ANSWER ✓ A lookup function that searches
horizontally across the top row of the lookup table and retrieves the value in
the column you specify.
=HLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
33.Lookup information, the location of the reference table, the column in the
table that contains the information that is returned, true if an approximate
match is OK and FALSE if an approximate match is not okay.
34.LEFT function - ANSWER ✓ LEFT (text,[num_chars]) - returns a specified
number of characters starting from the beginning of a block of text
=LEFT(text, [num_chars])
The cell reference that contains the block of text, the cell reference of the
number of characters to return, starting with the first character
35.RIGHT function - ANSWER ✓ RIGHT(text,[num_chars]) - returns a
specified number of characters starting from the end of a block of text
=RIGHT(text, [num_chars])
The cell reference that contains the block of text, the cell reference of the
number of characters to return, starting with the last character.
36.MID function - ANSWER ✓ MID(text,start_num,num_chars) - returns a
specified number of character from the middle of a block of text
EXAM 2025/2026 COMPLETE QUESTIONS
WITH CORRECT DETAILED ANSWERS ||
100% GUARANTEED PASS
<BRAND NEW VERSION>
1. Workbook - ANSWER ✓ an Excel file that stores all the information,
previous calculations, and analyses that you may have already completed
2. Worksheet - ANSWER ✓ contains the actual data and calculations
3. Cells - ANSWER ✓ store individual pieces of data or calculations
4. File Menu - ANSWER ✓ menu used to manipulate workbooks
5. Home - ANSWER ✓ area includes items used in formatting the appearance
of data in cells
6. Insert Area - ANSWER ✓ include features that allow you to place
specialized elements into your workbooks, such as charts, pictures, and
shapes
7. Page Layout Menu - ANSWER ✓ menu items are used to format the
appearance of worksheets
8. Formulas Menu - ANSWER ✓ menu items aid in performing calculations
using Excel's built-in functions
,9. Data Area - ANSWER ✓ used to aid in importing and working with large
amounts of data
10.Review Menu - ANSWER ✓ menu items help in sharing an Excel workbook
with colleagues
11.View Menu - ANSWER ✓ menu items are used to change how a worksheet
is displayed on the screen
12.Info portion of the File - ANSWER ✓ menu displays information about the
current workbook and the users who have contributed to the file
13.New portion of the File - ANSWER ✓ menu contains features related to
creating a new workbook
14.Templates - ANSWER ✓ can be particularly useful because they often
contain data, formatting and calculations that relate to common spreadsheet
tasks
15.Open - ANSWER ✓ used to select a different workbook that you want to be
opened in Excel or select a workbook that has been saves on Skydive or
locally on your computer
16.Save and Save As Functions - ANSWER ✓ allow you to (1) save the current
workbook, (2) save a copy of the current workbook with a new name or
location, or (3) save a copy of the current workbook as a different file type.
17.Print Area - ANSWER ✓ menu area contains items related to printing a
worksheet
18.Print Area - ANSWER ✓ area displays a preview of how a particular
worksheet will look once printed.
19.Share Area - ANSWER ✓ area used make the workbook available for
colleagues
20.SECOND function
, (define) - ANSWER ✓ function behaves like the HOUR and MINUTE
functions. It returns a number between 0 and 59 that represents the second
portion of a time.
21.LEN (text)
(define) - ANSWER ✓ function returns the length, in number of characters,
of a block of text
SEARCH (find_text,within_text, [start_num])
22.(define) - ANSWER ✓ function returns the position of a specific character,
word, or phrase within a block of text
23.LEFT (text,[num_chars])
(define) - ANSWER ✓ function returns a specified number of characters
starting from the beginning of a block of text
24.MID(text,start_num,num_chars)
(define) - ANSWER ✓ function returns a specified number of character
from the middle of a block of text
25.RIGHT(text,[num_chars])
(define) - ANSWER ✓ function returns a specified number of characters
starting from the end of a block of text
26.UPPER (text)
(define) - ANSWER ✓ function converts a block of text to all upper-case
characters
27.LOWER (text)
(define) - ANSWER ✓ function converts a block of text to all lower-case
characters
28.PROPER (text)
(define) - ANSWER ✓ function converts a block of text to title-case (the
first letter of each new word is capitalized)
29.CONCATENATE (text1,[text2],...)
(define) - ANSWER ✓ function combines blocks of text
, 30.SUBSTITUTE (text,old_text,new_text,[instance_num])
(define) - ANSWER ✓ function replaces specified characters, words, or
phrases within a block of text with new characters, words, or phrases
31.PMT function - ANSWER ✓ calculates the periodic payment for a loan with
a fixed interest rate and fixed term
=PMT(rate,nper,pv)
Interest rate (divided by 12 months), the number of payments to be made to
pay off the loan, the original loan amount.
32.HLOOKUP function - ANSWER ✓ A lookup function that searches
horizontally across the top row of the lookup table and retrieves the value in
the column you specify.
=HLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
33.Lookup information, the location of the reference table, the column in the
table that contains the information that is returned, true if an approximate
match is OK and FALSE if an approximate match is not okay.
34.LEFT function - ANSWER ✓ LEFT (text,[num_chars]) - returns a specified
number of characters starting from the beginning of a block of text
=LEFT(text, [num_chars])
The cell reference that contains the block of text, the cell reference of the
number of characters to return, starting with the first character
35.RIGHT function - ANSWER ✓ RIGHT(text,[num_chars]) - returns a
specified number of characters starting from the end of a block of text
=RIGHT(text, [num_chars])
The cell reference that contains the block of text, the cell reference of the
number of characters to return, starting with the last character.
36.MID function - ANSWER ✓ MID(text,start_num,num_chars) - returns a
specified number of character from the middle of a block of text
