Facebook-f Youtube

Search for:

Beginner Microsoft Excel: Final Exam

Beginner Microsoft Excel: Final Exam

Lessons

Before you start the final exam, make sure you download the Excel file below. Many questions will be based on this file. In order to successfully complete the course and receive a certificate, you must achieve a 70% or higher on the exam. You may take the exam as many times as you need.

Final Exam Workbook – Wisdify

Time limit: 0

Quiz Summary

0 of 9 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 9 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

Bummer, you didn’t pass the final exam. That’s okay, try taking it again! You can do it!
Congrats on passing the final exam! You can download your certificate which is found on the My Courses page and also on this screen.

1
2
3
4
5
6
7
8
9

Current
Review
Answered
Correct
Incorrect

Question 1 of 9

1. Question
Match the actions to the correct keyboard shortcut:
Sort elements
- Undo
- Print
- Cut
- Select entire row
- Ctrl + Z
- Ctrl + P
- Ctrl + X
- Shift + Spacebar
Question 2 of 9

2. Question
If I wanted to lock down the range A1 through B3 in a formula, what would that reference look like?
- $A$1:$B$3
- $A1:$B3
- A$1:B$3
- A1:B3
Question 3 of 9

3. Question
In a VLOOKUP formula, what is the purpose of putting “FALSE” at the end of the formula?
- Forces Excel to only find an exact lookup match
- Gives Excel the flexibility to find an approximate lookup match
- Returns FALSE anytime Excel cannot find a lookup match
- Gives you the ability to add an IF statement to the formula
Question 4 of 9

4. Question
Use the Final Exam Workbook file for this question. In column C, I want to include the customer’s first name. What would the VLOOKUP formula look like?
- =VLOOKUP(B5,$K$5:$O$26,2,FALSE)
- =VLOOKUP(B5,K5:O26,2)
- =VLOOKUP(B5,$K$5:$O$26,2)
- =VLOOKUP(B5,K5:O26,2,FALSE)
Question 5 of 9

5. Question
Use the Final Exam Workbook file for this question. In column F, I want to extract just the month number from the sale date in column E. What would the formula in cell F5 look like?
- =MONTH(E5)
- =EOMONTH(E5,0)
- =EDATE(E5,0)
- =DATE(E5)
Question 6 of 9

6. Question
Use the Final Exam Workbook file for this question. If I wanted to extract out just the area code from the phone numbers in column O, what formula would I use?
- LEFT
- RIGHT
- TRIM
- MID
Question 7 of 9

7. Question
Why do you need to click “Refresh” on the Analyze tab anytime you update your PivotTable’s source data?
- Your PivotTable does not update automatically when the source data is updated
- In order to insert a new Slicer
- So you can create a new calculated field for your PivotTable
- The Refresh button is somewhat redundant, PivotTables update automatically
Question 8 of 9

8. Question
Match the formula with the correct definition:
Sort elements
- Sums all cells within a defined range
- Counts all cells in a range that contains a value
- Performs a vertical lookup by searching for a value in the first column of a table and returning the value in a specified column
- Performs a logical test and then returns one value for a TRUE result and another for a FALSE result
- SUM
- COUNTA
- VLOOKUP
- IF
Question 9 of 9

9. Question
Use the Final Exam Workbook file for this question. What is the total of revenue in column H?
- $253,833.28
- $243,475.93
- $164,758.37
- $371,831.13

Join our Corporate Finance Community!

Join our growing community to get helpful tips in the world of Corporate Finance and Financial Planning and Analysis. We share helpful tutorials, career information, and more!

Name

Email

Facebook-f Youtube Envelope

Useful Links

Individuals
Companies
Pricing & Plans

Information

About us
FAQ
Contact us

Terms

Disclaimer
Cookie Policy
Privacy Policy

© 2024 Corporate Finance Academy. All Rights Reserved.

Hello!

My Courses
Account Settings
Help

All Courses
Free Resource Library

Pricing & Plans
Individuals
Companies

Articles
About
Contact us

Course Content

Expand All

1.00 Corp Finance & FP&A Careers 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

1.01 Corporate Finance Jobs and Org Chart

1.02 Corporate Finance and FP&A Salaries and Career Path

2.00 Finance & Accounting Foundations 16 Topics

Expand

Lesson Content

0% Complete 0/16 Steps

2.01 Accounting Introduction & Accounting Equation

2.02 Journal Entries & Accounting Basics

2.03 The Income Statement Explained

2.04 The Balance Sheet Explained

2.05 The Cash Flow Statement Explained

2.06 General Ledgers, Subledgers, other systems

2.07 Depreciation

2.08 Time Value of Money

2.09 Discounted Cash Flows

2.10 Working Capital

2.11 Cash & Liquidity

2.12 A/R Overview – What is Accounts Receivable

2.14 Inventory and Inventory Management

2.15 Supply Chain / Manufacturing Finance Fundamentals

2.16 Standard Costing & Costing Materials

3.00 Budgeting – Annual Operating Plan 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

3.01 Annual Operating Plan or Annual Budget Overview

3.02 Budgeting Process – methods, calendar, assumptions, and more

3.03 Sales & Production Budget

3.04 COGS, SG&A, Cap-Ex Budget

3.05 Budget Financials and Budget Presentation

3.06 Budgeting best practices

4.00 Forecasting

6.00 Close & Consolidation

7.00 Financial Analysis

8.00 Data Analytics & Technology

9.00 Modeling / Commercial

11.00 Operations

12.00 Leadership

13.00 Career Management

14.00 Finance / Treasury / Tax

15.00 Accounting / Controls / Risk

16.00 M&A and Due Diligence

17.00 Industry Specific – service, retail, manufacturing, etc.

18.00 Projects / Process / Simplifying and Streamlining

19.00 Soft skills – communication, etc.