Question 1 

(TCO 5) Excel's multiple worksheet abilities can do all of the following except

create pivot charts.

group worksheets together to enter data.

display worksheets side by side.

create links among the worksheets.

 

 

Question 2 

(TCO 5) In Excel, which of the following would you perform to group nonadjacent worksheets?

Click the first tab, hold Shift, and then click the last tab.

Click the first tab, hold Ctrl, and then click last tab.

Right-click a worksheet tab, and then select Select All Sheets.

Right-click a worksheet tab, and then select Group.

 

 

Question 3 

(TCO 5) If the active cell is in column A, but not in row 1, when you click the Split command, the worksheet will appear in two ________ panes.

horizontal

vertical

diagonal

square

 

 

Question 4 

(TCO 5) After saving the arrangement of windows, a workbook can be opened by opening the _____ file.

worksheet

workspace

workview

worklink

 

 

 

Question 5 

(TCO 5) If a worksheet name has a space in it, _____ surround the worksheet name in the worksheet reference.

double quotation marks

single quotation marks

parentheses

brackets

 

 

Question 6 

(TCO 5) Which formula would return the #NAME? error?

=SUM(B6.B12)

=MAX(B6:B12)

=AVG(B6:B12)

=IF(A6="Atlanta",A3,0)

 

 

Question 7 

(TCO 5) If A1 contains the hourly pay rate of $10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)?

A1

A2

A3

A1 & A2

 

 

Question 8 

(TCO 5) Information such as author, title, and keywords are examples of document _____.

properties

descriptions

identifiers

attributes

 

 

Question 9 

(TCO 5) To delete a comment from a cell, you _____.

double click the cell and select Delete Comment.

right-click the cell and select Delete Comment.

click in the comment and click Cut on the HOME tab.

click in the comment and press Delete.

 

 

Question 10 

(TCO 5) You would use the _____ command to indicate a workbook is complete and to make the file read only.

Lock workbook

Finalize workbook

Mark as Final

Mark as Completed

 

 

Question 11 

(TCO 5) Which Excel options category contains editing options?

General

Advanced

Formulas

Trust Center

 

 

Question 12 

(TCO 5) Which of the following is a limitation of sharing workbooks?

125 users can access at once

Workbooks that contain tables may not be shared.

Track changes is not supported.

The workbook cannot be printed.

 

 

Question 13 

(TCO 5) Which of the following changes will Excel not track?

Functions

Formulas

Deletion

Formatting

 

 

Question 14 

(TCO 5) In Excel, what displays properties the user can enter and change, such as title, subjet, author, manager, company, category, keywords, and comments?

Summary

General

Custom

Contents

 

 

Question 15 

(TCO 5) In Excel, what provides additional document details not provided in the property list?

Properties dialg box

Document Panel

Automatic property

Excel options

 

SmartExpert

(118)

Status NEW Posted 19 Nov 2017 10:11 AM My Price 8.00

BIS----------- 15-----------5 W-----------eek----------- 4 -----------Qui-----------z-----------

Attachments

file 1511106968-BIS 155 Week 4 Quiz.docx preview (387 words )

B-----------IS -----------155----------- We-----------ek -----------4 Q-----------uiz----------- Q-----------ues-----------tio-----------n 1----------- -----------(TC-----------O 5-----------) E-----------xce-----------l's----------- mu-----------lti-----------ple----------- wo-----------rks-----------hee-----------t a-----------bil-----------iti-----------es -----------can----------- do----------- al-----------l o-----------f t-----------he -----------fol-----------low-----------ing----------- ex-----------cep-----------t -----------cre-----------ate----------- pi-----------vot----------- ch-----------art-----------s. ----------- gr-----------oup----------- wo-----------rks-----------hee-----------ts -----------tog-----------eth-----------er -----------to -----------ent-----------er -----------dat-----------a. ----------- di-----------spl-----------ay -----------wor-----------ksh-----------eet-----------s s-----------ide----------- by----------- si-----------de.----------- c-----------rea-----------te -----------lin-----------ks -----------amo-----------ng -----------the----------- wo-----------rks-----------hee-----------ts.----------- Q-----------ues-----------tio-----------n 2----------- -----------(TC-----------O 5-----------) I-----------n E-----------xce-----------l, -----------whi-----------ch -----------of -----------the----------- fo-----------llo-----------win-----------g w-----------oul-----------d y-----------ou -----------per-----------for-----------m t-----------o g-----------rou-----------p n-----------ona-----------dja-----------cen-----------t w-----------ork-----------she-----------ets-----------? -----------Cli-----------ck -----------the----------- fi-----------rst----------- ta-----------b, -----------hol-----------d S-----------hif-----------t, -----------and----------- th-----------en -----------cli-----------ck -----------the----------- la-----------st -----------tab-----------. -----------Cli-----------ck -----------the----------- fi-----------rst-----------

Not Rated(0)

• Buy Answer