[06] Lessons 6 7 Exam

by | Aug 22, 2024 | Uncategorized | 0 comments

Question Description

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

a)

Start.

b)

Create Account.

c)

Sign In.

d)

New User.

Question 2 (2.5 points)

Question 2 Unsaved

You can insert ___________in an Excel worksheet to give a visual trend summary alongside your data.

Question 2 options:

a)

sparklines

b)

legends

c)

axes

d)

data points

Question 3 (2.5 points)

Question 3 Unsaved

_______________ is a charting command to swap the data over the axis-data being charted on the vertical axis will move to the horizontal axis and vice versa.

Question 3 options:

a)

Move data

b)

Realign Row/Column

c)

Switch Row/Column

d)

Reconfigure Row/Column

Question 4 (2.5 points)

Question 4 Unsaved

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

Question 4 options:

a)

financial analysis tool.

b)

checkbook ledger.

c)

forecasting mechanism.

d)

for tracking sales volume.

Question 5 (2.5 points)

Question 5 Unsaved

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

Question 5 options:

a)

Show formulas

b)

Point and click

c)

Context sensitive

d)

Display value

Question 6 (2.5 points)

Question 6 Unsaved

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

Question 6 options:

a)

reference point

b)

entry point

c)

cell

d)

cell address

Question 7 (2.5 points)

Question 7 Unsaved

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

Question 7 options:

a)

SharePoint.

b)

AutoFit.

c)

AutoFill.

d)

AutoComplete.

Question 8 (2.5 points)

Question 8 Unsaved

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

Question 8 options:

a)

workbook

b)

folder

c)

file

d)

document

Question 9 (2.5 points)

Question 9 Unsaved

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

Question 9 options:

a)

Dropbox

b)

your web browser

c)

SharePoint

d)

OneDrive

Question 10 (2.5 points)

Question 10 Unsaved

A specific way in which Excel displays numbers in a cell is a(n. ___________ format.

Question 10 options:

a)

General

b)

Number

c)

Accounting Number

d)

Underlying

Question 11 (2.5 points)

Question 11 Unsaved

Tracking total business sales in dollars along with total advertising and marketing expenditures with Excel allows you to see your __________ for each campaign.

Question 11 options:

a)

Return on Equity

b)

Return on Investment

c)

Cost of Capital

d)

Sales volume

Question 12 (2.5 points)

Question 12 Unsaved

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

Question 12 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 13 (2.5 points)

Question 13 Unsaved

Excel 2016 is a tool to communicate ___________business information effectively.

Question 13 options:

a)

quantitative

b)

qualitative

c)

strategic

d)

managerial

Question 14 (2.5 points)

Question 14 Unsaved

Text values are also referred to as:

Question 14 options:

a)

formulas.

b)

labels.

c)

calculations.

d)

constants.

Question 15 (2.5 points)

Question 15 Unsaved

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

Question 15 options:

a)

Access.

b)

Excel.

c)

Word.

d)

PowerPoint.

Question 16 (2.5 points)

Question 16 Unsaved

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

Question 16 options:

a)

task lists

b)

schedules

c)

contact lists

d)

productivity monitors

Question 17 (2.5 points)

Question 17 Unsaved

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

a)

General

b)

Number

c)

Accounting Number

d)

Underlying

Question 18 (2.5 points)

Question 18 Unsaved

The cell address displays in the:

Question 18 options:

a)

name box.

b)

formula bar.

c)

legend.

d)

split box.

Question 19 (2.5 points)

Question 19 Unsaved

An Excel ________ contains horizontal rows and vertical columns.

Question 19 options:

a)

workbook

b)

folder

c)

file

d)

spreadsheet

Question 20 (2.5 points)

Question 20 Unsaved

__________is a feature in Excel that works with alphabetic values.

Question 20 options:

a)

AutoComplete

b)

SharePoint

c)

AutoFit

d)

AutoFill

Question 21 (2.5 points)

Question 21 Unsaved

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

a)

length

b)

functions

c)

values

d)

cell references

Question 22 (2.5 points)

Question 22 Unsaved

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

Question 22 options:

a)

absolute.

b)

relative.

c)

exponentiation.

d)

central.

Question 23 (2.5 points)

Question 23 Unsaved

An element in the Excel window that displays the value or formula contained in the active cell is the:

Question 23 options:

a)

name box.

b)

status bar.

c)

formula bar.

d)

value box.

Question 24 (2.5 points)

Question 24 Unsaved

When a value is typed into a cell it also displays on the:

Question 24 options:

a)

fill handle.

b)

formula bar.

c)

function bar.

d)

value box.

Question 25 (2.5 points)

Question 25 Unsaved

__________ 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 25 options:

a)

Insert Options button

b)

AutoComplete

c)

Quick Analysis Tool

d)

Data Analysis Tool

Question 26 (2.5 points)

Question 26 Unsaved

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

Question 26 options:

a)

comma

b)

calculating

c)

accounting

d)

general

Question 27 (2.5 points)

Question 27 Unsaved

On startup, Excel displays a new blank:

Question 27 options:

a)

document.

b)

workbook.

c)

worksheet.

d)

grid.

Question 28 (2.5 points)

Question 28 Unsaved

A __________ is two or more cells that are adjacent (next to each other) or non-adjacent (not next to each other).

Question 28 options:

a)

column

b)

width

c)

range

d)

cell cluster

Question 29 (2.5 points)

Question 29 Unsaved

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

Question 30 Unsaved

The data that displays in the Formula Bar is referred to as the:

Question 30 options:

a)

constant value.

b)

underlying value.

c)

formula.

d)

calculated value.

Question 31 (2.5 points)

Question 31 Unsaved

Dragging a column to the right increases the:

Question 31 options:

a)

length.

b)

width.

c)

number of rows.

d)

cell size.

Question 32 (2.5 points)

Question 32 Unsaved

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.

<

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."

Order Solution Now

Submit a Comment

Your email address will not be published. Required fields are marked *