Computer Applications Flashcards
Excel
a spreadsheet program that allows users to organize, calculate, and format data
Computer App
An application program is a computer program designed to carry out a specific task. ExMS Office, PowerPoint, Word, Excel, and Outlook.
Central processing unit (CPU)
he component of a computer system that performs the system’s basic operations (such as processing data), that exchanges data with the system’s memory or peripherals, and that manages the system’s other components
Formula Bar in Excel
toolbar that allows users to view and edit the contents of cells in a spreadsheet.
SUM in Excel
The SUM() formula performs addition on selected cells. It works on cells containing numerical values and requires two or more cells.
AVERAGE
The AVERAGE() formula calculates the average of selected cells. You can provide a range of cells or select individual cells
Count
The COUNT() formula counts the total number of selected cells. It will not count the blank cells and different data formats other than numeric.
DATEDIF
calculates the difference between two dates and returns the number of days, months, weeks, or years based on your preference.
What is an Excel Formula
popular tool for managing data and performing data analysis. It is used for generating analytical reports, business insights, and storing operational records.
How to insert formulas in excel for an entire column
Dragging down the fill handle-Double click the fill handle -Shortcut: Copy-pasting:
Powerpoint
software developed by Microsoft that is used for creating engaging multimedia presentations.
Ribbon on Powerpoint
a set of toolbars and menus at the top of the PowerPoint window that organizes commands and functions for completing tasks
Note Section (powerpoint)
the place to store talking points that you want to mention when you give your presentation. Appears under your slides
File Tab
behind-the-scenes stuff you do with a file, such as opening, saving, sharing, exporting, printing and managing your presentation.
Folder
Stored and organized related files represented by an icon with the folder’s name
operating system
software that manages basic functions of computer
Application
program designed to perform a specific function; examples include word processors, web browsers, and games.
How to download an image for PowerPoint?
Right-click on the image and select “Save as Picture” from the drop-down menu. Choose a location to save the image and click “Save”
Excel spreadsheet
documents that organizes, calculates, and displays data in a grid of rows and columns
Formula
expression which calculates the value of a cell. Formulas in Excel can perform mathematical operations, such as addition and multiplication, or functions, like summing or averaging data.
