100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Microsoft Excel Test UPDATED Actual Exam Questions and CORRECT Answers $7.99   Add to cart

Exam (elaborations)

Microsoft Excel Test UPDATED Actual Exam Questions and CORRECT Answers

 5 views  0 purchase
  • Course
  • Microsoft Excel
  • Institution
  • Microsoft Excel

Microsoft Excel Test UPDATED Actual Exam Questions and CORRECT Answers spreadsheet - CORRECT ANSWER- an electronic file that contains a grid of columns and rows containing related data spreadsheet program - CORRECT ANSWER- a computer application used to create and modify spreadsheets works...

[Show more]

Preview 2 out of 7  pages

  • September 14, 2024
  • 7
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • Microsoft Excel
  • Microsoft Excel
avatar-seller
MGRADES
Microsoft Excel Test UPDATED Actual
Exam Questions and CORRECT Answers
spreadsheet - CORRECT ANSWER✔✔- an electronic file that contains a grid of columns
and rows containing related data


spreadsheet program - CORRECT ANSWER✔✔- a computer application used to create and
modify spreadsheets


worksheet - CORRECT ANSWER✔✔- a spreadsheet that contains formulas, functions,
values, text, and visual aids


workbook - CORRECT ANSWER✔✔- a file containing related worksheets



Steps to design a workbook? - CORRECT ANSWER✔✔- 1. State the purpose of the
worksheet
2. Decide what input values are needed
3. Decide what outputs are needed to achieve the purpose of the workbook
4. Assign the worksheet inputs and results into columns and rows, and consider labeling.
5. Enter the labels, values, and formulas in Excel
6. Format the numerical values in the worksheet
7. Format the descriptive titles and labels attractively but so as not to distract your audience
from the purpose of the worksheet.
8. Document the worksheet as thoroughly as possible
9. Save the completed worksheet


input area - CORRECT ANSWER✔✔- a range of cells containing values for variables used
in formulas


output area - CORRECT ANSWER✔✔- a range of cells containing results based on
manipulating the variables

, Name Box - CORRECT ANSWER✔✔- identifies the address of the current cell



formula bar - CORRECT ANSWER✔✔- displays the content (text, value, date, or formula)
in the active cell


sheet tab - CORRECT ANSWER✔✔- displays the name of a worksheet within a workbook



cell - CORRECT ANSWER✔✔- the intersection of the column and rows



cell address - CORRECT ANSWER✔✔- identifies a cell by a column letter and a row
number


active cell - CORRECT ANSWER✔✔- the current cell, indicated by a dark border



text - CORRECT ANSWER✔✔- includes letters, numbers, symbols, and spaces



value - CORRECT ANSWER✔✔- a number that represents a quantity or an amount



formula - CORRECT ANSWER✔✔- a combination of cell references, operators, values,
and/or functions used to perform a calculation


Ctrl + F - CORRECT ANSWER✔✔- enables a search box to find cell address


Order of Precedence/ Order of Operations - CORRECT ANSWER✔✔- controls the
sequence in which Excel performs arithmetic operations (PEMDAS: Parenthesis, Exponents,
Multiplication, Division, Addition, Substraction


Ctrl + ` (accent) - CORRECT ANSWER✔✔- shows all formulas in spreadsheet



Autofill - CORRECT ANSWER✔✔- enables you to copy the contents of a cell or cell range
or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells.

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller MGRADES. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $7.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67096 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$7.99
  • (0)
  Add to cart