Exam (elaborations)
SIMNet Final Exam - Excel With 100 Questions and Answers
- Course
- Institution
SIMNet Final Exam - Excel With 100 Questions and Answers...
[Show more]
Content preview
SIMNet Final Exam - Excel With 100 Questions andAnswers
DIV/0 is an example of a worksheet _______ that can display in a cell. - ANSWER
Error
If you move a named cell, the name updates with the new cell location
automatically. - ANSWER True
When you type text in a cell, the text will appear to continue to the __________ as
far as it can until there is another cell that contains data. - ANSWER Right
To make changes to grouped sheets, just make the change in one sheet and this
same change will be made to the same cell in all sheets in the group. - ANSWER
True
The Decrease Decimal button permanently deletes decimal places from the
number entered into the cell. - ANSWER False
Excel includes a special group of functions to modify text. - ANSWER True
When you change a name, Excel automatically updates the name in any formula
that references that name. - ANSWER True
To move or copy more than one non-consecutive worksheet, press _______ on the
keyboard and click the worksheets you want to copy or move. - ANSWER Ctrl
The VLOOKUP function finds a value or cell reference in a cell range and returns
another value from the same row. - ANSWER True
A _______ is a special report view that summarizes data and calculates the
intersecting totals. - ANSWER PivotTable
If you want more of your worksheet columns to fit on a printed page, change the
orientation to Portrait. - ANSWER False
The Format Painter is located on the Home tab in the _______ group. - ANSWER
Clipboard
To remove the contents of a cell without removing the cell from the worksheet,
use one of the Clear commands. - ANSWER True
, A _______ is text that appears at the top of every page. - ANSWER header
When you enter a formula with more than one mathematical operation, the
formula is not necessarily calculated left to right as Excel calculations follow the
mathematical rules called the ___________________________. - ANSWER Order of
operations
Excel''s _______ function lets you enter a desired value (outcome) for a formula and
specify an input cell that can be modified in order to reach that goal. - ANSWER
Goal Seek
If you select an entire column and then click the Insert button, Excel will
automatically insert a _______. - ANSWER Column
A two-variable data table works the same way as a one-variable data table, using
inputs for both a column and a row variable. - ANSWER True
A(n) __________ reference is a cell reference that adjusts to the new location in the
worksheet when the formula is copied. - ANSWER Relative
You can arrange workbooks to view several at the same time. - ANSWER True
The Fill Handle tool is located at top left of the selected cell. - ANSWER False
To add emphasis to a pie chart slice, you can "explode" a single slice by clicking it
and dragging it away from the rest of the slices. - ANSWER True
When a filter has been applied to a column, the column header will display an
arrow. - ANSWER False
For the Subtotal command to work properly, you must sort the rows into order by
the first column. - ANSWER False
To define more than one print area, you need to hold down the _______ key after
selecting the first print area and drag across the cells to include in the second
print area. - ANSWER Ctrl
Names assigned to cells act as a list of _______ to the cell locations. - ANSWER
Shortcuts
One of the most useful financial functions in Excel is the _______ function, which
you can use to calculate loan payments. - ANSWER PMT
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 luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
83822 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now