Spreadsheet Applications2007 District/Regional
Mark the correct answer on your Scantron sheet for each of the following questions.
1.The ____ function counts the number of cells containing numbers.
a.MAX
b.COUNT
c.AVERAGE
d.SUM
2.The ____ function calculates the smallest value in a set of numbers.
a.MAX
b.MIN
c.LEAST
d.SMALLEST
3.The ____ function calculates the present value of a loan or investment based on periodic, constant payments.
a.PMT
b.RATE
c.PV
d.NPER
4.A function that determines whether a condition is true or false is called a/an ____ function.
a.relational
b.comparative
c.logical
d.operational
5.The ____ function returns the value TRUE if all arguments are true, and FALSE if one or more arguments is false.
a.FALSE
b.AND
c.NOT
d.OR
6.The ____ operator checks if the value in a given cell is less than the value in another cell.
a.
b.
c.
d.<=
7.The ____ operator checks if the value in a given cell is not equal to the value in another cell.
a.
b.
c.
d.<=
8.The ____ function calculates the number of periods required to pay off a loan or investment.
a.FV
b.PV
c.PMT
d.NPER
9.The date functions use your computer's internal ____ to return a value.
a.calculator
b.clock
c.matrix
d.cache
10.You need to convert the number 5.663 to 5.7; what function should you use?
a.SUM()
b.MEDIAN()
c.ROUND()
d.TRUNCATE()
11.The ____ function calculates the average of a collection of numbers.
a.AVERAGE()
b.MEAN()
c.MODE()
d.AVE()
12.The value of which function is automatically updated whenever you reopen a workbook?
a.DATE()
b.NEW()
c.TODAY()
d.TIME()
13.What type of function should be used to compute the present value of a recent investment?
a.logical function
b.financial function
c.engineering function
d.information function
14.Which of the following is true about functions in spreadsheet software?
a.The Insert Function dialog box should be used for simple functions with no arguments.
b.Functions may be entered in more than one way.
c.There is one correct way to enter each function.
d.Most functions must be entered in cell A1.
15.
Using the data from the worksheet shown above, what will be displayed by the following formula: =MIN (B1:B3)?
a.12
b.-7
c.5
d.15
16.
Using the worksheet shown above, what will be displayed by the following formula: =IF(A2>B2, "Yes","No")?
a.#REF
b.Yes
c."Yes"
d.No
17.Which of the following is a true statement about date/time functions in a spreadsheet?
a.The NOW function displays the current date and time as a serial number with the date to left of the decimal point and the time to the right.
b.The NOW function displays the date and time of creation as a serial number with the date to the left of the decimal point and the time to the right.
c.The TODAY function displays the date and time as a serial number with the numbers to the left of the decimal point representing the date and the numbers to the right representing the time.
d.Inserting a date in a common format, such as 1/1/2010, will automatically update to the current date each time the workbook is opened.
18.Which function is used to make a decision based on a comparison?
a.IF
b.PMT
c.INT
d.MAX
19.Which of the following is the correct form for an IF statement?
a.=IF(<value if false>,<value if true>,<comparison>)
b.=IF(<value if true>,<value if false>.<comparison>)
c.=IF(<comparison>,<value if true>,<value if false>)
d.=IF(<comparison>,<value if false>,<value if true>)
20.
Using the data in the worksheet above, what will be displayed by the formula =IF(A1<MIN(B1:B3),0,MAX(A1:A3))?
a.22
b.A1
c.27
d.0
21.In a spreadsheet, a visual representation of workbook data is called a chart.
a.True
b.False
22.When more than one data series exists in a chart, a/an ____ helps to identify which data markers represent each data series.
a.key
b.legend
c.archive
d.map
23.To create a graphical shape on a chart, use the ____ toolbar.
a.Drawing
b.Image
c.Graphical
d.Object
24.A/an ____ chart shows the proportion of parts to a whole.
a.Line
b.Scatter
c.Pie
d.Area
25.____ marks are small lines that intersect an axis and represent the scale used for measuring values.
a.Series
b.Tick
c.Index
d.Value
26.The process of emphasizing one particular slice in a pie chart over others is referred to as ____ the slice.
a.detaching
b.attaching
c.deconstructing
d.exploding
27.Which type of chart would best display fluctuations in a stock price over a period of time?
a.line
b.pie
c.bar
d.column
28.Which type of chart would best display average test scores for a group of schools?
a.line
b.pie
c.column
d.scatter
29.What is a "group of related data?"
a.data labels
b.column
c.legend
d.data series
30.
What chart option is visible on the above graphic?
a.legend
b.series name data labels
c.value data labels
d.data table
31.Where should an independent variable go?
a.Y-axis
b.It does not matter which axis it goes on.
c.Z-axis
d.X-axis
32.Which of the following is a true statement about charts in spreadsheets?
a.A spreadsheet user would have to be very experienced to be able to adequately create a chart.
b.Charts must include an entire worksheet.
c.Once a chart is placed in a worksheet, its' size cannot be changed.
d.Charts enable you to see trends and make comparisons that would be hard to interpret just by looking at columns of numbers.
33.Categories in charts are generally plotted along the horizontal axis known as the:
a.Y-axis
b.X-axis
c.secondary axis
d.data point axis
34.A group of related data points on a chart is known as a:
a.worksheet
b.chart
c.data series
d.data point series
35.To create a chart, the first step is to:
a.select the cells that contain the data you want to appear in the chart
b.click the Chart Wizard button
c.identify the legend of the chart
d.identify the X-axis of the chart
36.How do you know if a chart is an active chart?
a.A dotted line surrounds the chart.
b.Selection handles appear on the boundaries of the chart.
c.A dark border appears around the chart.
d.The chart changes color.
37.To move a chart to another location in a worksheet:
a.position the pointer over the chart, click, hold down the mouse pointer and drag the chart
b.click File, then click Move Chart
c.click the Move button on the Chart toolbar
d.click the Move Chart button on the Standard toolbar
38.To create an exploded pie chart:
a.click the Explode Slice option from the Chart Type list arrow
b.double-click the slice you want to explode
c.right-click the slice you want to explode
d.click the pie chart, click the slice you want to explode, and then drag it away from the center of the chart
39.Which graph would be the best choice if you are trying to show how two variables may be related to each other?
a.bar
b.scatter
c.line
d.pie
40.What displays charted data in a grid at the bottom of the chart?
a.worksheet
b.data table
c.data series
d.sheet tab
41.A cell reference is a cell's column and row location.
a.True
b.False
42.To erase the contents of a cell, use the ___ key.
a.left arrow
b.clear
c.backspace
d.delete
43.To make A1 the active cell, you should press which of the following keys?
a.Page Up
b.Page Down
c.Ctrl+Home
d.Home
44.The characters +, -, *, and / are examples of:
a.arithmetic operators
b.calculations
c.formulas
d.values
45.The ___ button is the gray rectangle in the upper-left corner of the worksheet where the row and column headings meet.
a.column selector
b.cell selector
c.row selector
d.select all
46.Spreadsheets give you speed in completing which of the following tasks?
a.report writing
b.publishing
c.calculating
d.research
47.Which of the following would not be a practical use of a spreadsheet application?
a.keeping track of grades in a class
b.predicting the amount that you will spend on clothing in a year
c.planning a budget
d.printing out envelopes
48.What would be a good personal use of a spreadsheet?
a.creating a birthday card
b.managing customer accounts
c.predicting the amount of money you will need for gas in a year
d.keying letters to friends
49.A spreadsheet would not be the best software choice for which of the following?
a.building and using analytical models
b.preparing a club newsletter
c.calculating data
d.visualizing relationships with dynamic graphs
50.The above spreadsheet fragment shows that a spreadsheet could be used to do what?
a.demonstrate a real rate of return
b.calculate the risk premium in a market
c.make a purchasing decision
d.predict interest to be earned on an investment
51.A PivotTable report contains the same elements as a regular chart but also contains fields and items that can be added to, rotated, or removed to display different views of your data.
a.True
b.False
52.What must be identified when a pivot table is created?
a.page field
b.data field
c.column field
d.row field
53.A pivot table is an interactive table that enables you to group and summarize a list into a concise, tabular format for easier reporting and analysis.
a.True
b.False
54.The procedure to update a PivotTable with changes in the numerical figues is to:
a.use the Refresh Data command
b.make changes to the PivotTable, and then use the Refresh Data command
c.make changes to the list first, and then use the Refresh Data command
d.make changes directly to the PivotTable
55.Which button available on the pivot table toolbar opens the pivot table field dialog box so you can modify options for the selected field?
a.always display items
b.field settings
c.field select
d.formatting display
56.Excel automatically totals numbers when they are dropped into which area of a pivot table report?
a.page fields
b.column fields
c.row fields
d.data items
57.Which of the following cannot be done after a pivot table has been created?
a.create a chart
b.rename a field
c.use a formula referencing a field that has been removed
d.run a macro
58.Which of the following will not result in a pivot chart that remains separate from the original pivot table (or static)?
a.create a pivot chart from a pivot table based on an external data source
b.create a pivot chart and delete the pivot table worksheet
c.create a pivot chart by copying the pivot table, pasting the data, and creating a chart based on the pasted data
d.create a pivot chart and delete all cells in the original pivot table
59.How can pivot table layout be changed?
a.drag and drop
b.The layout of a pivot table cannot be changed; a new one must be created.
c.There is only one pivot table layout.
d.only in the pivot table wizard
60.Why would a page field be used in a pivot table?
a.to break the report into separate "pages"
b.to bring in data from more than one place
c.to analyze two or more spreadsheets
d.to identify which data will be summarized
61.You are creating macros and want the macros available at all times and don't want to repeatedly create them. What should you do?
a.Store the macros in the Individual Macro file.
b.Store the macros in the Personal Macro workbook.
c.Save the macros in Microsoft Word and import them.
d.Store the macros in the VBA editor.
62.To create a macro, you can write one by entering a series of commands in the ____ programming language.
a.Perl
b.HTML
c.VBA
d.Java
63.To execute a macro you create, you can select the ____ command in the Macro dialog box.
a.Run
b.Launch
c.Execute
d.Start
64.Which of the following is true of a high security level?
a.All macros containing an invalid digital signature are enabled.
b.The user is prompted as to whether or not to enable macros that lack a digital signature.
c.All macros lacking a digital signature are disabled.
d.All macros containing a valid signature from an unknown author will be disabled.
65.Where can macros be run?
a.Very hidden sheets
b.Saved worksheets
c.Hidden sheets
d.Protected sheets
66.What order should be followed to create a macro button?
1. Select the macro you want to assign to the button, type a new label.
2. Click View on the menu bar, point to Toolbars, and then click Forms.
3. Click the Button tool on the Forms toolbar, and then click and drag the mouse pointer until the button is the size and shape you want.
4. Release the mouse button. The button appears on the worksheet with a default label, and the Assign macro dialog box opens.
a.2, 3, 4, 1
b.1, 2, 4, 3
c.2, 3, 1, 4
d.1, 2, 3, 4
67.A macro can be stored in:
a.the current workbook.
b.the Macro Toolbar
c.a separate file linked to your workbook.
d.the clipboard.
68.To view the code of a macro, you need to open the Visual Basic:
a.Code Window
b.Reader
c.Manager
d.Editor
69.Which of the following cannot be used to run a macro?
a.button on a toolbar
b.keyboard shortcut
c.mouse right-click
d.menu option
70.Which of the following should you consider using if you share your macros with others?
a.digital certificate
b.Visual Basic Editor
c.digital signature
d.macro security
71.Before you complete a sort, you need to decide whether you want to put the list in ascending or descending order.
a.True
b.False
72.Custom AutoFilters allow you to specify relationships other than those that are "____" the criteria specified in the filter records.
a.in
b.equal to
c.like
d.greater than
73.What is the main difference between Advanced Filter and AutoFilter?
a.Complex criteria cannot be entered in AutoFilter.
b.Advanced Filter uses drop-down menus for each column, while AutoFilter does not.
c.AutoFilter cannot filter for more than one criteria while Advanced Filter can.
d.AutoFilter filters only a range in place, while Advanced Filter uses a separate criteria range for complex criteria.
74.When applying a filter, what happens to rows that do not meet the specified criteria?
a.They are moved to the bottom of the list.
b.They are hidden.
c.They are moved to another worksheet.
d.They are deleted.
75.Which of the following is not true about extracting data from a spreadsheet?
a.There is only one way to extract data from a spreadsheet.
b.The same data range can be extracted from many workbooks.
c.The source workbook may be listed beside the extraction.
d.Data can be extracted from many worksheets to one or to individual worksheets.
76.Which of the following is not a true statement about filtering a spreadsheet?
a.A filter produces a temporary view.
b.Filtering data enables you to work with a more manageable set of records.
c.When you filter a list, you hide all of the rows except those that meet specified criteria.
d.Applying a filter deletes records that do not meet the criteria of the filter.
77.When you initiate a search, you specify the search criteria or conditions placed on fields that define the records to be displayed.
a.True
b.False
78.The fields you use to order your data are called sort:
a.keys
b.tags
c.tools
d.values
79.What filter criteria would you use in a list of fines owed if you wanted only fines that were $10 or more but under $50?
a.fee is greater than or equal to 10 and less than or equal to 50
b.fee is greater than or equal to 10 and less than 50
c.fee is greater than 10 and less than 50
d.fee is between 10 and 50
80.What criteria must be set if you want to display salespeople whose sales for a week were at least $1000, but not over $2500?
a.is greater than or equal to 1000 OR is less than or equal to 2500
b.is equal to 1000 AND is less than 2500
c.is greater than or equal to 1000 AND is less than or equal to $2500
d.is greater than 1000 AND is less than or equal to $2500
81.To multiply the value of a cell by some number, use the __ operator.
a.*
b.+
c./
d.=
82.What is the result of the expression =50/(10*5) in a worksheet application?
a.25
b.50
c.1
d.1/5
83.What is the value of the expression =3+4*5?
a.-5
b.23
c.60
d.35
84.What is the correct syntax for a SUM formula adding the values of Cell F6 to F9?
a.=SUM(F6/F9)
b.=ADD(F6:F9)
c./SUM(F9:F6)
d.=SUM(F6:F9)
85.$B6 is an example of a/an ___ reference.
a.dollar
b.mixed
c.relative
d.absolute
86.Press the ___ key to change a cell reference while in Edit mode.
a.edit
b.enter
c.F1
d.F4
87.To create an absolute reference, insert a/an ___ before the column and row of the cell reference.
a.dollar sign
b.equal sign
c.number sign
d.plus sign
88.Given the initial selection Jan, Apr, which of the following extends this series?
a.July, October, January
b.May, Jun, July
c.Feb, May
d.Jul, Oct, Jan
89.What is the technique in which a cell is clicked to place its reference in a formula?
a.selecting
b.copying
c.pointing
d.fill right
90.If the formula =D1*$C$1 is copied from cell D2 to cell D3, what formula will appear in cell D3?
a.=D2*$D$1
b.=D2*$C$1
c.=D2*$C$2
d.=D1*$C$1
91.Which formula includes both absolute and relative cell references?
a.=A5*B9
b.=A5-*B*9
c.=A5*(B9+C9)
d.=A5/$B$9
92.What will happen if the formula =F5*G5 is placed in cell F5?
a.The result #DIV/0! will be displayed.
b.It will create a circular reference.
c.An absolute cell reference will be created.
d.The cell will display ######.
93.What type of reference is B2, D2, E2?
a.Absolute reference
b.Range reference
c.Union reference
d.Relative reference
94.What will be displayed if 30/3 is keyed in a cell?
a.30/3
b.27
c.10/1
d.10
95.What does the FV function calculate?
a.The formula valuation of an investment based on fixed payments and a fixed interest rate across many time periods.
b.The future value of an investment based on fixed payments and a varying interest rate.
c.The final value of an investment after 100 payments have been made
d.The future value of an investment based on fixed payments and a fixed interest rate across equal time periods.
96.What function should be used in order for the current date and time to display in a cell each time a workbook is opened?
a.AUTODATE
b.TIME
c.DATE
d.NOW
97.The expression used to calculate values displayed in a worksheet is called a/an:
a.operator
b.equation
c.relation