Exam (elaborations)

Exam (elaborations) BIS 155 (BIS155)/BIS 155 Week 1 Quiz QUESTIONS AND ANSWERS STUDY GUIDE

0 purchase

Course
BIS 155 (BIS155)

Institution
Devry University-Chicago

Question 1.1. (TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2) a range of cells containing results based upon manipulation of the variables in the input area displays the name of a worksheet within a workbook a range of cells containing values for variables...

[Show more]

Preview 2 out of 8 pages

View example

Uploaded on February 14, 2022
Number of pages 8
Written in 2021/2022
Type Exam (elaborations)
Contains Questions & answers

bis 155
bis 155 week 1 quiz
week 1
in excel 2010
an output area as it applies to excel 2010 is defined as
a cell is best described by which of the following points 2 must have formulas entered

Institution
Devry University-Chicago
Course
BIS 155 (BIS155)

Rubricguru

Member since 4 year 1070 documents sold

$10.49

Add to cart

Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

Page 1

Question 1.1. (TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2)
a range of cells containing results based upon manipulation of the variables in the input area

displays the name of a worksheet within a workbook

a range of cells containing values for variables used in formulas

displays the content of the active cell

Question 2.2. (TCO 1) In Excel 2010, a cell is best described by which of the following? (Points : 2)
Must have formulas entered into it

Cannot be used for labels or headings

Must have text entered into it

Is the intersection of a column and a row

Question 3.3. (TCO 1) Which of the following best describes the AutoComplete function? (Points : 2)
Adds all the numbers in the row automatically

Searches for and displays any other similar label in the current column as you begin to type

Adds all the numbers in the columns automatically

Is a number that represents a quantity and can be the basis of calculations

Question 4.4. (TCO 1) Why would you use cell references in formulas instead of constant
values? (Points : 2)
You can easily include letters, numbers, and spaces

It is easier to debug the errors

You can change the input values without changing the formulas

You can control the sequence in which Excel performs arithmetic operations

This study source was downloaded by 100000829216747 from CourseHero.com on 02-14-2022 01:36:02 GMT -06:00

https://www.coursehero.com/file/13923380/BIS-155-Week-1-Quiz/

, Question 5.5. (TCO 1) The fill handle in Excel 2010 _______. (Points : 2)

is the fastest way to type A1 in the name box
helps carry over the fill to the remaining slides
is the same action as pressing "Enter"
is a small black square at the bottom-right corner of a cell that facilitates fill operations

Question 5.5. (TCO 1) Which of the following best describes the result of using the fill handle on a cell
containing a formula? (Points : 2)
Cannot complete a sequence of dates in a column

Changes the background color of the selected cells to yellow

Copies the formula in the active cell to other cells and adapts it based upon the type of cell

references in the original formula
Has two or more sub-commands related to the command

Question 6.6. (TCO 1) In Excel 2010, a column width ________. (Points : 2)
is adjustable so you can display more or less characters in a column
is not adjustable so keep the formulas as short as possible
always switches back to default
is best left unchanged unless you absolutely have to

Question 6.6. (TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)
a shortcut to cell A1

there are two or more sub-commands related to the command

the next step in the process

directionality

Question 7.7. Which of the following best describes a "Range" in Excel 2010? (Points : 2)
Cannot be selected with the mouse
Are the numbers that fall between the smallest and largest in the formula
Is another word for the active worksheet
Refers to a group of adjacent or contiguous cells

Question 7.7. (TCO 1) If you had worksheets that contained the inventory of each room in your house,
with a separate sheet for each room, all the sheets together would be a: (Points : 2)
workbook.

ledger.

document.

This study source was downloaded by 100000829216747 from CourseHero.com on 02-14-2022 01:36:02 GMT -06:00

https://www.coursehero.com/file/13923380/BIS-155-Week-1-Quiz/

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Rubricguru. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $10.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling