CS101 FINAL EXAM QUESTIONS AND ANSWERS WITH
COMPLETE SOLUTIONS VERIFIED GRADED A++
2025/2026
What do spreadsheets do?
Spreadsheets store data in a collection of arrays of cells.
The cells are arranged in the spreadsheet by rows and columns.
Column width and row length can be modified to accommodate the data inside a
particular cell.
How is data stored?
A selection of data can be sorted by the following steps:
1. Highlight the cells you'd like to sort
2. Click on the Data menu
3. Select Sort
4. Choose Ascending or Descending according to your preference
5. Under the Options tab, select "Enable natural sort"
How are formulas entered into spreadsheets?
,Formulas can be entered into spreadsheets using =.
All the common operations +,-,*,/ act as you would expect.
Built-in functions can save time, such as sum(), average(),
max().
What are absolute and relative
reference?
A relative reference requires no special characters, is the default for the spreadsheet,
and refers to the case where the spreadsheet will adjust the cell numbers to fit the
original positioning.
Absolute references will fix one of the cell attributes in the formula. This could be the
exact cell location, the row, or the column.
For example, say you wanted to reference a formula like A9=B9*C8, and paste it to
D10.
- A9=B9C8 - relative reference, copying and pasting will adjust the row and
column choices to match the original positions: D10 = E10F9
- A9=B$9C$8 - absolute reference with xed rows, copying and pasting will adjust
the column choices: D10 = E9F8
, - A9=$B9$C8 - absolute reference with xed columns, copying and pasting will
adjust the row choices: D10 = B10C9
- A9=$B$9$C$8 - absolute reference with xed columns and rows: D10 = B9C8
How should information in a spreadsheet be organized?
The information should be organized in a logical, clean, and clear manner
- Descriptive headings should be on the top and towards the left
- Summary information on the bottom and towards the right
- Styling, fonts, colors, and use of graphics should be clean and consistent
- Use separate sheets for dierent categories of information
- Hide information that is not necessary in current context
What is conditional formatting?
Conditional Formatting is a method of applying an interpretation of the data in specic
cells.
Conditional formatting gives cells certain characteristics if they meet certain
requirements.
An example of conditional formatting would be to change the color of a cell if you have a
bill that is overdue on your budget spreadsheet.
COMPLETE SOLUTIONS VERIFIED GRADED A++
2025/2026
What do spreadsheets do?
Spreadsheets store data in a collection of arrays of cells.
The cells are arranged in the spreadsheet by rows and columns.
Column width and row length can be modified to accommodate the data inside a
particular cell.
How is data stored?
A selection of data can be sorted by the following steps:
1. Highlight the cells you'd like to sort
2. Click on the Data menu
3. Select Sort
4. Choose Ascending or Descending according to your preference
5. Under the Options tab, select "Enable natural sort"
How are formulas entered into spreadsheets?
,Formulas can be entered into spreadsheets using =.
All the common operations +,-,*,/ act as you would expect.
Built-in functions can save time, such as sum(), average(),
max().
What are absolute and relative
reference?
A relative reference requires no special characters, is the default for the spreadsheet,
and refers to the case where the spreadsheet will adjust the cell numbers to fit the
original positioning.
Absolute references will fix one of the cell attributes in the formula. This could be the
exact cell location, the row, or the column.
For example, say you wanted to reference a formula like A9=B9*C8, and paste it to
D10.
- A9=B9C8 - relative reference, copying and pasting will adjust the row and
column choices to match the original positions: D10 = E10F9
- A9=B$9C$8 - absolute reference with xed rows, copying and pasting will adjust
the column choices: D10 = E9F8
, - A9=$B9$C8 - absolute reference with xed columns, copying and pasting will
adjust the row choices: D10 = B10C9
- A9=$B$9$C$8 - absolute reference with xed columns and rows: D10 = B9C8
How should information in a spreadsheet be organized?
The information should be organized in a logical, clean, and clear manner
- Descriptive headings should be on the top and towards the left
- Summary information on the bottom and towards the right
- Styling, fonts, colors, and use of graphics should be clean and consistent
- Use separate sheets for dierent categories of information
- Hide information that is not necessary in current context
What is conditional formatting?
Conditional Formatting is a method of applying an interpretation of the data in specic
cells.
Conditional formatting gives cells certain characteristics if they meet certain
requirements.
An example of conditional formatting would be to change the color of a cell if you have a
bill that is overdue on your budget spreadsheet.
