Introduction to Computer Information Systems Final Exam Study Guide |
COMPLETE QUESTIONS WITH 100% RATED CORRECT ANSWERS|
GRADED A+ | 2025
Cell - (answers)The intersection of a column and a row
Workbook - (answers)an excel file that contains one or more worksheet
Worksheet - (answers)The primary document that you use in Excel to work with and store data,
and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.
Formula - (answers)An equation that performs mathematical calculations on values in a
worksheet
Expression - (answers)A statement or formula which returns a value
Constant/Value - (answers)numbers, text, dates, or times of day that you type into a cell
What are the types of values/entries that can be put into cells? - (answers)text, date, formula,
numbers
Autofill - (answers)An Excel feature that generates and extends values into adjacent cells based
on the values of selected cells
Quick Analysis - (answers)A tool that displays in the lower right corner of a selected range, with
which you can analyze your data by using excel tools such as charts, color-coding, and formulas
Paste Options - (answers)A gallery of buttons that provides a Live Preview of all these options
available in the current context
, default format in Excel - (answers)general and it takes whatever you type
Underlying Values - (answers)you see it by clicking it and look on the formula bar.
Function - (answers)A predefined formula- a formula that Excel has already built for you-that
performs calculations by using specific values in a particular order
Value axis - (answers)A numerical scale on the left side of a chart that shows the range of
numbers for the data points; also referred to as the Y-axis
Category axis - (answers)The area along the bottom of a chart that identifies the categories of
data; also referred to as the x-axis
Spell Check - (answers)Select the button and it will look over your worksheet for any
misspellings and offer to correct it for you.
arithmetic operators - (answers)The symbols +, -, *, /, %, and ^ used to denote addition,
subtraction, (or negation), multiplication, division, percentage, and exponentiation in an Excel
formula
which operators have precedence over others in Formulas - (answers)If there is multiple in one,
the use of PEMDAS occurs
What is displayed on startup in Excel? - (answers)A new blank workbook
typical column heading - (answers)The letter that displays at the top of a vertical group of cells
in a worksheet; beginning with the first letter of the alphabet, a unique letter or combination of
letters identifies each column
COMPLETE QUESTIONS WITH 100% RATED CORRECT ANSWERS|
GRADED A+ | 2025
Cell - (answers)The intersection of a column and a row
Workbook - (answers)an excel file that contains one or more worksheet
Worksheet - (answers)The primary document that you use in Excel to work with and store data,
and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.
Formula - (answers)An equation that performs mathematical calculations on values in a
worksheet
Expression - (answers)A statement or formula which returns a value
Constant/Value - (answers)numbers, text, dates, or times of day that you type into a cell
What are the types of values/entries that can be put into cells? - (answers)text, date, formula,
numbers
Autofill - (answers)An Excel feature that generates and extends values into adjacent cells based
on the values of selected cells
Quick Analysis - (answers)A tool that displays in the lower right corner of a selected range, with
which you can analyze your data by using excel tools such as charts, color-coding, and formulas
Paste Options - (answers)A gallery of buttons that provides a Live Preview of all these options
available in the current context
, default format in Excel - (answers)general and it takes whatever you type
Underlying Values - (answers)you see it by clicking it and look on the formula bar.
Function - (answers)A predefined formula- a formula that Excel has already built for you-that
performs calculations by using specific values in a particular order
Value axis - (answers)A numerical scale on the left side of a chart that shows the range of
numbers for the data points; also referred to as the Y-axis
Category axis - (answers)The area along the bottom of a chart that identifies the categories of
data; also referred to as the x-axis
Spell Check - (answers)Select the button and it will look over your worksheet for any
misspellings and offer to correct it for you.
arithmetic operators - (answers)The symbols +, -, *, /, %, and ^ used to denote addition,
subtraction, (or negation), multiplication, division, percentage, and exponentiation in an Excel
formula
which operators have precedence over others in Formulas - (answers)If there is multiple in one,
the use of PEMDAS occurs
What is displayed on startup in Excel? - (answers)A new blank workbook
typical column heading - (answers)The letter that displays at the top of a vertical group of cells
in a worksheet; beginning with the first letter of the alphabet, a unique letter or combination of
letters identifies each column
