BCIS FINAL
The code _____ will display the filename of the current workbook. a: &name b: +name c: &[File] d: +[file]
&[File]
The numbers, text, or cell references used by the function to return a value are called ____. a: expressions b: data c:arguments d: values
arguments
which of the following science technologies does NOT use satellite links to transmit data? a: JIT b:hurricane observation c: automatic weather stations d: moored buoys in the dart system
automatic weather stations
The Format Cells dialog box has six tabs, including _____. a: decimals b: security c: border d: shading.
border
which of the following theatre departments does not use CAD software? a: costume b:lighting and sound c: box office d:stage sets
box office
Using AutoFill, what would be the extended series of the initial entry Jan? ___ a: uary b: kan, lan, man, nan c: feb, mar, apr d: jan 1,jan2,jan3
feb mar apr
which of the following is NOT a MIDI component? a: port b:sequencer c:protocol d:file format
file format
the ____ command searches through the current worksheet or workbook for the content of formatting you want to locate. a:see b:locate c:find d:search
find
Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements—chosen because they look "nice"—confuse and distract the reader. a: espionage b: confusion c: clutter d: junk
junk
each worksheet will contain a specific class with the students grades for the entire term. in order to determine the current student grade, antoinette would have to use the ___ function. a: SUM b: COUNT c: AVERAGE d: MEDIAN
AVERAGE
which of the following is a statistical function: a: INT b: ROUND c: RAND d: AVERAGE
AVERAGE
the header and footer sections include a _____. a: left and right section b: top and bottom section c: center section only d: left, right, and center section
left, right, and center section
The ____ identifies which data markers are associated with each data series? a: x-axis b: chart area c:y axis d:legend
legend
when antoinette shares her worksheet with other colleagues, she wants to ensure that everyone knows why certain cells are highlighted. to accomplish this, she will create a ________. a: journal b:legend c:documentation sheet d:formula sheet
legend
__________ functions find values in the tables of data and insert them in another location in the worksheet such as cells or in formulas. a: sum b: lookup c: average d: find
lookup
A ______ contains the actual values that are plotted on the chart. a: data source b: data series c: category values d: legend
Data series
Ellen is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year. What function key will make D2 an absolute reference? a: F2 b:F6 c:F4 d:F1
F4
simon wants to change that charts border. to do this, he should select the CHART TOOLS _____ tab. a: format b: design c: edit d: layout
FORMAT
its difficult to read the exact scale on some of simons data. adding _____ would make it easier to read. a: a legend b: colors c: major tick marks d: more numbers
major tick marks
one group that completely opposes any manipulaion of a digital image is the : a: NPPA b:RIAA c:CNN d:L-VIS
NPPA
in recent years, _____ file sharing networks exploded in popularity as ameans for people to share music, video, and other files stored on their personal computer a:RIAA b:P2P c:MIDI d:MPAA
P2P
To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point. a: page insert b: print area c: manual page break d: selection
manual page break
A ______ is the space between the page content and the edges of the page. a: margin b:frame c: border d: ruler
margin
a logical function is a function that works with values that are either: a: right or wrong b:positive or negative c: absolute or relative d: true or false
true or false
ellen opens excel 2016 and enters her monthly income for one year beginning with january. to creat a series of months, she can: a: type +=Jan-dec in cell A1 and then press enter b: type January in cell A1 and then drag the fill handle. c:type =YEAR in cell A1 and then press enter d: type =DATE (jan,dec) in cell A1 and then press enter.
type January in cell A1 and then drag the fill handle
Harold would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____. a:type the data in A1 and merge cells A1:A5 b:type the data in A1 and merge cells A1:E1 c: type the dats in C1 d: type the data in any column ib row 1 and then choose center from the format menu
type the data in A1 and merge cells A1:E1
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____. a:a is equal to b b:A1+B1 is equal to C1 c: A does not equal B d: A>B1 is equal to C2
A does not equal B
to add a ______ to a sheet tab, right click a sheet tab, point to tab color on the short cut menu, and then click a color. a) fill color B) format color c) tab setting d) formatting style
A) fill color
in excel, to merge cells A1, B1, C1, D1, and E1, ____ is the correct reference for the merged cell. a: A1!E! b: E1 c:A1 d: A1-E1
A1
which of the following is not a date function? a: year b:and c:now d:today
AND
computers process data as ___ that represent on and off states. a: bits b:blocks c:signals d:waves
bits
If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell. a: #VALUE b:ERROR c:#N/A d:#NULL
#N/A
the possible values for the type argument in the function above are: a: 0 or null b: 0,1,or 2 c: 0 or 1 d: 0,1,2, or 3
0 or 1
sculptors use _____ to digitally recreate an existing physical object. a: image-editing software b: 3-d scanning c:video compostion d:digital cameras
3-d scanning
which of the following is not a comparison operator? a: = b: << c: <= d: <>
<<
after you have created a model for your sculpture, you can use ___ to shape your desired medium. a: CNC milling machines b: digital image editing c:Illustration software d: video composition
CNC milling machines
to format an individual sparkline, slect the sparkline you want to format, and then click the ungroup button in the group on the sparkline tools ______ tab. a: CREATE b: LAYOUT c: VIEW d:DESIGN
DESIGN
The _________ chart tools contextual tabs appear on the Ribbon when you select a chart. a: INSERT and DESIGN b: INSERT and FORMAT c: DESIGN and FORMAT d: FORMAT and PRINT
DESIGN and FORMAT
which of the following is a math & trig function? a: INT b: MIN c:COUNT d: AVERAGE
INT
The ___ function returns the maximum value in the range. a: TOP b:MAX c:FIRST d:MOST
MAX
In Excel, dates are _____-aligned in the cell by default, regardless of date format. a: right b: center c: left D:top
Right
you can open the format cells dialog box by right-clicking the format painter button to paste the same format multiple times and click the format painter again to _______. a: turn it on b: copy formatting c: turn it off d: paste formatting
Turn it off
=IF(G22= "x ", SUM(H22:J22), " ") with display ______ if G22 is not equal to "x". a:a blank cell b: dashes c: the result of the SUM d: false
a blank cell
Excel supports all of the following types of sparklines EXCEPT ____. a: a win/loss sparkline for highlighting positive and neg values. b: a column sparkline used for column charts c: a line sparkline for highlighting trends d: a true/false sparkline for help making decisions.
a true/false sparkline for help making decisions
Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value. a: numbers b: universal number c: text d: greenwhich mean time
a: numbers
when creating an excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness. a: red and green b:black and white c: yellow and blue d: red and yellow
a: red and green
Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she uses a(n)____ to identify the cell containing the income value. a: relative reference b:mixed reference c:absolute refernce d: fixed reference
absolute
one of the great advantages of _____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations. a: cell b:absolute c:relative d: formula
absolute
By default, numbers appear in the _____ and generally display values exactly as you type them. a: home tab b: general number toolbar c: general format d: currency format
c: general format
as a general rule, you should _____________. a: center column titles, left align text, and right align numbers b: center column titles, right align text, and left align numbers c: right align column titles, left align text, and right align numbers.
center column titles, left align text, and right align numbers.
You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ____ from the Type group in the Chart Tools Design tab. a: change chart type b: alter existing chart c: new chart d: modify chart
change chart type
To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left. a: legend b: formatting c: chart elements d: layout
chart elements
Placing a chart in a ____ displays only the chart and no worksheet cells. a: new worksheet b: graph display c: tabbed view d: chart sheet
chart sheet
to add and remove chart elements, you can use the add chart element button in the charts layout group on the ___________. a: chart tools layout b: insert c: chart tools design d: home
chart tools layout
Harold cannot increase the width of his worksheet because, if he does, he will not be able to print it on one sheet. However, his columns are truncating his content. What solution would be the best for Harold to use to make all his text visible without losing data? a: abbreviate all text b:choose wrap text for the columns c: change the font style d:delete one column
choose wrap text for the columns
the ______ displays the data series in seperate columns side by side so that you can compare the relative heights of the columns in the three series. a: clustered column chart b: 100% stacked column chart c: stacked column chart d: column chart
clustered column chart
the geophysical fluid dynamics laboratory has pioneered ______ research for better understanding weather behavior a: computer modeling b: genome c:remote sensing d: radiosonde
computer modeling
antoinettes workbook has all the data entered and students current grades displayed . she would like the current grade cells to display the value in red if it is less than 60. antoinette needs to add ____ to the cell. a: cell formatting b: highlighting c: conditional formatting d: fill color
conditional formatting
The fill handle copies ____. a: content only b: content and formats c: formats only d: formats and cell references
content and formats
________ are an example of conditional formats in excel. a: data bars b: font sets c: quick analysis tools d: percentages
data bars
______ provide descriptive text for the individual data markers, such as pie slices. a: asset labels b: data labels c: legend values d: leader lines
data labels
If an optional argument is not included, Excel assumes a(n) ____ value for it. a: default b: static c: generic d:absolute
default
SETI scientist rely on the concept of ____, in which the collevtive pocessing power of multiple computers is used to complete a large processing task. a: artificial intelligence b: distributed computing c: haptic feedback d: data modeling
distributed computing
When combination charts have data series with vastly different values, you can create ____ charts. a: dual axis b: secondary c: multivalues d: multiple axis
dual axis
Antoinette wants to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule _____ to check for this a:equal to b:duplicate values c: between d: a date occuring
duplicate values
header and footer elements such as worksheet name, current date, and time are ___ elements. a: descriptive b: impact c: dynamic d: required
dynamic
the dart system was developed to track _____: a: earthquakes b:tornados c:hurricanes d: tsunamis
earthquakes`
Category values are usually located in the ____ of the data source. a: first row b:either a or c c: first column d: neither a nor b
either a or b
To move one slice of a pie chart away from the pie creates a(n) ____. a: spontaneous pie chart b: exploded pie chart c: perfect pie chart d: exponential pie chart
exploded pie chart
you can choose center, inside end, outside end, or best fit for the data label positions in the ____ pane. a: format data labels b: format chart area c: format legend d: format axis
format data labels
the insert function button is in the _______ group. a: calculation b: sort and filter c: function library d: home
function library
The FV function stands for ______ a: function value b: financial value c: future value d: formulated value
future value
humans have approxmately 30,000 ______ that define their physical traits and many of their behaviors. a: dna b:cells c:bases d:genes
genes
after you describe a function in the search for a function box in the insert function dialog box, click _____. a: go b:insert c:select d:next
go
which category of excel functions returns information about the format, location, or centents of a worksheet cell. a: location b:reference c:information d:description
information
__________ is the amount added to the principle of a loan by the lender. a: rate b: interest c: simple d: maximum
interest
Ellen's spending varies from month to month. She wants to calculate the total expenses for each month. She wants to see all of the arguments associated with the SUM function so she clicks the ____ then clicks SUM to open the Function Arguments dialog box. a: math and trig button in the formula group b:math and trig button in the function library group c: financial button in the formula group d: financial button in the function library group
math and trig button in the function library group
computer generated fractals use ____ to create art. a: interpolation b: colorazation c: splitting d:mathmatical formulas
mathematical formulas
another name for the middle value is the _____ value. a: mode b:median c: center d: relative
median
________ merges each of the rows, in the selected range across the columns in the range. a:merge build b: merge across c: merge and center d: merge cells
merge cross
____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table. a: absoulte b: mixed c:relative d: matched
mixed
___ is a special effect in which one video image is transformed into another image over the course of several frames. a: splitting b:pruning c:morphing d:tweening
morphing
dancers rely on a technology called ___ to record and analyze their dance movements. a: sensor scanning b: image capture c: interpolation d: motion capture
motion capture
the ____ dialog box provides options for moving charts between worksheets and chart sheets. a: insert new b: move chart c: tab d: change chart
move chart
Excel functions are organized into ____ categories. a: 8 b:11 c:10 d:13
n/a
in digital cameras, the image is intially focused on a chip called: a: charge-coupled device b:digital signal processor c:analog to digital converter d: digital to analog converter
n/a
which function counts how many cells in a range contain numbers, where value 1, value 2, and so forth are text numbers or cell references? a:SUM b:COUNTA c:COUNT d:AUTOSUM
n/a
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ______ function. a: complex b:absolute c:logical d:nested
nested
Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges. a: selective b:consecutive c: nonadjacent d:specific
nonadjacent
In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays. a: number b: alignment c:font d: fill
number
a chart sheet can contain: a: only one chart b: one to four charts c: on or two charts d: one to six charts
only one chart
A pie slice is a data marker that represents ____ from a data series. a: only one value b: no more than three values c: at least one value d: no more than five values
only one value
File ___ involves uploading a music file to a file-sharing network with distortion, silence, or copyright law warnings a: sequencing b:pruning c:spoofing d:rendering
spoofing
______ arguments may provide more control over the returned value. a: relative b:required c:optional d:absolute
optional
in the figure above, fv and type are ___: a: financial functions b: comparison operators c:required arguments d: optional requirements
optional arguments
Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab. a: format b: sorter c:orientation d: alignment
orientation
Simon has finished his chart but needs to save some space. What's the most effective way for Andy to reduce space without losing important data? a: delete parts of the data b: delete the title c: delete the legend d: overlay the legend in areas without data
overlay the legend in areas without data
One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____. a: master b: palette c: gallery d: painter
painter
the _____ is the only one of the following charts to compare relative values from different categories to the whole. a: pie b: line c: column d: area
pie
a home or business photographer most likely uses the ___ type of digital camera. a:point and shoot b:virtual c:field d:studio
point and shoot
the amount of money being loaned is known as the ______. a: mortgage b: loan amount c: proposed principal d: principle
principle
in the figure above, pv stands for the : a: payments verified b: present value of the loan c: principle value of the loan d: primary interest of the load
princuple value of the loan
Setting the _____ to A1:L10 will print only data in those cells. a: page format b: page break c: print area d: print preview
print area
information that prints on each page, like a company name or logo, may be set as a _____. a: print setup b: text header c: copied text d: print title
print title
the format cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their elements is _________. a: alignment b:protection c:font d:security
protection
Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting. a: quick tool bar b: quick formatting bar c:quick analysis tool d: a date occuring
quick analysis tool
The range of values or _______, of an axis is based on the values in the data source. a: scale b: defined range c: series d: length
scale
the insert function dialog box has a _______ option. a: search b: find and replace c: formatting d: expand/collapse
search
To resize an embedded chart, ____. a: select the chart and drag the corner sizing handle of the selection box b: right click the chart and then click resize on the short cut menu c: select the chart and press tab d: both a and b
select the chart and drag the corner sizing handle of the selection box.
Which of the following shows the correct order of steps for adding a data series to a chart? a. Select the chart, Click the Add button, Click the Select Data button, Select the range . Select the chart, Click the Select Data button, Click the Add button, Select the range c. Select the range, Click the Select Data button, Click the Add button, Select the chart d. Select the range, Select the chart, Click the Select Data button, Click the Add button
select the chart, click the select data button, click the add button, select the range.
Ellen wants to find out what her median monthly spending is. The monthly totals for her spending appear in the range A10:L10. Which of the following is NOT a way to enter the MEDIAN function into her database? a. Type =MEDIAN(A10:L10) into an empty cell. b. Select the range A10:L10, click the Quick Analysis button, click TOTALS, and then click Median. c. Click the More Functions button in the Function Library group on the FORMULAS tab, point to Statistical, and then click MEDIAN. d. Click the Insert Function button in the Function Library group on the FORMULAS tab, scroll the Select a function list, then click MEDIAN.
select the range A10:L10, click the quick analysis button, click totals and then click median
A _______ indicates a manual page break. a: dashed blue line b: dashed red line c: solid blue line d: solid red line
solid blue line
A chart that compares three set of values in a three-dimensional chart is _____. a: stock b: surface c:radar d: scatter
surface
A ___ creats sound from digital instructions input by the user, either via a standard computer keybaord or devices resembling: a: audio-editing software program b: sequencer c: music notation software program d: synthesizer
synthesizer
which of the following is not an excel function category? a: math & trig b: statistical c:algebra d: text
text
In the formula =INT(AVERAGE(A1:A100)), which would occur first? ____ a:the average of the values in the range A1:A100 is added to the integer b: the average of the integer value is calculated c: the average of the values in the range A1:A100 is calculated d: the integer protion of the value is extracted.
the average of the values in the range A1:A100 is calculated.
in the following formula: =IF(A1+"YES","DONE", "RESTART"), what happens if A1="NO" a: the formula returns the text "RESTART" b: the formula returns the text "DONE" c: the formula returns the text "NO" d:the formula returns the text "NO, RESTART"
the formula returns the text "RESTART"
FUNCTION(argument1, argument2,....) Is ____. a:the syntax of writing optional arguments b: an example c: the general syntax of all functions d: the general syntax
the general syntax of all functions
When you nest functions, you should have ____. a: the equal sign b: the same number of left and right parenthesis c: at least 2 functions d: the correct number of brackets
the same number of left and right parenthesis
Fonts, colors, and cell styles are organized in _____ categories. a:theme and non theme b: color and black and white c: numbers and text d: form and function
theme and non theme
PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, nper stands for the ____. a: total number of payment periods b: total number of payments that have already been made C: number of payments per year d: number of interest payments per year.
total number of payment periods
Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____. A: use format painter b: format each element using the toolbar c: select all cells and use the formatting dialog box d: apply a table style
use format painter
In one of Harold's columns there are too many numbers after the decimal place. Harold does not need this level of detail. It is distracting from the data and he really only needs two numbers after the decimal. How could Harold make the data appear cleaner in the most efficient way? a:reenter all numbers and only enter two decimal places b: decrease the column width c: decrease the font size d: use the number group to decrease number of digits displayed.
use the number group to decrease number of digits displayed.
One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results. a: goal seek b:search c:gunction d: what-if analysis
what-if analysis