Additional Information

Site Information

 Loading... Please wait...

K02 MS Office Applications I Exam 6&7 Answers (Ashworth)

$16.99

Product Description

Question 1 (2.5 points)

 

Saved

With Excel Online you store workbooks on OneDrive or:

Question 1 options:

a) 

Dropbox.

 

b) 

SkyDrive.

 

c) 

SharePoint.

 

d) 

Windows Live.

 

Question 2 (2.5 points)

 

Saved

Businesses create basic employee and resource __________with Excel that can be color-coded and designed to automatically update.

Question 2 options:

a) 

task lists

 

b) 

schedules

 

c) 

contact lists

 

d) 

productivity monitors

 

Question 3 (2.5 points)

 

Saved

The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers is a(n. ______________ format.

Question 3 options:

a) 

General

 

b) 

Number

 

c) 

Accounting Number

 

d) 

Underlying

 

Question 4 (2.5 points)

 

Saved

A(n. __________ is a collection of evidence, stored electronically, that showcases what you have accomplished while completing your education.

Question 4 options:

a) 

online folder

 

b) 

database

 

c) 

E-Folder

 

d) 

E-Portfolio

 

Question 5 (2.5 points)

 

Saved

The__________ is the cell outlined in black and ready to accept data.

Question 5 options:

a) 

cell reference

 

b) 

entry point

 

c) 

active cell

 

d) 

constant value

 

Question 6 (2.5 points)

 

Saved

An Excel ________ contains one or more pages known as a worksheet or spreadsheet.

Question 6 options:

a) 

workbook

 

b) 

folder

 

c) 

file

 

d) 

document

 

Question 7 (2.5 points)

 

Saved

Columns are labelled with letters beginning with A and ending with ________ (16,384 columns).

Question 7 options:

a) 

ZY

 

b) 

ZXA

 

c) 

XFD

 

d) 

XHA

 

Question 8 (2.5 points)

 

Saved

Text values are also referred to as:

Question 8 options:

a) 

formulas.

 

b) 

labels.

 

c) 

calculations.

 

d) 

constants.

 

Question 9 (2.5 points)

 

Saved

The cell address displays in the:

Question 9 options:

a) 

name box.

 

b) 

formula bar.

 

c) 

legend.

 

d) 

split box.

 

Question 10 (2.5 points)

 

Saved

With Excel Online you use ___________to create, view, and edit workbooks.

Question 10 options:

a) 

Dropbox

 

b) 

your web browser

 

c) 

SharePoint

 

d) 

OneDrive

 

Question 11 (2.5 points)

 

Saved

Excel 2016 is a tool to communicate ___________business information effectively.

Question 11 options:

a) 

quantitative

 

b) 

qualitative

 

c) 

strategic

 

d) 

managerial

 

Question 12 (2.5 points)

 

Saved

_____________ is a command associated with the currently selected or active object; often activated by right-clicking a screen item.

Question 12 options:

a) 

Show formulas

 

b) 

Point and click

 

c) 

Context sensitive

 

d) 

Display value

 

Question 13 (2.5 points)

 

Saved

With Excel Online you use your web browser to do all of the following except _____________ and workbooks.

Question 13 options:

a) 

create

 

b) 

edit

 

c) 

view

 

d) 

export

 

Question 14 (2.5 points)

 

Saved

When using Google Sheets, you can download your Google file in several formats, including PDF or:

Question 14 options:

a) 

Access.

 

b) 

Excel.

 

c) 

Word.

 

d) 

PowerPoint.

 

Question 15 (2.5 points)

 

Saved

Small businesses often use Excel as a basic accounting program or:

Question 15 options:

a) 

financial analysis tool.

 

b) 

checkbook ledger.

 

c) 

forecasting mechanism.

 

d) 

for tracking sales volume.

 

Question 16 (2.5 points)

 

Saved

In Excel, there are a maximum of ________ rows.

Question 16 options:

a) 

500 thousand

 

b) 

1 million

 

c) 

5 million

 

d) 

1 billion

 

Question 17 (2.5 points)

 

Saved

The intersection of a row and a column is referred to as a(n):

Question 17 options:

a) 

reference point

 

b) 

entry point

 

c) 

cell

 

d) 

cell address

 

Question 18 (2.5 points)

 

Saved

If you do not already have a Google account, you will need to create one before you can use Google Sheets. To do so, go to http://google.com and in the upper right corner, click:

Question 18 options:

a) 

Start.

 

b) 

Create Account.

 

c) 

Sign In.

 

d) 

New User.

 

Question 19 (2.5 points)

 

Saved

If the first character you type matches an existing entry, Excel attempts to fill in the remaining characters using:

Question 19 options:

a) 

SharePoint.

 

b) 

AutoFit.

 

c) 

AutoFill.

 

d) 

AutoComplete.

 

Question 20 (2.5 points)

 

Saved

When others edit the worksheet, Excel Online shows their presence and the updates right away. This only works when:

Question 20 options:

a) 

share folders have been set up.

 

b) 

everyone is working in Excel Online.

 

c) 

each Excel Online account is linked.

 

d) 

workbooks are saved to Excel Online.

 

Question 21 (2.5 points)

 

Saved

__________ that refers to cells by their fixed position in a worksheet.

Question 21 options:

a) 

Relative cell reference

 

b) 

Dynamic cell reference

 

c) 

Cell address

 

d) 

Absolute cell reference

 

Question 22 (2.5 points)

 

Saved

Both values and formulas can be copied using the fill handle. When a formula is copied, Excel copies the formula but adjusts the ____________ relative to the row number.

Question 22 options:

a) 

length

 

b) 

functions

 

c) 

values

 

d) 

cell references

 

Question 23 (2.5 points)

 

Saved

__________ is an element of the Excel window that displays the name of the selected cell, table, chart, or object.

Question 23 options:

a) 

Cell content

 

b) 

Graphic content

 

c) 

Formula Bar

 

d) 

Name Box

 

Question 24 (2.5 points)

 

Saved

A formula can be created by inserting a ____________ (a prewritten formula).

Question 24 options:

a) 

formula template

 

b) 

function

 

c) 

row calculation

 

d) 

cell configuration

 

Question 25 (2.5 points)

 

Saved

Values can be copied to adjacent cells, based on the first cell, by using the:

Question 25 options:

a) 

fill handle.

 

b) 

formula bar.

 

c) 

function bar.

 

d) 

value box.

 

Question 26 (2.5 points)

 

Saved

A tiny chart in the background of a cell that gives a visual trend summary alongside your data and makes a pattern more obvious is a/an:

Question 26 options:

a) 

Legend.

 

b) 

Data field.

 

c) 

Axis.

 

d) 

Sparkline.

 

Question 27 (2.5 points)

 

Saved

Each function has a name and a set of arguments that are placed within parentheses after the function name. Which of the following is NOT a function name/ set of arguments?

Question 27 options:

a) 

Formulas

 

b) 

Calculations

 

c) 

Values

 

d) 

Cell references

 

Question 28 (2.5 points)

 

Saved

__________ is an Excel feature that generates and extends values into adjacent cells based on the values of selected cells.

Question 28 options:

a) 

AutoFit

 

b) 

AutoSum

 

c) 

Auto Fill

 

d) 

AutoMap

 

Question 29 (2.5 points)

 

Saved

__________ is an equation that performs mathematical calculations on values in a worksheet.

Question 29 options:

a) 

Formula

 

b) 

AutoSum

 

c) 

Operator

 

d) 

AutoFill

 

Question 30 (2.5 points)

 

Saved

__________ is a defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Question 30 options:

a) 

Cell address

 

b) 

Cell style

 

c) 

Cell reference

 

d) 

Cell content

 

Question 31 (2.5 points)

 

Saved

The chart __________ is a combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells.

Question 31 options:

a) 

type

 

b) 

layout

 

c) 

filters

 

d) 

theme

 

Question 32 (2.5 points)

 

Saved

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:

Question 32 options:

a) 

pixels.

 

b) 

operators.

 

c) 

data points.

 

d) 

option tags.

 

Question 33 (2.5 points)

 

Saved

__________ displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas.

Question 33 options:

a) 

Insert Options button

 

b) 

AutoComplete

 

c) 

Quick Analysis Tool

 

d) 

Data Analysis Tool

 

Question 34 (2.5 points)

 

Saved

Dragging a column to the right increases the:

Question 34 options:

a) 

length.

 

b) 

width.

 

c) 

number of rows.

 

d) 

cell size.

 

Question 35 (2.5 points)

 

Saved

The default format that Excel applies to numbers is the ____________ format.

Question 35 options:

a) 

comma

 

b) 

calculating

 

c) 

accounting

 

d) 

general

 

Question 36 (2.5 points)

 

Saved

On startup, Excel displays a new blank:

Question 36 options:

a) 

document.

 

b) 

workbook.

 

c) 

worksheet.

 

d) 

grid.

 

Question 37 (2.5 points)

 

Saved

The type of cell reference that refers to cells by their fixed position in a worksheet is:

Question 37 options:

a) 

absolute.

 

b) 

relative.

 

c) 

exponentiation.

 

d) 

central.

 

Question 38 (2.5 points)

 

Saved

A ___________ is a picture element (a point of light measured in dots per inch).

Question 38 options:

a) 

pixel

 

b) 

operator

 

c) 

label

 

d) 

option tag

 

Question 39 (2.5 points)

 

Saved

The value that displays in the ___________ is the displayed value.

Question 39 options:

a) 

Formula Bar

 

b) 

Function Bar

 

c) 

row calculation

 

d) 

cell

 

Question 40 (2.5 points)

 

Saved

The area along the bottom of a chart that identifies the categories of data is the:

Question 40 options:

a) 

data point.

 

b) 

value point.

 

c) 

value axis.

 

d) 

category axis

Find Similar Products by Category

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