Computer Skills for Business Practice Questions
Course Introduction
Computer Skills for Business is designed to equip students with essential technological competencies required in todays business environment. The course introduces the use of productivity software such as word processors, spreadsheets, presentation tools, and databases to efficiently create, manage, and analyze business documents. Students will learn to leverage internet resources for research and communication, understand basic cybersecurity protocols, and utilize collaborative platforms for effective teamwork. Emphasis is placed on real-world applications, digital literacy, and the integration of computer skills to support business operations and decision-making.
Recommended Textbook
Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition by Mary Anne
Available Study Resources on Quizplus
13 Chapters
1301 Verified Questions
1301 Flashcards
Source URL: https://quizplus.com/study-set/1467
Page 2
Chapter 1: Introduction to Excel
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29219
Sample Questions
Q1) It is always a good practice to test each formula you enter for accuracy.
A)True
B)False
Answer: True
Q2) What does pressing the Enter key while in a cell, do?
A)The value is set, and the active cell remains the active cell
B)The value is set, and the cell to the right becomes the active cell
C)The value is set, and the cell below becomes the active cell
D)The value is set, and the action is the same as pressing the Tab key
Answer: C
Q3) Which keyboard shortcut puts the user in cell edit mode?
A)F2
B)Shift F2
C)F3
D)Shift F3
Answer: A
Q4) You cannot hide column A or row 1 because they cannot be unhidden.
A)True
B)False
Answer: False
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Formulas and Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29223
Sample Questions
Q1) The inputs in a function are specified by its ________. Answer: arguments
Q2) If you wanted to count the number of entries in a list that contained numbers, text, and blank cells, but ignore the text and blank cells, which function would you use?
A)COUNT
B)COUNTA
C)COUNTBLANK
D)COUNTIF
Answer: A
Q3) When you use the VLOOKUP function, the ________ column in the array is used to look up the value.
Answer: left, first
Q4) The HLOOKUP function can only be used to find exact matches.
A)True
B)False
Answer: False
Q5) The ________ function counts the number of calculable values, but ignores cells that have text or are empty.
Answer: COUNT
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29224
Sample Questions
Q1) A(n)________ is a cell that contains a value used in a chart.
Answer: data point
Q2) A(n)________ is a type of chart which fits in one cell.
Answer: sparkline
Q3) If your chart is intended for presentation, as opposed to printing, you should use a(n)________ background.
Answer: black, dark
Q4) What is not a purpose of using an effective chart?
A)Compares data
B)Reveals trends and patterns
C)Reveals even subtle errors in formulas
D)Aids in making informed decisions
Answer: C
Q5) What chart type represents data as spokes going from the center to the outer edge of the chart?
A)Surface
B)Area
C)Radar
D)Histogram
Answer: C
5
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Datasets and Tables
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29225
Sample Questions
Q1) Selecting a range automatically makes it a data table.
A)True
B)False
Q2) If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?
A)Conditional formatting
B)AutoFill formatting
C)AutoComplete formatting
D)Aggregate Cell formatting
Q3) Excel uses dashed blue lines to indicate manual page breaks.
A)True
B)False
Q4) When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.
A)True
B)False
Q5) In Page Break Preview, the area to be printed has a light blue background.
A)True
B)False
Q6) A(n)________ is a range of organized, related data.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Subtotals, Pivottables, and Pivotcharts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29226
Sample Questions
Q1) You cannot create custom calculations in a PivotTable.
A)True
B)False
Q2) In a PivotTable Fields task pane, the ________ filters the data to display results based on particular conditions you set.
Q3) Displaying subtotals at the top or bottom of a section is controlled on the PivotTable styles gallery.
A)True
B)False
Q4) How would you add a date filter to a PivotTable with these fields: Date, Category, Item, Unit Price, Number Sold, and Extended Price?
A)remove Date from any PivotTable area
B)drag Date to the ROWS area and group it.
C)drag the Date field to the FILTERS area.
D)You must use a slicer with dates.
Q5) ________ apply different formatting and color schemes to a PivotChart.
Q6) PivotTables ________ or summarize large amounts of data for analysis
Q7) You would find the Group and Ungroup buttons in the Outline group on the ________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: What-If Analysis
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/29227
Sample Questions
Q1) A(n)________ is a structured report organized as a worksheet to summarize multiple scenarios.
Q2) This what-if analysis tool is best suited to determine the input value needed to achieve a specific output.
Q3) Where would you setup the two substitution values in a two-variable data table?
A)In the first row and first column in the table
B)In the Series dialog box
C)In the bottom row and last column
D)Excel does this for you.
Q4) Which of the following is not a solving method supported by Solver?
A)GRG nonlinear
B)Simplex LP
C)Duplex
D)Evolutionary
Q5) Use the ________ to edit, delete and create range names.
Q6) Which of these is not part of the Goal Seek dialog box inputs?
A)Set cell:
B)To value:
C)By changing cell:
D)Function:
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Specialized Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29228
Sample Questions
Q1) Which function would calculate a final value of an investment of $250 per month for 5 years at 4% interest?
A)NPV
B)IPMT
C)PV
D)FV
Q2) The formula = ________ (10/15/2018,2)would return 12/15/2018.
Q3) You can nest AND, OR and NOT functions in an IF function.
A)True
B)False
Q4) An OR condition in an advanced filter requires at least two rows in the criteria range.
A)True
B)False
Q5) An INDEX function returns the position of a value.
A)True
B)False
Q6) The ________ function calculates the principal payment for a specified period on a loan or investment.
Q7) ________ can copy filtered information to a new location.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Statistical Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29229
Sample Questions
Q1) FORECAST.ETS.SEASONALITY returns the projected quarter of the year when a forecasted value will happen.
A)True
B)False
Q2) Why is it important to analyze the relationships between a sample and full population?
A)To find out how many data points are necessary to be statistically valid
B)To help make more informed statements about a population
C)To bring diverging data into analysis
D)To limit variance
Q3) The k argument in a PERCENTILE function is a value from 0 to 1.
A)True
B)False
Q4) ANOVA stands for analysis of variability.
A)True
B)False
Q5) This formula will successfully count all green items in the range C2:C256. =COUNTIF(C2:C256,green)
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Multiple-Sheet Workbook Management
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/29230
Sample Questions
Q1) Which of the following formulas contains an accurate 3-D reference?
A)=B4+1st Quarter:'B3
B)=Sales-Expenses
C)=B4+'1st Quarter'!B3
D)=[Sales]-[Expenses]
Q2) A Watch Window displays the value, formula, and location of cells in a separate window.
A)True
B)False
Q3) A method to validate copy and pasted data is ________.
A)Post input validation check
B)Circle Invalid Data
C)Error tracing
D)Validity Tool
Q4) Objects such as charts cannot contain hyperlinks.
A)True
B)False
Q5) A Split Window has three panes by default
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Imports, Xml, and Power Add-Ins
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/29220
Sample Questions
Q1) Importing XML data into Excel enables you to maintain a link and ________ data.
Q2) The SUBSTITUTE function has an optional argument that enables you to replace the third occurrence of a string.
A)True
B)False
Q3) Which of these file types cannot be imported into Excel?
A).txt
B).CSV
C).PDF
D)CAD
Q4) A tab character separates data into columns in a CSV.
A)True
B)False
Q5) Power Query is ________.
A)installed by default
B)enabled in Options
C)downloadable Excel add-in
D)on the Data tab
Q6) To view XML data in Excel in a columnar format, choose the as a(n)________ option in the Open XML dialog box.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/29221
Sample Questions
Q1) If you didn't use the New Comment command on the Review tab, how would you insert a comment?
A)Use the New Comment command on the Home tab.
B)Right-click and select commenting options.
C)Right-click on the cell and then select Insert Comment.
D)Click comment in the status bar.
Q2) The default setting for printing comments is ________.
A)Print in place
B)Print at end
C)not to print
D)only displayed comments
Q3) A(n)________ colored triangle appears in a cell to indicate a comment.
Q4) Click the ________ command on the Review Tab to begin tracking changes.
A)Change Log
B)Track Changes
C)Logging
D)Highlight Changes
Q5) A workbook marked as final is shared.
A)True
B)False
13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Templates, Styles, and Macros
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29222
Sample Questions
Q1) Excel has no method of stopping macro viruses.
A)True
B)False
Q2) Use the ________ function to trap errors when creating templates.
Q3) Select ________ in Backstage view to access the Template Gallery.
Q4) A(n)________ performs actions on a workbook but doesn't necessarily return a specific value.
Q5) In VBA, everything between and including the two following lines would be the CleanData sub procedure.
Sub CleanData()
End Sub
A)True
B)False
Q6) A(n)________ is a set of instructions that execute a sequence of commands to automate repetitive tasks.
Q7) Formatting is limited in Templates.
A)True
B)False
Page 14
Q8) By default the ________ uses absolute cell references when storing a macro.
Q9) Start a custom function in a new ________.
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 13: Appendix: Exploring Microsoft Office Excel 2016
Comprehensive Poatsygrauer
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/29231
Sample Questions
Q1) Which of the following Microsoft Office applications is used to create dynamic presentations to inform and persuade audiences?
A)Access
B)Word
C)PowerPoint
D)Photoshop
Q2) Copy
A)Duplicates a selection from the original location and places a copy in the Office Clipboard
B)Removes a selection from the original location and places it in the Clipboard
C)Page that is wider than it is tall
D)Page that is taller than it is wide
E)Places a selection in the Clipboard into another location
Q3) Bold and Italic are examples of toggle command buttons.
A)True
B)False
Q4) If you used bear instead of bare, bear would be underlined with a red wavy line.
A)True
B)False
Q5) A word usage error is underlined with a(n)________ wavy line.
To view all questions and flashcards with answers, click on the resource link above. Page 16