Software Applications Final Exam Review- 2024

Baylor Schaeffer Bus 1350

Which type of chart would you create to compare expenses in each department as a percentage of all expenses?

Pie chart

 Which of the following chart elements identifies the purpose of a chart?

Chart Title

 Which of the following buttons lets you remove chart elements?

Chart Elements button

 With a _____, you can emphasize one data point by exploding it.

3-D Pie Chart

 When would you explode a slice in a pie chart?

To emphasize one data point

 Which of the following can you apply to a data series to change its appearance?

Shape Style

 Which of the following elements can you add to a chart to display a line representing the general direction in a data series?

Trendline

What type of chart is a Clustered Column - Line chart?

Combo Chart

 Which of the following chart types shows the distribution of data grouped in bins?

Histogram chart

Which of the following elements uses colors to identify how the data is represented in a chart?

Legend

Which of the following are effects you can apply to the chart title? Select all the options that apply.

Shadow, Outline, Glow

Which of the following options should you select to have Excel update all formulas as you edit a worksheet?

Automatic calculation

 Which of the following statements is true about COUNT functions?

The COUNT function returns the number of cells in a range that contain numeric data.

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'')

 Which of the following is true of the Excel spell checker?

You can change all instances of a flagged word to a selected suggestion.

 To accept a suggested spelling for that instance only, which of the following would you select?

Change

 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.

 Clicking the Accounting style in the Number Format arrow applies _____ decimal places by default.

Two

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

Color

 Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

Hide

 You receive a worksheet in which the row numbers are 1, 2, 3, 5, 6. This means that row 4 is  _____.

hidden

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

Left, Center

 The Comma Style format adds a comma and a dollar sign to a cell value.

False

A predesigned combination of formats, such as font size and color, is called a cell default.

False

When you wrap and center a range, you combine the cells into one cell.

False

To change the color of cell content, you use the ________ color list arrow.

Text

The _____ number format adds dollar signs and two decimal places to numeric data.

Accounting

 To delete a  worksheet column, you can first select it by _____.

Clicking the column heading

 To rename a worksheet, you change the text on the  _____.

Sheet Tab

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

False

 To find the largest value in a cell range, use the MIN function.

False

 The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

True

 In the formula =SUM(A6:A9), which of the following best describes A6:A9?

Argument

Which of the following lets you edit the contents of a cell?

Double-click the cell or click in the formula bar.

 Which of the following views shows how a worksheet will appear when printed?

Page Layout view

 Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

The formula =SUM(B6:B10)

To have Excel enter the lowest price from a range of prices, which of the following would you use?

MIN function

To print more than one copy of your worksheet, which tab would you go to?

File

Which of the following functions inserts the total of a range?

SUM

Which of the following lets you search for a function or select one from a category?

Insert function dialog box

 Which of the following tabs lets you set worksheet print options?

Preview

When you cut or copy a cell, it is cut or copied to which of the following?

Both the Windows and Office clipboard

In the formula =A8*$A$1, which of the following describes A8?

Relative cell reference

When should you use relative cell references?

When you want to preserve the relationship to the formula location.

Which of the following types of conditional formatting rules identifies a set of the highest or lowest values in a field or column?

Top/Bottom Rules

 A _____ is a preset combination of fill color, borders, and font color.

Table Style

 How can you add a record to the end of a table?

Type data directly below the last row of the table.

What happens when you drag a table's sizing handle to the right?

You add a column to the table.

 Luke is working with a table filtered to show only some records. What can he do to display all the records in the table?

Clear the Filter

Shelley has created a table listing the names of her students and their grades on an exam. She wants to display only the students who received a grade of 60. After clicking the Grade filter list arrow, what should she do?

Click 60.

What type of filter should you use when you want to display records that meet And conditions and Or conditions?

Advanced filter

After adding data to a table where a filter is applied, what should you do to filter the new data?

Reapply the filter

When you insert a table, it is organized into rows of data called _____.

records

Which of the following is a way to make a table accessible?

Enter a descriptive table name.

An Excel table contains columns named Salary and Commission. Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?

'=[Salary]+[Commission]

Which of the following functions can you use to locate information in a table?

LOOKUP

The _____ function returns the value from a range of data at the intersection of a specified row and column.

INDEX

Which of the following conditional formatting types can you apply to use red fill to indicate cells that have higher values and green fill to indicate lower values?

Color Scales

Warren has a table that applies fill formatting to every other column, which he finds distracting. How can he remove this formatting?

Turn off banded columns.

To apply banded columns to a table, select the table, click the Column Fill button, and then click Alternating.

False

Banded Rows applies banding to table rows to fill alternating rows with color.

True

To select a table to copy it to another worksheet, you can click anywhere in the table, and then press CTRL+ C to select and copy the table data in the entire table.

False

The Table Styles gallery includes an option for creating a custom table style.

True

Which of the following Excel features applies a design using theme colors to a table?

Table style

How can you add a new record to a table? Select all the options that apply.

Type data directly below the last row of the table, Drag the sizing handle in the lower-right corner of the table, Click a row, click the Insert arrow in the Cells group, then click Insert Table Rows Above.

Which tab and button do you use to edit document properties?

File Tab, info button

A(n) _____ is a section of columns or rows that you can freeze and unfreeze.

Pan

How can you remove the split panes from a worksheet?

Click the View tab, and then click the Split button in the Windows group.

Which of the following can be the target of a hyperlink in Excel?

Worksheet in the current workbook

A(n) _____ is a specially formatted word, phrase, or graphic that, when clicked, displays a webpage.

Hyperlink

A(n) _____ is a set of display or print settings that you can name and save, and then access later.

View

Which of the following items does the Document Inspector check for sensitive information?

Document properties

Which of the following features provides a way to correct a picture in a worksheet?

Sharpen/Soften

Which of the following is an effect you can apply to a picture?

Glow

Which of the following is a correction you can apply to a picture?

Brightness/Contrast

Which of the following can you insert in a SmartArt shape?

Picture

Which of the following can you do to decrease the level of a SmartArt shape?

Demote the shape

Which of the following options can you use to increase the level of a SmartArt shape?

Promote

 What happens when you drag a corner handle on SmartArt?

You resize the SmartArt proportionally

Text files you can import into Excel use a(n) _____, a separator such as a space or comma between columns of data.

delimiter

To import data from an Access table into Excel, you use the _____ tool.

Get & Transform

When you insert a picture in a worksheet, the Insert Picture dialog box displays only files that contain graphics file extension, such as _____.

.jpg

What must you do before inserting a screenshot in a worksheet?

Open the window you want to display in the screenshot.

 What can you insert to communicate information as a collection of shapes arranged in a list or cycle?

SmartArt

How can you move a picture, chart, or other object on a worksheet?

Drag the object

 To embed an Excel chart in a PowerPoint slide, you can use the Destination Theme & Link Data button in the Paste Options group.

False

When you link an Excel chart to a PowerPoint slide, the chart always retains its original formatting.

False

 You can import text data into Excel and save the imported data in Excel format.

True

Which of the following can you change in SmartArt? Select all the options that apply.

Style, Size of shapes, Color scheme

After creating a macro, how can you make it easier to run for other workbook users?

Assign the macro to a button.

 By default, Excel records which type of cell references in a macro?

Absolute

Jesse wants to set up a button shape so that when users click the button, a macro runs. Which of the following should he do?

Assign a macro to the button shape.

Arlo creates a rectangle on a worksheet, right-clicks the shape, and then clicks _____ on the shortcut menu so he can use the shape to run a macro.

Assign Macro

When you share a workbook, where can you upload the workbook for sharing?

To a OneDrive account

To document a workbook, you can use _____, notes you add to worksheet cells.

Cell comments

If you save an Excel workbook on OneDrive, _____ saves versions of your workbook as you make changes.

AutoSave

To clear all the comments from a workbook, you must delete them one at a time.

False

 The predefined colors in a workbook are called the cell styles.

False

 Richard retired recently and is receiving $400 per month from an investment at a rate of 7% for 20 years. Which of the following functions can he use to calculate the current value of the investment?

PV