Mis 180 excel exam - Study guides, Class notes & Summaries

MIS 180 EXCEL EXAM QUESTIONS AND ANSWERS ALL CORRECT 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 ...

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. 1.1-1.5 - answerType #1, #2> Home tab> Blue down arrow> Series> Autofill Make the table headers (range B3:J3) bold 1.1-1.5 - answerHome tab>Bolded B Center the table headers (ran...