Exam (elaborations)

SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM 200 QUESTIONS AND CORRECT DETAILED ANSWERS |ALREADY GRADED A+

0 purchase

Course
SPREADSHEET MODELLING

Institution
SPREADSHEET MODELLING

SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM 200 QUESTIONS AND CORRECT DETAILED ANSWERS |ALREADY GRADED A+ SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM 200 QUESTIONS AND CORRECT DETAILED ANSWERS |ALREADY GRADED A+ SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM 200 QUESTIONS AND CORRECT DE...

[Show more]

Preview 4 out of 39 pages

View example

Uploaded on December 29, 2023
Number of pages 39
Written in 2023/2024
Type Exam (elaborations)
Contains Questions & answers

spreadsheet
modelling
spreadsheet modelling
spreadsheet modelling final exam actual exam 200
modelling final exam actual exam 200
final exam actual exam 200

erickarimi

Member since 1 year 123 documents sold

221

$24.49

Add to cart

Add to wishlist

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

SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+

when you click a chart, you will see two additional tabs (____ and ___)
for working with the chart
a. layout tab and formula tab
b. view tab and design tab
c. design tab and format tab
d. formulas tab and format tab - ANSWER--c. design tab and format tab

tiny charts embedded in a cell that display a visual trend summary
alongside your data are called ___.
a. data markers
b. data labels
c. sparklines
d. data series - ANSWER--c. sparklines

T/F: the formula bar displays the value or formula in the active cell. -
ANSWER--true

the ___ function counts the number of cells within a range that meet the
criteria entered.
a. sum
b. if

,SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
c. countif
d. median - ANSWER--c. countif

T/F: when a new column is inserted into a worksheet, the remaining
columns move to the right. - ANSWER--true

the countif function has two arguments ___.
a. a value as the criteria and an average of a range of cells
b. the range of cells to sum and the criteria
c. the range of cells to check and the criteria
d. the range of cells to check and the sum of the range - ANSWER--c.
the range of cells to check and the criteria

where do sheet tabs display in a workbook?
a. under the ribbon
b. lower area of the workbook window
c. on the status bar
d. on the right side of the workbook window - ANSWER--b. lower area
of the workbook window

the median function finds ___.
a. the average value in a range of cells

, SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
b. the one number that corresponds to an argument in the function
c. all numbers that correspond to an argument in the function
d. the middle value in a range of cells - ANSWER--d. the middle value
in a range of cells

which of the following excel features recognizes a pattern in the data of
a worksheet?
a. if function
b. countif function
c. find and replace
d. flash fill - ANSWER--d. flash fill

in a conditional format, we use ___ to represent the value of a cell
relative to other cells
a. excel table
b. data bar
c. filter
d. sparkline - ANSWER--b. data bar

we can group multiple worksheets by right-clicking on the sheet tab, and
then click ___ on the shortcut menu.
a. tab color

, SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
b. select all sheets
c. grouping
d. protect sheet - ANSWER--b. select all sheets

T/F: you can sort a table in ascending or descending order. - ANSWER--
true

what are the default names of worksheets?
a. sheet1, sheet2, etc.
b. worksheet1, worksheet2, etc.
c. 1, 2, 3, etc.
d. excel 1, excel 2, etc - ANSWER--a. sheet1, sheet2, etc.

if you edit data in a worksheet that is associated with a pie chart, ___.
a. the pie slices will be automatically updated
b. the pie slices must be manually updated
c. a new second pie chart must be created
d. an error message will display - ANSWER--a. the pie slices will be
automatically updated

which symbol represents that a cell is an absolute cell reference in a
function or formula?

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 erickarimi. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $24.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

Exam (elaborations)

SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM 200 QUESTIONS AND CORRECT DETAILED ANSWERS |ALREADY GRADED A+

Document information

Subjects

Written for

Seller

Reviews received

Content preview