CIS 105 Word & Excel Exam Verified Exam Questions and Answers Latest update 2026/2027

CIS 105 Word & Excel Exam
Verified Exam Questions and Answers Latest update 2026/2027

Question:
To display cell formulas -
Answer:
Why would you press Ctrl+' in excel

Question:
A1:A10,D1:D10 -
Answer:
Which of the following is a non adjacent range

Question:
Merge and center the data over all columns -
Answer:
If you want to
balance a title over several columns what do you do

Question:
Increase column width -
Answer:
What should you do if you see column of
pound signs (####) instead of values or results of formulas

Question:
Workbook -
Answer:
A file containing related worksheets

Question:
Formular Bar -
Answer:
displays the formula or contents of an active cell

Question:
The name of a worksheet within a workbook -

, Answer:
What does a sheet
tab display

Question:
Name box -
Answer:
identifies the address of the current cell

Question:
Cell -
Answer:
is the intersection of a column and a row

Question:
Cell references, constant values -
Answer:
You should use in
formulas instead of so you can change the input values without changing the formulas

Question:
Ctrl+Enter -
Answer:
Press to enter data into a cel and keep the cell
as the active cell

Question:
Fill handle -
Answer:
Copies the formula in the active cell to other cells
and adapts it based upon the type of cell references in the original formula

Question:
Number of payment periods -
Answer:
The function =PMT (C5,C7,-C3) is
stored in cell C15, what much be stored in cell 7

Question:
Mixed cell reference -