Exam (elaborations)
wgu spreadsheet.
- Course
- Institution
Exam of 3 pages for the course D100 Intro to Spreadsheets at D100 Intro to Spreadsheets (wgu spreadsheet.)
[Show more]
Seller
Follow
denicetho
Content preview
wgu spreadsheetCell addresses - ANS-Cells are referenced by
addresses made from their column letter
and row number
To Edit a Cell's Content - ANS-Select the cell andclick the Formula Bar,or double-click
the cell. Edit the cell contentsand press
Enter
To Clear a Cell's Content - ANS-Select the cell(s) and press the Delete key
To Insert a Column or Row - ANS-Right-click to the right of the column,or below the row
you want to insert. Select Insertfrom the contextual menu, or click the Insertbutton
in the Cells group on the Home tab
To Insert a Commen - ANS-Select the cell where you want to insert a comment
and click the Reviewtabon the Ribbon. Click the New Comment buttonin the Comments
group. Type a comment and click outside the comment box
To Total a Cell Range - ANS-Click the cell where you want to insert the total and
click the Sum button in the Editing group on the Home tab. Verify the selected cell range
and click the Sum button again
To Create an Absolute Cell Reference - ANS-Precede the cell references with a $ sign
or press
F4 after selecting cell(s) to make it absolute
To Create a Chart - ANS-Select the cell range that contains the data you want to chart
and click the Insert tab on the Ribbon. Click a chart type button in the Charts group and
select the chart you want to use from the list
To Insert a Sparkline - ANS-Select the cell range that contains the data you want to
chart and click the Insert tab on the Ribbon.
Select the sparkline you want to insert from the Sparkline group. Select the cell or cell
range where you want to add the sparkline and click OK
To Format Text - ANS-Use the commands in the Font group on the Home tab, or click
the Dialog Box Launcher in the Font group to open the dialog box
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 denicetho. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.83. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
72964 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now