Computer Applications midterm
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?
$A$5
A workbook template has which of the following file extensions?
.xltx
How many actions does the Undo button let you reverse?
100
The default worksheet text is _____-point Calibri.
11
With a _____, you can emphasize one data point by exploding it.
3-D pie chart
The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?
=AND(B2>=70, C2>=80)
Sam wants to count the number of cells in the range B1: B20 that contain numbers. Which of the following formulas should he use?
=COUNT(B1:B20
Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text. Which of the following formulas should he use?
=COUNTA(B1:B20)
What is the correct formula to insert the date January 12, 1998 into a cell?
=DATE(1998,1,12)
Which of the following formulas can you use to find the serial number of the date January 1, 2017?
=DATEVALUE("01,1,2017")
Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?
=DAY(A1)
Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?
=HOUR(A1)
Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?
=IF(A4<25, "Poor", IF(A3<50, "Average", "Good"))
The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?
=IF(B2>=60, "Pass", "Fail")
Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?
=MINUTE(G5)
Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?
=MONTH(TODAY(2016,7,0))
The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60. which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?
=NOT(ORB2>=60, C2>=60))
A student's scores in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?
=OR(B2>=60, C2>=60)
Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?
=ROUND(A5,2)
To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.
CTRL
Which of the following keys should you press to have Excel calculate all open workbooks manually?
F9
Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?
IF
To have Excel enter the lowest price from a range of prices, which of the following would you use?
MIN function
Which of the following functions inserts the total of a range?
SUM
If cell A5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?
TIME
You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?
a column
A worksheet named Income (2) is most likely which of the following?
a copy of another worksheet named income
When you underline cell content, you are using _____.
a font style
In the formula =B6*$B$2, which of the following describes $B$2?
absolute cell reference
Julia noticed that she accidentally used the word "then" instead of "than" in a sentence. Word identified the grammar error with a blue double underline. To correct the error, she can do which of the following?
accept the suggested grammar change
The _____ number format adds dollar signs and two decimal places to numeric data.
accounting
Marianna wants to make the legend stand out on a chart. Which of the following can she do?
add a border
Sydney has created a table with two columns to store the name and address of clients. She needs to add additional information about phone numbers. She should do which of the following?
add a column
Cameron needs to insert a citation, but he does not have the source information. Which of the following should he do?
add a new citation placeholder
Which of the following is a way to enhance the look of a document?
add a page border
Tiana wants a line to appear around a paragraph. She should do which of the following?
add a paragraph border
Nathan is creating a document that needs to be accessible to people with visual impairment. He should do what to the pictures in the document?
add appropriate alt text to each of the pictures
Alyssa needs a paragraph to have a dotted border. She should do which of the following?
apply a paragraph border and change the line style of the border
How can you add a drop shadow to a picture?
apply a picture effect
Sarah wants to apply a set of effects such as shading, borders, and shadows to a picture. Which of the following can she use to do this?
apply a picture stylee
To quickly change the fill, outline, and effect of a shape, which of the following should be done?
apply a shape style
To quickly change the shading, borders, and font colors of a table, which of the following should be done?
apply a table style
Brianna needs the rows in a table to alternate colors. She should do which of the following?
apply a table style that includes banded rows
A document contains a list of items that appear in no particular order. Which of the following is the best way to format the list?
apply bullets to the list
In the formula =SUM(A6:A9), which of the following best describes A6:A9?
argument
Which of the following lets you fill a cell with only specific elements of a copied cell?
auto fill options button
When you double-click the right border of a column heading, which of the following occurs ?
autofit resizes the column to the wides cell entry
Which of the following options should you select to have Excel update all formulas as you edit a worksheet?
automatic calculation
What feature inserts a function that totals the cells above or to the left of the selected cell?
autosum button
Which of the following inserts a function into a cell?
autosum button
Where can you adjust page layout settings and see how they affect a preview of the printed worksheet?
backstage view
Which of the following would you use to print only one page of a multipage worksheet?
backstage view
When you cut or copy a cell, it is cut or copied to which of the following?
both the windows and office clipboard
One of the pictures in Destiny's document is covered up by another picture. To make the obscured picture visible, she should do which of the following?
bring the obscured picture to the front
To accept a suggested spelling for that instance only, which of the following would you click?
change
Silvio inserted an inline picture and wants to move it to the upper-right corner of the page. What must he do before moving it?
change it to a floating picture
Dawn wants to make a column chart look three dimensional. How can she do so?
change the chart type
Aliya needs her footnotes to be listed as I, II, III... instead of as 1,2,3... She should do which of the following to achieve this?
change the number format in the footnote and endnote dialogue box
Maria has a line chart that shows expense amounts on the vertical axis. What can she do to display the values as dollar amounts?
change the number format of the vertical axis
Charlie created a pie chart that displays number values in data labels. How can he change the values to show dollar amounts?
change the number of the date tabes to currency
Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?
change the page orientation to landscape
How can you apply a set of effects, such as a Subtle effect or Polished effect, to SmartArt?
change the smartart style
Kayla wants to apply a shadow to a paragraph border. She should do which of the following?
change the type of paragraph border in the borders and shading dialogue box
Nevaeh needs a paragraph border to be very thick. He should do which of the following?
change the width of the border in the borders and shading dialogue box
Which of the following buttons lets you remove chart elements?
chart elements butotn
Which of the following chart elements identifies the purpose of a chart?
chart title
To ensure that a document can be read by people with visual impairment, which of the following should be done?
check the document for accessibilty
To ensure a document is free of typos, always do which of the following before publishing the document.
check the document for spelling and grammar errors by clicking the spelling and grammar button
Jasmine is working on a research paper that needs to be in MLA format. To ensure her bibliography is formatted properly, she should do which of the following?
check to ensure the bibliography style is MLA in the citations and bibliography group of the references tab
Gabrielle opened a document that has a large number of tab stops in undesired locations. She wants the tab stops removed. She should do which of the following?
clear all tab stops from the document
To return cell contents to its default font and style, you can use the _____ command.
clear formats
To resize a shape nonproportionally, which of the following should be done?
click and drag a middle sizing handle
Which of the following do you do to select text?
click and drag across the desired text
Imani needs to rearrange a picture in her document. The picture has Square text wrapping. She should do which of the following?
click and drag the picture to the desired location
To clear all formatting from a picture, which of the following should be done?
click reset picture
To create a horizontal mirror reflection of a picture, which of the following should be done?
click rotate and select flip horozontal
To select a single worksheet cell so you can work with it, which of the following would you do?
click the cell
Alyssa needs to center the text of a paragraph on the page. Which of the following can she do?
click the center button in the paragraph group
Terri needs each word in a paragraph to be capitalized. Which of the following is the simplest method to achieve this?
click the change case button and select capitalize each word
Jordan wants a warm color palette for his SmartArt. He should do which of the following?
click the change colors button and select the desired option
Joshua needs stylized text in his document to be normal, unformatted text. He should do which of the following?
click the clear all formatting button
To recolor a picture with a green tint, which of the following should be done?
click the color button and select the desired options
To delete a worksheet column, you can first select it by _____.
click the columns heading
Cameron needs to brighten and increase the contrast of a picture. He should do which of the following?
click the corrections button and select the desired option
Aniyah needs to insert the date and time in her document. She should do which of the following?
click the insert date and time button and select the desired option
To remove space after a paragraph, do which of the following?
click the line and paragraph spacing button and then select remove space after paragraph
Jared wants to add space between each line of text in a paragraph. Which of the following is the best method to use for this action?
click the line and paragraph spacing button in the paragraph group, then select the desired amount of spacing
What is the simplest and most efficient way to locate the next comment in a document?
click the next button in the comments group of the review tab
To zoom a document so that you can see the left and right margins, which of the following should you do on the View tab?
click the page width button in the zoom group
To have a shape appear at the top and center of a page, which of the following should be done?
click the postion button and select position in top and center with square text wrapping
Hannah wants to position a picture in the middle and center of a page and let the text wrap around the picture. She should do which of the following?
click the postion button and select postion in middle center with square text wrapping
If you mistakenly undo an action, how do you correct your mistake?
click the redo button on the quick access toolbar
Kate needs to insert 10 text boxes in a document. After inserting the first text box, how can she easily repeat the action nine more times?
click the repeat button nine time
Jeremy is reading a document about geology when he encounters the word Paleolithic. To conduct research about the Paleolithic era, he should do which of the following?
click the researcher button
Alexis is having trouble clicking the right part of a table to select a row. After selecting a cell, what should she do instead?
click the select button and then click select row
David needs an oval to appear in his document. He should do which of the following?
click the shapes and select the desired option
To hide the comments in a document, do which of the following?
click the show comments button
To create a cycle diagram in a document, which of the following should be done?
click the smartart and select the desired option
To create a hierarchy diagram, which of the following should be done?
click the smartart button and select the desired option
To create two simultaneous views of a document, do which of the following?
click the split button
To quickly change the colors, fonts, and effects in a document, which of the following should be done?
click the themes button and select the desired option
After editing sources using the Source Manager, do which of the following to ensure the bibliography reflects the changes?
click the update citations and bibliography button in the content control tab for the bibliography
To calculate the number of words in a document, do which of the following?
click the word count button
Which of the following is the temporary storage area that holds selections you copy or cut?
clipboard
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.
color
What type of chart is a Clustered Column - Line chart?
combo chart
To format a range so that all values greater than $500 appear in red, which of the following can you use?
conditional formatting
Imani needs to duplicate a picture in her document. She should do which of the following?
copy and paste the picture
Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?
copy pointer
To indent the first line of every paragraph in a document, do which of the following?
create a first line indent
Tiana needs each line after the first line in a paragraph to be indented. She should do which of the following?
create a hanging indent
Betty wants to display negative percentages in red text with parentheses. What type of number format should she apply?
custom
If a worksheet contains cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them .
data bars
Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?
data labels
Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?
delete
When a comment is no longer useful, you should do which of the following?
delete the comment
Joan has a redundant source in her bibliography. What is the best way for her to remove this redundant source from the bibliography?
delete the redundant source in the source manager, then update the bibliography
File details such as the document title and author name are called _____.
document properties
What are user-defined details about a file that describe its content and origin called?
document properties
Which of the following lets you edit the contents of a cell?
double-click the cell or click in the formula bar
To have text appear at the bottom of each page in a document, do which of the following?
double-click the footer region of the page and enter the desired text
To resize a picture proportionally, which of the following should you do?
drag a corner sizing handle
Which of the following lets you resize a selected picture on your worksheet?
drag any corner handle
Which of the following do you do to better view small, difficult-to-read text in a document?
drag the zoom slider to enlarge the document
To correct an error in a comment, do which of the following?
edit the comment
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?
edit the conditional formatting rule
Kyle needs the same text to appear at the top of each page in a document. Which of the following is the best method to achieve this?
edit the document header
Elise is preparing to print a worksheet that displays the worksheet name centered at the bottom of every page. She also wants to display the current date next to the worksheet name. Which of the following should she do?
edit the footer to add the date
Brianna needs to correct the year of publication in one of her sources. She should do which of the following?
edit the source to correct the error in the source manager
Anna needs to leave a message for a collaborator about a specific paragraph in a document. Which of the following methods is the best way for her to communicate with her collaborator?
enter the desired message in a comment attached to the paragraph
Sydney wants to resize a picture to exact dimensions. She should do which of the following?
enter the height in the shape height text box and enter the width in the shape width text box
To specify the exact dimensions of a shape, which of the following should be done?
enter the height in the shape height text box and enter the width in the shape width text box
Which of the following is true about inserting cells in a worksheet?
excel automatically adjusts cell references to reflect new formula locations
To print more than one copy of your worksheet, which tab would you go to?
file
Juana needs to open a document. To access the Open dialog box, which tab should she use?
file tab
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?
fill handle
A _____ is the appearance and shape of letters, numbers, and special characters.
font
To change the color of cell content, you use the ________ color list arrow.
font
To change the starting and ending values on a chart axis, use the _____ pane.
format axis
To copy a cell's formatting to another cell, which of the following can you use?
format painter
Which of the following is a predefined procedure that returns a value?
function
To move to a specific page, section, line, or graphic, you can use the _____.
go to tab in the find and replace dialogue box
To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?
gridlines view
You receive a worksheet in which the row numbers are 1, 2, 3, 5, 6. This means that row 4 is _____.
hidden
Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.
hide
To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?
highlight cell rules
Which of the following chart types shows the distribution of data grouped in bins?
histogram chart
Which of the following is not a way to move cell contents?
holding the CTRL key while dragging the selected cells
To apply a cell style, you would use the Cell Styles command on the _____ tab.
home
Which of the following window elements displays the left and right document margins?
horizontal ruler
Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?
icon sets
You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?
if it needs an absolute cell reference
The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?
ignore all
Ben moved a chart to a chart sheet, but now the axis labels are too small. What can he do to make them easier to read?
increase the font size
Aamir is preparing a research paper. He needs to insert a parenthetical reference that gives credit to the source of a quotation. What is the best way for him to achieve this?
insert a citation
Jada needs to create a note at the bottom of a page that references text in the body of the document. She should do which of the following?
insert a footnote
To start entering text on a new page, do which of the following?
insert a page break
Isaiah needs to insert a copyright symbol (©). He should do which of the following?
insert a symbol from the symbol gallery
Where can you see a brief description of a selected function?
insert function dialogue box
Which of the following lets you search for a function or select one from a category?
insert function dialogue box
In a complex formula, how does Excel determine which calculation to perform first?
it follows the order of opertations
Why is it necessary to use care when inserting worksheet cells?
it may disturb row or column alignment, which can effect worksheet accuracy
Which of the following should Tim use to italicize text?
italic button on the mini toolbar
In a formal, professional document, which of the following can you apply to make a word stand out?
italic formatting
Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance. He should use which of the following paste options?
keep source formatting
Which of the following elements uses colors to identify how the data is represented in a chart?
legend
Amanda wants to calculate formulas only when she saves or opens a workbook. Which of the following calculation options should she select?
manual
To combine multiple cells into one combined cell, which of the following do you use?
merge and center button
Angel wants all Subtitle text to be green. She can right-click the Subtitle style in the Styles pane and then click _____.
modify
Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?
more button
Alexis needs the text after a tab character to be moved further to the right. She should do which of the following?
move the appropriate tab stop to the right
You can use the _____ to quickly move to a specific page in the document.
navigation pane
As you change the number format of a chart axis using the Format Axis pane, which of the following axis options can you also add?
number format code
Karen has a document with a list of five priorities in separate paragraphs. The priorities are listed in order from most important to least important. Which of the following options is the best way to format this list?
numbered list
The Clipboard task pane shows the contents of the _____.
office clipboard
Jacki needs all Heading 1 text to appear green. Which of the following methods is the best way to achieve this?
open the modify style dialogue box for heading 1 and change the font color to green
Which of the following methods is the best way to find a word in a document?
open the navigation pane and then enter the search text
To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?
open the workbook, make changes, and then save it using a different name
To rotate cell contents to an exact value, you change its _____.
orientation
Which of the following is a text effect you can select from the Text Effects and Typography gallery?
outline
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?
page break preview
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?
page layout
Which of the following tabs lets you set worksheet print options?
page layout
Which of the following views shows how a worksheet will appear when printed?
page layout view
Which worksheet view shows headers, footers, and rulers?
page layout view
You double-click the Format Painter button when you want to _____.
paste the same format multiple times
Which type of chart would you create to compare expenses in each department as a percentage of all expenses?
pie chart
To switch between two open windows, do which of the following?
point to the word icon on the taskbar and then click a document
Jeremiah inserted a table and needs to fill it with data. After entering a value, he should do which of the following to move the insertion point to the next cell in the row?
press TAB
Which of the following methods copies an existing worksheet within the same workbook?
press and hold CTRL and drag its sheet tab to a new location
Dan needs to view his document as it will appear after being printed. Which view should he use?
print layout
Which view most closely resembles how your document will look when printed?
print layout
After selecting a range of data, what can you click to display common chart types based on the range you selected?
quick analysis button
You can create conditional cell formats using either the Home tab or the _____.
quick analysis tool
Eric wants to rearrange the legend, title, gridlines, and other elements in a bar chart. Which of the following tools can he use to change many chart elements at the same time?
quick layout button
Rihanna wants to display document text so that it is easy to read on screen. Which of the following views should she use?
read mode
Walter selected data on a worksheet to show in a chart. Which button on the Insert tab can he click to display charts appropriate for the selected data?
recommended charts button
Gabrielle accidentally deleted several paragraphs in her document. To restore her work, she should do which of the following?
recover unsaved changes using the info screen on the file tab
To view the entire page of a document, which of the following should you do?
reduce the zoom level
Which of the following options is included in the Bibliography gallery?
references
In the formula =A8*$A$1, which of the following describes A8?
relative cell reference
Chloe notices that when she inserts a tab character, her insertion point moves to the right side of the page and the text she enters is right-justified. She does not want tab characters to behave this way. She should do which of the following?
remove the tab stop
If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command.
replace
Shane is reading through a document that has comments from his editor. He needs to respond to one of the comments. He should do which of the following?
reply to the comment
What is a simple way to signify that a concern raised in a comment has been addressed?
resolve the comment
When a red wavy line appears below a word, which of the following methods do you use to accept a spelling change?
right-click the misspelled word, then select a correction option
Jessica encounters text in a document that appears blue and underlined. When she presses CTRL and clicks the text, she is taken to a website. She wants the text to appear and behave like normal text. Which of the following should she do?
right-click the text and remove hyperlink
Andrew accidentally misspelled a word. To correct the error, he can do which of the following?
right-click the word and select the desire suggested spelling
Kennedy needs to rotate a horizontal picture so it appears in a vertical orientation. She should click the Rotate button then select which of the following options?
rotate left 90 degress
Tom clicked and dragged the rotation handle above a picture. This resulted in which of the following?
rotated the shape to an approximate value
The _____ show the document margins.
rulesr
Where do you rename a workbook and adjust its save location?
save as dialog box
Jane has created a new document and entered some text. What should she do to ensure she does not lose her work?
save the document
Which of the following options can you set to make sure a worksheet will print on one page?
scaling
Which of the following helps you move around a worksheet that is too large to fit on the screen at once?
scroll bars
Derek needs to change all green text in a document to purple text. Which of the following methods is the most efficient way to locate green text in the document?
search for text based on font color
Laura is changing data in a worksheet, but the worksheet is not updating the results in cells with formulas. She does not want to update the data tables on the worksheet, but she does want to update the other formulas. Which of the following is the most efficient way for her to do so?
select the automatic except for data tables option
Dana created a column chart showing four quarters of data, but she no longer wants to display the Quarter 1 data series. How can she quickly remove it?
select the date series then press DEL
To change the shading of a cell in a table, which of the following should be done first?
select the desired cell
Jasmine needs to select the first sentence of a paragraph and the last sentence of a paragraph simultaneously. The text is nonadjacent. Which of the following should she do?
select the first sentence, then press and hold CTRL while selecting the second sentence
Jenna changed the font color of a heading with the Heading 1 style to green. She wants all headings with the Heading 1 style in the document to be green. Which of the following is the best way to achieve this?
select the green heading 1 header, then update the heading 1 style to match the selection
Hailey wants to resize a picture using percentages of its original size. She should do which of the following?
select the lock aspect ratio check box before entering percentages
Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data. How can he work more efficiently?
select the manual calculation option
To enter your name in the lower right corner of a worksheet page, you can _____.
select the right footer text box and type your name
Brian needs to view the paragraph marks in a document. Which of the following should he do?
select the show/hide button
Laila needs to change the formatting of a table. To do so, which of the following does she need to do first?
select the table
Joseph needs to remove the formatting from a selection of text. He should do which of the following?
select the text and click all formatting
Susan typed a long title using lowercase text, but needs to change the title to uppercase text. Which of the following is the best way to change the title?
select the text, click the change case button in the font group, then select UPPERCASE
Before you can align pictures with each other, what do you need to do?
select two or more pictures
Ashley needs to find an underlined word in a 100-page document. Which of the following is the most efficient way to find the word?
serach for underline formatting
Which of the following formatting enhancements can you apply to paragraphs?
shading
Which of the following is a way to format a paragraph?
shading
You can change the color of a data series by selecting the series and then clicking the _____ button.
shape fill
Which of the following can you apply to a data series to change its appearance?
shape style
To rename a worksheet, you change the text on the _____.
sheet tab
Which of the following can you use to change the amount of space set before the active paragraph?
spacing before box on the layout tab
Alexandra wants text to appear within a circle shape in her document. After selecting the shape, she should do which of the following?
start typing the desired text
Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?
sum
A _____ is a point on the horizontal ruler that indicates where to align text.
tab stop
To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.
template
Makayla inserted a shape and wants to change the way text flows around it. What should she change
text wrapping
Which of the following statements is true about COUNT functions?
the COUNT function returns the number of cells in a range that contain number date
Which of the following is true when you copy and paste formulas using the fill handle?
the autofill options button lets you fill cells with specific elements of the copied cel
After you delete a worksheet column, _____.
the column to its right shift left
Ben has added a source for a quotation. To insert a citation using this source, he can click the Insert Citation button and then click which option?
the desired source in the list of sources
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
the formula =SUM(B6:B10)
When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?
the paste option button then lets you paste specific elements of the copied cells
Austin needs to emphasize text by applying a transparent color to the text. Which of the following tools should he use?
the text highlight color button
If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?
the undo button on the quick access toolbar
A _____ is a set of unified design elements for a document, including colors, fonts, and effects.
theme
Why would you use the Line and Paragraph Spacing arrow on the Home tab?
to add or remove space b/w paragraphs
Which of the following is true about deleting a worksheet row?
to delete a row, you can select the row, then use the delete button in the cells group
When would you explode a slice in a pie chart?
to emphasize one date point
For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?
to paste the value's number formatting only
To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.
transpose
Which of the following elements can you add to a chart to display a line representing the general direction in a data series?
trendline
To select a paragraph, do which of the following?
triple click the paragraph
Clicking the Percentage style in the Number Format list applies _____ decimal places by default.
two
Joe accidentally deleted a paragraph. Which of the following is the fastest way to restore the paragraph?
undo the action
Madison bolded text formatted using the Subtitle style, and now wants all Subtitle text to be bold. She can right-click the Subtitle style in the Styles pane and then click _____.
update subtitle to match selection
To ensure your bibliography accurately reflects the sources in your source list, do which of the following?
update the bibliography
Katlyn needs to remove all tab characters from a document. Which of the following is the most efficient way for her to do so?
use the find and replace dialogue box to locate the tab characters
Jaylen needs a shape in her document to have the same formatting as another shape in her document. She should do which of the following?
use the format painter
Which of the following do you use to change the document margins?
use the margins button in the page setup group of the layout tab to select the desired option
Joanne needs each page in her document to be numbered. She should do which of the following?
use the page number button
Caleb created a column chart that lists numbers from $50,000 to $0 on the left. What can he add to the chart to indicate that these are monthly revenue amounts?
vertical axis title
Which of the following is a document view you an select using a button on the status bar?
web layout view
Which of the following is true when you delete a cell?
when you delete cells using the delete list arrow, you can choose which way to move adjacent cells
When should you use relative cell references?
when you want to preserve the relationship to the formula location
To create a list of sources cited in your document, insert which of the following?
works cited
Which of the following is true about adding cell borders?
you can add a border to the left, top, right, or bottom edge of a cell
Which of the following is true of the Excel spell checker?
you can change all instances of a flagged work to a selected sugestion
Which of the following is not true about setting column width?
you can change the width of only one column at a time
Which of the following is true about moving cell contents?
you can move cells using the drag-and-drop feature
What can you use to enlarge the document in the document window so you can focus on a detail?
zoom slider
