CSci
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
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)
Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?
=MINUTEG5
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)
What is information such as the author's name, a keyword, or the title, that helps others understand, identify, and locate the file called?
?
What is the correct formula to insert the date January 12, 1998 into a cell?
A. =DATE(1998,1,12)
The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?
A. =IF(B2 >= 60, "Pass", "Fail")
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?
A. Click the AutoFill Options button and then click Fill Without Formatting.
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?
A. Open the presentation in a new window.
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 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.
Which of the following functions would you use to calculate the arithmetic mean of a price list?
Average
Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?
B. =HOUR(A1)
Ravi wants the title of the last slide in her presentation to stand out. Which of the following will help her do this?
B. Change the color of the title text.
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?
B. On the Home tab, click the Layout button, and then click Two Content.
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?
B. X - Clustered Column, Y - Line
Which of the following tools can you use to create a query?
B:Simple Query Wizard
What should you do if you want to make a copy of a database in a secure location?
Back up the 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
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
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?
C. Analysis
In each theme, what are the alternate designs that could include different colors, fonts, effects, and slide elements, called?
C:Variants
How can you display the title of a report in green?
Change the font color of the label in the Report Header.
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.
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.
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.
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 data type works best to store dollar amounts
Currency
Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016 ?
D. =MONTH(DATE(2016,7,0))
If selected text is bold, how do you change it so that it is no longer bold?
D. Click the Bold button on the Home tab on the ribbon.
Which of the following can you do to make a chart title stand out on a chart?
D. Increase the font size.
When you _____ a database, you make more storage space available and enhance the performance of the database.
D:compact and repair
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.
Which two properties are required for every field?
Field Name and Data Type
Which view can you use to add a new record to a table?
Form view
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
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.
How do you apply a theme to only one slide in a presentation?
It is NOT Click a theme on the Design tab, and then click the slide thumbnail.
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
To have Excel enter the lowest price from a range of prices, which of the following would you use?
MIN function
When you create a form containing data from two tables that have a one-to-many relationship, what type of form are you creating?
Main form with a subform
After you click "Share" on a presentation, a drop-down menu appears below the "Invite people" box. What is the function of this drop down menu?
NOT It allows you to determine whether your invitees can edit the file or only can view the file.
The _____ to the left of a table record indicates that you are editing the record.
NOT plus sign
To add a picture to the Form Header section, click the _____ button on the Design tab when modifying the form.
NOT title
The Zoom animation is applied an object. By default, PowerPoint will animate an object _____.
NOT with previous
Tyler created a table with an AutoNumber primary key field, and then entered 10 records in alphabetic order by the values in the LastName field. When he closes and then reopens the table, how are the records ordered?
Not any date field
When you apply an animation, which of the following is the default Start setting?
Not on click
A _____ typically shows all the fields for one record on a single screen for data entry and editing.
Not report
By default, the objects you create in a database are formatted with which theme?
Office
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.
To rotate cell contents to an exact value, you change its _____.
Orientation
Which of the following will you click under the Picture tools on the Format tab to change a picture to a SmartArt?
Picture layout
The _____ button creates a new, blank report in Report Design view.
Report Design
Which Access feature asks you a series of questions and then creates a report based on your answers?
Report Wizard
Which Access tool guides you through the steps of creating a report?
Report Wizard
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.
While working in Page Layout view, how can you enter your name so it appears in the lower-right corner of the printout?
Select the right footer text box and type your name.
Which of these will you click in Text pane to add text to a SmartArt?
Text
What happens when you apply a theme to a form?
The formatting changes in all forms and reports.
How can you remove data labels from a chart?
Uncheck the box beside Data Labels in Chart Elements.
How can you highlight report records that include values greater than $500 in the OrderAmt field?
Use conditional formatting.
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
As you create a report, when might you want to work in Report Layout view?
When you want to view the data as you change the report.
Which data type stores only one of two values?
Yes/No
Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?
You can change the orientation of the report to landscape
How is the font set for a table in Table Datasheet view?
You use the Font box on the Home tab.
When you underline cell content, you are using _____.
a font style
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
Which of the following lets you extend any data pattern involving dates, times, numbers, or text?
autofill options button
If you want to format a picture so it looks like it has a frame, which of the following should you add
border
You can use the Find and Replace dialog box to find and replace _____.
cell ref?
Which of the following alignment options places text, so it is the same distance from the top and bottom edges in a table cell?
centered vertically
What can you do to make data series easier to distinguish from one another?
change color of data series
To change the color of cell content, you use the ________ color list arrow.
color
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 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
A _____ is an item on a form that you can manipulate to modify the form's appearance.
control
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?
control left arrow
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?
control q
Jacquan wants to use a cell style similar to the default Title style, but with a larger font size and different font color. What can he do?
create his own cell style
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
Which of the following keys will you press after clicking on a chart to remove it from an 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
What is alt text?
descriptive text added to an object
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?
effects options
A category of data such as a customer's name, city, state, or phone number is called a _____.
field
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 and line
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
After changing the _____ of a report control, you might also need to widen the control.
font size
To copy a cell's formatting to another cell, which of the following can you use?
format painter
Which of the following Print settings prints each slide so it fills the piece of paper?
full pages slide
To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?
highlight cell rules
Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells?
highlight cell rules
The second-level bulleted items on one of Carlos's slides is 14-point Calibri. 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 dialog function box
Which formatting command changes text so it is slanted?
italic
Which of the following will you select as X in the following series of clicks/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
Using the Report Wizard, you can select the _____ for the report.
layout
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
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
When you remove a control layout from a form or report, Access ____.
no longer groups the controls together
Which key do you press to remove all characters when editing a field value in Table Datasheet view?
not delete
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?
not sure
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
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
The Clipboard task pane shows the contents of the _____.
office clipboard
When you apply an animation, what is the default setting for how the animation starts?
on click
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 for 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
You double-click the Format Painter button when you want to _____.
pastes it multiple times
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 text size measure in?
points
What must you do before removing a page break?
print area
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
When using the Form Wizard, you can select fields from tables and _____ in the database.
queries
You can create an Access report by selecting fields from one or more tables or _____.
queries
A group of related fields, such as all the demographic information for one customer, is called a _____.
record
If you want to manage lists of data about customers and the products they order, use _____ software.
relational database
You can use a wizard to create a _____, a formatted printout or display of the contents in tables or queries.
report
To close a report in Print Preview and keep Access running, you _____.
right-click the report tab, and then click Close on the shortcut menu.
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
Which of the following commands lets 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
If you want to see many slide thumbnails on the screen at the same time, which view should you use?
slide sorter
Raj 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
To move a slide in Normal view, what do you drag in the pane on the left?
slide thumbnail
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
Which of the following is a grid used to organize data and that is composed of columns and rows?
table
In which object can you rename a field?
table? (not form)
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
Which of the following elements can you add to a chart to display a line representing the general direction in a data series?
trendline
What can you do if you do not want to show the first minute of video in a presentation?
trim 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 Formats < Format Cells dialog box < Category < Custom
type
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 presentation in grayscale
A _____ chart tracks the addition and subtraction of values within a sum.
waterall
Arlo wants to use Goal Seek to answer a what-if question in a worksheet. Which button should he click on the Data tab to access the Goal Seek command?
what if analysis
The Percent style formats numbers as percentages with _____ decimal places by default.
zero