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