• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 4 pages
Exam (elaborations)

Spreadsheet Modelling Final Exam

Document preview thumbnail
Preview 1 out of 4 pages

SPREADSHEET MODELLING FINAL EXAM

Content preview

SPREADSHEET MODELLING FINAL EXAM LATEST 2024 ACTUAL
EXAM
The Formula Bar displays the value or formula in the active cell (T/F) - ANSWER: True

What is the name of box that displays the selected cell? - ANSWER: The Name Box

When you type data in a cell and press Tab, what cell becomes the active cell? -
ANSWER: The cell to the right

What is the name of small square that enables you to auto full data or formula> -
ANSWER: Fill Handle

Hold down the ________ key to select nonadjacent cells. - ANSWER: Ctrl

Tiny charts embedded in a cell that give a visual trend summary alongside your data
are: - ANSWER: sparklines

There are commands to change style such as the Total or Heading 1 style in the
_____ - ANSWER: Cell Styles Gallery

When you click a chart, you will see two additional tabs (_____ and _____) for
working with the chart - ANSWER: Design tab and format tab

Which symbol represents that a cell is an absolute cell reference in a function or
formula? - ANSWER: $

_____ is the keyboard shortcut to the last cell in the last column of the active area -
ANSWER: Ctrl + End

You can sort a table in ascending and descending order (T/F) - ANSWER: True

When you select a single sheet that is a part of a group, the grouping of the sheets is
canceled (T/F) - ANSWER: True

Which of the following Excel features recognizes a pattern in the data of a
worksheet? - ANSWER: Flashfill

The COUNTIF function has two arguments ______ - ANSWER: The range of cells to
check and the criteria

Deleting the ____ of a cell deletes the value or formula but does not clear formatting
of that cell - ANSWER: contents

Connected book
 image
Cliff T. Ragsdale, Cliff T. Ragsdale Spreadsheet Modeling
Publisher: Unknown ISBN: 9781305947412 Edition: 1

Document information

Uploaded on
September 21, 2024
Number of pages
4
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
CA$27.23

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
maxmaxwellmm254
4.9
(135)
Sold
9
Followers
1
Items
839
Last sold
1 year ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions