Introduction to Information Technology
Chapter Exam Questions
Course Introduction
Introduction to Information Technology provides students with a comprehensive overview of the fundamental concepts, tools, and applications that define the modern digital landscape. The course covers the essential components of hardware and software, explores data management, networking, and cybersecurity principles, and examines the role of IT in organizations and society. Students will gain hands-on experience with basic productivity software, learn about emerging technologies, and develop an understanding of ethical issues in the use and management of information systems. This course lays the foundation for further studies in information technology and computer science.
Recommended Textbook
GO with Microsoft Excel 2016 Comprehensive 1st edition by Shelley Gaskin
Available Study Resources on Quizplus
12 Chapters
1128 Verified Questions
1128 Flashcards
Source URL: https://quizplus.com/study-set/2442
Page 2
Chapter 1: Introduction to Microsoft Office 2016 Features
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/48546
Sample Questions
Q1) When inserting a picture into a document,you can download pictures from Facebook,as well as from several other account types.
A)True
B)False
Answer: True
Q2) Microsoft's research indicates that two-thirds of people who open Word documents never,print them.
A)True
B)False
Answer: True
Q3) ________ Preview shows you what the result of applying an edit or format change before you commit to applying it.
Answer: Live
Q4) A computer program that helps you perform a task for a specific purpose is referred to as a(n)________.
Answer: app;application
Q5) When you select an object for editing,the ________ displays commands that are commonly used with the selected object.
Answer: Mini toolbar
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 1: Excell: Creating a Worksheet and Charting Data
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/48535
Sample Questions
Q1) All formulas begin with a(n)________.
A)= sign
B)% sign
C)+ sign
D)# sign
Answer: A
Q2) The ________ command joins two or more selected cells together into one cell. Answer: Merge & Center
Q3) The Wrap Text command displays numbers or formulas on multiple lines as well as text.
A)True
B)False
Answer: False
Q4) You can use the Switch/Row Column command to move a chart from a set of rows on one worksheet to a set of columns on another.
A)True
B)False
Answer: False
Q5) A(n)________ is a vertical group of cells in an Excel worksheet.
Answer: column
4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/48536
Sample Questions
Q1) Data can be edited on more than one worksheet at a time.
A)True
B)False
Answer: True
Q2) On your keyboard,which two symbols function identically in date formats?
A)The forward slash key and the period
B)The dollar sign and the ampersand
C)The comma and the forward slash key
D)The hyphen key and the forward slash key
Answer: D
Q3) You can leave the year off entirely when typing a date into a cell.
A)True
B)False
Answer: True
Q4) A large + sign icon displays next to column headings when a filter is invoked in a table.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 3: Excell: Analyzing Data With Pie Charts, Line
Charts, and What-If Analysis Tools
Available Study Resources on Quizplus for this Chatper
79 Verified Questions
79 Flashcards
Source URL: https://quizplus.com/quiz/48537
Sample Questions
Q1) Match each of the following terms to its definition:
i.data series
II.chart sheet
III.pie chart
IV.legend
v.chart area
A)entire chart and all of its elements
B)shows the relationship of parts to a whole
C)identifies the data markers in a chart
D)a worksheet that contains only a chart
E)related data points represented by data markers
Q2) Which symbol represents that a cell is an absolute cell reference in a function or formula?
A)%
B)&
C)$
D)*
Q3) Goal Seek is a what-if analysis tool.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 4: Excell: Use Financial and Lookup Functions,
Define Names, Validate Data, and Audit Worksheets
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/48538
Sample Questions
Q1) Data tables make it easy to calculate multiple versions in one operation,and then to view and compare the results of all the different variations.
A)True
B)False
Q2) A one-variable data table will allow you to see how different interest rates and different payment periods will affect a monthly payment.
A)True
B)False
Q3) The data in a table array,which can be numbers or text,must be sorted in ascending order.
A)True
B)False
Q4) ________ are prebuilt formulas that perform common business calculations such as calculating a loan payment on a vehicle.
Q5) ________ are tools and commands accessible from the Formulas tab that help you check your worksheet for errors.
Q6) When using a validation list,any value not on the list is considered ________.
Q7) A(n)________ is the result of a formula that Excel cannot evaluate correctly.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/48539
Sample Questions
Q1) Match the terms or phrases with their meanings:
i.Database
II.Field
III.Detail Data
IV.Subtotal Command
v.List
A)A specific type of data such as name or social security number that is stored in columns.
B)A series of rows that contains related data that you can group by adding subtotals.
C)The command that totals several rows of related data together by automatically inserting subtotals and totals for the selected cells.
D)An organized collection of facts related to a topic.
E)The subtotaled rows that are totaled and summarized;typically adjacent to and either above or to the left of the summary data.
Q2) Clicking a ________ will take you to another location in the worksheet,another file location,a webpage on the intranet,or to your organization's Internet.
Q3) ________ is the process of organizing data in a specific order.
To view all questions and flashcards with answers, click on the resource link above.
Page 8
Chapter 6: Excell: Creating Charts, Diagrams, and Templates
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/48540
Sample Questions
Q1) The ________ is the range of numbers in the data series and that controls the minimum,maximum,and incremental values on the value axis.
A)legend
B)template
C)scale
D)matrix
Q2) The entire chart and all of its elements comprise the ________.
Q3) ________ display alongside each row of data and provide a quick visual trend summary.
Q4) The Process SmartArt graphic can show steps in a timeline.
A)True
B)False
Q5) You cannot add additional shapes to a SmartArt graphic.
A)True
B)False
Q6) The Text Pane displays to the ________ of the SmartArt diagram.
A)left
B)bottom
C)top
D)right Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 7: Excell: Creating Pivottables and Pivotcharts
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/48541
Sample Questions
Q1) Match the following terms with their meanings:
i.field names
II.list
III.source data
IV.field section
v.layout section
A)The data for a PivotTable,formatted columns and rows that can be located in an Excel worksheet or an external source.
B)The upper portion of the PivotTable Fields pane containing the fields.
C)The lower portion of the PivotTable Fields pane containing the four areas for layout.
D)A series of rows that contains related data with column titles in the first row.
E)The column titles from source data that form the categories of data for a PivotTable.
Q2) A(n)________ report is a graphical representation of the data in a PivotTable report.
Q3) A row label corresponds to a data series in a PivotTable report.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter
8: Excell: Using the Data Analysis, Solver, and
Features, and Building Complex Formulas
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48542
Sample Questions
Q1) ________ are elective commands and features that are NOT immediately available that must be installed within Excel before you can use them.
Q2) The point at which a business begins to make a profit is called the price point.
A)True
B)False
Q3) On a line chart that shows estimated income and expenses,the point where the lines cross each other is the projected break-even point.
A)True
B)False
Q4) You must use Scenario Manager to create a scenario. A)True
B)False
Q5) A forecast is a prediction of the future,often based on past performances. A)True
B)False
Q6) In Excel,it is NOT possible to create custom date formats. A)True
B)False
Q7) ________ functions,for example AND and NOT,test for specific conditions.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 9: Excell: Using Macros and Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/48543
Sample Questions
Q1) Match the following ActiveX Control buttons with their descriptions:
i.Command Button
II.Combo Box
III.Check Box
IV.Image
v.More Controls
A)Inserts a control button that displays a list of additional controls.
B)Inserts a control button that displays a list of choices from another source.
C)Inserts a control button to which code can be attached,initiating an action when clicked.
D)Inserts a control button that can be turned on (selected)or turned off (cleared).
E)Inserts a control button to embed a picture.
Q2) Any macro setting changes made in Excel in the Macro Settings category apply to
A)Excel only
B)all office programs
C)Access only
D)Excel and Access
Q3) To record a macro,a worksheet must be ________.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 10: Excell: External Data, Database Functions, and
Side-By-Side Tables
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48544
Sample Questions
Q1) Data in an Access database is organized in a format of horizontal rows and vertical columns.
A)True
B)False
Q2) The ________ function capitalizes the first letter of each word in a string.
Q3) The letter D at the beginning of a function identifies to Excel that a ________ range will be used in the formula.
A)table
B)column
C)row
D)database
Q4) A(n)________ is a collection of data related to a particular topic or purpose.
Q5) To print all the worksheets in a workbook at the same time,you can either ________ the worksheets,or under Print Settings,select Print Entire Workbook.
A)view
B)define print area
C)scale
D)group
Q6) You can ________ data into Excel from an Access database.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 11: Excell: Collaborating With Others and Preparing a
Workbook for Distribution
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/48545
Sample Questions
Q1) To change a file to Read-only,display the file list in File Explorer,right-click on the file name,and then click ________.
A)Rename
B)Delete
C)Properties
D)Create shortcut
Q2) The Author name area is generated from ________.
A)the last time you accessed the file
B)the computer where you stored the file
C)your current computer
D)the computer where the file originated
Q3) The Track Changes features finds and removes hidden properties and personal information from a workbook.
A)True
B)False
Q4) You can provide another level of security for your workbook by adding encryption.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Q5) When you create your own ________,it is referred to as a self-signed project.