Introduction to Microsoft Excel Study Guide Questions
Course Introduction
Introduction to Microsoft Excel provides students with foundational skills in spreadsheet creation, data entry, and basic data analysis using Microsoft Excel. The course covers essential features such as formulas, functions, formatting, and chart generation. Students will learn how to organize and manipulate data, perform calculations, and visualize information through tables and graphs. By the end of the course, participants will be able to efficiently navigate Excel, create professional spreadsheets, and utilize Excels tools to support problem-solving and decision-making in academic and professional contexts.
Recommended Textbook
Your Office Microsoft Excel 2013 Comprehensive 1st Edition by Amy S. Kinser
Available Study Resources on Quizplus
16 Chapters
1553 Verified Questions
1553 Flashcards
Source URL: https://quizplus.com/study-set/1565
Page 2
Chapter 1: Navigate, manipulate, and Print Worksheets
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/30981
Sample Questions
Q1) An example of a range of cells is ________.
A)A1&A3
B)A1+A3
C)A1-A3
D)A1:A3
Answer: D
Q2) When using a touch screen,the Excel 2013 commands on the Ribbon and in shortcut menus are rearranged to accommodate the use of a fingertip.
A)True
B)False
Answer: False
Q3) A comment is indicated by the presence of a ________ in the upper-right corner of a cell.
A)red square
B)blue square
C)red triangle
D)blue triangle
Answer: C
Q4) To place the insertion point in the contents of a cell,you ________ the cell.
Answer: double-click
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting, functions, and Formulas
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30987
Sample Questions
Q1) The argument for the COUNT function is limited to a range of contiguous cells.
A)True
B)False
Answer: False
Q2) The keyboard shortcut for apply the Comma format is ________.
A)Ctrl + !
B)Ctrl + ,
C)Ctrl + Shift + !
D)Ctrl + Shift + ,
Answer: C
Q3) Pressing the ________ key deactivates Format Pointer.
Answer: Esc
Q4) You can apply a different theme to each worksheet in your workbook.
A)True
B)False
Answer: False
Q5) The ________ number formatting displays commas and decimal points but not currency symbols.
Answer: Comma
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Cell References, named Ranges, and Functions
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/30988
Sample Questions
Q1) When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6,the formula in cell F6 is ________.
A)=G7/H8
B)=$G$7/$H$8
C)=B5/C6
D)=$B$5/$C$6
Answer: D
Q2) A named range can begin with the / symbol.
A)True
B)False
Answer: False
Q3) A(n)________ cell reference changes when a formula or function is copied from one location to another location.
Answer: relative
Q4) The Text Excel function category provides data about cell content within a worksheet.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Effective Charts
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30989
Sample Questions
Q1) To see possible types of graph to use,you can click Recommended Charts in the
A)Illustrations group on the INSERT tab.
B)Charts group on the INSERT tab.
C)Illustrations group on the VIEW tab.
D)Charts group on the VIEW tab.
Q2) Actions performed in the Chart Formatting Control can be performed through the Chart Tools contextual tab on the Ribbon.
A)True
B)False
Q3) If a change is made to a worksheet,you have to make the corresponding change to the connected chart.
A)True
B)False
Q4) When using an area chart,the x-axis typically involves time.
A)True
B)False
Q5) A common enhancement for a scatter chart is the addition of ________.
Q6) To change the style of a chart,you would click the ________ conceptual tab.
Q7) ________ gridlines are displayed at each of the designated label values.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Complex Conditional and Retrieval Functions
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/30990
Sample Questions
Q1) COUNTIF and AVERAGEIF are examples of ________ statistical functions.
Q2) The ________ function looks for a value within a range and returns the position of that value within the range.
Q3) The ________ function returns the value of an element in a table or array selected by the row and column number indexes.
Q4) If the VLOOKUP range_lookup argument has the ________ value entered,an exact match with the lookup_value argument is required.
A)YES
B)NO
C)TRUE
D)FALSE
Q5) The ________ function is a useful tool for detecting an error and displaying something more user friendly than the error message.
Q6) The symbols < and > are examples of logical ________.
Q7) Conditional aggregate functions are functions that consolidate or summarize a subset of data that has been filtered based upon one or more criteria.
A)True
B)False
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Analyze Data Using Tables
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/30991
Sample Questions
Q1) Users can change the look of an existing table through the Style gallery located on the ________ tab.
Q2) ________ sets are named collections of related sets of information that are composed of separate elements.
Q3) If there are a lot of groups within a field,it is better to put those fields across the top in the columns of a PivotTable instead of along the row side.
A)True
B)False
Q4) When using the SUBTOTAL function,entering a number from 1 to 10 in the SUBTOTAL function's first argument will result in the filtered only data being used.
A)True
B)False
Q5) Gender and dates are two examples of PivotTable ________ variables.
A)aggregate
B)category
C)grouping
D)summary
Q6) The PivotTable ________ tab has all the options for fine-tuning the PivotTable.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Multiple Worksheets workbooks and Templates
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/30992
Sample Questions
Q1) All of the following statements are TRUE about tracking changes EXCEPT:
A)As long as workbooks are shared, you can view the changes made and continue making changes to the shared workbooks.
B)Change history is information that is maintained about all changes made in past editing sessions to the shared workbook.
C)When you save the workbook, the History worksheet will be hidden and you will have to use the Track Changes options to add the History worksheet again.
D)Once you stop sharing the workbook, the change history will remain intact.
Q2) A worksheet can store ________ consolidation(s).
A)one
B)two
C)three
D)unlimited
Q3) The ________ extension is used for an Excel 2013 template.
A).xlst
B).xltx
C).xlt
D).xltp
Q4) Excel 2013 addresses linked workbooks using ________ addresses.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Refine an Excel Application
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/30993
Sample Questions
Q1) The Input Message and Error Message for a data validation rule are helpful but not required when creating the rule.
A)True
B)False
Q2) A(n)________ is a form of computer program that automates activities such as mouse movements and clicks,menu selections,and data entry.
Q3) ________ are the vertical and horizontal lines on a worksheet that help define a cell's boundaries.
Q4) If you make a mistake when recording a macro,you can delete the macro and record a new one,or if you know VBA you can edit a macro and change the VBA that Excel produced.
A)True
B)False
Q5) The ________ tab is used to hide scroll bars,as well as row and column headings.
Q6) Running a macro in Excel deletes the entire Undo history.
A)True
B)False
Q7) A(n)________ cell is a cell that supplies a value to the formula in the active cell.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Organize, import, export, and Cleanse Data Sets
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/30994
Sample Questions
Q1) Anything that is NOT stored in an Excel format or NOT stored locally is considered to be an external data set.
A)True
B)False
Q2) Because Flash Fill involves less typing than traditional text functions,it can be easier to use on ________ devices.
Q3) ________ are markup indicators in an XML document used to identify the data.
A)Brackets
B)Processors
C)Parenthesis
D)Tags
Q4) Excel has a query wizard built into its Microsoft Query function that can be a very powerful aid for linking a worksheet to an Access database.
A)True
B)False
Q5) Excel users can import data from a variety of sources including ________,which is anything that is neither stored in an Excel format nor stored locally.
Q6) The ________ function returns the total number of characters in a string.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Data Tables, scenario Manager, and Solver
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30982
Sample Questions
Q1) The Simplex LP,Generalized Reduced Gradient Nonlinear,and Evolutionary are the three solving methods within the Solver Parameters dialog box.
A)True
B)False
Q2) A ________ is a type of scenario tool that allows you to change a number in a target cell location in single-unit increments.
A)variable
B)data bar
C)break-even point
D)scroll bar
Q3) All of the following solving methods are available within the Solver Parameters dialog box EXCEPT ________.
A)Simplex LP method
B)Evolutionary method
C)GRG Nonlinear method
D)Linear programming method
Q4) What-if analysis tools can be found on the ________ tab.
Q5) To compare scenarios,create a scenario ________ report.
Q6) In Solver,the ________ cell always contains a formula.
12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Loan Amortization, investment Analysis, and Asset Depreciation
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/30983
Sample Questions
Q1) The ________ argument in the DDB function is the rate at which the balance declines.
Q2) An alternative method to using the negative sign to make the result positive is to use the ABS function.
A)True
B)False
Q3) You would use the ________ function to determine the amount of interest paid over a specific number of periods
Q4) The CUMIPMT can be used to help calculate interest for a federal tax return.
A)True
B)False
Q5) ________ is a reduction in the value of a fixed asset from its original cost.
Q6) The ________ method of depreciation calculates depreciation evenly over the life of the asset.
A)accumulated depreciation
B)double-depreciation
C)fixed-declining balance
D)straight-line
13
Q7) The ________ is the unpaid balance amount of the loan.
Q8) The IRR and ________ functions are used for capital budgeting purposes.
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 12: Business Statistics and Regression Analysis
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/30984
Sample Questions
Q1) In a data set consisting of gender,salary,and name of employees,the employees are the ________ and the variables are the gender,salary,and names.
Q2) If there are seven variables,the ________ value is the 4th variable in the list where there are three variables above and three variables below.
Q3) A(n)________ describes all the possible values and likelihoods that a given variable can be within a specific range,and they can be in the form of a graph,table,or formula.
A)continuous variable
B)probability distribution
C)observational unit
D)discrete variable
Q4) ________ is the process of taking data from a sample of the population and making predictions about the entire population.
Q5) Interval data measures the size of the difference between values.
A)True
B)False
Q6) Each of these calculations,mean,median,and mode,attempt to define the ________ of a data set.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Excels Data Model, Power-pivot, and Power View
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/30985
Sample Questions
Q1) The ________ window has options to create multiple PivotCharts on the same worksheet using data from all connected data sources.
A)PivotTable
B)Power View
C)PowerPivot
D)PivotChart
Q2) A positive KPI is when the value becomes worse as it deviates too far from the target value in either direction.
A)True
B)False
Q3) The Microsoft ________ is a cloud computing platform offering a variety of features and services to individuals and businesses.
A)Silverlight
B)Azure Marketplace
C)SkyDrive
D)Outlook Live
Q4) A target value is a calculated field that resolves to a value.
A)True
B)False
16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/30986
Sample Questions
Q1) Names for Sub procedures must begin with a(n)________ and cannot contain any spaces.
Q2) There are two primary types of procedures which are supported by Visual Basic: a Sub procedure and a ________ procedure.
A)Virtual
B)Prime
C)Function
D)Base
Q3) The Project Explorer window is where all the VBA code is typed and also where VBA generated by a recorded macro can be viewed and edited.
A)True
B)False
Q4) The two primary types of procedures that are supported by VBA are Sub procedures and ________ procedures.
Q5) A(n)________ is space in a computer's memory that is given a name and is used to store a value of a specified data type.
Q6) Creating a lookup table and using the ________ function is a common approach to linking values to various form controls.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Appendix:efficient Interaction With a Touch Screen
Available Study Resources on Quizplus for this Chatper
62 Verified Questions
62 Flashcards
Source URL: https://quizplus.com/quiz/30996
Sample Questions
Q1) ________ in Windows 8 is (are)better than any prior version of Windows.
A)GUI
B)Menus
C)Icons
D)Speech recognition
Q2) ________ allow you to perform actions like zooming and switching programs by performing certain movements.
A)Gestures
B)Clicks
C)Icons
D)Swings
Q3) All touch gestures may also be completed with a pen or stylus.
A)True
B)False
Q4) ________ switches Office into a version that makes a touch screen easy to use.
A)Windows 8
B)Touch mode
C)Gesturing
D)Flicking
Q5) ________ are quick short gestures that can be made with a finger or a pen.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 16: The Common Features of Microsoft Office
Available Study Resources on Quizplus for this Chatper
77 Verified Questions
77 Flashcards
Source URL: https://quizplus.com/quiz/30995
Sample Questions
Q1) Buttons where one click turns a feature off and another click turns it on,are called ________ buttons.
A)switch
B)option
C)toggle
D)on/off
Q2) A Microsoft program that can be used for e-mail,contact,and information management is ________.
A)Access
B)OneNote
C)Excel
D)Outlook
Q3) A file format that preserves fonts and other formatting when sharing files with others is ________.
A)USB
B)PDF
C)RTF
D)TXT
Q4) ________ are small windows that display descriptive text when you point to an object.
To view all questions and flashcards with answers, click on the resource link above. Page 19