Exam (elaborations)
COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM
- Course
- Institution
- Book
COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM
[Show more]
Connected book
Book Title:
Author(s):
- Edition:
- ISBN:
- Edition:
More summaries for
-
COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM
Seller
Follow
maxmaxwellmm254
Content preview
COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAMLATEST 2024 ACTUAL EXAM
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
A date might be displayed as a series of ___ if the date, as initially formatted by
Excel, does not fit in the width of the cell. - ANSWER: number signs
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 maxmaxwellmm254. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
82215 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now