cfp 3 Flashcards
is a kind of software that performs specific functions for the end user by interacting directly with it
application software
sole purpose of application software
aid the user in doing specified task
examples of application software
- word processors
- spreadsheets
- database software
- presentation software
- computer aided design (cad)
is application software that enables the user to create, save ,edit, format, and print text-enrich documents
word processor
examples of common word processors
- microsoft word
- corel wordperfect
- lotus word pro
- google docs
indicates the name of the application program in use, the current open file, minimize, restore, and the close buttons
title bar
provides the user with group of commands in drop down list used to create and manipulate a document
menu bar
consists of button of commands that provide shortcut to the same commands available in the menu bar
toolbars
this is the work area where you can create your document. it resembles an ordinary piece of paper
document window
advantages of word processor programs
- easy to use due to automated features
- superior editing tools
- can store documents
- superior formatting features
cursor automatically wraps the last word that cannot fit the current line to the next line
word warp
making necessary changes or modification to an existing document
editing
to delete a character, a word, or a block of text
delete
____cancels the last issued command while ____ reverts back the cancelled action
undo and redo
these are programs used to analyze and manipulate numeric data
spreadsheets
examples of spreadsheets
- microsoft excel
- lotus 1-2-3
- google sheets
is a computer program that can capture, display and manipulate data arranged in rows and columns,
spreadsheet
shortcut for undo
ctrl + z
shortcut for redo
ctrl + y
autosum shortcut
alt+=
filter shortcut
ctrl+shift+l
used to create and manipulate databases
database software, commonly referred to as database management sytems (dbms)
like an electronic cabinet, a collection of related data
database
programs that combines a variety of visual objects to create attractive and interesting electronic presentations
presentation software
specialized design software used to draw architectural and engineering designs
cad
is a general purpose, cost effective computer that is designed to be used by a single end-user
personal computer
is a multi-purpose computer whose size, capabilities, and price make it feasible for individual use
personal computer
is basically a system program which is a medium between all the computer hardware components and the application software
operating system
is a software that acts as an interface between computer hardware components and the user
operating system
two functions of operating systems
- extending the machine
- managing resources
main function of an os
- start up the computer
- access the web
- manage memory
- manage programs
- provide user interface
a process of starting or restarting a computer
booting
process of turning on a computer after it has been powered off completely
cold boot
process of restarting a computer that is already powered on
warm boot
controls how you enter data and the instructions and how information displays on the screen
user interface
allows a single user to work on two or more applications that reside in memory at the same time
multitasking
operating system goals
- efficiency
- portability
- interactivity
- security
- scalability
popular windows based personal computer operating systems
- windows xp
- windows vista
- windows 7
- windows 8
- windows 10
popular apple based computer operating systems
- macOS X 10.0-10.11
- macOS 10.12-10.15
- macOS 11-12
describes machines that could be used to type a document
word processing
entering text and symbols into a document
writing
revising or reorganizing the text
editing
changing how the text look on the page
formatting
producing a printed copy
printing
word processing programs can be used to create:
- letters
- reports
- calendars
- brochures
create a new document shortcut
ctrl + n
feature that automatically starts a new page when a page is full
pagination
feature that fixes common spelling mistakes as they are typed
autocorrect
feature protects you from losing your work
autorecover or autosave
family used
font
height of the character
font size
characteristics such as bold, underline, italic
font style
workbook contains
3 worksheets
worksheets are made up of ____ rows and _____ columns
65 536
256
columns and rows intersect to create
cells
a current cell is called
active cell
extension of the excel file
.xls
worksheet cell with a dark border, text or numbers you type appear in this cell and in the formula bar
active cell
the placement of cell data in a cell
alignment
feature that enables you to fill in a series of numbers, dates, or other items automatically in a specified range
auto fill
feature that enables insertion of a formula to sums up a range of cells automatically
auto sum
compares individual items. categories are organized vertically, values horizontally to place more emphasis on comparing values than on time
bar chart
