Exam review
If text on a slide is underlined and formatted as bold, which of the following tools can you use to format other text in the same way?
Format Painter
To copy a cell's formatting to another cell, which of the following can you use?
Format Painter
Which of the following alignment options places text so the last character is net to the right edge of a table cell
Align Right
Which of the following alignment options places text, so it is next to the top edge of a table cell?
Align Top
Kevin wants to make sure that people with low vision who use a screen reader can review his presentation. What should he add to images, charts, and other graphics in his presentation?
Alt text
Which of the following will you select as X in the following series of clicks to change the chart layout for lines or bars that you want to change: Chart > Chart Tools > Layout tab > X > Layout option for any lines or bars that you want to add or change?
Analysis
Which of the following lets you extend any data pattern involving dates, times, numbers, or text?
AutoFill Options button
What can you do to make data series easier to distinguish from another?
Change the color of the data series
Which of the following keys will you press after clicking on a chart to remove it from excel sheet but keep the data intact?
Delete
When you add a field to a table in Table Design view, the _______ property is optional.
Description
Which key do you press to remove all characters when editing a field value in Table Datasheet view?
ESC
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?
Edit the conditional formatting rule.
The Push transition is applied to Slide 1 of your presentation. You want to modify this transition to change the direction. Which of the following options would you use to make this modification?
Effect Options
To import data from Excel to Access, you would begin by clicking the __________.
External Data tab
To link the data form one table to another in an Access relational database, a(n) __________ must be common to each table.
Field
Which two properties are required for every field?
Field Name and Data Type
Marianna wants to add a border to a legend. Which of the following should she select as X in the following series of clicks to do so?Legend > (right click) Format legend > Legend Options > X > Border > Solid Line
Fill & Line
To change the color of cell content, you use the ________ color list arrow.
Font
The _________ key field is the linking field on the "many" side for the relationship.
Foreign
A _______ typically shows all the fields for one record on a single screen for data entry and editing.
Form
To format a cell range so that values between 100 and 500 appear in red, who in of the following can you use?
Highlight Cells Rules
Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells?
Highlight Cells Rules
To apply a cell style, you would use the Cell Styles command on the _____ tab.
Home
Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?
IF
Which of the following is a type of logical function?
IF
You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?
If it needs an absolute cell reference.
You can use the _______ to copy data from Excel to Access.
Import Spreadsheet Wizard
________ makes a duplicate copy of the data in the Access database
Importing
Which of the following can you do to make a chart title stand out on a chart?
Increase font size
Which process is most likely copying and pasting?
importing
What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)
number of the column containing the return value
Tables, queries, and forms are examples of Access _________.
objects
You double-click the Format Painter button when you want to _____.
paste the same format multiple times
To have Excel enter the lowest price from a range of prices, which of the following would you use?
MIN function
Which of the following identify the spacing between the units on the value axis?
Major gridlines
In column D of a worksheet, Cal lists the number of hours each employee works. What function should he use to find the employee who worked the most hours?
Max
If you want an object on a slide to move after it is displayed, but you don't want the object to disappear, what type of animation should you apply?
Motion Path
Which of the following will you select as X in the following series of clicks/entries to change the number format of a chart axis: (Double-click) Value Axis labels > Format Axis > Axis Options > X > Select choice in Category box?
Number
The clipboard task pane shows the contents of the _________.
Office Clipboard
The zoom animation is applies an object. By default, PowerPoint will animate an object ________.
On Click
When you apply an animation, what is the default setting for how the animation starts?
On Click
When you apply an animation, which of the following is the default Start setting?
On Click (incorrect)
When can you rename a table?
After you close the table.
Which of the following alignment options places text, so it is next to the bottom edge of a table cell?
Align Bottom
Which of the following alignment options places text so the first character is next to the left edge of a table cell?
Align Left
If the VLOOKUP function cannot find a match in the lookup table, what does it return?
#N/A error value
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?
$A$5
What is the correct formula to insert the date January 12, 1998 into a cell?
=DATE(1998,1,12)
Which formula can be applied for the given data in a cell A2: 01/01/2017 to get the serial number of the date as text?
=DATEVALUE(''01/01/2017'')
Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?
=DAY(A1)
Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?
=HOUR(A1)
The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following function should you insert in cell C2 to check whether the student has passed or failed?
=IF(B2 >= 60, "Pass", "Fail")
Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?
=MINUTE(G5)
Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?
=MONTH(F5)
Jason wants to average the sales in the range C3:C50, and then round the result to the nearest integer. Which of the following formulas should he use?
=ROUND(AVERAGE(C3:C50),0)
Which of the following functions would you use to calculate the arithmetic mean of a price list?
AVERAGE
Which data type is used for sequential integers controlled by Access?
AutoNumber
How can you distinguish between a manually added page break and an automatic page break in a worksheet?
Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines.
What should you do if you want to make a copy of a database in a secure location?
Back up the database.
If you want to shade every other row in a PowerPoint table, which of the following options do you select on the Table Tools Design tab?
Banded Rows
If you want to format a picture so it looks like it has a frame, which of the following should you add?
Border
Tyler created a table with an AutoNumber primary key field, and then entered 10 records in alphabetical order by the values in the LastName field. When he closes and then reopens the table, how are the records ordered?
By the primary key field
Which of the following alignment options places text, so it is the same distance form the top and bottom edges in a table cell?
Centered Vertically
Ravi wants the title of the last slide in her presentation to stand out. Which of the following will help her do this?
Change the color of the title text.
Which of the following is text that describes the data illustrated in the chart?
Chart Title
Steffie needs a wider left margin in her worksheet. Which of the following can she do to change the margin?
Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.
When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. What can she do to prevent the formatting change?
Click the AutoFill Options button and then click Fill Without Formatting.
If selected text is bold, how do you change it so that it is no longer bold?
Click the Bold button on the Home tab on the ribbon.
How do you apply a glow effect to text?
Click the Text Effects button, point to Glow, and then click a glow effect.
Which of the following actions would change the format of selected text or a selected text box?
Click the Underline button on the Home tab.
After starting Access, which of the following is the fastest way to open a database you worked on yesterday?
Click the database you want to open in the list of recent databases.
While working in Page Layout view, how can you enter your name so it appears in the lower-right corner of the printout?
Click the footer section on the right and type your name.
What will you do to explode a pie chart slice?
Click the pie chart, then double-click the slice you want to explode, and drag it away from the center of the chart.
Use the ______ to exit Access.
Close button
What should you do when you are finished working a database?
Close the database
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.
Color
Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart>Chart tools> Design tab> Type group> Change chart type>All charts>X>Clustered column> OK?
Column
To relate two fields in a one-to-many relationship, you connect them using a _____________.
Common field
When you ________ a database, you make more storage space available and enhance the performance of the database.
Compact and repair
Jacquard wants to use a cell style similar to the default Title style, but with larger font size and different font color. What can he do?
Create a custom cell style.
Kyle inserted a photo of a dog on a slide. In the photo, the dog is on the right, and an empty street is on the left. What can Kyle do to remove the part of the photo that contains the empty street?
Crop the photo
Which of the following will you select as X in the following series of clicks/entries to insert a chart using the Quick Analysis tool: Range of cells > X > Charts > Select Chart Type you want?
Ctrl + Q
Which data type works best to store dollar amounts?
Currency
You can right-click the status bar to display the ________.
Customize Status Bar shortcut menu
If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them.
Data Bars
Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?
Data Callout (I got this wrong; not sure the right answer, I put Inside End)
The second-level bulleted items on one of Carlos's slides is 14-point Calabrian. His associate thinks those items are hard to read. How can Carlos improve the readability of that slide?
Increase the font size of the second-level bulleted items by using the Increase Font Size button.
Which of the following tabs will you click to select a symbol from the Symbols dialog box?
Insert
Which of the following Excel tools displays the syntax for a selected function?
Insert Function dialog box
Which of the following will you select as X in the given series of clicks to insert a 3-D pie chart: Insert > Charts group > X > 3-D Pie?
Insert Pie or Doughnut Chart
After you click "Share" on a presentation, a drop-down menu appears below the "Invite people" box. What is the function of the drop down menu?
It allows you to determine whether your invitees can edit the file or only can view the file. (Incorrect)
Which formatting command changes text so it is slanted?
Italic
Which of the following will you select as X in the following series of click/entries to change the number format of data labels in a chart: (Double-click) Data labels > Format Data Labels > X > Number > Select choice in Category Box?
Label options
Which of the following will you select as X in the given series of clicks to add a legend to the bottom of a chart: Chart > + sign > X > Bottom?
Legend
Annemarie lists 12 months of product sales data in the range A3:M7. The products are listed in the range A3:A7 and the monthly sales data in the range B3:M7. She wants to display a simple chart at the end of each row in column N to track the monthly sales for each product. What can she insert in the range N3:N7?
Line sparklines
The title text box on a slide in Kelly's presentation has the Wheel entrance animation applied to it. She decided that she does not want the title text to animate. Which of the following actions removes the animation of the selected title text box?
On the Animations tab, click None in the Animation gallery.
A slide in Olivia's presentation has the Title and Content layout applied. The bulleted list on the slide contains 14 items and each item is only one or two words, so Olivia thinks the Two Content layout would work better than the Title and Content layout. How does she change the slide's layout?
On the Home tab, click the Layout button, and then click Two Content
Amelia needs to make similar changes to two slides in her presentation. To ensure that the changes she makes are consistent, she wants to be able to see the two slides side by side. Which of the following is the best method for doing this?
Open the presentation in a new window
To rotate cell content to an exact value, you change its _________.
Orientation
Bree added data labels to a pie chart, where they appear on each slice. She wants the data labels to appear outside of the pie chart but close to each slice. Which label Position option should she select from the data labels?
Outside End
Igor wants to set 1-inch margins on the left and right and 0.5-inch margins on the top and bottom of a printed page. Which of the following dialog boxes should he use to change the margins?
Page Setup dialog box
Amari wants to paint the format of one object onto a target object. She selects the first object, then clicks on Format Painter, on the Clipboard group in the Home tab. She then observes the cursor change to a specific icon. Which of the following is the icon into which the cursor changed?
Paintbrush
Which of the following is the space before or after paragraphs?
Paragraph spacing
The _______________ to the left of a table record indicates that you are editing the record.
Pencil symbol
Which of the following will you click under the Picture tools on the Format tab to change a picture to a SmartArt?
Picture Layout
To which of the following chart types can you not add axis titles?
Pie Chart
Under which tab will you click the Rewind After Playing checkbox?
Playback
What unit is a text size measure in?
Points
What is the information such as the author's name, a keyword, or the title, that helps others understand, identify, and locate the file called?
Presentation Information
If you need to move an object on a slide a very small distance to the left, which of the following actions is the best method for accomplishing this?
Press CTRL+LEFT ARROW.
Eleanor wants to repeat the first row of the worksheet on each printed page of a four-page worksheet. Which of the following options should she use in the Page setup dialog box??
Print titles
You can create an Access report by selecting fields from one or more tables or
Queries
___________ is a set of Access rules that governs data entry and helps ensure data accuracy.
Referential integrity
How do you apply a theme to only one slide in a presentation?
Right-click the theme on the Design tab, and then click Apply to Selected Slides.
Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?
Round(A5,2)
Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?
Save the table.
Which of the following chart types show how two numeric data series are related to each other?
Scatter
Which of the following dialog boxes do you use to remove a data series from a chart?
Select Data Source dialog box
What must you do before removing a page break?
Select a cell below or to the right of the page break.
Which of the following commands let you add color to table cells?
Shading
If you want to format a table on a slide so that it looks like it is floating above the slide, which effect should you apply?
Shadow
Which of the following tools can you sue to create a query?
Simple Query Wizard
If you want to see many slide thumbnails on the screen at the same time, which view should you use?
Slide Sorter
Ran needs to rearrange the slides in his presentation. Which of the following views would be the best one to use?
Slide Sorter
Which view do you choose if you want to see a thumbnail of each slide in a presentation arranged in a grid?
Slide Sorter
In which object can you rename a field?
Table
Which of the following is a grid used to organize data and that is composed of columns and rows?
Table
Which of the following will you select as X in the following series of clicks to apply a shadow effect: (Double-click) Text box > Format Options > Text Options > X > Shadow?
Text Effects
SmartArt consists of the graphic and which of the following?
Text pane
What can you do if you do not want to show the first minute of video in a presentation?
Trim the video
Betty wants to choose the list to create a custom number format. To do so, what should she choose after the following series of clicks? Home tab < Number group < Number Format list < More Number Format < Format Cells dialog box < Category < Custom
Type
How can you remove data labels from a chart?
Uncheck the box beside Data Labels in Chart Elements.
What is the most efficient way to navigate to the last record in a table containing 100 records?
Use the Last record button on the navigation bar.
In each theme, what are the alternate designs that could include different colors, fonts, effects, and slide elements, called?
Variants
Which option should you click on after selecting Video on Insert tab to insert a video from your system?
Video on my PC
Gabriella plans to print her slides on a printer that does not print in color. Which of the following actions should she do before she prints the entire presentation?
View the presentation in grayscale.
Arlo wants to use Goal Seek to answer a what-if question in worksheet. Which button should he click on the Data tab to access the Goal Seek command?
What-if analysis
What will you select as X and Y in the following series of clicks/entries to insert a Clustered Column - Line Combination chart: Range of cells > Insert tab > Charts group > Insert Combo Chart symbol > Create Custom Combo Chart > Insert Chart dialog box > All Charts > Series 1 > X (Chart type) > Series 2 > Y (Chart type) > OK?
X - Clustered Column, Y - Line
Which data type stores only one of two values?
Yes/No
Which of these will you click in Text pane to add text to a SmartArt?
[Text]
In the formula =B6*$B$2, which of the following describes $B$2?
absolute cell reference
Olivia wants to align a certain shape on her worksheet in a specific manner. To do so, she clicks on the shape, and then clicks on the Format tab under Drawing Tools. She then clicks on Align in the Arrange group. What should Olivia click on next to align the picture to the left?
align left
You can import table data from _____.
another Access database
For use as watermark, Alba wants to insert a picture as a worksheet background. For this, she clicks the desired worksheet, then selects option X from the Page Layout tab in the Page Setup group. Alba then selects the picture and then clicks Insert. What can X in her series of selections be?
background
You can use the Find and Replace dialog box to find and replace ________.
cell formatting
To rename a field in Table Datasheet view, you change the text in the ______.
column heading
To format a range so that all values greater than $500 appear in red, which of the following can you use?
conditional formatting
What is alt text?
descriptive text added to an object
A category of data such as a customer's name, city, state, or phone number is called a
field
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?
fill handle
A __________ refers to a collection of characters with a similar, specific design.
font
When you underline cell content, you are using ________.
font style
Which of the following Print settings prints each slide so it fills the piece of paper?
full page Slides
A group of related fields, such as all the demographic information for one customer, is called a _________.
record
The goal of building one-to-many relationships between tables is to minimize __________ data.
redundant
If you want to manage lists of data about customers and the products they order, use ______ software.
relational database
Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?
sum
Which Access object contains all of the data in the database?
table
A relational database can best be described as a collection of related _______ designed to minimize redundant data.
tables
If you move the City column in a table Datasheet, _________.
the City field also moves in Table Design view
To move a slide in Normal view, what do you drag in the pane on the left?
the slide thumbnail
Which of the following elements can you add to a chart to display a line representing the general direction in a data series?
trendline
A ______ chart tracks the addition and subtraction of values within a sum.
waterfall
The Percent style formats numbers as percentages with _____ decimal places by default.
zero
