computer final
When the pointer is moved onto the worksheet, it changes to a. + b. diagonal arrow c. pointer clicker d. I looking thing
a. +
Using the data in the worksheet above, what will be displayed by the formula =min(a1:b3) a. -10 b. 52 c. 30 d. 42
a. -10
Which number format displays values with a dollar sign aligned at the left edge of the cell and two decimal places? a. accounting b. currency c. number d. percentage
a. accounting
A triangle in the upper-left corner of a cell indicates a. cell has been modified while changes are being tracked b. worksheet has been emailed c. the cell is a hyperlink d. cell contents are on the clipboard
a. cell has been modified while changes are being tracked
To enter a function into a formula without typing, a. click a button in the function library group on the formulas tab b. double click a cell c. select the function from function styles gallery d. use the name box
a. click a button in the function library group on the formulas tab
to select the entire worksheet a. click the elect all button b. press the worksheet button c. press the ctrl+end d. drag the pointer from cell A1 to cell A1048576
a. click the elect all button
the chart title a. describes what is charted b. is below the category labels c. is the same of the data range d. is also the vertical axis label
a. describes what is charted
Pressing the ctrl+ a. displays the formulas stored in cells b. formats the active cell as currency c. selects the row that contains the active cell d. enters a modified formula
a. displays the formulas stored in cells
Which key removes the dashed border around copied cells? a. esc key b. ctrl key c. alt key d. tab key
a. esc key
Which key enters data and makes the next cell in the column active? a. the enter key b. the tab key c. the right-arrow key d. the esc key
a. the enter key
new slides are added a. before the current slide b. after the current slide c. as the last slide of the presentation d. as the first slide of the presentation
after the current slide
To have titles fade in one by one during a slide show, apply a. slide transistion b. animation c. transition sped d. slide layout
an animation
The way items move onto a slide is called a. slide transition b. annimation c. slide speed d. color scheme
animation
Markings made on a slide during a slide show are called a. slide transitions b. slide animations c. annotations d. footers
annotations
in the chart above which is the first horizontal axis label a. 0 b. architecture c. 2014 d. program
architecture
which chart type shows trends of values over time a. area chart b. stock chart c. doughnut chart d. radar chart
area chart
Using the data in the worksheet above, what will be displayed by the formula =sum(a1:a3) a. -10 b. 45 c. 30 d. 141
b. 45
Which formula calculates the monthly payment for a $5,000 loan taken out for 3 years at 7% interest? a. =pmt(7%/12, 3, 5000) b. =pmt(7%/12, 36, -5000) c. =pmt(-5000, 7%/12, 3) d. =pmt(-5000, 7%, 3/12)
b. =pmt(7%/12, 36, -5000)
To make a sheet active a. select the sheet name on the home tab b. click the appropriate tab at the bottom of the excel window c. click the name box until it displays the appropriate sheet d. select the sheet name on the view tab
b. click the appropriate tab at the bottom of the excel window
The worksheet data below has been sorted in ascending order. Which column was the key sort column when the data was sorted? a. column a b. column b c. column c d. inventory
b. column b
A chart is sized proportionately by dragging a. a chart border b. corner handle c. middle left handle d. top middle handle
b. corner handle
the sheet tabs are used to a. display the contents of the active cell b. display the worksheets in a workbook c. identify a single cell d. create a new workbook
b. display the worksheets in a workbook
Sheet order can be changed by a. clicking the insert worksheet tab b. dragging a sheet tab to a new location c. right clicking a sheet tab and typing a new number for the sheet d. using home --> cut and home ---> paste
b. dragging a sheet tab to a new location
the order of slides in a presentation can be changed in slide sorter view by a. tying the new order in the print dialogue box b. dragging a slide to another position c. displaying the slide master d. clicking view --> order
b. dragging a slide to another position
which application would most likely be needed to copy a chart a. word b. excel c. access d. outlook
b. excel
which number formats displays numbers in the way they are typed a. accounting b. general c. number d. percentage
b. general
Which Error Checking option is selected to remove a green triangle from a cell? a. remove triangle b. ignore error c. delete erro d. correct all
b. ignore error
when connecting text boxes what does the pointer look like when it is moved over the second text box a. ... b. mug tipped c. mug straight up d. left arrow
b. mug tipped
what is printed if a chart tat appears as an object in a worksheet is selecting before printing a. all the sheets and charts in the workbook b. only the chart on a single sheet of paper in landscape orientation c. the sheet and chart on a single sheet of paper in portrait orientation d. the sheet and chart on a single sheet of paper in landscape orientation
b. only the chart on a single sheet of paper in landscape orientation
Which view is a worksheet displayed in when a header is inserted? a. normal view b. page layout view c. page break preview view d. outline view
b. page layout view
Which view should be used when preparing a worksheet for printing? a. normal view b. page layout view c. web layout view d. outline view
b. page layout view
Which chart object is the part of the chart that displays data? a. series name b. plot area c. data labels d. legend
b. plot area
a technique in which a cell is clicked to place its reference in a formula is called a. selecting b. pointing c. formula fill d. cell reference
b. pointing
the auto fit feature automatically a. sizes a graphic proportionately b. resizes text to fit in a placeholder c. resizes a slide to accommodate the text d. resizes a slide when it is projected
b. resizes text to fit in a placeholder
which is not a way to deliver a presentation a. publish the presentation to the web b. save it on a hard drive c. have a live speaker narrate while the presentation is projected onto a screen d. play the presentation on a continuous loop
b. save it on a hard drive
the first step in creating a pie chart is to a. select a location for the chart b. select the data to be charted c. select the chart type d. verify the source data
b. select the data to be charted
number signs (####) displays in a cell indicate a. number signs have been types as a column title b. the cell is not wide enough to display the formatted number c. an incorrect format has been applied d. the number format has been applied
b. the cell is not wide enough to display the formatted number
a variety of cell styles is associated with a a. cell reference b. theme c. template d. formula
b. theme
the fill handle is a. used to change the color of a cell b. used to copy the contents of the selected cell to adjacent cells c. an icon used to scroll a worksheet d. a cell representing a column of labels
b. used to copy the contents of the selected cell to adjacent cells
which of the following is an example of a cell reference? a. b7 b. 7b c. b d. 7
b7
which type of chart is best for comparing the differences between values a. bar b. value c. line d. pie
bar
which type of chart would best illustrate a comparison of the number of employees in each department of a store a. bar b. line c. pie d. area
bar
What formula will appear in cell C7 if the formula =B6*$B$1 is copied from cell C6 to C7? a. =b6*$b$1 b. =b7*$b$2 c. =b7*$b$1 d. =c6*$b$1
c. =b7*$b$1
What will the formula =SUM(A1:A10) change to if row 3 is deleted? a. it will not change b. =sum(b1:b10) c. =sum(a1:a9) d. =sum(a1:a11)
c. =sum(a1:a9)
A chart is moved by dragging a. middle right handle b. corner handle c. a chart border d. top middle handle
c. a chart border
a cell reference that does not change when it is copied is called a(n) a. statues reference b. relative cell reference c. absolute cell reference d. currency reference
c. absolute cell reference
text on a slide is edited by a. adding a slide transition b. selecting the edit button on the toolbar c. clicking a placeholder to place the insertion point and then typing d. typing in the notes pane
c. clicking a placeholder to place the insertion point and then typing
which chart object identifies each value in a data series a. series name b. plot area c. data labels d. legend
c. data labels
Data from Word can be copied to an Excel worksheet a. only if it contains numerical data b. if it is formatted in paragraphs c. if it is organized in a table or aligned with tabs or tab stops d. if it is all uppercase letters
c. if it is organized in a table or aligned with tabs or tab stops
which is used to change the look of printed speaker notes a. slide master b speaker master c. notes master d. handouts master
c. notes master
which paste options command is selected to paste a chart as a graphic in a word document a. chart (link to excel data) b. excel chart (entire workbook) c. paste as picture d. graphic (excel)
c. paste as picture
which is not a default footer placeholder on the slide master a date b. footer text c. presentation slide d. slide number
c. presentation slide
a selected chart is deleted by a. double clicking a chart border b. double clicking a corner handle c. pressing the delete key d. pressing the esc key
c. pressing the delete key
PAGE LAYOUT-> Print Area-> Set Print Area is used to a. freeze selected rows and columns b. print only cells containing formulas c. print a selected part of a worksheet d. print only cells containing values
c. print a selected part of a worksheet
Which allows different data sets to be defined and used within the same worksheet? a. absolute references b. amortization table c. scenerios d. multiple sheets
c. scenerios
which is not a way to add audio to a powerpoint presentation a. add an audio click from online audio b. record sound using a connected microphone c. select a sound from the sound gallery group on the insert tab d. play music from a cd during the presentation
c. select a sound from the sound gallery group on the insert tab
the first step when sorting data in a worksheet is to a. click data --> sort a to z b. click data --> sort z to a c. select the range to sort d. select the entire workbook.
c. select the range to sort
Which view is useful for changing slide order and selecting multiple slides? a. normal view b. outline view c. slide sorter view d. slide show view
c. slide sorter view
which view displays thumbnails of all the slides in the presentation a. normal view b. outline view c. slide sorter view d. slide show view
c. slide sorter view
Which type of application is required to view an HTML file? a. word processor b. spreadsheet application c. web browser d. personal information manager
c. web browser
which is not a category of a worksheet data a. label b. data/time c. value d. calculations
calculations
the intersection of a row and column is a a. label b. value c cell d sheet tab
cell
which type of chart is shown above a. column b. line c. pie d. area
column
Text, images, and other objects that appear on a slide are the a. content b. layout c. thumbnails d. audience
content
which file name extension is added when excel workbook is saved as a single file we page a. .webx b. .xlsx c. .htm d. .mht
d. .mht
Using the data in the worksheet above, what will be displayed by the formula =max (a2:b3)? a. -10 b. 52 c. 30 d. 42
d. 42
Using the data in the worksheet above, what will be displayed by the formula =sum(b1:b3) a. 25 b. 44 c. 94 d. 96
d. 96
which is not a way to add video to a powerpoint presentation a. add a video clip stored on the computer b. search for a video online c. import a video from youtube d. add a video clip from the video gallery on the home tab
d. add a video clip from the video gallery on the home tab
during a slide show, pressing the p key or backspace key a. displays the list slide b. displays slide 1 c. displays the next slide d. displays the previous slide
d. displays the previous slide
Which theme is applied to a new workbook? a. facet b. integral c. ion d. office
d. office
Which number format displays values as a percentage with two decimal places? a. accounting b. general c. number d. percentage
d. percentage
Cell references that reflect the row or column they have been copied to are called a. absolute cell references b. reflective cell references c. copied cell refrences d. relative cell reference
d. relative cell reference
a function performs a calculation that results in a. cell reference b. label c. range of values d. single value
d. single value
which view displays the current slide in full screen size a. normal view b. outline view c. slide sorter view d. slide show view
d. slide show view
a master worksheet that includes the basic elements for a particular type of worksheet is called a. a master b. html workbook c. basic worksheet d. template
d. template
Which key cancels data entry and restores the original contents of the cell? a. the enter key b. the tab key c. the right-arrow key d. the esc key
d. the esc key
When moving a range of cells between sheets, what needs to be selected before Home-> Paste is clicked? a. cell a1 b. esc key c. a new range of cells d. the upper left cell of the range where the data is to be pasted
d. the upper left cell of the range where the data is to be pasted
when moving a range of cells, what needs to be selected before past is selected a. a1 b. esc key c. new range of cells d. upper left cell of the range where the data is to be pasted
d. upper left cell of the range where the data is to be pasted
Which color combination would be the easiest to read? a. red background, black text b. light yellow background, light orange text c. dark blue background, white text d. dark green background, pink text
dark blue background, white text
Fonts, colors, and accent graphics that appear on a slide are the a. content b. contrast elements c. thumbnails in the presentation d. design of the slides
design of the slides
Which error value indicates the formula is trying to divide by zero? a. divo b. #ref c. #num d. ###
divo
what will be displayed when the formula =c8+d9/0 is entered a. 3+2 b. 5 c. Divo d. 0
divo
which backstage option is selected to save the publication in a PDF format or publish it as a web page a. export b. send c. share d. print
export
Which key can be used to create an absolute cell reference? a. enter b. f4 c. tab d. ctrl
f4
which key is used to zoom into a selected object a. f1 b. f9 c. up arrow key d. page up key
f9
Printing a worksheet in landscape orientation a. changes the order of the rows in the worksheet b. fits more columns and fewer rows on a page c. fits more rows and fewer columns on a page d. prints the worksheet on both sides of the paper
fits more columns and fewer rows on a page
Which print layout option prints one slide per page? a. full page slides b. 6 slides vertical c. notes pages d. outline
full page slides
Mail merge is used to a. integrate the information stored in an access database with a publication b. email publications c. join text boxes that contain addresses d. insert a word document into a publication
integrate the information stored in an access database with a publication
the arrangements of text and images on a slide is the a. content b. layout c. design d. thumbnails
layout
which is used to combine two or more characters into a single character a. styles b. master page c ligatures d. drop cap
ligatures
which type of chart is best for comparing the differences of data over time a. bar b. value c. line d. pie
line
which type of chart would best illustrate price fluctuations over a period of time for three stocks a. bar b. line c. pie d. area
line
Changing the data on one sheet automatically updates the data on the other sheet when the cells are a. upgraded b. pasted c. linked d. copied
linked
which is used to create a design that applies to every page in the publication a. press the enter key b. master page c. press the esc key d. drag it off the document
master page
what will be displayed by the formula =if(a1:=B1, a1, "no") a. 5 b. no c. a1 d. #value
no
Which view divides the window into the slide pane, the slide thumbnail pane, and the notes pane? a. normal view b. outline view c. slide sorter view d. slide show view
normal view
Which print layout option prints one slide in the top half of each page and any text typed in the notes pane in the bottom half of the page? a. full page slides b. 6 slides vertical c. notes pages d. outline
notes pages
Which part of the PowerPoint window displays notes that correspond to the current slide? a. quick access toolbar b. slide pane c. notes pane. d. status bar
notes pane
Which theme is applied to a new presentation? a. integral b. slice c. organic d. office
office
how many worksheets are in a new workbook? a. one b. two c. three d. five
one
what can be used to control how a worksheet is divided into pages a. page breaks b. columns c. rows d. functions
page breaks
Which PowerPoint feature is used to create a slide show of pictures? a. annimation b. photo album c. movie d. template
photo album
which is not a type of sparkline a. column b. line c. pie d. won/loss
pie
which type of chart is shown above a. bar b. colum c. line d. pie
pie
which type of chart is the best for charting data that is a percentage of a whole a. bar b. column c. line d. pie
pie
which type of chart would best illustrates each departments sales as a percentage of the overall store sales a. bar b. line c. pie d. area
pie
which is not a powerpoint compatible audio format a. mpeg b. mp3 c. wav d. pptm
pptm
to delete a selected graphic a. press the enter key b. press the delete key c. press the esc key d. drag it off the document
press the delete key
desktop publishing creates a file called a. document b. publication c. workbook d. database
publication
which file name is used temporarily until the publication is saved with a descriptive name a. document1 b. workbook1 c. publication1 d. template1
publication1
which chart type shows changes in values relative to a center point a. xy(scatter) chart b. stock chart c. surface area d. radar chart
radar chart
Which error value indicates the formula contains a reference that is not valid? a. divo b. #ref c. #num d. ###
ref
the grey area around publication that is used as a holding area for holding objects referred to as the a. pages pane b. scratch area c. work area d. title bar
scratch area
A publication can be previewed to a. see how the publication will appear when printed b. add a graphic c. display the print dialog box d. add a header
see how the publication will appear when printed
which is a good font choice for large amounts of text a. sans serif b. serif c. decorative d. italic
serif
which backstage option is selected to send the publication as an email attachment a. export b. send c. share d. print
share
what will be displayed by the formula =if("blue"<"green","sky","water) a. sky b. water c. blue d. divo
sky
the way one slide changes to the next slide in slide show view is called the a. slide transistion b. slide footer c. slide number d. animation
slide transition
Which part of the PowerPoint window displays the current slide number and the total number of slides? a. title bar b. ribbon c. notes pane d. status bar
status bar
A master presentation that includes the basic formatting and elements for a particular type of presentation is called a(n) a. annotation b. template c. theme d. html file
template
Connecting text boxes means a. the boxes physically touch each other b. the layout is placed in even columns c. text flows from one text box to another d. there are similar text boxes in two separate publications
text flows from one text box to another
the images over are examples of a. slide layouts b. themes c. slide masters d. animations
themes
which is not used to select commands and perform actions a. title bar b. menu bar c. toolbar d. objects toolbar
title bar
which chart type compares pairs of values a. area chart b. stock chart c. xy chart d. radar chart
xy chart
what will be displayed by the formula =if(a:1<B1, "yes), "no") a. yes b. no c. yes no d. #value
yes
Which key removes the dashed border around copied cells? a. esc key b. ctrl key c. alt key d. tab key
. esc key
Using the data in the worksheet above, what will be displayed by the formula =if(b1<>b2, 0, -5) a. 0 b. 5 c. -5 d. 52
0
in the chart above which is the first vertical axis label a. 0 b. architecture c. 2014 d. program
0
what will be displayed by the formulas =round(93.99,-2) a. 94 b. 100 c. 93 d. 93.99
100
what will be displayed when the formula =2*c8+3*d9 is entered a. 18 b. 2*c8+3*d9 c. #Divo d. 12
12
Using the data in the worksheet above, what will be displayed by the formula =min(b1:b3) a. 2 b. 52 c. -10 d. 26
2
how many data series were used to create the chart above a. 1 b. 2 c. 3 d. 4
2
what will be displayed by the formulas =round (c2,0) if the number 21.2534 is stored in c2 a. 22 b. =round(c2,0) c. 21 d. 21.25
21
Using the data in the worksheet above, what will be displayed by the formula =if(a1<min(b1:b3), 1, a1) a. 1 b. b1 c. 25 d. 2
25
How many arguments does an IF function have? a.1 b.2 c.3 d.5
3
what will be displayed by the formulas =round(43.92, -1) a. 43.9 b. =round(43.92,-1) c. 40 d. #ref
40
Fade, Wipe, and Fly in are examples of a. slide layouts b. animations c. slide speed d. themes
Animations
"What-If?" questions are answered by a. Changing values and noting the results b. inserting a series of blank columns c. using the if function d. changing the formatting and noting the results
Changing values and noting the results
During a slide show, pressing the N key a. disobeys the last side b. displays slide 1 c. displays the next sldie d. displays the previous slide
Displays the next slide
During a slide show, pressing the Esc key a. displays the last slide b. displays slide 1 c. ends the slide show d. displays the previous slide
Ends the slide show
Which key is pressed to start Slide Show view? a. f1 b. f5 c. enter d. spacebar
F5
INSERT -> Online pictures is used to a. add a digital camera picture b. add a scanned picture c. search for royalty free clip art on office.com d. create word art
Search for royalty free clip art on Office.com
Drape, Wind, and Glitter are examples of a. slide transistions b. slide footers c. design templates d. layouts
Slide transitions
The image above contains examples of a. slide transitions b. slide orientations c. themes d. layouts
Slide transitions