Computer Applications
Mock Exam
Course Introduction
Computer Applications introduces students to the fundamental concepts and practical skills necessary to effectively use a variety of computer software tools in academic, professional, and personal contexts. The course covers essential topics such as word processing, spreadsheets, presentation software, databases, and internet research techniques. Students gain hands-on experience navigating operating systems, managing files, and utilizing cloud storage. Emphasis is placed on the development of problem-solving abilities and digital literacy, enabling students to efficiently analyze, organize, and present information using modern computing technologies.
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) Which of the following is not considered an Excel element?
A)Formula Bar
B)Name Box
C)Active cell
D)Print Preview
Answer: D
Q2) The fill handle allows you to copy and paste formulas to adjacent cells.
A)True
B)False
Answer: True
Q3) What is the best practice for centering a title over multiple columns?
A)Enter the title in the center column of the range
B)Use the Merge Title feature
C)Use the Merge and Center alignment
D)Use the Combine and Center alignment
Answer: C
Q4) It is always a good practice to test each formula you enter for accuracy.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
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 HLOOKUP function can only be used to find exact matches.
A)True
B)False Answer: False
Q2) The PMT function uses three required arguments and no optional arguments. A)True
B)False Answer: False
Q3) The most used logical function is the IF function.
A)True
B)False Answer: True
Q4) Excel assigns date number 1 to January 1, 1900.
A)True
B)False Answer: True
Q5) The ________ function is similar to the TODAY()function, except that it also returns the system time.
Answer: NOW(), =NOW()
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 type of chart which fits in one cell. Answer: sparkline
Q2) You can link to a cell as the title of a chart.
A)True
B)False
Answer: True
Q3) It is good practice to delete any blank rows or columns before creating a chart.
A)True
B)False
Answer: True
Q4) As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.
A)True
B)False
Answer: False
Q5) In a(n)________ column chart data appears as side by side columns. Answer: clustered
Q6) A group of data points used in a graph become a data ________. Answer: series
To view all questions and flashcards with answers, click on the resource link above. Page 5
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) In a data table you can use ________ references in place of cell references inside the formulas.
Q2) You cannot sort cells by their fill color.
A)True
B)False
Q3) What would be the result if you sorted the following dates in ascending order:
December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?
A)December 25, 2000; December 26, 1959; January 1, 2015; January 16, 1959
B)January 1, 2015; January 16, 1959, December 25, 2000; December 26, 1959
C)January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015
D)December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959
Q4) In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?
A)The COUNT function
B)The SUM function
C)The number of rows to subtotal
D)The row number in which to place the subtotal
Q5) Excel uses solid blue lines to indicate automatic page breaks.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) A worksheet of faculty members at your university contains these columns in this sequence: Rank, Last Name, First Name, Department, and Salary.What is the first step to subtotal departmental salaries?
A)Sort by Last Name
B)Sort by Salary
C)Sort by Rank
D)Sort by Department
Q2) A(n)________ is the tool which appears in a separate window and displays all available options to show or hide data for a field.
Q3) Build a PivotChart in the PivotChart wizard on the PivotTable Tools Design tab.
A)True
B)False
Q4) A slicer has a window with a button for each item in a field.
A)True
B)False
Q5) PivotTables ________ or summarize large amounts of data for analysis
Q6) You would find the Group and Ungroup buttons in the Outline group on the ________ tab.
Q7) A(n)________ hides some values from a field in a PivotTable.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
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) Solver does not support which of the following calculations on the target cell?
A)Maximize
B)Range
C)Minimize
D)Exact Value
Q2) If Solver is loaded, it will appear on this tab.
A)Data
B)Formulas
C)Insert
D)View
Q3) Optimization models find the highest, lowest, or exact value for one particular result.
A)True
B)False
Q4) The what-if analysis tool best suited to evaluating multiple scenarios within a formula is ________.
Q5) If Solver is installed on your computer, it will display on the ________ tab.
Q6) How many scenarios can Scenario Manager manage?
Q7) The ________ specifies the cell containing the formula that produces a value for Solver to optimize.
To view all questions and flashcards with answers, click on the resource link above. Page 8
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) Why would you put a negative sign in many financial functions?
A)Excel requires a negative interest rate.
B)Excel interprets these calculations as a negative cash flow (money leaving your account).
C)Excel uses negatives for all financial functions.
D)Excel doesn't differentiate between income and outflow.
Q2) 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
Q3) The ________ function identifies the highest value in a database column that matches specified conditions in a criteria range.
Q4) Which is the Array argument in =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)?
A)MAX(B2:B5)
B)MATCH(MAX(B2:B5),B2:B5,0)
C)1
D)A2:B5
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) The ________ function identifies a value's rank within a list of values, omitting the next rank in the case of tied values.
Q2) A histogram requires ________ to tabulate data and return a frequency distribution table.
Q3) The RANK.EQ function returns ________.
A)the rank of a value within a dataset, giving an average ranking to tied values
B)the rank of a value within a dataset, giving the highest ranking possible to ties
C)the rank of a value within a dataset, throwing out ties
D)the rank of a value within a dataset, giving the same ranking to tied values
Q4) 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
Q5) The ________ function will use average values to determine the rank of a number within a list if tied values are present.
Q6) ________ is a measure of how two sets of data vary simultaneously.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
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) The Fill Across Worksheets command is ________.
A)only usable on an empty workbook
B)an option on the Fill button on the Home Tab
C)applicable to formats but not contents
D)an option on the Group button on the Data Tab
Q2) You can apply uniform page layouts to grouped worksheets.
A)True
B)False
Q3) Formula auditing replaces known errors with alternate values.
A)True
B)False
Q4) Which of the following is an example of Pascal Case notation.
A)pascalCaseNotation
B)PascalCaseNotation
C)pascal_case_notation
D)Pascal Case Notation
Q5) A(n)________ is where you go when you click a hyperlink.
Q6) By default, ________ text appears underlined in blue in an Excel Worksheet
Q7) '[StPaul.xlsx]Qtr3'!A3 is an example of a(n)________.
Q8) ________ cells are referenced by a formula in another cell.
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) Power Query is ________.
A)installed by default
B)enabled in Options
C)downloadable Excel add-in
D)on the Data tab
Q2) <?xml version="1.0" encoding="UTF-8"?> is an XML declaration.
A)True
B)False
Q3) The return of the RIGHT function is always a number.
A)True
B)False
Q4) The ________ function will change tabitha turner to Tabitha Turner.
Q5) The TRIM function removes leading and trailing spaces in a text string but maintains spaces between words.
A)True
B)False
Q6) Power Pivot can import XML data.
A)True
B)False
Q7) Use the ________ function to combine text from multiple columns.
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) How would you return to the default installation settings of the Ribbon?
A)Click Reset in the Customize Ribbon tab of the ExcelOptions dialog box, and then select Reset all customizations, and then click Yes.
B)Click Reset in the customize Ribbon tab of the Excel Options dialog box, and then select Reset Group customizations, and then click Yes.
C)Reinstall Excel.
D)Right Click on the Ribbon and select return to default.
Q2) Users can see the changes made by other users in a shared workbook. A)True
B)False
Q3) If you send an email link to a workbook, the recipients of the file have access to change the original file on your computer. A)True B)False
Q4) The Document Inspector can remove personal data from a workbook. A)True
B)False
Q5) The Share Workbook command is on the ________ tab.
Q6) To Mark Workbook as Final, click ________ in the Backstage view.
Page 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) A(n)________ is one that prevents users from editing the contents or formatting.
Q2) ________ is the file extension for Macro-Enabled Workbooks.
Q3) PDF file format is XML Paper Specifications.
A)True
B)False
Q4) Cells can be locked from the ________ group on the Home tab.
Q5) What would be the first line of the module for a function named Mileage with parameters Miles and Rate?
A)Function Mileage (Miles, Rate)
B)Sub Mileage (Miles, Rate)
C)Mileage (Miles, Rate)
D)End Function
Q6) What is the file extension for a Macro-Enabled Workbook?
A).xlsb
B).xlsm
C).xltm
D).xlm
Q7) Good, Bad, and Neutral are predefined cell styles.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) 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
Q2) Portrait orientation
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) A ________ consists of one or more lines at the bottom of each page.
A)header
B)endnote
C)footnote
D)footer
Q4) A(n)________ consists of one or more lines at the top of each page.
To view all questions and flashcards with answers, click on the resource link above. Page 15