Microsoft Excel Test UPDATED Actual
Exam Questions and CORRECT Answers
spreadsheet - CORRECT ANSWER✔✔- an electronic file that contains a grid of columns
and rows containing related data
spreadsheet program - CORRECT ANSWER✔✔- a computer application used to create and
modify spreadsheets
worksheet - CORRECT ANSWER✔✔- a spreadsheet that contains formulas, functions,
values, text, and visual aids
workbook - CORRECT ANSWER✔✔- a file containing related worksheets
Steps to design a workbook? - CORRECT ANSWER✔✔- 1. State the purpose of the
worksheet
2. Decide what input values are needed
3. Decide what outputs are needed to achieve the purpose of the workbook
4. Assign the worksheet inputs and results into columns and rows, and consider labeling.
5. Enter the labels, values, and formulas in Excel
6. Format the numerical values in the worksheet
7. Format the descriptive titles and labels attractively but so as not to distract your audience
from the purpose of the worksheet.
8. Document the worksheet as thoroughly as possible
9. Save the completed worksheet
input area - CORRECT ANSWER✔✔- a range of cells containing values for variables used
in formulas
output area - CORRECT ANSWER✔✔- a range of cells containing results based on
manipulating the variables
, Name Box - CORRECT ANSWER✔✔- identifies the address of the current cell
formula bar - CORRECT ANSWER✔✔- displays the content (text, value, date, or formula)
in the active cell
sheet tab - CORRECT ANSWER✔✔- displays the name of a worksheet within a workbook
cell - CORRECT ANSWER✔✔- the intersection of the column and rows
cell address - CORRECT ANSWER✔✔- identifies a cell by a column letter and a row
number
active cell - CORRECT ANSWER✔✔- the current cell, indicated by a dark border
text - CORRECT ANSWER✔✔- includes letters, numbers, symbols, and spaces
value - CORRECT ANSWER✔✔- a number that represents a quantity or an amount
formula - CORRECT ANSWER✔✔- a combination of cell references, operators, values,
and/or functions used to perform a calculation
Ctrl + F - CORRECT ANSWER✔✔- enables a search box to find cell address
Order of Precedence/ Order of Operations - CORRECT ANSWER✔✔- controls the
sequence in which Excel performs arithmetic operations (PEMDAS: Parenthesis, Exponents,
Multiplication, Division, Addition, Substraction
Ctrl + ` (accent) - CORRECT ANSWER✔✔- shows all formulas in spreadsheet
Autofill - CORRECT ANSWER✔✔- 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.
Exam Questions and CORRECT Answers
spreadsheet - CORRECT ANSWER✔✔- an electronic file that contains a grid of columns
and rows containing related data
spreadsheet program - CORRECT ANSWER✔✔- a computer application used to create and
modify spreadsheets
worksheet - CORRECT ANSWER✔✔- a spreadsheet that contains formulas, functions,
values, text, and visual aids
workbook - CORRECT ANSWER✔✔- a file containing related worksheets
Steps to design a workbook? - CORRECT ANSWER✔✔- 1. State the purpose of the
worksheet
2. Decide what input values are needed
3. Decide what outputs are needed to achieve the purpose of the workbook
4. Assign the worksheet inputs and results into columns and rows, and consider labeling.
5. Enter the labels, values, and formulas in Excel
6. Format the numerical values in the worksheet
7. Format the descriptive titles and labels attractively but so as not to distract your audience
from the purpose of the worksheet.
8. Document the worksheet as thoroughly as possible
9. Save the completed worksheet
input area - CORRECT ANSWER✔✔- a range of cells containing values for variables used
in formulas
output area - CORRECT ANSWER✔✔- a range of cells containing results based on
manipulating the variables
, Name Box - CORRECT ANSWER✔✔- identifies the address of the current cell
formula bar - CORRECT ANSWER✔✔- displays the content (text, value, date, or formula)
in the active cell
sheet tab - CORRECT ANSWER✔✔- displays the name of a worksheet within a workbook
cell - CORRECT ANSWER✔✔- the intersection of the column and rows
cell address - CORRECT ANSWER✔✔- identifies a cell by a column letter and a row
number
active cell - CORRECT ANSWER✔✔- the current cell, indicated by a dark border
text - CORRECT ANSWER✔✔- includes letters, numbers, symbols, and spaces
value - CORRECT ANSWER✔✔- a number that represents a quantity or an amount
formula - CORRECT ANSWER✔✔- a combination of cell references, operators, values,
and/or functions used to perform a calculation
Ctrl + F - CORRECT ANSWER✔✔- enables a search box to find cell address
Order of Precedence/ Order of Operations - CORRECT ANSWER✔✔- controls the
sequence in which Excel performs arithmetic operations (PEMDAS: Parenthesis, Exponents,
Multiplication, Division, Addition, Substraction
Ctrl + ` (accent) - CORRECT ANSWER✔✔- shows all formulas in spreadsheet
Autofill - CORRECT ANSWER✔✔- 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.
