CIS 105 Word & Excel UPDATED ACTUAL Questions and CORRECT Answers

CIS 105 Word & Excel UPDATED
ACTUAL Questions and CORRECT
Answers
To display cell formulas - CORRECT ANSWER - Why would you press Ctrl+' in excel



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



Merge and center the data over all columns - CORRECT ANSWER - If you want to
balance a title over several columns what do you do


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


Workbook - CORRECT ANSWER - A file containing related worksheets



Formular Bar - CORRECT ANSWER - displays the formula or contents of an active cell



The name of a worksheet within a workbook - CORRECT ANSWER - What does a sheet
tab display


Name box - CORRECT ANSWER - identifies the address of the current cell



Cell - CORRECT ANSWER - is the intersection of a column and a row



Cell references, constant values - CORRECT ANSWER - You should use _____ in
formulas instead of ______ so you can change the input values without changing the formulas