SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM 200 QUESTIONS AND CORRECT DETAILED ANSWERS |ALREADY GRADED A+
8 views 0 purchase
Module
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...
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 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 £19.87. You're not tied to anything after your purchase.
