Computer Literacy
Final Exam Questions
Course Introduction
Computer Literacy provides students with a foundational understanding of computers and digital technology, equipping them with essential skills for navigating today's information-driven world. The course covers basic computer concepts, including hardware, software, operating systems, and internet usage. Students learn practical skills such as word processing, spreadsheet management, presentations, and safe online practices. Emphasis is placed on critical thinking, digital communication, and responsible use of technology, preparing learners to confidently utilize computers in academic, professional, and personal contexts.
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 relatively easy to copy Excel cells into other Office programs.
A)True
B)False
Answer: True
Q2) In Excel, columns are identified by numbers and rows by letters. A)True
B)False
Answer: False
Q3) A(n)________ is a line you can put around a cell or range of cells for emphasis. Answer: border
Q4) The ________ feature helps you complete an incremental series. Answer: AutoFill, auto fill
Q5) A(n)________ is a group of cells which have been selected at the same time. Answer: range
Q6) In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?
A)5/6
B)1+
C)(2-3)
D)6^2
Answer: C
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) ________ references change when formulas are copy and pasted.
Answer: Relative, Mixed
Q2) If you will never copy and paste a formula you do not have to be concerned about absolute, relative, or mixed references.
A)True
B)False
Answer: True
Q3) The VLOOKUP function has four required arguments.
A)True
B)False
Answer: False
Q4) This is not a valid way to use the MAX function: =MAX(a4:d11, f1:f2)
A)True
B)False
Answer: False
Q5) There are rare occasions when both the second and third argument of an IF function are executed.
A)True
B)False
Answer: False
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) If you are not sure which chart type to pick, it may be helpful to click ________ Charts in the Chart group.
Answer: Recommended
Q2) What is not found on the Chart Elements List?
A)Chart Type
B)Data Table
C)Gridlines
D)Legend
Answer: A
Q3) Do not use data ________ and individual values in a chart. Answer: aggregates
Q4) In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed?
A)Bottom left
B)Bottom right
C)Top left
D)Top right
Answer: D
Q5) The ________ axis is the vertical axis.
Answer: Y
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) Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.
A)True
B)False
Q2) By default, what is the first table on a worksheet named?
A)Table 1
B)Table A
C)Table
D)Data tables do not have names.
Q3) By default Excel prints page in what order?
A)Top-left section, top-right section, bottom-left section, and bottom-right section
B)All the odd numbered pages, then all the even numbered pages
C)All the even numbered pages, then all the odd numbered pages
D)Top-left section, bottom-left section, top-right section, and bottom-right section
Q4) Excel will allow you to sort on ________ levels.
Q5) You can select multiple print areas.
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) If you have related data stored in multiple tables, create a(n)________ to create a PivotTable on the combined data
A)Access link
B)data collection
C)Excel table
D)data model
Q2) What does applying a banded row format do to a Pivot Table?
A)Puts a band around subtotals
B)Shades odd and even rows differently
C)Keeps totals together
D)Puts a line between each row
Q3) If you create a Recommended PivotTable on a group of data about book sales with theses columns: Discipline (i.e.Business), Area (i.e.Finance and Marketing), Units Sold, Wholesale Price, what column might Excel use as values?
A)Discipline
B)Area
C)Units Sold
D)Both Discipline and Area
Q4) A(n)________ associates matching fields between 2 tables.
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) What-if analysis always provides a definitive solution to a problem.
A)True
B)False
Q2) An objective cell is required to complete a Solver model.
A)True
B)False
Q3) A one-variable data table would be the appropriate what-if analysis tool to compare loans with variable time period and interest rates.
A)True
B)False
Q4) How many variables does Goal Seek change with each time it is run?
A)2
B)1
C)up to 3
D)unlimited
Q5) ________ can define 32 different scenarios for comparison.
Q6) ________ has an optional summary output of a PivotTable.
Q7) A(n)________ constraint does not restrict the target that Solver finds.
Q9) Business managers often create ________ /worst-case scenarios. Page 8
Q8) A(n)________ is a rule that Solver has to enforce to reach the objective value.
To view all questions and flashcards with answers, click on the resource link above.
Page 9
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) What effect does paying an extra small bit of principal on a mortgage have on the life of a 30 year loan?
A)It has no impact on amount of interest paid but shortens the length of the loan.
B)It saves money in interest and shortens the length of the loan.
C)It increases the amount of interest paid and lengthens the length of the loan.
D)It has no impact on either interest or life span of the loan.
Q2) If you have 3 possible outcomes in a nested IF statement, then you need ________ logical tests.
Q3) The MONTH function would return 25 when used on a cell containing August 25, 2018. A)True B)False
Q4) Which function returns the relative position of a value?
A)INDEX
B)MATCH
C)HLOOKUP
D)VLOOKUP
Q5) ________ can copy filtered information to a new location.
Q6) The ________ function returns the difference between 2 dates.
To view all questions and flashcards with answers, click on the resource link above. Page 10
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 returns the length of the repetitive pattern Excel detects for the time series.
Q2) The FREQUENCY function determines the strength of the relationship between two data sets.
A)True
B)False
Q3) ANOVA stands for analysis of variability.
A)True
B)False
Q4) Which of the following functions determines the standard deviation of a sample?
A)STDEVA
B)VARA
C)STDEV.P
D)STDEV.S
Q5) The Greek letter mu is the symbol for standard deviation.
A)True
B)False
Q6) Covariance has two functions associated with it - COVARIANCE.P and COVARIANCE.S.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
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 is true about the following external cell reference? 'G:\Branches[Minneapolis.xlsx]Qtr 1'!A1
A)It is in the same folder as the destination file.
B)It is in the same workbook as the destination file
C)It is in a different folder than the destination file.
D)It will not work because of the spaces in the worksheet name.
Q2) The ________ is the file which holds a pointer to outside data in a source file.
Q3) Which of the following functions does not contain a syntax error?
A)=AVERAGE(A1:A9)
B)=avg(A1:A9)
C)=AVERAG(A1,A9)
D)=AVERAGE(A1;A9)
Q4) You developed a sales quotation workbook that you will share with your sales staff to help them quote prices.It shows #DIV/0 in some cells where there are empty quantities in a column.Which function would handle the error and replace it with another value.
A)ERRRORRETURN
B)IFERROR
C)ERRORHANDLER
D)ERRORTRACK
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) The SUBSTITUTE function has an optional argument that enables you to replace the third occurrence of a string.
A)True
B)False
Q2) The ________ function will change JILL JONES to jill jones.
Q3) Flash Fill only fills formulas.
A)True
B)False
Q4) ________ is an Excel add-in that enables you to create a visual dashboard.
A)Power View
B)Power Pivot
C)Power Query
D)Power Dash
Q5) Use the ________ function to combine text from multiple columns.
Q6) Which of the following functions is not a text string manipulation tool?
A)CONCATENATE
B)MATCH
C)TRIM
D)LEFT
Q7) The ________ is the area that contains the dashboard in Power View.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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 a workbook ________ is lost, it cannot be recovered.
Q2) The user cannot change automatically updated properties.
A)True
B)False
Q3) ________ is the process of more than one person working together.
Q4) The Share Workbook command is on the ________ tab.
Q5) Which of the following is not a Property in Excel?
A)Author:
B)Last Modified By:
C)Tags:
D)Contents of cells
Q6) Compatibility Checker checks workbook content tor incompatibility with previous versions of Excel.
A)True
B)False
Q7) Excel uses no metadata in its files.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 14
Q8) The ________ dialog box appears if more than one person makes changes in a cell at the same time
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) The Macro Recorder uses absolute references by default.
A)True
B)False
Q2) A forgotten ________ in Excel is unrecoverable.
Q3) Keywords are words or symbols that are reserved for specific actions in VBA.
A)True
B)False
Q4) Use the ________ function to trap errors when creating templates.
Q5) Images or other objects can serve as buttons to run macros.
A)True
B)False
Q6) Which of the following items is not stored inside VBA modules?
A)Sub procedures
B)Keywords
C)Index documents
D)Comments
Q7) Functions are edited in the ________.
Q8) To make a comment line in VBA, start the line with ________.
Q9) ________ is the file extension for Macro-Enabled Workbooks.
Q10) By default the ________ uses absolute cell references when storing a macro. Page 15
To view all questions and flashcards with answers, click on the resource link above.
Page 16
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) Cut
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) Cut
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) You can use the ________ to quickly and easily copy all formatting from one area to another.
Q4) The ________ provides fast access to commonly executed tasks such as saving a file and undoing recent actions.
Q6) Microsoft's cloud storage is called ________ . Page 17
Q5) A grammatical error is underlined with a(n)________ wavy line.
To view all questions and flashcards with answers, click on the resource link above.
Page 18