Information Technology Fundamentals
Study Guide Questions
Course Introduction
Information Technology Fundamentals provides a comprehensive introduction to the concepts, terminology, and applications of information technology in modern organizations. The course covers basic hardware components, software systems, networking principles, internet technologies, data management, and cybersecurity essentials. Students will also explore the role of IT in problem-solving, decision making, and supporting business operations. Through hands-on activities and real-world scenarios, learners gain a foundational understanding of how information technology shapes and influences todays digital landscape.
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) In Office 2016 programs,the mouse ________ is any symbol that displays on your screen in response to moving your mouse device.
Answer: pointer
Q2) ________ text helps people using a screen reader to understand the content of pictures.
Answer: Alternative
Q3) Adding keywords to the document property called ________ makes the file easier to search for.
Answer: tags
Q4) Use the ________ feature to search a document for hidden data or potentially personal data that should not be shared.
A)Inspect Document
B)Check Accessibility
C)Check Compatibility
D)Check Properties
Answer: A
Q5) ________ are related commands displayed within the current active tab within Microsoft Office programs.
Answer: Groups
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) The Sum button resides on both the Home tab and the Formulas tab.
A)True
B)False
Answer: True
Q2) A(n)________ is a prewritten formula that uses one or more cell references,performs an operation,and then returns a value.
Answer: function
Q3) When you select a range of data,the ________ button displays.
Answer: Quick Analysis
Q4) If you move formulas by inserting additional rows or columns in your worksheet,Excel automatically adjusts the formulas.
A)True
B)False
Answer: True
Q5) AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.
A)True
B)False Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
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) The MEDIAN function finds ________.
A)the average value in a range of cells
B)the middle value in a range of cells
C)all numbers that correspond to an argument in the function
D)the one number that corresponds to an argument in the function
Answer: B
Q2) Ctrl + P is the keyboard shortcut for Paste.
A)True
B)False
Answer: False
Q3) How do you know if some rows of a table have been hidden from view when a filter is invoked?
A)Row numbers display is red
B)Row numbers are bolded
C)Row numbers display in blue
D)A number pertaining the number of hidden rows displays next to the funnel icon
Answer: C
Q4) The NOW function is ________,meaning that it will update automatically each time the workbook is opened.
Answer: volatile
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) A Major unit value in a line chart determines the range of numbers in the value axis.
A)True
B)False
Q2) Excel follows a set of mathematical rules called the ________.
Q3) A workbook sheet that contains only a chart is a(n)________.
Q4) To what extent can a pie chart be rotated?
A)Up to 360 degrees
B)Up to 180 degrees
C)Up to 90 degrees
D)Up to 45 degrees
Q5) A chart and all of its elements is known as the ________.
A)chart sheet
B)chart area
C)plot area
D)axis
Q6) A(n)________ is a value in a worksheet cell that is represented in a chart by a data marker.
Q8) Goal Seek is a ________ tool in Excel 2016. Page 6
Q7) A(n)________ displays the relationship of each part of a whole.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
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) The HLOOKUP function looks up values in a table array arranged in vertical columns.
A)True
B)False
Q2) ________ is the process of examining a worksheet for errors in formulas.
Q3) In a lookup formula,the defined range is referred to as the ________.
A)table array
B)named range
C)validation list
D)defined name
Q4) The ________ command checks for common errors that occur when using formulas.
A)Hide Error
B)Audit
C)Error Checking
D)Seek Error
Q5) Goal Seek is part of a suite of data tools used for ________.
Q6) A(n)________ data table changes the values in two cells.
Q7) You can monitor the values of cells in one part of a workbook while working on another part of the workbook by using the ________,a window that displays the results of specified cells. Page 8
To view all questions and flashcards with answers, click on the resource link above.
Page 9
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) Both the List and the Criteria ranges use absolute references.
A)True
B)False
Q2) Detail data refers to the subtotaled rows that are totaled and summarized.
A)True
B)False
Q3) An organized collection of facts related to a specific topic is known as a ________.
A)field
B)database
C)query
D)record
Q4) When outlining a worksheet,if the data is not organized so that Excel can outline it automatically,you can create an outline manually.
A)True
B)False
Q5) You can customize your table by creating and applying a custom table style of your own design.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) Column and row titles that describe the values in the column or row are known as
A)plots
B)groups
C)lines
D)labels
Q3) To make comparisons among related data,use a ________ chart.
A)line
B)pie
C)column
D)scatter
Q4) You should plot both totals and details on the same chart.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) A chart that illustrates the relationship of each part to a whole is called a ________.
A)column chart
B)line chart
C)pie chart
D)bar chart
Q2) A slicer includes a ________ that indicates the category of the slicer items.
A)button header
B)filter header
C)category header
D)slicer header
Q3) Which of the following is a report that is useful when you want to analyze related totals,such as when you have a long list of numbers to sum and you want to compare several facts about each total?
A)PivotTable chart
B)PivotChart table
C)PivotChart report
D)PivotTable report
Q4) A series of rows that contains related data with column titles in the first row is known as a(n)________.
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) A ________ is a sequence of averages computed from parts of a data series that shows a trend more clearly.
Q2) Scenario Manager is one of the tools under ________ in the Forecast group on the Data tab.
A)What-If Analysis
B)Goal Seek
C)Data Validation
D)Data Table
Q3) A ________ function occurs when one function is contained inside another function.
Q4) The ________ of a function specifies the arrangement of the arguments in the function.
A)criteria
B)rules
C)logical functions
D)syntax
Q5) When entering a function,optional arguments display in the ScreenTip.
A)True
B)False
Q6) ________ expenses fluctuate depending on the amount of sales and wages. Page 13
To view all questions and flashcards with answers, click on the resource link above.
Page 14
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) On the Categorized tab,the same properties are listed,but they are organized by ________ groups.
A)sorted
B)logical
C)related
D)alphabetized
Q2) As your actions are recorded,VBA code is created.
A)True
B)False
Q3) A named sequence of statements that performs a task is called ________.
A)a module
B)a function
C)a procedure
D)an ActiveX
Q4) A module can contain several sub procedures.
A)True
B)False
Q5) The word that notes the beginning of a VBA construct is ________.
Page 15
Q6) When you use someone else's computer,it is proper computer ________ to return it to the condition that you found it.
To view all questions and flashcards with answers, click on the resource link above.
Page 16
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) The ________ function is used to join up to 255 strings of characters.
A)UPPER
B)CONCATENATE
C)MID
D)LOWER
Q2) To insert headers or footers in several worksheets at the same time,you must first ________ the worksheets.
Q3) The criteria range for the DAVERAGE function must consist of at least ________ vertical cell(s).
A)one
B)three
C)four
D)two
Q4) A(n)________ is a collection of data related to a particular topic or purpose.
Q5) Filtering controls enable you to change the background color of table cells. A)True
B)False
Q7) The ________ Wizard assists you with steps to import a text file into Excel. Page 17
Q6) Small graphic images known as ________ provide visual cues about the value of a cell relative to other cells.
To view all questions and flashcards with answers, click on the resource link above.
Page 18
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) Within the Properties dialog box for a file on the General Tab,there are additional properties that can be viewed and changed,such as ________.
A)protection parameters
B)keywords
C)backstage options
D)the date the file was last accessed
Q2) If the Read-only property is selected,the file can be read or copied,but NOT
A)changed or saved
B)zoomed out
C)viewed in page layout view
D)deleted
Q3) After the changes have been reviewed and before the workbook is published,the Shared designation must be discarded from the workbook.
A)True
B)False
Q4) To ensure that an Excel 2016 workbook does NOT have compatibility issues in an earlier version of Excel,you can run the ________ Checker.
Page 19
To view all questions and flashcards with answers, click on the resource link above.