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