Fundamentals of Information Technology
Question Bank
Course Introduction
Fundamentals of Information Technology introduces students to the essential concepts and components of modern computing systems. The course covers the basics of computer hardware and software, operating systems, networking principles, database management, and cybersecurity. Students will develop an understanding of how information is processed, stored, and communicated, as well as explore common productivity software and emerging trends in IT. Through lectures, hands-on labs, and projects, this course lays a foundation for further study in information technology and equips students with the practical skills necessary for academic and professional environments.
Recommended Textbook
New Perspectives on Microsoft Office 2013 First Course 1st Edition by Ann Shaffer
Available Study Resources on Quizplus
20 Chapters
1948 Verified Questions
1948 Flashcards
Source URL: https://quizplus.com/study-set/1957 Page 2
Chapter 1: Creating a Database
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38989
Sample Questions
Q1) A table's contents are shown in rows and columns when using the ____________________ view.
Answer: Datasheet
Q2) Field values that may be entered into a field are determined by the <u>data type</u> of the field. _________________________
A)True
B)False
Answer: True
Q3) When copying and pasting records from one table to another, the records must first be copied to the ____.
A) database
B) query
C) storage device
D) clipboard
Answer: D
Q4) Complete field names for all fields are not visible in the table. Which Access feature can Marissa use to make the entire field name visible while entering data?
Answer: best fit column width feature
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Building a Database and Defining Table
Relationships
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/38990
Sample Questions
Q1) By choosing the Definition Only option in the Import Objects dialog box, the ____ of a table is imported, but not the ____.
A) data, structure
B) data type, structure
C) structure, data
D) structure, data type
Answer: C
Q2) Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?
A) there is no relationship between tables
B) the Excel and Access caption property values to do not match
C) the data was entered incorrectly
D) the Access field names and the Excel worksheet column headings do not match
Answer: D
Q3) ____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.
Answer: Import Importing
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Maintaining and Querying a Database
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38991
Sample Questions
Q1) Which aggregate function supports the Yes/No field data type?
A) Count
B) Average
C) Minimum
D) Sum
Answer: A
Q2) Which method of adding all of the fields from a table to the design grid is best when record selection criteria will be used in the query? How are the fields ordered in the design grid using this method?
Answer: The best method to use is to double-click the field list title bar which highlights all the fields in the table then click and drag any of the highlighted fields to the first column in the design grid. This adds each field in the table in a separate column on the grid and arranges the fields in the order in which they appear in the field list.
Q3) The most simple technique to use for filtering records is <u>Filter By Form</u>.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Creating Forms and Reports
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38992
Sample Questions
Q1) The Columnar form layout displays the fields from one record at a time.
A)True
B)False
Q2) The Report Wizard allows detail records to be <u>sorted</u> by up to four fields.
A)True
B)False
Q3) The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.
A)True
B)False
Q4) The Form Wizard limits fields to be used in a form to one table or one query.
A)True
B)False
Q5) The default theme for a new form that is created is the ____________________ theme.
Q6) The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.
Q7) Why is it important to use Print Preview before printing a report in Access?
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Essential Computer Concepts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38993
Sample Questions
Q1) ____ are laptops that are smaller and less powerful than typical laptop computers but have a longer battery life.
A) Netbooks
B) Lifebooks
C) Smartphones
D) Tablets
Q2) Most PCs use ____________________ SDRAM.
Q3) Software can be divided into two major categories: ____ and ____.
A) Microsoft, Apple
B) read-only, rewritable
C) system, application
D) license-ware, free-ware
Q4) You can connect to another computer, a LAN, a modem, or sometimes directly to the Internet using port ____.
A) C
B) L
C) M
D) A
Q5) ____________________ is the largest WAN in the world.
Q6) The software that helps you navigate the web is called
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38994
Sample Questions
Q1) In the figure above, which box displays the range references?
A) 2
B) 4
C) 5
D) 6
Q2) Multiplication before addition
A)function
B)Name box
C)worksheet
D)range
E)order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template
Q3) <u>Normal</u> view shows how the worksheet will appear when printed.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38995
Sample Questions
Q1) When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.
A) red and green
B) yellow and blue
C) black and white
D) red and yellow
Q2) _____ are an example of conditional formats in Excel.
A) Data bars
B) Quick Analysis tools
C) Font sets
D) Percentages
Q3) If you want to print only part of a worksheet, you can set a(n) <u>print area</u>, which is the region of the worksheet that is sent to the printer.
A)True
B)False
Q4) After you merge a range into a single cell, you cannot realign its content.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Calculating Data With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38996
Sample Questions
Q1) Which of the following is a Math & Trig function? ____
A) INT
B) COUNT
C) MIN
D) AVERAGE
Q2) An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.
Q3) One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.
A) cell
B) relative
C) absolute
D) formula
Q4) FUNCTION(argument1, argument2, ...) is ____.
A) the syntax of writing optional arguments
B) an example of a formula
C) the general syntax of all functions
D) the general syntax of all formulas
Q5) TODAY is an example of a(n) ____________________ function.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38997
Sample Questions
Q1) Compares relative values of different categories to the whole. A value is indicated by the area of a(n) ____
A)Scatter
B)Column
C)XY
D)Line
E)Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area
Q2) Each value from a data series is represented by a ________.
Q3) In the figure above, pv stands for the ____.
A) payments verified
B) principal value of the loan
C) present value of the loan
D) primary interest rate of the loan
Q4) An _______ chart takes up less space than a chart sheet.
Q5) Excel supports ____________________ types of charts into 10 categories..
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Exploring the Basics of Windows 8
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38998
Sample Questions
Q1) You open the Search menu from the ____________________ bar.
Q2) You can press and hold the Windows key and then the C key to display the <u>Charms bar</u>. _________________________
A)True
B)False
Q3) In the accompanying figure, clicking the box marked C ____.
A) will open the Charms bar
B) will scroll the screen to the right
C) will launch the Search bar
D) will shut down Windows
Q4) This screen appears after you sign into Windows 8.
A) Start screen
B) Apps screen
C) desktop
D) Charms screen
Q5) The Charms bar is displayed on this screen.
A) Start screen
B) Charms screen
C) desktop
D) Help & Support screen
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Integrating Word, Excel, Access, and Powerpoint
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38999
Sample Questions
Q1) Box B in the accompanying figure points to ____.
A) fields currently in the main document
B) fields in the data source
C) active linked files
D) other open Word documents
Q2) Linking and embedding are two different terms for the same type of integration.
A)True
B)False
Q3) When importing an outline into PowerPoint, second-level bulleted items are created from paragraphs formatted with the ____ style.
A) Heading 1
B) Heading 2
C) Heading 3
D) Body Text
Q4) You can modify an embedded chart's appearance using commands on the ____________________ contextual tabs that appear on the ribbon.
Q5) The item labeled B in the accompanying figure denotes the ____________________.
Q6) If you ____________________ an Excel chart into Word, and then modify the chart in Word, the source file remains unmodified.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Internet Basics and Information Literacy
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39000
Sample Questions
Q1) Pinning a page to the Start screen ____.
A) can only be done from the Internet Explorer app
B) can only be done from the Internet Explorer desktop application
C) can be done from either the Internet Explorer app or desktop application
D) is not possible
Q2) Saving a webpage using the .txt format means saving ____.
A) the entire webpage, including all elements that make up the page
B) only the HTML code that makes up the webpage
C) only the visible text in the webpage
D) a "picture" of the current webpage, without any page elements
Q3) ____ are personal commentaries that present the writer's opinion, but can also provide innovative ideas or breaking news.
A) Blogs
B) Web directories
C) Metasearch engines
D) Deep webs
Q4) A(n) ____________________ is a protection granted by law to the author or creator of an original work who creates a tangible expression of that work or creation.
Q5) MLA stands for ____________________ Association.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Introduction to Cloud Computing
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/39001
Sample Questions
Q1) Alyssa has a very large desktop publishing file she wants to store on her SkyDrive. It is 5 GB large. How should she upload it?
A) Using the SkyDrive app
B) Using the SkyDrive desktop application
C) Dragging and dropping from within File Explorer
D) Using a browser
Q2) For security, the only way to move files between your SkyDrive and your computer is via File Explorer.
A)True
B)False
Q3) To upload a file to your SkyDrive from within Microsoft Excel, you will need to click "Save As" in the navigation bar ____.
A) in Backstage view
B) on the SkyDrive panel
C) on the SkyDrive ribbon tab
D) in File Explorer
Q4) You can use SkyDrive as a video player.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Managing Your Files
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39002
Sample Questions
Q1) The non-icon views available in File Explorer include ____________________, Details, Tiles, and Content.
Q2) File Explorer displays the file path in the <u>Status</u> bar.
A)True
B)False
Q3) the default view for all folders except in the Pictures library
A)backslash
B)Large icons
C)Clipboard
D)root directory
E)SkyDrive
F)extension
G)folder
H)archive
I)Details
J)library
Q4) Windows stores folders and important files that it needs when you turn on the computer in the ____________________ directory.
Q5) In order to use SkyDrive, you need to have a(n) ____________________ account.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Creating a Presentation
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39003
Sample Questions
Q1) A ____ item is a main item in a list.
A) base-level
B) root
C) sub-
D) first-level
Q2) If you choose to print your presentation in ____________________ it will print in white and shades of gray.
Q3) Use the ____ button on the status bar to magnify text
A)Zoom in
B)smart guides
C)Compressing
D)Font
E)PICTURE TOOLS FORMAT
F)INSERT
G)Proofing
H)Clipboard
I)layout
J)FORMAT
Q4) Briefly explain how to undo and redo actions.
Q5) In ____________________ view, each slide fills the screen, one after another.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Adding Media and Special Effects
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39004
Sample Questions
Q1) You can modify transitions in <u>Normal</u> or Slide Sorter view.
A)True B)False
Q2) Merlia wants all of her slides to come "From Right" except the last slide. She can change the last slide to come "From Top" by clicking the ____ button.
A) Effect Movement
B) Effect Options
C) Transition Movement
D) Transition Options
Q3) The Remove Background tool is available only to <u>pictures</u>.
A)True B)False
Q4) When you preview an animation, it plays automatically on the slide in the ____________________ pane.
Q5) Use the Shape ____________________ button to add a shadow, glow, or soft edges to a shape.
Q6) The ____________________ is the formatting of the area inside a shape.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 17: Creating and Editing a Document
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39005
Sample Questions
Q1) Discuss the use of color and special effects in formal documents.
Q2) To accept an AutoComplete suggestion, press the _______ key.
A) Esc
B) Shift
C) Enter
D) Ctrl
Q3) The _______ shown in the accompanying figure provides information about the current document, such as the page and number of words in the document.
A) ribbon
B) Quick Access Toolbar
C) title bar
D) status bar
Q4) The _______ tab shown in the accompanying figure includes options for formatting and editing text.
A) HOME
B) DESIGN
C) INSERT
D) PAGE LAYOUT
Q5) ____________________ automatically corrects common typing errors.
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 18: Navigating and Formatting a Document
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39006
Sample Questions
Q1) A group of related paragraphs that have a particular order can use numbers instead of bullets to create a(n) <u>numbered</u> list. _________________________
A)True
B)False
Q2) You typed a paragraph on page 2 that should appear on page 27. To move that paragraph to the correct place in your document, you should use ____.
A) drag and drop
B) cut and paste
C) delete and replace
D) copy and paste
Q3) Thomas has typed 20 pages of his report and realizes that he typed Niko and should have typed Nike. The most efficient way for him to fix this error is to ____.
A) proofread
B) use Find and Replace
C) run the Spelling and Grammar Checker
D) search the text
Q4) The First Line Indent marker looks like the top half of a(n)
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 19: Creating Tables and a Multipage Report
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39007
Sample Questions
Q1) An explanatory comment or reference that appears at the bottom of a page
A)record
B)footnote
C)endnote
D)header
E)footer
F)reference marker
G)header row
H)sort
I)tab stop
J)section
Q2) A(n) <u>SmartArt</u> graphic is a diagram or chart that illustrates concepts that would otherwise require several paragraphs of explanation.
A)True
B)False
Q3) Dragging the mouse pointer across columns and rows is the most foolproof method for selecting part of a table.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 20: Enhancing Page Layout and Design
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39008
Sample
Questions
Q1) Discuss copyright laws in relation to the images students can use in a Microsoft Word document, for example.
Q2) In the accompanying figure, the option marked _______ is applied by default to any shapes inserted via the Shapes button in the Illustrations group on the INSERT tab.
A) 3
B) 4
C) 5
D) 6
Q3) Most clip art websites include a search box where you can type some descriptive <u>clues</u> to help you narrow down your selection to a smaller range of clip art.
A)True
B)False
Q4) The Illustrations group contains all but a _______.
A) Shapes button
B) Chart button
C) Photo button
D) Pictures button
Q5) Graphics file that stores an image as a mathematical formula
To view all questions and flashcards with answers, click on the resource link above. Page 22