MIS Final
In the context of logical functions, the _________ symbol in the logical test argument is a comparison operator.
=
In Microsoft PowerPoint, you can use options on the _________ button menu to soften details in a photo or adjust the brightness and contrast to change the difference between dark and light areas in the photo.
Corrections
In Microsoft Access 2016, you cannot change the default primary key.
False
In Microsoft PowerPoint, the Remove Background tool is available only to shapes.
False
SmartArt diagrams cannot be animated.
False
The font size—the size of the text—in subitems is larger than the size used for text in the level above.
False
The horizontal axis is the axis along the side of the chart that shows the range of values from all of the data series plotted on the chart.
False
The order of operations that Microsoft Excel follows is division, multiplication, exponentiation, and addition.
False
A word document in plain text file format preserves the formatting and layout of data.
False
In Microsoft Word, you can use the Text from Slide command on the Object button menu to insert text of another text file into a slide.
False
Notes view was designed to make it easier to display a slide show using a second monitor or a projector screen.
False
The header and footer entered in an Excel sheet are static and do not get updated automatically when the worksheet"s name is changed.
False
The page number appears in the header of notes and handouts by default.
False
You can export Access data directly to a PowerPoint slide.
False
In Microsoft Access 2016, _________ refers to the maximum storage size for Short Text, Long Text, Number, and AutoNumber fields.
Field Size
A row or a column in an Excel worksheet can be hidden by using the _________ button on the Home tab.
Format
To access conditional formatting on Microsoft Excel, click the Conditional Formatting button on the _________ tab.
Home
Which of the following is true of a report in Microsoft Access 2016?
It shows field values for each record in a row.
A text argument can be included in an IF function by enclosing it in quotation marks.
True
The Conditional Formatting button is available on the Home tab in Microsoft Excel.
True
To enter records in a table datasheet, you type the field values below the column headings for the fields.
True
To have a specific date always appear on slides, select the Fixed option button on the Slide tab in the Header and Footer dialog box, and then type a date in the Fixed box.
True
Using one of the buttons on the Paste button menu allows you to choose to keep the source file theme and formatting or apply the theme and formatting in the destination file.
True
You can use the Check for Errors command to simulate the merge and list any errors found.
True
Click the _________ tab to change the volume of the video from high to medium or low or mute it.
Video Tools Playback
When working with Microsoft Access 2016, Zafar adds fields in Design view and wishes to switch to Datasheet view to enter records. He clicks the View button before saving the table design. Which of the following is a consequence of Zafar's action?
When working with Microsoft Access 2016, Zafar adds fields in Design view and wishes to switch to Datasheet view to enter records. He clicks the View button before saving the table design. Which of the following is a consequence of Zafar's action?
The _________ shows the patterns or relationship between two or more sets of values.
X Y (Scatter) Chart
In Microsoft Excel, _________ is a page break that Excel inserts when no more content will fit on the page.
automatic page break
A(n) _________ is a placeholder designed to hold any type of slide element—text, a graphic, or another object.
content placeholder
A _________ is a horizontal bar that is always placed in the cell containing the value it represents.
data bar
A _________ is a main item in a list.
first-level item
In a mail merge, data source is a file that contains the variable information for a _________.
form letter
A _________ in PowerPoint is text that appears at the top of handouts and notes pages in a document.
header
Since extensive data in the form of numbers can be difficult to assimilate, such data are better represented as charts. There are several types of charts available in Microsoft Excel. Choosing the right chart type to represent a data source is important to effectively illustrate a data. A chart type should be chosen based on the number of data series, range of data series values, type of data series etc. Benjamin, a nuclear physicist, needs to represent electron decay at five time intervals for ten different elements. Benjamin thus has five data series for ten category values. In this scenario, Benjamin can use a _____ to represent the data.
line chart
A(n) _________ is a list of paragraphs with sequential numbers to the left of each paragraph.
numbered list
When you create slides from a(n) _________ of a Word document, PowerPoint inserts them after the current slide.
outline
If you use the Reset button on the Home tab in a Microsoft PowerPoint 2016 presentation, _____. ed item on the slide.
the position, size, and formatting match the settings in the slide masters.
A _________ is the manner in which the next slide appears on the screen in place of the previous slide during a slide show.
transition
A bar chart is a column chart turned on its side so that the length of each bar is based on its value.
true
When text is typed in a shape, the text _____.
will wrap in the shape automatically
While using Flash Fill, make sure that:
you enter the data pattern in the column right next to the related data.
Which of the following is true of a database created in Microsoft Access 2016?
A table can have many foreign keys
The print screen in Microsoft PowerPoint 2016 appears in _____.
Backstage view
Which of the following is true of slide animations in Microsoft PowerPoint 2016?
By default, animations are set to start On Click.
Zelda, the Human Resource (HR) manager at ProfDot Technologies, creates a database on an Excel sheet of the names of potential candidates for a job. In addition, she enters the work experience, current salary, and expected salary against each name. Zelda uses conditional formatting to make the following changes: change the background color of the cells with current salary of $3000 to $4000 to yellow, change the font color, generate data bars on each cell, and highlight the cells containing the names with blue color. In this scenario, which of the following changes will be applied first?
Changing the background color of the cells to yellow
Wayne, a senior software engineer, creates a chart using Microsoft Excel that represents the number of projects and types of projects undertaken by a team in the past five years. The chart presents the chart legend below the chart by default. Wayne wants to change the position of the chart legend to the left of the chart. In this scenario, Wayne should click the _____ to change the position of the legend.
Chart Elements button
Judith, a management student, creates a graph showing the number of start-ups commenced in her country in the year 2015. She uses a pie chart to represent her data. Judith, while reviewing her graph, feels that she should change the colors of the pies since she had used a dark colored background. In this scenario, Judith should click the _____ to change the color of the pies.
Chart Styles button
Eugene, a financial analyst, collects data on the gross income of people working in different industries. She presents this data in a bar graph. However, she later feels that a line graph will be more appropriate for representing the data. In this scenario, Eugene should click the _____ in the Excel sheet to change the graph type.
Chart Tools Design tab
Zelda, the Human Resource (HR) manager at ProfDot Technologies, creates a database on an Excel sheet of the names of potential candidates for a job. In addition, she enters the work experience, current salary, and expected salary against each name. Zelda previously highlighted the cells with the names of candidate who have over two years of work experience using conditional formatting. If Zelda wants to remove the condition from the worksheet, she should use the _____ option.
Clear Rules
Which of the following is possible on Microsoft PowerPoint?
Creating a custom layout
Which of the following is a true statement about chart elements in Microsoft Excel?
Excel allows you to edit or replace the default chart title.
Frank, a management consultant, creates a Microsoft PowerPoint presentation about different management styles. After making the PowerPoint slides, he wants to upload the presentation to a Web site in the form of a video. In this scenario, Frank should use the _____ function in the navigation tab in Backstage view to convert the presentation to a video format.
Export
Which of the following is an example of conditional formatting?
Highlighting cells based on their values
The arrow in the accompanying figure of a Microsoft PowerPoint 2016 presentation is pointing to the _____.
Normal button
The _____ is the area of the PowerPoint window that contains notes for the presenter to refer to when delivering a presentation.
Notes pane
Josh is a student who works on PowerPoint. He creates a presentation that uses many bulleted points. He notices that some of the points are not in logical order. Instead of deleting the points and typing them over, Josh can switch to the _____ pane and rearrange the points.
Outline
Lillian, a student working on PowerPoint, wants to begin adding content to a new presentation.Lillian connects her slide to a projector. She starts a slide show and the view she was previously working on automatically changes. It now shows a large view of the current slide and a smaller view of the next slide, as well as speaker notes. She also sees navigation buttons which allow her to move from slide to slide. In this scenario, Lillian is viewing her slides in _____ view.
Presenter
Steve, a sales manager, maintains a worksheet for sales details, which includes his target, the number of sales achieved, the clients, etc. in the past two years. If Steve wants to print these details for just the last quarter, Steve should use the _____.
Print Area button
Which of the following is true of creating a database in Microsoft Access 2016?
The Navigation Pane is the main control center for opening and working with database objects.
Han, an environmental lawyer, travels around the United States to create awareness and propagate the environmental law. She presents such information in various institutes on PowerPoint slides. Han creates her first slide in her presentation - Content. This slide typically lists the headings and subheadings in the form of bullets and subpoints. Which of the following statements is true by default if Han animates the Content list? __ group in the Animations tab.
The subitems animate at the same time as their first-level bullet.
Which of the following is true of Speaker Notes?
They help the speaker remember what to say when a particular slide appears
Which of the following is a function of the Office Clipboard?
To collect text and object from various files
In the context of mail merge in Word, when you click the Check for Errors button, _____.
Word opens a dialog box that simulates a mail merge
George, an environmental scientist, collects information on the types and amount of gases emitted by a cheese processing factory. George decides to present the data on an Excel sheet in the form of bars against X and Y axes. In this scenario, George presents the data in the form of a _____.
chart
Conditional formatting can be used to:
clear all the rules in a workbook
To reposition a graphic on a slide, _____.
drag it to its new position
If a row is hidden in an Excel sheet, _____.
it does not get printed on paper
When a text box is active, _____.
its border is a dotted line
In a pie chart, each pie slice always represents _____.
one data series value
Flash Fill enters text based on _____.
patterns it finds in the data
Alisha, a teacher, is required to maintain a database of the students in her class. She keeps track of each student's name, registration number, grades, and the number of courses they have signed up for. She uses Microsoft Access 2016 to maintain and manage the database. Alisha wants to retrieve the names of the students who have consistently obtained B grade and above. She requests information from the database for the details of all the students that satisfy this criteria. The information requested by Alisha is an example of a _____.
query
Bulleted items in Microsoft PowerPoint can be moved by working in _____.
the Outline pane
The Error Checking button appears on an Excel sheet when:
the cell containing the error is the active cell
In the context of mail merges, you can explicitly identify a merge field by:
using the Match Fields dialog box
John, a researcher, collects a large amount of data to perform statistical analysis and saves them using Excel. He wants to print the data and bind the pages to submit as a thesis. In this scenario, John has to _____ to accommodate the page binding.
widen the margins
A _________ is an illustration that visually depicts information or ideas and shows how they are connected.
diagram
Files created in PowerPoint are called _________.
presentations
Frank, a business analyst at Pro-White Technologies, deals with vast amount of data and analysis. Since Frank uses Excel worksheets for most of his work, he uses several advanced functions of Excel that eases and speeds up his work. Frank fills eight columns and over a thousand rows of text in an Excel worksheet. He wants to collate the text in three of the columns in a single column. Frank enters the first two cells manually and then uses the Flash Fill function. Flash Fill suggests a pattern that is not the pattern Frank requires. To reject the suggested pattern, Frank should press the _____ key.
Esc
Identify a true statement about deleting a graphic in a theme on a PowerPoint slide.
It can be done in a Slide Master view.
Which of the following statements is true of the IF function in Excel?
It can include text within quotations
Which of the following is true of a slide master?
It ensures that all the slides in a presentation have a similar appearance.
In Microsoft Excel, which of the following is true of a chart legend?
It identifies each data series in a chart
Which of the following best defines the term wizard?
It is a series of dialog boxes that takes you step-by-step through a process
Which of the following is true of printing the data in an Excel sheet?
It prints as much of the content that fits on a single page.
Lillian, a student working on PowerPoint, wants to begin adding content to a new presentation. Lillian wants to be able to see how it will look during a slide show, and she wants quick access to thumbnails or an outline. In this scenario, she should use _____ view.
Normal
Sarah, who has been an apparel retailer for ten years, wants to analyze and compare the monthly profits for the ten years. She fills details such as the year, month, and profit in three columns on an Excel sheet. She wants to highlight the months with a profit of more than $100. In this scenario, Sarah should use the _____ function to highlight the relevant cells at once.
conditional formatting
Robert, the manager of a small-scale software firm, uses Microsoft Access 2016 to store employee details. He maintains the database and updates it as the details change. Robert retrieves the stored details as and when required using Access. Robert adds a new column in the database to include each employee's strength. The new column added by Robert to include a characteristic of each employee is an example of a _____.
field
Roger, an accountant at SellDom Inc., has entered the company's expenditure, assets, profits, and debt details on an Excel sheet. Since the data are valuable, he needs to retain and save the sheet. If Roger wants to print only the details of the company's expenditure and profits from the Excel sheet, he should:
hide the assets and debts columns.
_________ is the Access view that shows exactly how a report will look when printed.
Print Preview
If you select a chart's sequence, the formula displayed in the formula bar uses the _________function.
SERIES
Jessie, a student, creates a PowerPoint presentation. She views her presentation in the Slide Sorter view and is unable to see more than two slides on her screen. Which of the following should Jessie do to see more slides on her screen?
Jessie should decrease the zoom level of the presentation.
Emmet manages a cafeteria at a university and has to update the policy on seating and special dietary requirements. He creates a Word file for the policy and then selects a list of contacts from the University's intranet. He picks the Word file as his main document and the list of contacts as a data source. Before Emmet completes a mail merge, he should:
insert merge fields into the main document.
Vivian, a doctor, creates a PowerPoint presentation on cardiac diseases. In one of the slides, he adds a video that plays for a minute. Vivian intends to shorten the length of the video. In this scenario, Vivian should _____.
trim the video
Bob is making a PowerPoint presentation and has created a few slides from a Word outline. After completing his work, he notices that a few slides do not have the same formatting as the rest of the slides. To correct this, Bob should:
use the Reset button in the Home tab.
If a formula contains several functions, Excel starts with the outermost function and then moves inward.
False
The error value "#N/A" indicates that:
a value is not available to a function or formula.
