Formulas
Which function inserts the total of a range?
=SUM()
There is a pie chart and you want the number values to display with dollar amounts. How do you change it?
Change the number format of the data labels to Currency.
What should you add to your report if you want the same words on the top of each page?
A header
How do you remove space after a paragraph?
Click the Line and Paragraph Spacing button and then select remove Space After paragraph
Which tab lets you set worksheet print options?
Page Layout
Which function inserts the average for a selected range?
=AVERAGE()
Which type of chart can you emphasize by exploding one data point?
A pie chart
You inserted footnotes that go I, II, III, but you want them to be 1, 2, 3. What steps do you take to achieve this?
Change the Number format in the Footnote and Endnote dialogue box
What is a Theme?
A set of unified design elements for a document, including colors, fonts, and effects.
In the formula =B6*$B$2, what is $B$2?
An absolute cell reference
A student's scores in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which formula returns FALSE if the student has passed and TRUE if the student has failed?
=OR(B2>=60, C2>=60)
Which element can you add to a chart to display a line representing the general direction in a data series?
A trendline
What type of page border should you use if you want a single, predesigned line to appear all around the document?
Box
How can you add a drop shadow to a picture?
Apply a Picture Border
Before you can align pictures with each other, what do you need to do?
Select two or more pictures
The score of a student is inserted in cell B2. The passing score for the subject is 60. Which function should you insert in cell C2 to check whether the student has passed or failed?
=IF(B2>=60, “Pass”, “Fail)
You made a chart that lists number 500 to 0 on the left. What should you add to show that these are monthly expense amounts?
Vertical axis title
How do you set tabs in Word?
Select the type of tab stop you want and click on the ruler where you want it to be
What is a bibliography similar to?
A work cited page
How do you change the font color?
Click the Font Color button in the Font Group on the Home tab
What is the correct formula to insert the date December 10, 1998 into a cell?
=DATE(1998, 12, 10)
You started with a pie chart, but decided that a column chart would be best. Where should you go to make this change?
Chart Design, then click Change Chart Type
Which tab should you select if you decide to add page numbers to your portfolio?
Insert
You want to insert a long line from the Shapes group. What key can you hold down to ensure the line is put in evenly?
The SHIFT key
When should you use conditional formatting?
When data meets specific criteria