MIS 180- EXCEL Exam Questions With Correct Answers
25 views 0 purchase
Course
MIS 180
Institution
MIS 180
MIS 180- EXCEL Exam Questions With
Correct Answers
Insert a new column between columns B and C. Label the new column (cell C3) "Record ID"
1.1-1.5 - answerHome tab>Insert green button>insert column or row sheet
Use the "Fill" feature of Excel to insert the numbers 1 to 47 in cells C4:C50....
MIS 180- EXCEL Exam Questions With
Correct Answers
Insert a new column between columns B and C. Label the new column (cell C3) "Record ID"
1.1-1.5 - answer✔✔Home tab>Insert green button>insert column or row sheet
Use the "Fill" feature of Excel to insert the numbers 1 to 47 in cells C4:C50. 1.1-1.5 -
answer✔✔Type #1, #2> Home tab> Blue down arrow> Series> Autofill
Make the table headers (range B3:J3) bold 1.1-1.5 - answer✔✔Home tab>Bolded B
Center the table headers (range B3:J3) horizontally 1.1-1.5 - answer✔✔Home tab> Highlight
cells> Middle lines
Merge and center cell G2 across columns G:J
1.1-1.5 - answer✔✔Home Tab> Right button with lines/blue arrow> Merge & Center
Change the format of the date range (G4:G73) to "Short Date"
1.1-1.5 - answer✔✔Home Tab> Long "general" tab> short date
Center the cells in the table (range B4:J50) horizontally
1.1-1.5 - answer✔✔
Notice that both the "Place" and "Country" fields display the country where the record was
established. Hide column I ("Place") to avoid redundency in the table
11-1.5 - answer✔✔Home tab>Format>Hide & UnHide
Place a "Thick Bottom Border" (from the border drop-down menu) under the data labels (range
B3:J3)
1.1-1.5 - answer✔✔Home tab>Box with thick line
Place a dotted line border (the option directly under "None" in the "Border" tab of the "Format
Cells" dialog window) under each subsequent row in the table.
1.1-1.5 - answer✔✔Home Tab> Highlight cells>Format> Format Cells>Border> "None">Dotted
line
Fill rows 2 and 3 of the table (range B2:J3) using any color (not "No Fill") from the "Fill Color"
drop-down menu.
1.1-1.5 - answer✔✔Home tab>Fill icon
Set the print area of the worksheet to include only the area of the data table (Range B2:J50)
1.1-1.5 - answer✔✔File>Highlight cells>Print Area
Set the left and right print margins of the worksheet to be .5 inches
1.1-1.5 - answer✔✔Page Layout> Print Margins> Custom Print
Set column B as "Columns to repeat at left" page titles
1.1-1.5 - answer✔✔File>Page Setup>Sheet>Highlight cells> Columns to repeat at left
In the same sort, first sort the table on the "World Records Sorted" worksheet by Country in
ascending order (A to Z) then sort the table by 'Record Date' in descending order (Newest to
Oldest).
32 8
11.12 - answer✔✔Hom Tab>Sort & Filter
Filter the table on the "World Records Sorted" worksheet to display only athletes whose
"Nationality" listed as "Kenya" or "Jamaica"
1.1-1.2 - answer✔✔Home Tab>Sort & Tab> Filter> Arrow should show up on cell
Construct a formula in cell D11 to calculate the sales tax amount for transaction 578. Be sure to
appropriately reference the transaction amount in cell C11 and the sales tax rate in cell C8 so that
your formula can be reused for the remaining transations.
21.25
FORMULAS - answer✔✔"=">"ref cell> "*">ref cell> enter
Construct a formula in cell E11 to calculate the total amount for transaction 578. Be sure to
appropriately reference the transaction amount in cell C11 and the sales tax amount in cell D11
so that you can reuse your formula to calculate the total for the remaining transactions.
21.25
FORMULAS - answer✔✔"=">"ref cell> "*">ref cell> "+"> ref cell> enter
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 Thebright. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
