MICROSOFT EXCEL STUDY GUIDE WITH
QUESTIONS AND ANSWERS PROVIDED.
2024/2025 REVISION MATERIAL
1. Worksheet: A spreadsheet that contains formulas, functions,
values, text, and visual aids.
2. Workbook: A file containing related worksheets.
3. Input Area: A range of cells containing values for variables used in
formulas.
4. Output Area: A range of cells containing results based on
manipulating the variables.
5. Name Box: Identifies the address of the current cell.
6. Formula Bar: Displays the content (text, value, date, or formula) in
the active cell.
7. Sheet Tab: Displays the name of a worksheet within a workbook.
8. Cell: The intersection of a column and row.
9. Text: Includes letters, numbers, symbols, and spaces.
10. Values: A number that represents a quantity or an amount.
1 1 . Order of Precedence: Rules that control the sequence in which
excel performs arithmetic operations.
12. Auto Fill: Enables you to copy the contents of a cell or cell range
or to continue a sequence by dragging the fill handle over an
adjacent cell or range of cells.
13. Fill Handle: A small green square at the bottom-right corner of a
cell.
14. Column Width: The horizontal measurement of a column.
15. Row Height: The vertical measurement of a row.
16. Range: A rectangular group of cells
17. Alignment: The position of data between the cell margins.
18. Wrap Text: Formatting that enables a label to appear on multiple
lines within the current cell.
19. Fill Color: The background color appearing behind data in a cell.
, MICROSOFT EXCEL STUDY GUIDE WITH
QUESTIONS AND ANSWERS PROVIDED.
2024/2025 REVISION MATERIAL
20. Formula: A combination of cell references, operators, values, and/or
functions used to perform a calculation.
21 . Syntax: A set of rules that governs the structure and components for
properly entering a function.
22. TODAY Function: Displays the current date.
23. Absolute Cell Reference: Indicates a cell's specific location; the
cell reference does not change when you copy the formula
24. Circular Reference: Occurs when a formula directly or indirectly
refers to itself.
25. Arguments: An input, such as a cell reference or value, needed to
complete a function.
26. MAX function: Identifies the highest value in a range.
27. COUNTA function: Tallies the number of cells in a range that
contain values.
28. VLOOKUP: Looks up a value in a vertical lookup table and returns a
related result from the lookup table.
29. Lookup Table: A range that contains data for the basis of the
lookup and data to be retrieved.
30. AVERAGE function: Calculates the arithmetic mean, or average,
of values in a range.
31 . MEDIAN function: Identifies the midpoint value in a set of values.
32. NOW Function: Displays the current date and time.
33. IF Function: Evaluates a condition and returns one value if the
condition is true and a different value if the condition is false.
34. SUM Function: Calculates the total of values contained in two or
more cells. 35. PMT Function: Calculates the periodic payment for a
loan with a fixed interest rate and fixed term.
,36. Relative Cell Reference: Indicates a cells location from the cell
containing the formula; the cell reference changes when the formula
is copied.
37. Mixed Cell Reference: Contains both an absolute and a relative
cell reference in a formula; the absolute part does not change
but the relative part does when you copy the formula.
38. Range Name: A word or string of characters that represents one
or more cells.
39. Logical Test: An expression that evaluates to true of false.
40. MIN Function: Displays the lowest value in a range.
41 . Name Box: Which area on the left side of the formula bar
indicates the cell address of a selected cell?
42. Row: Joan has a table that includes demographic information about
her employees. If the demographic information is listed across the
top and employee names down the left side of the table, what does
all the information about one employee represent?
43. Entry: Joan has entered her name in the First Name field in cell
B2 of her table.
What does her First Name represent in the table?
44. Ctrl End: What is the shortcut that will lead to the last record on her
spreadsheet?
45. Quick Access Toolbar: Which Microsoft Office object would you use
for quick, convenient, one-click access to frequently used Excel
commands?
46. Worksheet: Which of the following would you use to enter,
calculate, manipulate, and analyze data such as numbers and
text in Excel?
47. Normal: Which view is the default view used in Microsoft Excel?
48. File: Which tab is used to display the area that contains the print
command? 49. Close: Which command among the window control
, MICROSOFT EXCEL STUDY GUIDE WITH
QUESTIONS AND ANSWERS PROVIDED.
2024/2025 REVISION MATERIAL
buttons is used to close an open file and completely exit the
Microsoft Excel program?
50. Microsoft Excel: Which software program is a powerful
spreadsheet program that allows users to organize data, complete
calculations, and graph data?
51 . Cut: Alicia needs to move the data in cell B5 to cell E5. Which
command would she select?
52. AutoFit: In a Microsoft Excel worksheet, how do you change the
width of a column so that the widest entry will fit?
53. Document Properties: Which would be used to help organize
and identify Microsoft Excel files by providing details about the files?
54. Copy: In Microsoft Excel, which feature makes an exact replica
of the cell data and format while keeping the original cell intact?
55. Clear: Alicia needs to delete the data in cell B5. Which
command would she select?
56. Backspace Key: When entering data into a cell, which keyboard
key is used to remove characters to the left of the insertion point?
57. Shortcut Menu: What is the name of the list of frequently used
Excel commands available when a user right-clicks an item in the
worksheet?
58. Fill Handle: What is the name of the small black square in the
lower-right corner of the heavy border of an active cell that repeats
a cell's value in adjacent cells? 59. Label: Joan is creating a table that
will include demographic information about her employees. What is
each header in her table considered?
60. Label: Jennifer needs to identify the values in column B for a
statistics report.
Which type of entry should she use in the column header?
QUESTIONS AND ANSWERS PROVIDED.
2024/2025 REVISION MATERIAL
1. Worksheet: A spreadsheet that contains formulas, functions,
values, text, and visual aids.
2. Workbook: A file containing related worksheets.
3. Input Area: A range of cells containing values for variables used in
formulas.
4. Output Area: A range of cells containing results based on
manipulating the variables.
5. Name Box: Identifies the address of the current cell.
6. Formula Bar: Displays the content (text, value, date, or formula) in
the active cell.
7. Sheet Tab: Displays the name of a worksheet within a workbook.
8. Cell: The intersection of a column and row.
9. Text: Includes letters, numbers, symbols, and spaces.
10. Values: A number that represents a quantity or an amount.
1 1 . Order of Precedence: Rules that control the sequence in which
excel performs arithmetic operations.
12. Auto Fill: Enables you to copy the contents of a cell or cell range
or to continue a sequence by dragging the fill handle over an
adjacent cell or range of cells.
13. Fill Handle: A small green square at the bottom-right corner of a
cell.
14. Column Width: The horizontal measurement of a column.
15. Row Height: The vertical measurement of a row.
16. Range: A rectangular group of cells
17. Alignment: The position of data between the cell margins.
18. Wrap Text: Formatting that enables a label to appear on multiple
lines within the current cell.
19. Fill Color: The background color appearing behind data in a cell.
, MICROSOFT EXCEL STUDY GUIDE WITH
QUESTIONS AND ANSWERS PROVIDED.
2024/2025 REVISION MATERIAL
20. Formula: A combination of cell references, operators, values, and/or
functions used to perform a calculation.
21 . Syntax: A set of rules that governs the structure and components for
properly entering a function.
22. TODAY Function: Displays the current date.
23. Absolute Cell Reference: Indicates a cell's specific location; the
cell reference does not change when you copy the formula
24. Circular Reference: Occurs when a formula directly or indirectly
refers to itself.
25. Arguments: An input, such as a cell reference or value, needed to
complete a function.
26. MAX function: Identifies the highest value in a range.
27. COUNTA function: Tallies the number of cells in a range that
contain values.
28. VLOOKUP: Looks up a value in a vertical lookup table and returns a
related result from the lookup table.
29. Lookup Table: A range that contains data for the basis of the
lookup and data to be retrieved.
30. AVERAGE function: Calculates the arithmetic mean, or average,
of values in a range.
31 . MEDIAN function: Identifies the midpoint value in a set of values.
32. NOW Function: Displays the current date and time.
33. IF Function: Evaluates a condition and returns one value if the
condition is true and a different value if the condition is false.
34. SUM Function: Calculates the total of values contained in two or
more cells. 35. PMT Function: Calculates the periodic payment for a
loan with a fixed interest rate and fixed term.
,36. Relative Cell Reference: Indicates a cells location from the cell
containing the formula; the cell reference changes when the formula
is copied.
37. Mixed Cell Reference: Contains both an absolute and a relative
cell reference in a formula; the absolute part does not change
but the relative part does when you copy the formula.
38. Range Name: A word or string of characters that represents one
or more cells.
39. Logical Test: An expression that evaluates to true of false.
40. MIN Function: Displays the lowest value in a range.
41 . Name Box: Which area on the left side of the formula bar
indicates the cell address of a selected cell?
42. Row: Joan has a table that includes demographic information about
her employees. If the demographic information is listed across the
top and employee names down the left side of the table, what does
all the information about one employee represent?
43. Entry: Joan has entered her name in the First Name field in cell
B2 of her table.
What does her First Name represent in the table?
44. Ctrl End: What is the shortcut that will lead to the last record on her
spreadsheet?
45. Quick Access Toolbar: Which Microsoft Office object would you use
for quick, convenient, one-click access to frequently used Excel
commands?
46. Worksheet: Which of the following would you use to enter,
calculate, manipulate, and analyze data such as numbers and
text in Excel?
47. Normal: Which view is the default view used in Microsoft Excel?
48. File: Which tab is used to display the area that contains the print
command? 49. Close: Which command among the window control
, MICROSOFT EXCEL STUDY GUIDE WITH
QUESTIONS AND ANSWERS PROVIDED.
2024/2025 REVISION MATERIAL
buttons is used to close an open file and completely exit the
Microsoft Excel program?
50. Microsoft Excel: Which software program is a powerful
spreadsheet program that allows users to organize data, complete
calculations, and graph data?
51 . Cut: Alicia needs to move the data in cell B5 to cell E5. Which
command would she select?
52. AutoFit: In a Microsoft Excel worksheet, how do you change the
width of a column so that the widest entry will fit?
53. Document Properties: Which would be used to help organize
and identify Microsoft Excel files by providing details about the files?
54. Copy: In Microsoft Excel, which feature makes an exact replica
of the cell data and format while keeping the original cell intact?
55. Clear: Alicia needs to delete the data in cell B5. Which
command would she select?
56. Backspace Key: When entering data into a cell, which keyboard
key is used to remove characters to the left of the insertion point?
57. Shortcut Menu: What is the name of the list of frequently used
Excel commands available when a user right-clicks an item in the
worksheet?
58. Fill Handle: What is the name of the small black square in the
lower-right corner of the heavy border of an active cell that repeats
a cell's value in adjacent cells? 59. Label: Joan is creating a table that
will include demographic information about her employees. What is
each header in her table considered?
60. Label: Jennifer needs to identify the values in column B for a
statistics report.
Which type of entry should she use in the column header?
