Additional Information

Site Information

 Loading... Please wait...

K02 MS Office Applications I Exam 8 Answers (Ashworth)

$9.99

Product Description

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

Question 1 options:

a) 

the Ribbon.

 

b) 

shortcut menus.

 

c) 

Edit bar.

 

d) 

keyboard shortcuts.

 

Question 2 (5 points)

 

Saved

Which of the following is NOT a symbol for an arithmetic operator?

Question 2 options:

a) 

+

 

b) 

-

 

c) 

#

 

d) 

*

 

Question 3 (5 points)

 

Saved

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

Question 3 options:

a) 

page number.

 

b) 

the current cell mean.

 

c) 

the current cell mode.

 

d) 

worksheet information.

 

Question 4 (5 points)

 

Saved

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

Question 4 options:

a) 

Text Effects

 

b) 

Wrap Text

 

c) 

AutoFit

 

d) 

Align

 

Question 5 (5 points)

 

Saved

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

Question 5 options:

a) 

a column

 

b) 

a row

 

c) 

a range of cells

 

d) 

the typed data

 

Question 6 (5 points)

 

Saved

Placing the insertion point to the left of the cell reference, in the Formula Bar, and pressing _________ inserts dollar signs ($) in the cell reference, changing it to an absolute cell reference.

Question 6 options:

a) 

F1

 

b) 

F2

 

c) 

F3

 

d) 

F4

 

Question 7 (5 points)

 

Saved

___________ indicates numbers, text, dates, or times of day that you type into a cell.

Question 7 options:

a) 

Data marker

 

b) 

Data series

 

c) 

Constant value

 

d) 

Displayed value

 

Question 8 (5 points)

 

Saved

Text and numbers can be edited directly in the cell or in the ____________ Bar.

Question 8 options:

a) 

Status

 

b) 

Review

 

c) 

Formula

 

d) 

Formula Review

 

Question 9 (5 points)

 

Saved

The __________check box centers a worksheet horizontally on a page.

Question 9 options:

a) 

Format

 

b) 

Align

 

c) 

Center on page

 

d) 

AutoFit

 

Question 10 (5 points)

 

Saved

AutoCalculate is a feature of Excel that displays three calculations in the status bar when a range of numerical cell entries are selected. These include all the following EXCEPT:

Question 10 options:

a) 

count.

 

b) 

sum.

 

c) 

average.

 

d) 

multiply.

 

Question 11 (5 points)

 

Saved

____________ 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 11 options:

a) 

AutoFit

 

b) 

AutoComplete

 

c) 

AutoFill

 

d) 

AutoCalculate

 

Question 12 (5 points)

 

Saved

Using___________, you can calculate the percentage by which a part makes up a total-with the percentage formatted as a decimal.

Question 12 options:

a) 

AutoCalculate

 

b) 

%calculate

 

c) 

the equation segment/total = percentage

 

d) 

the equation amount/total = percentage

 

Question 13 (5 points)

 

Saved

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

Question 13 options:

a) 

Alignment

 

b) 

Text Effects

 

c) 

Format

 

d) 

Page Setup

 

Question 14 (5 points)

 

Saved

__________refers to the process of specifying the appearance of cells and the overall layout of your worksheet.

Question 14 options:

a) 

Text effects

 

b) 

Page setup

 

c) 

Formatting

 

d) 

Artistic editing

 

Question 15 (5 points)

 

Saved

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 15 options:

a) 

Formula Bar.

 

b) 

Formula Review Bar.

 

c) 

adjacent cell.

 

d) 

cell reference.

 

Question 16 (5 points)

 

Saved

__________are symbols that specify a type of calculation.

Question 16 options:

a) 

Cell references

 

b) 

Calculators

 

c) 

Arithmetic captions

 

d) 

Arithmetic operators

 

Question 17 (5 points)

 

Saved

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

Question 17 options:

a) 

on the Print tab

 

b) 

in Backstage view.

 

c) 

in Print Preview.

 

d) 

in Settings.

 

Question 18 (5 points)

 

Saved

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

Question 18 options:

a) 

Scaling

 

b) 

AutoFit

 

c) 

Merge & Fit

 

d) 

Adjust

 

Question 19 (5 points)

 

Saved

A relative cell reference automatically adjusts when the formula is copied but for those times when you want the cell reference to remain the same, you must use a(n) ___________ cell reference.

Question 19 options:

a) 

absolute

 

b) 

static

 

c) 

stationary

 

d) 

locked

 

Question 20 (5 points)

 

Saved

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

Question 20 options:

a) 

format

 

b) 

alignment

 

c) 

text effects

 

d) 

page setup

Find Similar Products by Category

Click the button below to add the K02 MS Office Applications I Exam 8 Answers (Ashworth) to your wish list.