[07] Lesson 8 Exam

Would you like us to handle your paper? Use our company for better grades and meet your deadlines. When you need high quality assignment help online, we are here to help you


Order a Similar Paper Order a Different Paper

On the Format tab, in the Format Auditing group, clicking Show Formulas, will ____________ in the cell.

Question 1 options:

a)

print the formula

b)

display the formula

c)

print the result

d)

display the result

Question 2 (5 points)

Question 2 Unsaved

____________ is a feature that speeds your typing and lessens the likelihood of errors; if the first few characters you type in a cell match an existing entry in the column, Excel fills in the remaining characters for you.

Question 2 options:

a)

AutoFit

b)

AutoComplete

c)

AutoFill

d)

AutoCalculate

Question 3 (5 points)

Question 3 Unsaved

Data can be entered by selecting ___________ and then typing text or a number.

Question 3 options:

a)

a column

b)

a row

c)

a range of cells

d)

the typed data

Question 4 (5 points)

Question 4 Unsaved

In Excel, you can apply custom margins, center the spreadsheet on the page, and insert a Header or Footer using the same technique as ____________ before printing the spreadsheet.

Question 4 options:

a)

Access

b)

Word

c)

Quicken

d)

PowerPoint

Question 5 (5 points)

Question 5 Unsaved

In Excel, the __________command begins its checking process with the currently selected cell and moves to the right and down.

Question 5 options:

a)

Format

b)

Spelling

c)

Formula Review

d)

Review

Question 6 (5 points)

Question 6 Unsaved

The __________check box centers a worksheet horizontally on a page.

Question 6 options:

a)

Format

b)

Align

c)

Center on page

d)

AutoFit

Question 7 (5 points)

Question 7 Unsaved

The ____________ group can be used to align text vertically and horizontally in a cell.

Question 7 options:

a)

format

b)

alignment

c)

text effects

d)

page setup

Question 8 (5 points)

Question 8 Unsaved

Like the ___________ in Word, the Quick Analysis button displays a set of commands and formatting tools when you select a range of data.

Question 8 options:

a)

status bar

b)

calculate button

c)

mini toolbar

d)

stationary

Question 9 (5 points)

Question 9 Unsaved

You can change the worksheet orientation on the Page Layout tab or:

Question 9 options:

a)

on the Print tab

b)

in Backstage view.

c)

in Print Preview.

d)

in Settings.

Question 10 (5 points)

Question 10 Unsaved

Cells and the overall layout of the worksheet can be formatted, using various commands on all the following EXCEPT:

Question 10 options:

a)

the Ribbon.

b)

shortcut menus.

c)

Edit bar.

d)

keyboard shortcuts.

Question 11 (5 points)

Question 11 Unsaved

__________will adjust the width of a column to accommodate the content of the widest cell.

Question 11 options:

a)

Scaling

b)

AutoFit

c)

Merge & Fit

d)

Adjust

Question 12 (5 points)

Question 12 Unsaved

When the Header or Footer is a field, such as the file name, it displays with the ____________ symbol.

Question 12 options:

a)

#

b)

+

c)

^

d)

&

Question 13 (5 points)

Question 13 Unsaved

Use the _______________command to display the contents of a cell on multiple lines.

Question 13 options:

a)

Text Effects

b)

Wrap Text

c)

AutoFit

d)

Align

Question 14 (5 points)

Question 14 Unsaved

Text that is too long to fit in a cell will overflow into the cell on the right (if it is empty). If the cell to the right contains data, the text is truncated in the spreadsheet, however the entire value displays in the:

Question 14 options:

a)

Formula Bar.

b)

Formula Review Bar.

c)

adjacent cell.

d)

cell reference.

Question 15 (5 points)

Question 15 Unsaved

__________are symbols that specify a type of calculation.

Question 15 options:

a)

Cell references

b)

Calculators

c)

Arithmetic captions

d)

Arithmetic operators

Question 16 (5 points)

Question 16 Unsaved

In the ______________ group, the Wrap Text command can display the contents of a cell on multiple lines.

Question 16 options:

a)

Alignment

b)

Text Effects

c)

Format

d)

Page Setup

Question 17 (5 points)

Question 17 Unsaved

When creating a formula, you must use a(n) ___________ so that if the value in the cell changes Excel automatically re-calculates the spreadsheet.

Question 17 options:

a)

arithmetic operator

b)

calculator

c)

cell reference

d)

AutoFit command

Question 18 (5 points)

Question 18 Unsaved

Using the Backstage View, properties and tags can be added or modified and Excel files can be saved as _____________ files.

Question 18 options:

a)

Quicken

b)

Word

c)

PDF

d)

Access

Question 19 (5 points)

Question 19 Unsaved

The left side of the Status Bar displays all the following EXCEPT:

Question 19 options:

a)

page number.

b)

the current cell mean.

c)

the current cell mode.

d)

worksheet information.

Question 20 (5 points)

Question 20 Unsaved

When constructing a formula, the referenced cells display bordered in the same color. This feature is known as the ___________ and provides a visual cue showing the cells included in the formula.

Question 20 options:

a)

formula identifier

b)

range finder

c)

calculated range

d)

detail view

Once you get frustrated and struggling to accomplish your work on time, you need online assignment help. We understand your needs and provides you with reliable writing specialists to complete your projects at an affordable price.


Order a Similar Paper Order a Different Paper

Looking for this or a Similar Assignment? Order a Paper Now