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