Intro to Math for Technicians

Question 1

Tells you what part of the equation to calculate first

PEMDAS

Answer 1

Order of Operations

Question 2

what does PEMDAS mean?

Answer 2

Parenthesis
Exponents (roots or powers)
Multiplication
Division
Addition
Substraction

Question 3

Contains one or more numbers and operation symbols

6 + 20 - 4

Answer 3

numerical expression

Question 4

Temperature formula for Celsius

Answer 4

(F - 32) / 1.8 = C

Question 5

Temperature formula for Fahrenheit

Answer 5

(C x 1.8) + 32 = F

Question 6

A computer can be defined as an electronic device that can…

Answer 6

Store, Retrieve, and Process data

Question 7

refers to the physical items of equipment

monitor (the screen you look at)
Keyboard (which you type on)

Answer 7

Hardware

Question 8

refers to the programs or applications that tell a computer what to do and allow the user to be productive.

Directs the computer to complete a task

Browse the internet or launch an email program

Answer 8

Software

Question 9

what are the 2 main types of software?

one has 3 words, and the other one has 2 words.

Answer 9

Operating System Software and Software Applications

Question 10

This is software that manages the operation of the entire computer

such as Microsoft Windows

Answer 10

Operating System Software

Question 11

These are the programs that allow you to complete specific tasks

such as write documents, create presentations, calculate data in spreadsheets, and play games.

Answer 11

Software Applications

Question 12

Used to input data into the computer

Answer 12

Keyboard

Question 13

Used to create pictures or video images that can be saved and distributed through electronic sources

Answer 13

Camera/Video Camera

Question 14

Device used to produce audio input

Answer 14

Microphone

Question 15

Device used to display signals of the computer

typically thin with and LCD display

Answer 15

Monitor

Question 16

Pointing device used to operate or perform specific functions of the computer

Answer 16

Mouse

Question 17

Used to print text or images from a computer

Answer 17

Printer

Question 18

Analyzes images and processes them

Answer 18

Scanner

Question 19

Devices used to produce audio output

Answer 19

Speakers and Sound Inputting devices

Question 20

Allows user to perform specific functions of the computer by applying a light touch to the screen

Answer 20

Touch Screen

Question 21

Word processing

Answer 21

Microsoft Word

Question 22

Spreadsheets

Answer 22

Microsoft Excel

Question 23

Presentations

Answer 23

Microsoft Powerpoint

Question 24

Databases

Answer 24

Microsoft Access

Question 25

a type of productivity suite used in various healthcare organizations across the country.

Answer 25

Microsoft Office

Question 26

a type of word processing system used for specifc tasks ## Footnote such as creating and generating forms

Answer 26

Microsoft Word

Question 27

a spreadsheet application that allows users to create and edit spreadsheets or interactive worksheets in which data is organized and analyzed.

Answer 27

Microsoft Excel

Question 28

Each page in microsoft excel is called a

Answer 28

worksheet

Question 29

multiple pages in excel is called a

Answer 29

workbook

Question 30

predefined worksheets in which the formatting has already been created in terms of styles, formulas, and text.

Answer 30

Templates

Question 31

what are the 2 features that excel uses to input data

Answer 31

Formulas and Functions

Question 32

Allows you to perform mathematical calculations on data.

Answer 32

Formulas

Question 33

Are formulas that have been predefined to perform certain calculations

Answer 33

Functions

Question 34

Examples of functions includes:

Answer 34

SUM and AVERAGES

Question 35

Adds values in cells

Answer 35

SUM

Question 36

calculates the average for a group of selected cells

Answer 36

AVERAGE

Question 37

counts the number of cells

Answer 37

COUNT

Question 38

determines the highest cell value in the selected cells

Answer 38

MAX

Question 39

Determines the lowest cell value in the selected cells

Answer 39

MIN