Introduction to Business Computing Practice
Questions
Course Introduction
Introduction to Business Computing provides students with a foundational understanding of how computers and information technology are used in modern business environments. The course covers essential topics such as computer hardware, software applications, networking, the internet, data management, and cybersecurity. Emphasis is placed on practical skills in office productivity tools like word processing, spreadsheets, and presentations, as well as exploring the role of information systems in decision-making and business operations. Through hands-on exercises and real-world examples, students gain the knowledge needed to effectively use computing resources to solve business problems and improve organizational efficiency.
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 Page 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) The ### signs indicate that the column width is insufficient to display the complete value in the cell.
A)True
B)False
Answer: True
Q2) To use a "general" formula over and over again but with a different set of numbers, use a feature called Rotating Values.
A)True
B)False
Answer: False
Q3) The Excel operator for exponent is ____.
A) *
B) / C) ^
D) & Answer: C
Q4) The Excel operator used for multiplication is ____________________.
Answer: * asterisk
To view all questions and flashcards with answers, click on the resource link above. Page 3
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) The simplest method to copy information is to first select the information you want to copy, and then use the Copy button and the Paste button in the Clipboard group on the ____ tab.
A) FORMAT
B) HOME
C) INSERT
D) DATA
Answer: B
Q2) In the LARGE function, the second argument, k, is the desired ranking, where 1 is
A) the largest value
B) the smallest value
C) required
D) not allowed
Answer: A
Q3) Relational operators are used to compare data.
A)True
B)False
Answer: True
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) Use a pie chart when it's most important to show relative percentages rather than values.
A)True
B)False
Answer: True
Q2) In a ____ chart, values are indicated by the height of the lines.
A) column
B) line
C) pie
D) radar
Answer: B
Q3) The ____________________ dialog box, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.
Answer: Select Data Source
Q4) In a line chart, values are indicated by the filled areas below the lines.
A)True
B)False
Answer: False
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) The NOT function takes only one argument and essentially changes a single TRUE value to FALSE, or a single FALSE value to TRUE.
A)True
B)False
Q2) With conditional formatting, if both types of formatting cannot be applied to the cell simultaneously, the rule that appears first in the rules list overrides other rules for that specific cell. ____________________
A)True
B)False
Q3) By nesting levels of ____ functions, multiple sets of criteria can be sequentially analyzed until a final value is returned.
A) IF
B) AND C) OR D) NOT
Q4) The Dun & Bradstreet financial ____________________ risk class is a rating from 1 to 5 indicating the risk of a company in financial distress.
Q5) logical_test is the ____________________ argument of the IF function.
To view all questions and flashcards with answers, click on the resource link above. Page 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) The Lookup function argument called lookup_vector is the location of the data you want to look up. _________________________
A)True
B)False
Q2) The IS function where the value refers to a reference is ____________________.
Q3) Mark writes a formula to look up the unit pricing for each order. He starts by writing one for Order #1 and then plans to copy it from E12 to E13:E16. The correct formula would be ____.
A) =VLOOKUP(D12,A$7:B$8,3,TRUE)
B) =VLOOKUP(D12,A$7:B$8,2,TRUE)
C) =VLOOKUP(D12,A$7:B$8,0,TRUE)
D) =VLOOKUP(D12,A$7:B$8,1,TRUE)
Q4) In an INDEX function, the argument ____ refers to the column in the range referenced in the first argument.
A) reference
B) row_num
C) column_num
D) area_num
To view all questions and flashcards with answers, click on the resource link above. Page 7
Q5) The INDEX function allows you to retrieve data from ____________________ tables.
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 NPV function in Excel takes the cash flow from year 0, which is referred to as value0, and discounts the value by one year. _________________________
A)True
B)False
Q2) The ____ of a loan is NOT directly tax deductible.
A) principal payment
B) interest
C) both a and b
D) neither a nor b
Q3) =CIPMT(rate,nper,pv,start_period,end_period,type) returns the cumulative interest paid on a loan between start_period and end_period.
A)True
B)False
Q4) When cash is paid out, it is considered to be ____.
A) positive cash flow
B) negative cash flow
C) out money
D) bad cash
8
Q5) The ____________________ argument is a list of
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) Excel includes several external data sources saved as database files that you can use to import data into Excel.
A)True
B)False
Q2) The TRIM function removes all spaces in a text string except for the single spaces between words.
A)True
B)False
Q3) In the FIND function, ____ is the text that you want to find.
A) find_text
B) find_words
C) text_find
D) words_find
Q4) The first goal when working with unstructured data is to determine the ____ you need so you can find the best way to change the unstructured data into structured data.
A) format
B) size of the file
C) color coding
D) reports
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) Although Excel does not consider case when evaluating cell names, the use of case differences in cell names can make them ____.
A) easier to read
B) easier to interpret
C) both a and b
D) neither a nor b
Q2) To specify which input cell in the worksheet relates to the values in the data table, open the ____ dialog box.
A) Data Table
B) Input Cell
C) Worksheet
D) What-if
Q3) Beckham's boss has asked him to be more precise about how many units the company will need to sell to break even. What can Beckham do to get this information?
A) Create a larger data table with smaller increments in specifying units sold.
B) Create a larger data table with larger increments in specifying units sold.
C) Change the input variable to sales revenue.
D) Change the input variable to income.
Q4) The Scenario Manager refers to output cells as ____________________ cells.
Page 11
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) 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
Q2) When you plot a linear function in a chart, the result is a ____.
A) straight line
B) curved line
C) bar
D) circle
Q3) You must answer four questions before using optimization to solve a problem. They do NOT include ____.
A) How many resources are there and how many are needed?
B) How many resources does each decision variable consume?
C) How much does each decision variable contribute to the objective?
D) How much does each decision variable cost?
Q4) In the field of management science, the method you use to narrow the available options for a problem so you can choose the best potential outcome is an analytical process known as ____________________.
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) You access the data validation tool by clicking the DATA tab on the ribbon, and then clicking Data Validation in the ____ group to open the Data Validation dialog box.
A) Data Tools
B) Data
C) View
D) Formulas
Q2) To achieve a gross profit, an item's COGS should always be less than the sales price.
A)True
B)False
Q3) You can obtain a(n) ____________________ from a commercial certification authority or, in some cases, from your system administrator.
Q4) ____ data is input data for which you already know the results.
A) Test
B) Complex
C) Scenario
D) Break-even
Q5) A(n) ____________________ cell contains a formula that refers to other cells.
Page 13
Q6) ____________________ is input data for which you already know the results.
To view all questions and flashcards with answers, click on the resource link above.