MISY 5325 MS Excel Midterm Exam |2024/2025 ACTUAL
COMPLETE REAL EXAM QUESTIONS AND (VERIFIED
ANSWERS) / 100% ACCURATE|ALREADY GRADED A+
Workbook - ANSWER -When Excel opens a new _____________ is
created, which is like a notebook.
Worksheet - ANSWER -Inside a workbook are ______________,
each of which has a name.
Descending - ANSWER -To order the records in the Client table in
reverse alphabetical order by City, click the ____ button.
Close - ANSWER -To exit Access, click the ______ button on the
right side of the Access title bar.
True - ANSWER -To add a pie chart, first select the data to be
charted and then tap or click the Insert Pie or Doughnut Chart
button (INSERT tab | Charts group).
False - ANSWER -To use the AutoCalculate area, select the range
of cells containing the numbers for a calculation you want to
,verify and then press and hold or double-click the AutoCalculate
area to display the Customize Status Bar shortcut menu.
True - ANSWER -The Microsoft Office Specialist (MOS) program
provides an opportunity for you to obtain proof that you have the
Excel 2013 skills required by employers.
True - ANSWER -You can clear cell contents and formatting by
tapping or clicking Clear Contents on the Clear button menu.
True - ANSWER -The equal sign (=) precedes a formula
True - ANSWER -The most common error when entering a formula
is to reference the wrong cell in the formula.
False - ANSWER -An asterick (*) following a cell reference in a
formula is the arithmetic operator that directs Excel to perform
the division operation.
False - ANSWER -The arithmetic operator, ^, directs excel to
perform the division operation.
False - ANSWER -As in algebra, you can use the brackets to
override the order of operations Excel follows to perform
calculations.
,False - ANSWER -If you drag the fill handle to the left or up, Excel
will increment the series rather than decrement the series.
True - ANSWER -The Increase Indent Button indents the contents
of a cell to the right by three spaces each time you click it
True - ANSWER -A requirements document includes a needs
statement, a source of data, a summary of calculations, and any
other special requirements for the worksheet
False - ANSWER -Worksheet title and subtitles should be as
wordy as possible
Themes - ANSWER -PowerPoint displays many _____ that are
varied and appealing and give you an excellent start designing a
presentation.
Title slide - ANSWER -The ___ introduces the presentation to the
audience
Contrast - ANSWER -A photos color intensity can be modified by
changing the brightness and ____
, Style - ANSWER -A ___ is named group of formatting
characteristics
Brightness - ANSWER -____ determines the overall lightness or
darkness of an entire image
Contrast - ANSWER -____ is the difference between the darkest
and lighters areas of an image
Options - ANSWER -The difference between the effects and the
styles is that each effect has several ____ providing you with
more control over the exact look of the image.
Graphical elements - ANSWER -One method of getting the
audiences attention and reinforcing the major concepts being
presented is to have____ on the title slide
Predefined - ANSWER -PowerPoint provides a wide variety of ___
shapes that can add visual interest to a slide
Shapes - ANSWER -Many of the shapes included in the ___
gallery can direct the viewer to important aspects of the
presentation
COMPLETE REAL EXAM QUESTIONS AND (VERIFIED
ANSWERS) / 100% ACCURATE|ALREADY GRADED A+
Workbook - ANSWER -When Excel opens a new _____________ is
created, which is like a notebook.
Worksheet - ANSWER -Inside a workbook are ______________,
each of which has a name.
Descending - ANSWER -To order the records in the Client table in
reverse alphabetical order by City, click the ____ button.
Close - ANSWER -To exit Access, click the ______ button on the
right side of the Access title bar.
True - ANSWER -To add a pie chart, first select the data to be
charted and then tap or click the Insert Pie or Doughnut Chart
button (INSERT tab | Charts group).
False - ANSWER -To use the AutoCalculate area, select the range
of cells containing the numbers for a calculation you want to
,verify and then press and hold or double-click the AutoCalculate
area to display the Customize Status Bar shortcut menu.
True - ANSWER -The Microsoft Office Specialist (MOS) program
provides an opportunity for you to obtain proof that you have the
Excel 2013 skills required by employers.
True - ANSWER -You can clear cell contents and formatting by
tapping or clicking Clear Contents on the Clear button menu.
True - ANSWER -The equal sign (=) precedes a formula
True - ANSWER -The most common error when entering a formula
is to reference the wrong cell in the formula.
False - ANSWER -An asterick (*) following a cell reference in a
formula is the arithmetic operator that directs Excel to perform
the division operation.
False - ANSWER -The arithmetic operator, ^, directs excel to
perform the division operation.
False - ANSWER -As in algebra, you can use the brackets to
override the order of operations Excel follows to perform
calculations.
,False - ANSWER -If you drag the fill handle to the left or up, Excel
will increment the series rather than decrement the series.
True - ANSWER -The Increase Indent Button indents the contents
of a cell to the right by three spaces each time you click it
True - ANSWER -A requirements document includes a needs
statement, a source of data, a summary of calculations, and any
other special requirements for the worksheet
False - ANSWER -Worksheet title and subtitles should be as
wordy as possible
Themes - ANSWER -PowerPoint displays many _____ that are
varied and appealing and give you an excellent start designing a
presentation.
Title slide - ANSWER -The ___ introduces the presentation to the
audience
Contrast - ANSWER -A photos color intensity can be modified by
changing the brightness and ____
, Style - ANSWER -A ___ is named group of formatting
characteristics
Brightness - ANSWER -____ determines the overall lightness or
darkness of an entire image
Contrast - ANSWER -____ is the difference between the darkest
and lighters areas of an image
Options - ANSWER -The difference between the effects and the
styles is that each effect has several ____ providing you with
more control over the exact look of the image.
Graphical elements - ANSWER -One method of getting the
audiences attention and reinforcing the major concepts being
presented is to have____ on the title slide
Predefined - ANSWER -PowerPoint provides a wide variety of ___
shapes that can add visual interest to a slide
Shapes - ANSWER -Many of the shapes included in the ___
gallery can direct the viewer to important aspects of the
presentation
