Introduction to Microsoft Excel Solved Exam Questions
Course Introduction
Introduction to Microsoft Excel provides a comprehensive overview of one of the most widely used spreadsheet applications in both academic and professional settings. This course covers the fundamental concepts and functionalities of Excel, including data entry, formatting, basic calculations, and the use of essential formulas and functions. Students will learn how to organize, analyze, and visualize data through the creation of charts and tables. Emphasis is placed on practical applications and problem-solving skills, equipping learners with the tools necessary to efficiently manage and interpret data for a variety of purposes.
Recommended Textbook
New Perspectives on Microsoft Excel 2013 Comprehensive 1st Edition by June Jamrich Parsons
Available Study Resources on Quizplus
13 Chapters
1319 Verified Questions
1319 Flashcards
Source URL: https://quizplus.com/study-set/1082 Page 2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21371
Sample Questions
Q1) Column B in Tyler's spreadsheet contains the addresses of his clients.Some of the addresses are truncated so Roger ____.
A)uses the AutoComplete command to allow for complete entries
B)uses the AutoFit command to remove unwanted space
C)resizes the column width until all addresses are visible
D)switches to Edit mode
Answer: C
Q2) An Excel worksheet can have a maximum of ____ columns in a worksheet.
A)156
B)256
C)16,384
D)17 million
Answer: C
Q3) An adjacent range is a collection of separate ranges.
A)True
B)False
Answer: False
Q4) The ____________________ font size for worksheets is 11 points.
Answer: default
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21372
Sample Questions
Q1) In the accompanying figure,the font in Live Preview is _____.
A)Algerian
B)Calibri
C)Arial
D)Calibri Light
Answer: A
Q2) A(n)\(\underline { \text { footer } }\)appears at the top of each printed page._________________________
A)True
B)False
Answer: False
Q3) A(n)____________________ is a selection of formatting options using a specific font and color from the current theme.
Answer: style
Q4) A _____ indicates a manual page break.
A)dashed blue line
B)solid blue line
C)dashed red line
D)solid red line
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: 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/21373
Sample Questions
Q1) When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the \(\underline { \text { current } }\) cell._________________
A)True
B)False
Answer: True
Q2) A constant is a value in a formula that doesn't change.
A)True
B)False
Answer: True
Q3) Functions can also be ____________________ or placed inside another function.
Answer: nested
Q4) The statement "A1 >= B1" tests whether the value in cell A1 is\(\underline { \text { lesser } }\) than or equal to the value in cell B1._________________________
A)True
B)False
Answer: False
Q5) The ____________________ is the middle value from a sample.
Answer: median
5
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21374
Sample Questions
Q1) Referring to the figure above,the chart title for the pie chart is ____.
A)Estimated Production
B)Projected Revenue and Expenses
C)Total Revenue
D)Production
Q2) You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.
A)Change Chart Type
B)New Chart
C)Alter Existing Chart
D)Modify Chart
Q3) Category values are usually located in the ____ of the data source.
A)first row
B)first column
C)either a or b
D)neither a nor b
Q4) Interest is the amount of money being loaned.
A)True
B)False
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21375
Sample Questions
Q1) Enables you to specify various conditions in addition to those that are based on an "equals" criterion
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort
Q2) The second sort field in a sort is called the ____________________ field.
Q3) To add a sort field in the Sort dialog box,click the ____ button.
A)Add Level
B)Add Field
C)New Sort Field
D)New Level
Q4) A(n)____________________ list indicates the sequence in which you want data ordered.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21376
Sample Questions
Q1) If the destination file is closed when you make a change in the source file,you choose whether to update the link to display the current values when you open the destination file or continue to display the older values from the destination file.
A)True
B)False
Q2) You can use the ____________________ dialog box to break links between workbooks.
Q3) ____________________ appear whenever you place the pointer over a hyperlink.
Q4) A worksheet ____ is a collection of two or more selected worksheets.
A)index
B)roster C)group D)cluster
Q5) The ____ arrangement option layers the open workbooks on the screen. A)Cascade
B)Horizontal
C)Tiled
D)Lateral
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21377
Sample Questions
Q1) Usually,you will want to protect a worksheet but leave some cells _____.
A)open
B)empty
C)clear
D)unlocked
Q2) Range names must begin with _____.
A)a letter or an underscore
B)a number
C)a hash tag
D)an asterisk
Q3) Protecting the _____ prohibits users from renaming,deleting,hiding,or inserting worksheets.
A)skeleton
B)structure
C)format
D)location
Q4) A digital ____________________ is often used to identify the author of a workbook that contains macros.
Q5) List three advantages to using defined names instead of cell references.
Q6) What are the steps for creating a validation rule?
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Working With Advanced Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21378
Sample Questions
Q1) The _____ error value means that a value is not available to a function or formula.
A)#NAME?
B)#N/A
C)#NULL!
D)#NUM!
Q2) For conditional formatting,a formula must be in the form of a(n)_____ test that results in a true or false value.
A)conditional
B)hypothetical
C)logical
D)approximate
Q3) Sometimes the built-in conditional formatting rules do not apply the formatting you need.In these instances,you may be able to create a conditional formatting rule based on a formula that uses a logical expression to describe the condition you want.Give an example of when you would use this type of formula,and list two guidelines you must follow when creating this type of formula.
Q4) The ____________________ function calculates the difference between two dates and shows the result in months,days,or years.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Exploring Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21379
Sample Questions
Q1) The _______ function calculates the amount paid into an investment or loan during each payment period.
A)NPER
B)RATE
C)PMT
D)INT
Q2) To calculate the annual rate,you must _______ the value returned by the RATE function by the number of payments per year.
A)add
B)subtract
C)multiply
D)divide
Q3) The DB function used to calculate the declining balance depreciation has the following syntax: _______.
A)=DB(salvage, life, period [month])
B)=DB(cost, salvage, period [month])
C)=DB(salvage, cost, life, period [month])
D)=DB(cost, salvage, life, period [month])
Q4) How do you determine which method of depreciation is most appropriate?
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Performing What If Analyses
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21380
Sample Questions
Q1) The sensitivity report is most often used in science and engineering environments.
A)True
B)False
Q2) Cells that display the value _______ indicate that all of the values in the worksheet satisfy the Solver constraints.
A)TRUE
B)YES
C)1
D)0
Q3) Click the Scenario PivotTable ____________________ option button to create a PivotTable describing the scenarios.
Q4) In Solver,changing cells are sometimes referred to as _______ cells.
A)self-adjusting
B)variable
C)key
D)constraint
Q5) In a data table,____________________ cells are cells whose values are impacted by the changing input cells.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Connecting to External Data
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/21381
Sample Questions
Q1) Once you insert the _______ function into a cell,the value of the cell will display the latest value retrieved from a measuring device.
A)schema
B)XML
C)RTD
D)real
Q2) The _______ formatting only option retrieves the text from a web query along with simple formatting,but not advanced formatting such as hyperlinks or complicated table structures.
A)Rich text
B)Text
C)Default
D)Normal
Q3) The following is a common text filename extension: _______.
A)dat
B)ppt
C)xls
D)doc
Q4) What are the steps to filter data in a query?
Q5) Data ____________________ can be databases,text files,or other Excel workbooks.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Collaborating on a Shared Workbook
Available Study Resources on Quizplus for this Chatper
120 Verified Questions
120 Flashcards
Source URL: https://quizplus.com/quiz/21382
Sample Questions
Q1) Conditions you set to limit the number of records a database extracts
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)criteria
H)common field
I)element
J)Rich Text
Q2) Chloe has decided to hide the worksheet gridlines and the vertical scroll bar.What does Henry tell her to use to do this?
A)Customization dialog box
B)Screen Elements dialog box
C)Excel Options dialog box
D)Display Options dialog box
Q3) ____________________ are the conditions that limit the number of records displayed in the results of a query.
Q4) Describe the steps to review tracked changes in a shared workbook.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Managing Your Files
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21370
Sample Questions
Q1) You can switch to Details view or Large icons view in File Explorer by using the view buttons on the status bar.
A)True
B)False
Q2) James asks about touch-screen functionality,specifically how Windows 8 shows ScreenTips for items on a touch screen.You assure him that you simply ____ to show its ScreenTip.
A)swipe an object from left to right
B)touch and hold an object
C)tap an object
D)pinch two fingers on an object
Q3) Describe some of the text's best practices for determining where to save files.
Q4) You organize files by storing them in ____.
A)namespaces
B)drawers
C)rings
D)folders
Q5) File Explorer uses backslashes to separate locations in a file path.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15