WGU D388 Fundamentals of Spreadsheets
and Data Presentations OA EXAM STUDY
GUIDE 2026/2027 COMPLETE QUESTIONS
WITH CORRECT DETAILED ANSWERS ||
100% GUARANTEED PASS
<NEWEST VERSION>
1. What are spreadsheets primarily used for? - ANSWER To organize and
manipulate data into useful information.
2. Name two popular spreadsheet programs. - ANSWER Excel and Google
Sheets.
3. What is a worksheet? - ANSWER A single spreadsheet within a spreadsheet
program.
4. What is a constant in a spreadsheet? - ANSWER A set value that doesn't
change and is directly inserted into a cell.
5. How does a formula begin in Excel? - ANSWER With an equals sign (=).
6. What is the purpose of a function in a formula? - ANSWER To perform a
specific calculation or operation within the formula.
,7. What does the Fill Handle do? - ANSWER Copies the contents of a cell,
including formulas, to other cells.
8. What is an absolute cell reference? - ANSWER A cell reference that remains
constant even when copied or moved, indicated by a dollar sign ($).
9. What is a relative cell reference? - ANSWER A cell reference that changes
when a formula is copied to another cell.
10.How can you resize a column in Excel? - ANSWER By dragging the line
between column headings or using the Format menu.
11.What is the AutoFit feature? - ANSWER Automatically adjusts the cell size
to fit the data.
12.What is the syntax for the AVERAGE function? - ANSWER =
AVERAGE(argument1, argument2, ... argument255)
13.What does the SUM function do? - ANSWER Calculates the total of a range
of numbers.
14.What is the purpose of the AutoSum feature? - ANSWER To quickly
calculate the sum of a range of cells.
15.What happens if a column is not wide enough for its content? - ANSWER It
may display ###### or the text may spill over into the next cell.
16.How do you insert text into a cell in Excel? - ANSWER Click on the cell
and type the text.
,17.Spreadsheets are used primarily in:
A) education
B) business
C) government
D) the home - ANSWER B
18.The basic unit of a spreadsheet is a:
A) box
B) cube
C) cell
D) grid - ANSWER C
19.Spreadsheets:
A) can only be sorted by column A
B) can be sorted by any column provided the column is named
C) are sorted by rows then columns
D) can be sorted by any column - ANSWER D
20.A range of cells can include:
A) cells from more than one row
B) cells from more than one column
C) the entire spreadsheet
D) all of the above - ANSWER D
21.Workbook - ANSWER An excel file that stores all the information, previous
calculations, and analyses that you may have already completed. Must
contain atleast one worksheet.
22.Worksheet - ANSWER A collection of cells arranged in the form of a table
that contains the actual data and calculations.
, 23.Cell - ANSWER Small box that stores an individual piece of data or a
calculation in a worksheet
24.Value - ANSWER The content within a cell.
25.Column - ANSWER A stack of cells arranged vertically from the top to the
bottom of a worksheet - labeled with a letter.
26.Row - ANSWER Collection of cells arranged horizontally from left to right
of a worksheet- labeled with a number of
27.Function - ANSWER Built in method for performing a calculation in excel
28.File - ANSWER A group of menu items used to manipulate workbooks
29.Home - ANSWER A group of menu items used to format the appearance of
data in cells
30.Insert - ANSWER Group of menu items that includes features for
specializing elements into workbooks, such as charts, pictures, and shapes
31.Draw - ANSWER Group of menu items used to insert freehand sketches into
worksheets
32.Page layout - ANSWER Group of menu items used to format the appearance
of worksheets when they are printed
and Data Presentations OA EXAM STUDY
GUIDE 2026/2027 COMPLETE QUESTIONS
WITH CORRECT DETAILED ANSWERS ||
100% GUARANTEED PASS
<NEWEST VERSION>
1. What are spreadsheets primarily used for? - ANSWER To organize and
manipulate data into useful information.
2. Name two popular spreadsheet programs. - ANSWER Excel and Google
Sheets.
3. What is a worksheet? - ANSWER A single spreadsheet within a spreadsheet
program.
4. What is a constant in a spreadsheet? - ANSWER A set value that doesn't
change and is directly inserted into a cell.
5. How does a formula begin in Excel? - ANSWER With an equals sign (=).
6. What is the purpose of a function in a formula? - ANSWER To perform a
specific calculation or operation within the formula.
,7. What does the Fill Handle do? - ANSWER Copies the contents of a cell,
including formulas, to other cells.
8. What is an absolute cell reference? - ANSWER A cell reference that remains
constant even when copied or moved, indicated by a dollar sign ($).
9. What is a relative cell reference? - ANSWER A cell reference that changes
when a formula is copied to another cell.
10.How can you resize a column in Excel? - ANSWER By dragging the line
between column headings or using the Format menu.
11.What is the AutoFit feature? - ANSWER Automatically adjusts the cell size
to fit the data.
12.What is the syntax for the AVERAGE function? - ANSWER =
AVERAGE(argument1, argument2, ... argument255)
13.What does the SUM function do? - ANSWER Calculates the total of a range
of numbers.
14.What is the purpose of the AutoSum feature? - ANSWER To quickly
calculate the sum of a range of cells.
15.What happens if a column is not wide enough for its content? - ANSWER It
may display ###### or the text may spill over into the next cell.
16.How do you insert text into a cell in Excel? - ANSWER Click on the cell
and type the text.
,17.Spreadsheets are used primarily in:
A) education
B) business
C) government
D) the home - ANSWER B
18.The basic unit of a spreadsheet is a:
A) box
B) cube
C) cell
D) grid - ANSWER C
19.Spreadsheets:
A) can only be sorted by column A
B) can be sorted by any column provided the column is named
C) are sorted by rows then columns
D) can be sorted by any column - ANSWER D
20.A range of cells can include:
A) cells from more than one row
B) cells from more than one column
C) the entire spreadsheet
D) all of the above - ANSWER D
21.Workbook - ANSWER An excel file that stores all the information, previous
calculations, and analyses that you may have already completed. Must
contain atleast one worksheet.
22.Worksheet - ANSWER A collection of cells arranged in the form of a table
that contains the actual data and calculations.
, 23.Cell - ANSWER Small box that stores an individual piece of data or a
calculation in a worksheet
24.Value - ANSWER The content within a cell.
25.Column - ANSWER A stack of cells arranged vertically from the top to the
bottom of a worksheet - labeled with a letter.
26.Row - ANSWER Collection of cells arranged horizontally from left to right
of a worksheet- labeled with a number of
27.Function - ANSWER Built in method for performing a calculation in excel
28.File - ANSWER A group of menu items used to manipulate workbooks
29.Home - ANSWER A group of menu items used to format the appearance of
data in cells
30.Insert - ANSWER Group of menu items that includes features for
specializing elements into workbooks, such as charts, pictures, and shapes
31.Draw - ANSWER Group of menu items used to insert freehand sketches into
worksheets
32.Page layout - ANSWER Group of menu items used to format the appearance
of worksheets when they are printed
