Computer Science 1: Final Exam Chapter 1 Excel Practice

Clicking the ____ box completes an entry. -enter -tab -formula -cancel

enter

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart. outer exploded offset rasterized

exploded

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names. True or False

false

Excel can display characters in only three font colors: black, red, and blue. True or False

false

In a worksheet, columns typically contain information that is similar to a list. True or False

false

Live preview is available on a touch screen. True or False

false

____________________ involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

green computing

Which of the following keys moves the insertion point to the beginning of data in a cell? ENTER HOME TAB INSERT

home

Which of the following keys moves the insertion point to the beginning of data in a cell? -enter -insert -tab -home

home

Combining two or more selected cells into one cell is called ________ cells -mixing -merging -combining -spanning

merging

____________________ cells involves creating a single cell by combining two or more selected cells.

merging

The active cell reference appears in the ____________________ on the left side of the formula bar.

name box

The range of cells receiving copied content is called the ____ area. fill range location paste

paste

How many chart types does Excel offer? -5 -15 -50 -30

15

Which of the following is the Ribbon path to the Cell Styles button? (STYLES tab | Home group) (HOME tab | Styles group) (HOME tab | Format group) (FORMAT tab | Styles group)

(HOME tab | Styles group)

Excel remembers the last ____ actions you have completed. 100 50 75 30

100

You can apply the Bold font style by pressing the ____ keyboard shortcut keys. -CTRL+B -SHIFT+B -TAB+B -ALT+B

CTRL + B

Pressing the ____ keyboard shortcut key(s) selects cell A1. END HOME CTRL+HOME CTRL+END

CTRL + HOME

Press ____ to select the entire worksheet. CTRL+A F4 ALT+A F1

Ctrl+A

What effect does the Comma Style format have on the selected cells? -Converts decimals to commas within merged cells -Displays cell contents with two decimal places and commas as thousands separators -Converts decimals to commas within a cell -Allows for substitution of selected characters

Displays cell contents with two decimal places and commas as thousands separators

What effect does the Accounting Number Format have on the selected cells? -Converts alphabetic characters to numbers -Copies the numbers of one cell to another -Displays cell contents with two decimal places that align vertically -Performs tax calculations

Displays cell contents with two decimal places that align vertically

You use ____ to view an XPS file. -xps viewer -adobe reader -backstage view -microsoft power view

XPS Viewer

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu. -AutoCalculate -AutoFormat -AutoComplete AutoFunction

auto calculate

The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

auto fill options

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. -AutoTyping -AutoFormat -AutoComplete -autocorrect

autocorrect

____________________ corrects two initial capital letters by changing the second letter to lowercase.

autocorrect

The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

autofill options

To enter data in a cell, you must first select the ____. -row -cell -worksheet -column

cell

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. none of the above semi-colon (;) colon (:) period (.)

colon

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu. True or False

false

Worksheet titles and subtitles should be as wordy as possible. true or false

false

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group). True or False

false

____________________ indicates how characters are emphasized.

font style

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. clear format print save

format

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

formula bar

Which of the following keys toggles between Insert mode and Overtype mode? ENTER INSERT ALT TAB

insert

A ____ reference is an adjusted cell reference in a copied and pasted formula. -revised -retained -recycled -relative

relative

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

relative referenece

The person or persons requesting the worksheet should supply their requirements in a ____ document. test issues blank requirements certified

requirements

Pressing the ____ key to complete an entry activates the adjacent cell to the right. DOWN ARROW RIGHT ARROW LEFT ARROW UP ARROW

right arrow

____ properties are associated with all Microsoft Office files and include author, title, and subject. -automatic -hidden -replacement -standard

standard

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

sum

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

sum

____ is/are used to place worksheet, column, and row titles on a worksheet. -Tabs -Color -Text -Links

text

A character with a point size of 10 is about 10/72 of one inch in height. True or False

true

A character with a point size of 10 is about 10/72 of one inch in height. True or False

true

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. True or False

true

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column. True or False

true

The AutoCorrect feature can automatically capitalize the first letter in the names of days. True or False

true

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. True or False

true

The opposite of merging cells is splitting a merged cell. true or false

true

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group). True or False

true

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group). true or false

true

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data. True or False

true

With Excel in Edit mode, you can edit cell contents directly in the cell. True or False

true

The first step in creating an effective worksheet is to make sure you ____. -insert a chart -understand what is required -apply font formatting -enter the data

understand what is required

The ____ button allows you to erase recent cell entries. Bold Undo Cell Style Increase Decimal

undo

An Excel ____ allows data to be summarized and charted easily. document worksheet workflow presentation

worksheet