Chapter 5 Working with Multiple Worksheets and Workbooks. Exam Questions With Verified Answers
5 views 0 purchase
Course
Chapter 5
Institution
Chapter 5
Chapter 5 Working with Multiple
Worksheets and Workbooks. Exam
Questions With Verified Answers
Display the ___ tab to specify page setup options, such as setting the location of page breaks or
centering a printout horizontally and vertically. - answerPAGE LAYOUT
You can drill a ___ down throug...
Chapter 5 Working with Multiple
Worksheets and Workbooks. Exam
Questions With Verified Answers
Display the ___ tab to specify page setup options, such as setting the location of page breaks or
centering a printout horizontally and vertically. - answer✔PAGE LAYOUT
You can drill a ___ down through a workbook. (format, function, formula) - answer✔all of the
above
To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ___ key
and click the sheet tab at the other end of the list of adjacent sheet tabs. - answer✔SHIFT
1,2,3,4 etc. is an example of a ____ fill series? - answer✔linear
If you complete a paste operation using the ___ key, then the marquee disappears and the office
Clipboard no longer contains the copied data following the action. - answer✔ENTER
If you are summing numbers on noncontiguous sheets, hold down the ___ key when selecting the
sheets. - answer✔CTRL
A style affects the format of a cell or range of cells only if the corresponding check box is
selected in the ___ area in the style dialog box. - answer✔Style includes
Excel displays ___ on the worksheet to show the boundaries of each page. - answer✔dotted lines
A range that spans two or more worksheets in a workbook is called a(n) ___ range. - answer✔3-
D
Use the shortcut key ___ to copy the format of the source area but not the contents. -
answer✔CTRL+R
Use which of the following to sum all the values in column A? - answer✔=sum(a : a)
Use the shortcut key ___ to copy the format of the contents, format and styles of the source area.
- answer✔CTRL+K
which of the following is NOT a series type that you can create in Excel (Auto fill, Growth,
Date) - answer✔Nonlinear
By default, headers and footers ___. - answer✔are blank
A(n) ___ dollar sign always appears immediately to the left of the first significant digit in a cell.
- answer✔floating
A format code can have up to ___ sections. - answer✔four
The ___ defines the appearance and format of a printed worksheet. - answer✔page setup
A ___ appears at the top of every printed page. - answer✔header
Consolidating data from other workbooks can be referred to as ___. - answer✔linking
___ allow you to specify how cell entry assigned a format will appear. - answer✔Custom format
codes
A ___ reference is a formula that depends on its own value. - answer✔circular
The ___ style is the format style that Excel initially assigns to all cells in a workbook. -
answer✔Normal
A ___ appears at the bottom of every printed page. - answer✔footer
A(n) ___ is a group of format specifications that are assigned a style name. - answer✔style
Linked workbooks are called the ___ workbooks. - answer✔source
To copy the contents of a cell to the cell directly below it, tap or click in the target cell and press
___. - answer✔CTRL+D
A(n) ___ dollar sign always appears in the same position in a cell (regardless of the number of
significant digits). - answer✔fixed
Use the shortcut key ___ to copy the formulas from the source area but not the contents or
format. - answer✔CTRL+F
Excel limits the number of worksheets you can have in a workbook ___. - answer✔based on the
amount of memory in your computer
Which of the following functions will display the system date? - answer✔NOW()
You use the ___ to drag through cells to create a fill series - answer✔fill handle
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 Brainbarter. 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.
