Computer Literacy
Solved Exam Questions
Course Introduction
Computer Literacy is an introductory course designed to familiarize students with the fundamental concepts and practical applications of computers in modern society. The course covers essential topics such as computer hardware and software basics, operating systems, file management, word processing, spreadsheets, presentations, internet navigation, online safety, and responsible digital citizenship. Through hands-on activities and real-world scenarios, students will develop the confidence and skills needed to effectively use computers and common software tools for academic, professional, and personal purposes.
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) A(n)________ is a group of cells which have been selected at the same time. Answer: range
Q2) When you do not need the data on a worksheet you should ________ it to make the file smaller.
Answer: delete
Q3) Where is the Show Formulas command found?
A)Formula Auditing group on the Formulas tab
B)Formula Auditing group on the Data tab
C)Formula Auditing group on the Review tab
D)Formula Auditing group on the Developer tab
Answer: A
Q4) One point is how big?
A)1/72 of an inch
B)1/36 of an inch
C)The same as a pixel
D)The same as one character
Answer: A
Q5) ________ a carefully formatted worksheet can save you a lot of time when you need that formatting on another sheet.
Answer: Copying
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) Which status bar statistic can you not enable?
A)SUM
B)MIN
C)Range Name
D)Page Number
Answer: C
Q2) Excel assigns date number 1 to January 1, 1900.
A)True
B)False
Answer: True
Q3) The MIN and MAX functions can be used with ________ as well as numbers. Answer: dates, variables, arguments, expressions
Q4) In military time, 15:00 is ________ in non-military time. Answer: 3:00 PM, 3 PM, 3 P.M.
Q5) The ________ is the lowest value for a category in the table lookup table. Answer: breakpoint, break point
Q6) ________ is a set of analytical tools that appears when you select a range. Answer: Quick Analysis
Q7) When working with dates, Excel actually assigns ________ numbers to each date. Answer: serial
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/29224
Sample Questions
Q1) A(n)________ is a cell that contains a value used in a chart. Answer: data point
Q2) In a bar chart, which axis displays the categories?
A)Horizontal
B)Vertical
C)X
D)Z Answer: B
Q3) To understand a chart you need to include the chart data.
A)True
B)False Answer: False
Q4) A stacked column chart displays multiple columns for each category.
A)True
B)False Answer: False
Q5) Sparklines do not include the normal chart labels.
A)True
B)False
Answer: True
Page 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) What is not true about creating a data table?
A)Make sure no column labels are the same.
B)Make sure to leave one blank row below the data labels.
C)Format the field names so that they stand out visually.
D)Keep field names short.
Q2) You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.
A)True
B)False
Q3) Table ________ add color and borders to a table.
Q4) 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
Q5) ________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.
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) Grouping is ________.
A)using a VLOOKUP function to categorize data
B)joining rows or columns of related data into a single entity for analysis
C)the top level in an outline
D)joining unrelated data for analysis
Q2) When the underlying data changes, a PivotTable automatically updates.
A)True
B)False
Q3) A slicer has a window with a button for each item in a field.
A)True
B)False
Q4) A PivotTable has a live update feature which refreshes the data in real time as the dataset changes.
A)True
B)False
Q5) If you are interested in finding what products people buy when they buy coffee, you would employ data warehousing techniques on supermarket sales data.
A)True
B)False
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) Solver does not support which of the following calculations on the target cell?
A)Maximize
B)Range
C)Minimize
D)Exact Value
Q2) The ________ are the cells containing variables whose values change within the constraints until the objective cell reaches its optimum value.
A)goal seek cells
B)changing variable cells
C)objective cells
D)constraints
Q3) ________ has an optional summary output of a PivotTable.
Q4) How many scenarios can Scenario Manager manage?
Q5) Goal Seek differs from one and two-variable data table analysis by ________.
A)building a data table automatically
B)providing a single best answer rather than a table of possible answers
C)providing a row of possibilities
D)providing an average of the possibilities
Q6) ________ can define 32 different scenarios for comparison.
Q7) A valid character to separate words in a range name is ________.
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/29228
Sample Questions
Q1) What is the match_type argument value for an exact match in a MATCH function?
Q2) A MATCH function returns the value of a given position.
A)True
B)False
Q3) The DCOUNTA function returns an error if it encounters a blank record.
A)True
B)False
Q4) What is a nested function?
A)A function with more than one argument
B)Any IF function
C)A function with more than two arguments
D)A function embedded within an argument of another function
Q5) The ________ function returns the difference between 2 dates.
Q6) The ________ function calculates the total number of periods in a loan.
Q7) When using advanced filtering, leaving a cell empty in the criteria range will return which of the following?
A)All records
B)No records
C)Empty records
D)#N/A
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/29229
Sample Questions
Q1) The FORECAST.ETS function returns a confidence interval for a forecast at all future dates.
A)True
B)False
Q2) Which function returns the rank of a value within a dataset, assigning an average rank for tied values?
A)RANK.EQ
B)RANK.AVG
C)RANK.TIE
D)AVERAGERANK
Q3) The ________ function identifies a value's rank within a list of values, omitting the next rank in the case of tied values.
Q4) ________ returns the forecasted values for a specific future target date using exponential smoothing.
Q5) The ________ function returns the forecasted values for a specific future target date using exponential smoothing.
Q6) ________ is a statistical hypothesis test that helps determine if samples of data were taken from the same population.
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/29230
Sample Questions
Q1) In a 3-D Reference, the ________ name is enclosed in single quotes and followed by an exclamation point.
Q2) ________ locks 2 windows together and enables you to view them line by line as you scroll through them.
Q3) All of the following could produce a #NAME? error except ________.
A)Misspelled word
B)Invalid Range Name
C)Invalid arguments in a function
D)Invalid Function Name
Q4) To edit or remove a hyperlink ________.
A)left-click the hyperlink and then select Edit Hyperlink
B)double-click the hyperlink and then select Edit Hyperlink
C)select the hyperlink and then press delete
D)right-click the hyperlink and then select Edit Hyperlink
Q5) By default, ________ text appears underlined in blue in an Excel Worksheet
Q6) A logic error happens mostly because a user makes a mistake by using an incorrect value or reference in a formula.
A)True
B)False
Page 11
To view all questions and flashcards with answers, click on the resource link above.
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) Power BI is a ________.
A)Business Integration tool suite
B)Business Intelligence tool suite
C)Business Investment tool suite
D)Business Interconnectivity tool suite
Q2) Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?
A)TRIM
B)LEFT
C)CONCATENATE
D)SUBSTITUTE
Q3) ________ is the process of inserting external data created or stored in another format into the current application.
Q4) Text string functions cannot be nested.
A)True
B)False
Q5) You cannot separate data in a single column into multiple columns.
A)True
B)False
Q6) A(n)________ links two tables together for a Power Pivot PivotTable.
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) 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) A file with an .ods extension is ________.
A)Macro-Enabled
B)Binary
C)OpenDocument spreadsheet
D)Portable Document Format
Q3) What is metadata?
A)The data schema
B)The file path of a file.
C)A tool to measure data quality
D)Data that describes other data
Q4) Track changes ________.
A)records changes to existing cells, but not inserted cells
B)can record changes by eight people
C)exports all changes to a Word document log file
D)records changes to a workbook
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) Where would you store macros that you'd like to use in any workbook?
A)A template
B)The Normal Document
C)The current workbook
D)The Personal Macro Workbook
Q2) Use these instead of numbers in formulas in templates whenever possible.
A)Cell references
B)Functions
C)Styles
D)Text
Q3) There are many templates available online.
A)True
B)False
Q4) Start a custom function in a new ________.
Q5) A cell style is a collection of ________.
A)themes
B)format settings
C)fonts
D)colors
Q6) View and edit macros in the ________.
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) A(n)________ is a predesigned file that incorporates formatting elements and may include content that can be modified.
A)template
B)add-in
C)view
D)gallery
Q2) When you ________ a selection, the selection is duplicated and the duplicate is placed in the Clipboard.
Q3) ________ gives you access to the most common formatting selections, such as adding bold or italic, or changing font type or color.
A)An enhanced ScreenTip
B)A gallery
C)Live Preview
D)The Mini toolbar
Q4) The ________ Preview displays a preview of the results of a selection.
Q5) You can customize the Quick Access Tool bar.
A)True
B)False
Q6) The mouse shortcut for selecting a word is to ________ the word.
To view all questions and flashcards with answers, click on the resource link above. Page 15