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...
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
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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.