1. Open the attached image of excel
worksheet and answer the following:
a. If we insert a row above the row 1
and enter the text RESULT 2020, we
want this text must be seen across all
the columns up to j and centrally
aligned, which feature can we use.
b. Write down the formula to find
HIGHEST and LOWEST marks in the
subsequent columns wherever applied
(write down the formula).
c. If we want to display pass or fail as
per the column B in column k, which
formula can be used if the condition is
more than 60 marks pass otherwise
fail, use the appropriate formula.
d. Which feature is used in row 7 as it
seems to be different as compared to
rest of the rows, give name of feature,
steps to obtain such result? Observe
carefully and then answer.
e. Which formula to use in column D, G
and J, also which feature can be used
to fill the entire column, name and
explain that kind of referencing, if you
feel some referencing is used.
Answers
Answer:
Use formatting techniques as introduced in the Excel Spreadsheet Guidelines to enhance the appearance of a worksheet.
Understand how to align data in cell locations.
Examine how to enter multiple lines of text in a cell location.
Understand how to add borders to a worksheet.
Examine how to use the AutoSum feature to calculate totals.
Use the Cut, Copy, and Paste commands to manipulate the data on a worksheet.
Understand how to move, rename, insert, and delete worksheet tabs.
This section addresses formatting commands that can be used to enhance the visual appearance of a worksheet. It also provides an introduction to mathematical calculations. The skills introduced in this section will give you powerful tools for analyzing the data that we have been working with in this workbook and will highlight how Excel is used to make key decisions in virtually any career. Additionally, Excel Spreadsheet Guidelines for format and appearance will be introduced as a format for the course and spreadsheets submitted.
FORMATTING DATA AND CELLS
Enhancing the visual appearance of a worksheet is a critical step in creating a valuable tool for you or your coworkers when making key decisions. There are accepted professional formatting standards when spreadsheets contain only currency data. For this course, we will use the following Excel Guidelines for Formatting. The first figure displays how to use Accounting number format when ALL figures are currency. Only the first row of data and the totals should be formatted with the Accounting format. The other data should be formatted with Comma style. There also needs to be a Top Border above the numbers in the total row. If any of the numbers have cents, you need to format all of the data with two decimal places.
Format Guidelines (used when both currency and non-currency are reflected in a worksheet). Excel Guidelines for Units and Dollar Amounts in Same Worksheet. Three-line title for workbooks not containing Documentation sheet: Company Name, Type of Report, Date. When mixing units and dollars columns, format entire dollar column with Accounting Number format ($). No decimals when dollar amounts are whole dollars, no cents. Remember: Spellcheck. Print preview before printing or submitting. Proofreading common sense: do results make sense? Make sure worksheet looks professional.
Figure 1.31a