Spreadsheet Applications in Business Exam Preparation Guide
Course Introduction
This course introduces students to the practical use of spreadsheets as powerful tools for business analysis and decision-making. Emphasizing the application of Microsoft Excel, students will learn to create, format, and manage spreadsheets, use formulas and functions, analyze data, generate charts and reports, and solve real-world business problems. Topics include data organization, financial modeling, what-if analysis, and basic automation with macros. By the end of the course, students will be proficient in leveraging spreadsheets to improve efficiency, accuracy, and insight in a variety of business contexts.
Recommended Textbook
Succeeding in Business with Microsoft Excel 2013 by Frank Akaiwa
Available Study Resources on Quizplus
10 Chapters
1500 Verified Questions
1500 Flashcards
Source URL: https://quizplus.com/study-set/709
2
Chapter 1: Applying Fundamental Excel Skills and Tools in Problem Solving
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13819
Sample Questions
Q1) SUM calculates the minimum value in a list of values.
A)True
B)False
Answer: False
Q2) Excel stores times as ____.
A) decimal fractions
B) whole numbers
C) mini clocks
D) all of the above
Answer: A
Q3) The default print format has ____________________ rather than formulas printed in the cells.
Answer: values
Q4) To use a "general" formula over and over again but with a different set of numbers, use a feature called absolute cell referencing. _________________________
A)True
B)False
Answer: False
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Solving Problems with Statistical Analysis Tools
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13820
Sample Questions
Q1) If you were to help Nevia, you would tell her that the space labeled #1 in the above figure ____.
A) indicates the cell containing the output value
B) indicates the desired output value
C) indicates the cell containing the data to vary in order to reach the desired output
D) none of the above
Answer: A
Q2) The ____ symbol(s) specify/specifies that text enclosed in between these marks should be inserted as shown.
A) ,
B) * C) ""
D) @
Answer: C
Q3) When the # symbol acts as a placeholder for a digit, it is considered to be a(n) ____________________ code.
Answer: number formatting
Q4) The relational operator >= stands for ____________________ than or equal to. Answer: greater
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Determining Effective Data Display with Charts
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13821
Sample Questions
Q1) #8
A)Data series
B)Chart title
C)Data table
D)X-axis labels
E)X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label
Answer: C
Q2) A(n) ____ chart combines the features of a line chart with a bar or column chart by filling in the area below the line.
A) area
B) stacked
C) contrast
D) radar
Answer: A
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Applying Logic in Decision Making
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13822
Sample Questions
Q1) Dun & Bradstreet's credit rating includes a classification ranging from ____ indicating the net worth category of the company.
A) 5A to HH
B) 1A to ZZ
C) 2B to 2Z
D) 1 to 100
Q2) The financial stress risk class is a rating from ____, indicating the risk of a company in financial distress, where 1 represents businesses with the lowest probability of risk.
A) 1 to 5
B) 1 to 4
C) 1 to 9
D) 1 to 99
Q3) The formula =OR(K3:K21) returns a TRUE value if any of the values in K3 through K21 contain the value TRUE.
A)True
B)False
Q4) Briefly describe each of the arguments in an IF function: IF(logical_test,value_if_true,value_if_false).
To view all questions and flashcards with answers, click on the resource link above.
6
Chapter 5: Retrieving Data for Computation, Analysis, and Reference
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13823
Sample Questions
Q1) With the INDEX function, if you are using a noncontiguous range, you must enclose the entire reference in ____.
A) quotation marks
B) brackets
C) parentheses
D) none of the above
Q2) When using the CHOOSE function, if the index_num argument is 2, the function returns ____.
A) the first value from the list
B) the second value from the list
C) an error message
D) the first value that equals "2"
Q3) row_num
A)#1
B)#2
C)#3
D)#4
E)#5
Q4) The function =____________________(index_num,value1,value2, ) can return up to 254 values.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Evaluating the Financial Impact of Loans and Investments
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13824
Sample Questions
Q1) The formula =PMT(0.03/12,12*3,15000,-2000) includes a ____.
A) balloon payment
B) depreciation factor
C) down payment
D) none of the above
Q2) The best chart to show a functional relationship, such as hurdle rate versus NPV, is ____.
A) an X plot
B) an XY Scatter
C) a Y plot
D) a pie chart
Q3) When cash is received, it is considered negative cash flow.
A)True
B)False
Q4) Range ____________________ must start with a letter, an underscore, or a backslash.
Q5) A(n) ____________________ payment is money required from the borrower toward the purchase of an asset.
Page 8
Q6) What is the correct syntax of the PMT function? Briefly describe each of the arguments associated with this function.
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 7: Organizing Data for Effective Analysis
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13825
Sample Questions
Q1) The ____ function calculates the number of years between two dates.
A) YEARBET
B) YEARTWEEN
C) YEARFRAC
D) YEARCALC
Q2) The ____ function returns the last character or characters in a text string, based on the number of characters specified.
A) LEFT
B) CHARACTER
C) RIGHT
D) NUMBER
Q3) The term ____________________ is commonly used in the XML community to describe an XML document that is properly structured, and meets established rules and guidelines for how data is described and defined using XML.
Q4) The ____ function converts uppercase letters in a text string to lowercase.
A) HIGHER
B) LOWER
C) UPPER
D) STRING
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Using Data Tables and Excel Scenarios for What
If Analysis
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13826
Sample Questions
Q1) You can use Custom number formats to display a label in a worksheet even when the cell contains a value or a formula.
A)True
B)False
Q2) Both one-variable data tables and two-variable data tables have ____________________ cells, which are the cells containing values that can vary.
Q3) A data table depends on values and formulas used in a worksheet, and must appear on the same worksheet that contains this data.
A)True
B)False
Q4) ____________________ results are those that are based on realistic but not actual data.
Q5) A defined name can be used outside its scope if it is ____, which means if its original scope is identified in its reference.
A) qualified
B) saved
C) archived
D) linked
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Enhancing Decision Making with Solver
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13827
Sample Questions
Q1) Creating a(n) ____ table in a worksheet organizes the constraints and makes them visible in the worksheet at any time, and without the limitation of having to open the Solver Parameters dialog box and scroll the constraints to view them.
A) constraints
B) data
C) input
D) results
Q2) You can use Solver to determine how to allocate ____, such as people, budgets, or inventories, in such a way as to achieve the greatest benefits.
A) resources
B) formulas
C) data
D) research
Q3) Click the Save Scenario button in the ____ dialog box to open the Save Scenario dialog box.
A) Solver Results
B) Solver Save
C) Solver Summary
D) Solver Scenario
To view all questions and flashcards with answers, click on the resource link above.
Page 12
Chapter 10: Troubleshooting Workbooks and Automating Excel Applications
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13828
Sample Questions
Q1) Which of the following is NOT one of the three tabs in the Data Validation dialog box?
A) Settings
B) Input Message
C) Error Alert
D) Audit
Q2) Which of the following is NOT one of the three available error alert styles for a cell?
A) Stop
B) Warning
C) Information
D) Help
Q3) Common formula errors include ____.
A) using mixed cell references in a formula
B) multiplying a cell's value by 0
C) using a defined name in a table
D) problems with order of precedence
Q4) You can obtain a(n) ____________________ from a commercial certification authority or, in some cases, from your system administrator.
Q5) A(n) ____________________ cell contains a formula that refers to other cells.
To view all questions and flashcards with answers, click on the resource link above. Page 13