Summary
Summary Grade 10 - 12 C.A.T [Computer Applications Technology] Excel Practical Booklet
- Course
- Institution
A booklet with step by step instructions on features and functions in MS Excel that is examined through grade 10 - 12.
[Show more]
1 review
By: raijmakersm • 1 year ago
Seller
Follow
notedx19
Reviews received
Content preview
Computer.Applications .
Technology .
,INTRODUCTION TO EXCEL
What is excel used for ? :
WORKSPACE FEATURES
⇨This is called a RIBBON.
On the ribbon we have other features like tabs (Insert tab, home tab etc.) as
well as the menu’s by using the arrows at the right-hand corner of each
“category”
TABS
We click here to open
different menu’s
FILE OPTIONS (TAB)
This opens a new file into the
In the file tab we have the following options:
already open Excel workbook
Here we can protect (password lock)
the workbook and get information
(metadata) about the file
Saving a workbook for the first time /
saving it in a different place / overwrite
Saving a workbook under a new name
in the same file as the original
, ROW VS COLUMNS
Formula field
CELL NAME
COLUMN NAMES
ROW NUMBERS
SHEETS
A workbook consists out of several (or only one) sheets. We can see our sheets
at the bottom of the spreadsheet:
We can edit these tabs appearances and names by right-clicking on them with the
mouse and then clicking on the feature you would like to change about the tab
for example the name and colour :
, NUMBER TYPES
Format Description
General The default number format that Excel applies when you type a
number. For the most part, numbers that are formatted with
the General format are displayed just the way you type them.
However, if the cell is not wide enough to show the entire number,
the General format rounds the numbers with decimals.
The General number format also uses scientific (exponential)
notation for large numbers (12 or more digits).
Number Used for the general display of numbers. You can specify the
number of decimal places that you want to use, whether you want
to use a thousands separator, and how you want to display negative
numbers.
Currency Used for general monetary values and displays the default currency
symbol with numbers. You can specify the number of decimal places
that you want to use, whether you want to use a thousands
separator, and how you want to display negative numbers.
Accounting Also used for monetary values, but it aligns the currency symbols
and decimal points of numbers in a column.
Date Displays date and time serial numbers as date values, according to
the type and locale (location) that you specify. Date formats that
begin with an asterisk (*) respond to changes in regional date and
time settings that are specified in Control Panel. Formats without an
asterisk are not affected by Control Panel settings.
Time Displays date and time serial numbers as time values, according to
the type and locale (location) that you specify. Time formats that
begin with an asterisk (*) respond to changes in regional date and
time settings that are specified in Control Panel. Formats without an
asterisk are not affected by Control Panel settings.
Percentage Multiplies the cell value by 100 and displays the result with a percent
(%) symbol. You can specify the number of decimal places that you
want to use.
Fraction Displays a number as a fraction, according to the type of fraction
that you specify.
Scientific Displays a number in exponential notation, replacing part of the
number with E+n, where E (which stands for Exponent) multiplies the
preceding number by 10 to the nth power. For example, a 2-
decimal Scientific format displays 12345678901 as 1.23E+10, which is 1.23
times 10 to the 10th power. You can specify the number of decimal
places that you want to use.
Text Treats the content of a cell as text and displays the content
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 notedx19. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $5.91. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
73314 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now