CIS FINAL EXAM WITH ACCURATE
SOLUTIONS
The ________ formula "returns the largest value in a set of values - ANSWER-Max
What is the name of the box that allows the user to find the appropriate function to
perform a specific task within a cell in MS Excel. - ANSWER-Insert Function
You don't have to Protect the entire Workbook in Excel. You can Protect just the Sheet -
ANSWER-True
The _________ tool group allows you to set the height and width of the cells -
ANSWER-Scale to Fit
Landscape orientation is ideal when I have more Columns than Rows to show on a
chart - ANSWER-True
The Degrees Function is in the _____________ formula category. - ANSWER-Math &
Trig
The cell that highlights every cell on the sheet is in the ________________. -
ANSWER-Top Left corner
Excel Sheets in a Workbook can be renamed from "Sheet 1, Sheet 2, Sheet 3" to
custom names - ANSWER-True
Which tool allows me to make space for more content by spreading it to another line? -
ANSWER-Wrap Text
In order to insert a row between rows 7 and 8, you have to select and right click on row
______. - ANSWER-8
If I want my cell data to appear in the top right corner of the cell than I should
select____________ in the Alignment Tool Group. - ANSWER-Top Align, Align Text
Right
"Scientific" is a type of numbering format. - ANSWER-True
It is possible to Format a Condition where the cell shows red, green and blue flags as
Icon Indicators - ANSWER-False
, __________________ is the name of a chart inserted within a single cell. - ANSWER-
Sparkline
There is a Tool that allows you to hide a slide from the presentation so that it doesn't
show during a full-screen presentation. - ANSWER-True
The Arrange Tool allows you the option to ReGroup and UnGroup objects in a slide. -
ANSWER-True
If a PPT slide will not advance automatically, nor with the mouse click then
_____________ - ANSWER-none of the Advance Slide settings were chosen
Headers have to be inserted on each slide if you want it throughout the entire slide
show - ANSWER-False
Animation Timing cannot be triggered ______________ - ANSWER-Before previous
When you "Loop" a transition sound, then it means the sound will _______________ -
ANSWER-Repeat the sound until the next slide or sound file
Background Styles can be formatted to change their transparency - ANSWER-True
Radar charts kind of look like a spider web - ANSWER-True
Which tool allows me to copy a portion of another screen, to paste it onto a Powerpoint
slide? - ANSWER-screenshot
Landscape Orientation is horizontal, side to side - ANSWER-True
Sound file downloads are always virus free, unlike Video file downloads - ANSWER-
False
I can set up a PPT slide show to play only selected slides - ANSWER-True
I can place the "Ungroup" Tool on the Quick Access Toolbar - ANSWER-true
There is only one way to create a table in a PPT slide - ANSWER-False
How many different available formats are available to choose from if you want to insert
the Date and Time on PPT slides? - ANSWER-13
If I'm on slide 3 and I click the View From Current Slide button, the slide show will start
over from the beginning - ANSWER-false
SOLUTIONS
The ________ formula "returns the largest value in a set of values - ANSWER-Max
What is the name of the box that allows the user to find the appropriate function to
perform a specific task within a cell in MS Excel. - ANSWER-Insert Function
You don't have to Protect the entire Workbook in Excel. You can Protect just the Sheet -
ANSWER-True
The _________ tool group allows you to set the height and width of the cells -
ANSWER-Scale to Fit
Landscape orientation is ideal when I have more Columns than Rows to show on a
chart - ANSWER-True
The Degrees Function is in the _____________ formula category. - ANSWER-Math &
Trig
The cell that highlights every cell on the sheet is in the ________________. -
ANSWER-Top Left corner
Excel Sheets in a Workbook can be renamed from "Sheet 1, Sheet 2, Sheet 3" to
custom names - ANSWER-True
Which tool allows me to make space for more content by spreading it to another line? -
ANSWER-Wrap Text
In order to insert a row between rows 7 and 8, you have to select and right click on row
______. - ANSWER-8
If I want my cell data to appear in the top right corner of the cell than I should
select____________ in the Alignment Tool Group. - ANSWER-Top Align, Align Text
Right
"Scientific" is a type of numbering format. - ANSWER-True
It is possible to Format a Condition where the cell shows red, green and blue flags as
Icon Indicators - ANSWER-False
, __________________ is the name of a chart inserted within a single cell. - ANSWER-
Sparkline
There is a Tool that allows you to hide a slide from the presentation so that it doesn't
show during a full-screen presentation. - ANSWER-True
The Arrange Tool allows you the option to ReGroup and UnGroup objects in a slide. -
ANSWER-True
If a PPT slide will not advance automatically, nor with the mouse click then
_____________ - ANSWER-none of the Advance Slide settings were chosen
Headers have to be inserted on each slide if you want it throughout the entire slide
show - ANSWER-False
Animation Timing cannot be triggered ______________ - ANSWER-Before previous
When you "Loop" a transition sound, then it means the sound will _______________ -
ANSWER-Repeat the sound until the next slide or sound file
Background Styles can be formatted to change their transparency - ANSWER-True
Radar charts kind of look like a spider web - ANSWER-True
Which tool allows me to copy a portion of another screen, to paste it onto a Powerpoint
slide? - ANSWER-screenshot
Landscape Orientation is horizontal, side to side - ANSWER-True
Sound file downloads are always virus free, unlike Video file downloads - ANSWER-
False
I can set up a PPT slide show to play only selected slides - ANSWER-True
I can place the "Ungroup" Tool on the Quick Access Toolbar - ANSWER-true
There is only one way to create a table in a PPT slide - ANSWER-False
How many different available formats are available to choose from if you want to insert
the Date and Time on PPT slides? - ANSWER-13
If I'm on slide 3 and I click the View From Current Slide button, the slide show will start
over from the beginning - ANSWER-false
