Csci Final Exam
Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so? (522619)
A:=COUNT(B1:B20)
What is the correct formula to insert the date January 12, 1998 into a cell? (522563)
A:=DATE(1998,1,12)
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? (522565)
A:=DAY(A1)
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? (522546)
A:=IF(B2 >= 60, "Pass", "Fail")
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? (522562)
A:=ROUND(A5,2)
When you paste formula cells using the Paste button in the Clipboard group, which of the following is true? (522643)
A:A button appears near the selected cells with options for pasting formulas and values.
How can you distinguish between a manually added page break and an automatic page break in a worksheet? (522506)
A: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? (522018)
A:Back up the database.
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? (533061)
A:Click the AutoFill Options button and then click Fill Without Formatting.
To select a single worksheet cell so you can work with it, which of the following would you do? (522601)
A:Click the cell.
Use the _____ to exit Access.
A:Close button
Which of the following is true about inserting cells in a worksheet? (522638)
A:Excel automatically adjusts cell references to reflect new formula locations.
When you insert a column in a worksheet, what happens to formulas you already entered? (522652)
A:Excel updates their cell references to reflect the new layout.
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? (522552)
A:If it needs an absolute cell reference.
By default, the objects you create in a database are formatted with which theme? (522233)
A:Office
The Clipboard task pane shows the contents of the _____. (522517)
A:Office Clipboard
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? (522580)
A:Sum
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?
A:Type
How can you highlight report records that include values greater than $500 in the OrderAmt field? (522213)
A:Use conditional formatting.
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? (522554)
A:What-if Analysis
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? (522215)
A:You can change the orientation of the report to landscape.
When you underline cell content, you are using _____. (522501)
A:a font style
You can import table data from _____. (522102)
A:another Access database
In the formula =SUM(A6:A9), which of the following best describes A6:A9? (522593)
A:argument
To rename a field in Table Datasheet view, you change the text in the _____. (522008)
A:column heading
To format a range so that all values greater than $500 appear in red, which of the following can you use? (522490)
A:conditional formatting
A _____ is an item on a form that you can manipulate to modify the form's appearance. (533025)
A:control
To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table. (522096)
A:field
Which process is most like copying and pasting? (522089)
A:importing
What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE) (522579)
A:number of the column containing the return value
The _____ to the left of a table record indicates that you are editing the record. (522013)
A:pencil symbol
To close a report in Print Preview and keep Access running, you _____. (522232)
A:right-click the report tab, and then click Close on the shortcut menu.
If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid? (522156)
A:to the right of the City field
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? (522551)
B:$A$5
Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this? (522566)
B:=HOUR(A1)
Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56? (522567)
B:=MINUTE(G5)
In the formula =B6*$B$2, which of the following describes $B$2? (522553)
B:Absolute cell reference
Which of the following lets you extend any data pattern involving dates, times, numbers, or text? (527198)
B:AutoFill Options button
Which data type is used for sequential integers controlled by Access? (522027)
B:AutoNumber
Which of the following inserts a function into a cell? (522627)
B:AutoSum button
How can you list the records in a query datasheet in A-Z order by CustomerName? (522157)
B:Click a value in the CustomerName field, and then click the Ascending button.
After starting Access,which of the following is the fastest way to open a database you worked on yesterday? (522005)
B:Click the database you want to open in the list of recent databases.
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? (522502)
B:Create a custom cell style.
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? (522491)
B:Edit the conditional formatting rule.
Maddie entered customer first names in column A and last names in column B. What feature can she use to enter the full names in column C? (522629)
B:Flash fill
To copy a cell's formatting to another cell, which of the following can you use? (522519)
B: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? (522545)
B:IF
You can use the _____ to copy data from Excel to Access. (522095)
B:Import Spreadsheet Wizard
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? (533065)
B:Line sparklines
When you create a form containing data from two tables that have a one-to-many relationship, what type of form are you creating? (522222)
B:Main form with a subform
To replace "coffee" with "beverage" in any part of a field, you click the _____ in the Find and Replace dialog box. (522151)
B:Match arrow
When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field? (522159)
B:Modify Expression
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? (522525)
B:Page Setup dialog box
Which of the following tools can you use to create a query? (522014)
B:Simple Query Wizard
What happens when you apply a theme to a form? (522211)
B:The formatting changes in all forms and reports.
What might you need to do after increasing the font size in a table datasheet? (522161)
B:Widen the columns.
To relate two fields in a one-to-many relationship, you connect them using a _____. (522087)
B:common field
What expression would you use to create a calculated field that determines the discount price by subtracting 10 from the value in the Price field? (522158)
B:filter
A _______ refers to a collection of characters with a similar, specific design. (522499)
B:font
Using the Report Wizard, you can select the _____ for the report. (522221)
B:layout
When you _____ a formula, Excel retrieves the formula from the Clipboard and places it into the selected cell. (522641)
B:paste
A group of related fields, such as all the demographic information for one customer, is called a _____. (522011)
B:record
If you want to manage lists of data about customers and the products they order, use _____ software. (522019)
B:relational database
The Percent style formats numbers as percentages with _____ decimal places by default. (522488)
B:zero
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 (523764)
C: Fill & Line
A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so? (522620)
C:=COUNTA(B1:B20)
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? (523753)
C:Analysis
How can you display the title of a report in green? (522219)
C:Change the font color of the label in the Report Header.
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab. (522489)
C:Color
Which view can you use to add a new record to a table? (533028)
C:Form view
Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells? (522522)
C:Highlight Cell Rules
Which of the following is a type of logical function? (533064)
C:IF
____ makes a duplicate copy of the data in the Access database. (522094)
C:Importing
In a complex formula, how does Excel determine which calculation to perform first? (522633)
C:It follows the order of operations.
To have Excel enter the lowest price from a range of prices, which of the following would you use? (522557)
C:MIN function
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in? (522632)
C:Page Break Preview
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? (522529)
C:Paintbrush
_____ is a set of Access rules that governs data entry and helps ensure data accuracy. (522093)
C:Referential integrity
Which Access feature asks you a series of questions and then creates a report based on your answers? (533030)
C:Report Wizard
Which Access tool guides you through the steps of creating a report? (522214)
C:Report Wizard
Suppose you rename a field in Table Design view. What must you do before you can view the data in the table? (522031)
C:Save the table.
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently? (522596)
C:The formula =SUM(B6:B10)
You can redisplay all the query records by clicking the the _____ button. (522152)
C:Toggle Filter
Which data type stores only one of two values? (522009)
C:Yes/No
Characteristics, such as Field Name and Data Type, are_____ that define a field. (522091)
C:properties
You can create an Access report by selecting fields from one or more tables or _____. (522016)
C:queries
A relational database can best be described as a collection of related _____ designed to minimize redundant data. (522097)
C:tables
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? (522564)
D:=DATEVALUE(''01/01/2017'')
Which of the following functions would you use to calculate the arithmetic mean of a price list? (522558)
D:AVERAGE
What happens when you run a query from Query Design view? (522155)
D:Access displays a datasheet containing the query results.
When you double-click the right border of a column heading, which of the following occurs ? (522614)
D:AutoFit resizes the column to the widest cell entry.
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? (522534)
D:Background
Which of the following keys do you press to copy cells while dragging them? (522604)
D:CTRL
Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem? (522606)
D:Change the page orientation to landscape.
What should you do when you are finished working a database? (522020)
D:Close the database.
Which data type works best to store dollar amounts? (522024)
D:Currency
You can right-click the status bar to display the _____. (522104)
D:Customize Status Bar shortcut menu
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? (523751)
D:Data Callout
Which of the following lets you edit the contents of a cell? (522594)
D:Double-click the cell or click in the formula bar.
To import data from Excel to Access, you would begin by clicking the ____. (522088)
D:External Data tab
Which two properties are required for every field? (522026)
D:Field Name and Data Type
To print more than one copy of your worksheet, which tab would you go to? (522599)
D:File
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell? (522556)
D:Fill handle
To change the color of cell content, you use the ________ color list arrow. (522498)
D:Font
To format a cell range so that values between 100 and 500 appear in red, which of the following can you use? (522524)
D:Highlight Cells Rules
To apply a cell style, you would use the Cell Styles command on the _____ tab. (522503)
D:Home
Which of the following can you do to make a chart title stand out on a chart? (523771)
D:Increase the font size.
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? (533063)
D:MAX
To rotate cell contents to an exact value, you change its _____. (522516)
D:Orientation
Which of the following functions inserts the total of a range? (522602)
D:SUM
Which of the following chart types show how two numeric data series are related to each other? (523749)
D:Scatter
What is the most efficient way to navigate to the last record in a table containing 100 records? (522012)
D:Use the Last record button on the navigation bar.
As you create a report, when might you want to work in Report Layout view? (522216)
D:When you want to view the data as you change the report.
How is the font set for a table in Table Datasheet view? (522242)
D:You use the Font box on the Home tab.
Which of the following can you change when formatting a table? (522160)
D:background color
When you _____ a database, you make more storage space available and enhance the performance of the database. (522017)
D:compact and repair
You use Query Design view to add _____ to determine which records are shown in the resulting datasheet . (522147)
D:criteria
The _____ key field is the linking field on the "many" side of the relationship. (522098)
D:foreign
Which of the following is a built-in formula that helps you perform complex calculations? (522610)
D:function
Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C. (522617)
D:hide
When you remove a control layout from a form or report, Access ____. (522239)
D:no longer groups the controls together
When using the Form Wizard, you can select fields from tables and _____ in the database. (522220)
D:queries
The goal of building one-to-many relationships between tables is to minimize _____ data. (522092)
D:redundant
You can use a wizard to create a _____, a formatted printout or display of the contents in tables or queries. (522236)
D:report
In which object can you rename a field? (522030)
D:table
When you click the File tab and then click Print, which of the following elements appears in the preview of the worksheet printout? (522598)
D:worksheet data
A category of data such as a customer's name, city, state, or phone number is called a _____.
field
Tables, queries, and forms are examples of Access ____.
objects
Which Access object contains all of the data in the database?
table