COMPUTER SCIENCE EXCEL EXAM(ACTUAL
EXAM) WITH CORRECT 120+ QUESTIONS
WITH WELL ANSWERED ANSWERS WITH
GOOD GRADE GUARANTEED LATEST 2024
– 2025 ALREADY GRADED A+
the active worksheet tab displays in red font - ANSWERS-Which of the
following is FALSE about worksheet tabs?
bold font - ANSWERS-The active worksheet tab/name displays in ___.
Excel worksheet tabs may not be renamed - ANSWERS-Which of the
following is FALSE about Excel worksheets tab names?
esc - ANSWERS-Use the ___ key to cancel a moving border after you
have copied and pasted in Excel.
,third from left to right
fourth from left to right
first from left to right
second from left to right - ANSWERS-The mathematical Order of
Operations is as follows (choose from the dropdown menu for each):
- multiplication and division are processed [Select]
- addition and subtraction are processed [Select]
- expressions within parentheses are processed [Select]
- exponents are processed [Select]
Paste Options, Paste Special, Paste Values, Values & Number
Formatting - ANSWERS-What is the procedure in Excel to paste only a
formula's resulting values to a new location, rather than pasting the
formula itself?
,from left to right - ANSWERS-How are consecutive operators with the
same level of precedence calculated?
the result of the formula will automatically recalculate - ANSWERS-If
you change the value in a cell referenced in a formula, what will
happen?
on the mini toolbar and the home bar - ANSWERS-Where is the Format
Painter button located?
exponentiation - ANSWERS-Which of the following is the second order
of operations?
expressions within parentheses - ANSWERS-Which of the following is
the first order of operations?
what-if analysis - ANSWERS-The process of changing cells in a
worksheet to see how those changes affect the outcome of formulas is
known as ________.
the pie slices will automatically be updated - ANSWERS-If you edit data
in a worksheet that is associated with a pie chart ________.
, normal - ANSWERS-Which view maximizes the number of cells visible
on your screen in Excel?
formula bar - ANSWERS-The ___ in Excel 2016 displays the value or
formula in the active cell; also permits entry or editing.
status bar - ANSWERS-Displays the current cell mode, page number,
worksheet information, view and zoom buttons, and for numerical
data, common calculations such as Sum and Average.
workbook; worksheets - ANSWERS-A/n ___ is an Excel document that
stores data in one or more ___, made up of rows and columns.
name box - ANSWERS-Displays the name given to a selected cell, table,
chart, or object in an Excel worksheet.
cell - ANSWERS-Intersection of the vertical and horizontal groupings of
data in an Excel worksheet; identified by the combined headings of
those groupings.
spreadsheet - ANSWERS-Another commonly used and more traditional
term for worksheet.
EXAM) WITH CORRECT 120+ QUESTIONS
WITH WELL ANSWERED ANSWERS WITH
GOOD GRADE GUARANTEED LATEST 2024
– 2025 ALREADY GRADED A+
the active worksheet tab displays in red font - ANSWERS-Which of the
following is FALSE about worksheet tabs?
bold font - ANSWERS-The active worksheet tab/name displays in ___.
Excel worksheet tabs may not be renamed - ANSWERS-Which of the
following is FALSE about Excel worksheets tab names?
esc - ANSWERS-Use the ___ key to cancel a moving border after you
have copied and pasted in Excel.
,third from left to right
fourth from left to right
first from left to right
second from left to right - ANSWERS-The mathematical Order of
Operations is as follows (choose from the dropdown menu for each):
- multiplication and division are processed [Select]
- addition and subtraction are processed [Select]
- expressions within parentheses are processed [Select]
- exponents are processed [Select]
Paste Options, Paste Special, Paste Values, Values & Number
Formatting - ANSWERS-What is the procedure in Excel to paste only a
formula's resulting values to a new location, rather than pasting the
formula itself?
,from left to right - ANSWERS-How are consecutive operators with the
same level of precedence calculated?
the result of the formula will automatically recalculate - ANSWERS-If
you change the value in a cell referenced in a formula, what will
happen?
on the mini toolbar and the home bar - ANSWERS-Where is the Format
Painter button located?
exponentiation - ANSWERS-Which of the following is the second order
of operations?
expressions within parentheses - ANSWERS-Which of the following is
the first order of operations?
what-if analysis - ANSWERS-The process of changing cells in a
worksheet to see how those changes affect the outcome of formulas is
known as ________.
the pie slices will automatically be updated - ANSWERS-If you edit data
in a worksheet that is associated with a pie chart ________.
, normal - ANSWERS-Which view maximizes the number of cells visible
on your screen in Excel?
formula bar - ANSWERS-The ___ in Excel 2016 displays the value or
formula in the active cell; also permits entry or editing.
status bar - ANSWERS-Displays the current cell mode, page number,
worksheet information, view and zoom buttons, and for numerical
data, common calculations such as Sum and Average.
workbook; worksheets - ANSWERS-A/n ___ is an Excel document that
stores data in one or more ___, made up of rows and columns.
name box - ANSWERS-Displays the name given to a selected cell, table,
chart, or object in an Excel worksheet.
cell - ANSWERS-Intersection of the vertical and horizontal groupings of
data in an Excel worksheet; identified by the combined headings of
those groupings.
spreadsheet - ANSWERS-Another commonly used and more traditional
term for worksheet.
