Applied Computer Skills Exam Practice Tests
Course Introduction
Applied Computer Skills is a practical course designed to equip students with essential competencies in using modern computer applications and tools. The course emphasizes hands-on experience in word processing, spreadsheets, presentations, internet navigation, and email communication. Students learn to efficiently manage files, collaborate digitally, and troubleshoot common software issues. By integrating real-world tasks and problem-solving scenarios, the course prepares learners to confidently utilize technology in academic, professional, and everyday contexts.
Recommended Textbook
Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition by Mary Anne Poatsy
Available Study Resources on Quizplus
13 Chapters
1286 Verified Questions
1286 Flashcards
Source URL: https://quizplus.com/study-set/1601
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/31798
Sample Questions
Q1) Number ________ controls how a value appears in a cell.
Answer: formatting
Q2) When you insert rows or columns all relative references are updated but not any absolute references.
A)True
B)False
Answer: False
Q3) The contents of a cell can be seen in the naming box.
A)True
B)False
Answer: False
Q4) What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?
A)How to do date calculations
B)Order of operations
C)Naming convention for cell ranges
D)The various printing options available in Excel
Answer: B
Q5) The ________ feature helps you complete an incremental series.
Answer: AutoFill,auto fill
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/31799
Sample Questions
Q1) Which function would you use to find the oldest date in a range?
A)MIN
B)MAX
C)OLDEST
D)MEDIAN
Answer: A
Q2) If you omit the fourth argument in a VLOOKUP function,Excel will assume you intend the fourth argument to be False.
A)True
B)False
Answer: False
Q3) What does Excel use to indicate optional arguments in a function?
A)Square brackets []
B)Parenthesis ()
C)Curly brackets {}
D)Quote marks ""
Answer: A
Q4) The TODAY()and NOW()functions are updated every time you open or ________ the spreadsheet.
Answer: print
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/31800
Sample Questions
Q1) You might want to avoid using 3-D charts because they can distort the appearance of the data.
A)True
B)False
Answer: True
Q2) What does Excel not determine about the value axis when you create a chart?
A)Incremental value
B)Start value
C)End value
D)Average value
Answer: D
Q3) What is a disadvantage of a stacked column chart?
A)Segments do not start at the same point.
B)Segments do not end at the same point.
C)There is a limit as to how many segments can be displayed.
D)This is only useful for one data series.
Answer: A
Q4) 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/31801
Sample Questions
Q1) Use the Sort by ________ Color if you want to sort records by the color of the text.
Q2) The ________ wildcard symbol is often used in filters and can represent any number of characters.
Q3) Excel uses dashed blue lines to indicate manual page breaks.
A)True
B)False
Q4) What is not true about creating a data table?
A)Each record should be unique somehow.
B)For efficiency,make sure your data table does not exceed 256 rows.
C)It is best to put individual data tables on separate sheets.
D)Delete any blank columns in your table.
Q5) It is impossible to create a data table from random,unorganized data.
A)True
B)False
Q6) Excel will allow you to sort on ________ levels.
Q7) If you wanted several cells to be filled with a certain color where the width of the fill color in the cell represents that cell's value compared to the values in the other cells,you would use the Data ________ conditional formatting option.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Subtotals, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31802
Sample Questions
Q1) You created a PivotTable and later made changes to values in the underlying data.What happens to the PivotTable?
A)The PivotTable updates automatically when you make changes to the dataset.
B)Excel gives an error message that data has changed and the PivotTable may no longer be accurate.
C)Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
D)Excel deletes the PivotTable automatically so you can recreate it.
Q2) 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.
Q3) A relationship is an association between two tables where the tables contain a common field of data.
A)True
B)False
Q4) PivotTables ________ or summarize large amounts of data for analysis
Q5) A(n)________ is a collection of related tables forming a database.
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
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/31803
Sample Questions
Q1) Which is not true about Scenario Manager?
A)Is rarely used in business models
B)Defines and manages up to 32 scenarios
C)Provides more variability and details than a data table
D)Used to provide best-case,worst-case,and most-likely scenarios.
Q2) ________ is an add-in application that searches for the optimum solution by manipulating variables using constraints you set.
Q3) If you set up a two-variable data table to calculate monthly payments on different interest rates and loan terms,what values would be a likely set of entries in the left column of your data table?
A)$150,000,$160,000,$170,000
B)APR
C)3)0%,3.25%,3.5%,3.75%
D)$583.73,$630.02,$659.97
Q4) Goal Seek would be the best what-if analysis tool to use to discover the necessary interest rate to keep your car payment below $500 per month.
A)True
B)False
Q5) Select ________ from the File menu to install the Solver Add-in.
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/31804
Sample Questions
Q1) The ________ function calculates the current value of an investment given a fixed discount rate.
Q2) A Truth Table is a matrix that provides true or false for every possible combination for an OR,NOT,or AND criteria combination.
A)True
B)False
Q3) An INDEX function returns the position of a value.
A)True
B)False
Q4) The YEARFRAC calculates ________.
A)the year 2018 from a date
B)the number of years between two dates
C)the serial number of the year
D)the fraction of a year in days between two dates
Q5) 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.
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/31805
Sample Questions
Q1) A histogram requires ________ to tabulate data and return a frequency distribution table.
Q2) STDEV.S calculates the standard deviation of a sample.
A)True
B)False
Q3) ________ is a measure of a dataset's dispersion or the difference between the highest and lowest values.
Q4) The ________ function returns a value's rank as a percent between 0% and 100%.
Q5) ANOVA stands for analysis of variability.
A)True
B)False
Q6) =AVERAGEIFS(C2: C64,A2: A64,"Blue",B2: B64,"Black")
Returns an average of Column C of the items which are either Blue or Black.
A)True
B)False
Q7) The ________ function is best suited to calculate quartiles including quartiles 0 and 4.
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/31806
Sample Questions
Q1) ________ locks 2 windows together and enables you to view them line by line as you scroll through them.
Q2) Which character or characters notes the file path in an external reference?
A)[]
B)''
C)!
D):/
Q3) Formula auditing replaces known errors with alternate values.
A)True
B)False
Q4) =SUM('1st Quarter: 4th Quarter'!B4:
B12)is a function using a 3-D reference.
A)True
B)False
Q5) A Warning error style prevents the user from entering invalid data.
A)True
B)False
Q6) '[StPaul.xlsx]Qtr3'!A3 is an example of a(n)________.
Q7) When worksheets are grouped,[Group} appears in the ________.
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
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/31807
Sample Questions
Q1) The return of the RIGHT function is always a number.
A)True
B)False
Q2) Power Query can do all of the following except ________.
A)delete empty records
B)chart data
C)select records matching specific criteria
D)add additional data from multiple sources
Q3) If you do not want to create a link to an Access database table ________.
A)use the Embed Access table command
B)copy each line of data from Access and paste into an Excel worksheet
C)open the table in Access and select data and field names and then copy and paste it into an Excel worksheet
D)Excel had no capacity to do this.It must be done in Access.
Q4) Tab-delimited files use tabs to separate data into new rows.
A)True
B)False
Q5) Power Pivot is installed in all version of Excel.
A)True
B)False
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
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/31808
Sample Questions
Q1) A shared workbook is ________.
A)passed from person to person via email
B)limited to four users
C)designed to be stored on a network and be used by multiple people
D)available through any shared link
Q2) Where in the Excel Options dialog box would you add a word or phrase to AutoCorrect in Excel?
A)Proofing
B)Formulas
C)Save
D)Advanced
Q3) A(n)________ is a workbook that can be viewed and edited simultaneously by multiple users.
Q4) A workbook marked as final is shared.
A)True
B)False
Q5) Shared workbooks must be in read-only network drives.
A)True
B)False
Q6) If a workbook ________ is lost,it cannot be recovered.
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/31809
Sample Questions
Q1) View and edit macros in the ________.
Q2) A(n)________ performs actions on a workbook but doesn't necessarily return a specific value.
Q3) A(n)________ is macro code embedded in a worksheet which does something malicious.
Q4) Which of the following is not a good guideline for creating a template?
A)Include instructions
B)Enter all possible data.
C)Use consistent and appropriate formatting
D)Provide meaningful names to worksheets
Q5) What does the following line of code do to the selected cell? Selection.Font.Bold = False
A)Turns on bold formatting in the selected cell.
B)Replaces the contents of the selected cell with "False"
C)Turns off bold formatting in the selected cell.
D)Nothing,it contains a syntax error.
Q6) A password on a protected workbook can be ________ characters long.
Q7) Select ________ in Backstage view to access the Template Gallery.
Q8) The Themes Gallery is located on the ________ tab.
Q9) By default the ________ uses absolute cell references when storing a macro. Page 14
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 13: Office 2016 Common Features
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/31797
Sample Questions
Q1) Which of the following keyboard shortcuts is used to paste the contents of the Clipboard?
A)Ctrl+P
B)Ctrl+C
C)Ctrl+V
D)Ctrl+X
Q2) Which of the following applications is not included with Microsoft Office?
A)Photoshop
B)Word
C)Excel
D)Access
Q3) You can customize the Ribbon.
A)True
B)False
Q4) A potential misspelled word is underlined with a ________ wavy line.
A)yellow
B)green
C)blue
D)red
Q5) The ________ Preview displays a preview of the results of a selection.
Page 16
To view all questions and flashcards with answers, click on the resource link above.