Computer Operation Level 3 Notes

• These are study notes for Computer Operation Level 3, with suggestions and questions

Functions in MS Excel

• IMSUM() is used to find the sum of complex numbers in MS Excel

Google Sheets

• Columns in Google Sheets are represented by Letters

PowerPoint Font Dialogue Box

• Strikethrough is a font effect not available in the PowerPoint Font dialogue box

Microsoft Word

• Auto Correct automatically corrects common spelling mistakes as you type in Microsoft Word
• MS Word is an example of Word Processing software
• Home tab is the default tab in MS Word
• The number of characters is automatically counted in MS Word
• CTRL+N is used to Create a New Document
• Auto Correct was originally designed to replace misspelled words as you type
• Word Processing is a software

Data Display

• Shorting is used to display values in ascending or descending order

Paragraph Spacing

• Indentation is the space between the margin and the start of a paragraph

Logical Functions

• The Excel function AND returns TRUE or FALSE based on two or more conditions
• The function of the "Find and Replace" feature is to search specific words and replace them with new ones
• The "Track Change" feature keeps a record of all the changes made to the document

Excel

• Freezing panes under the View tab allows you to freeze the top rows and the first column in Excel
• Inserting a Page Break allows you to insert a new page in the middle of an existing document in MS Word
• MS Word 1206 is not an edition of MS Word
• Margins is the blank space outside the printing area on a page
• AND is a logical function that indicates TRUE only if all arguments are assessed as TRUE otherwise
• Cell is the intersection of a column and a row in a worksheet

Conditional Logic

• =IF(logical_test, [value_if_true], [value_if_false]) is the correct syntax of the IF() function
• Templates provide users with a design concept, color scheme, and fonts for presentations

Applications of PowerPoint

• PowerPoint presentations are widely used as a Communication of Planning

Motion Path

• A motion path is a method of moving items on a slide

Text Functions in Excel

• DB() is not a Text function in MS Excel
• Dollar ($) sign is used in the formula to use absolute references

Data Handling

• Filters is a feature that allows you to narrow down the data in your worksheet

Numerical Format

• Currency format represents numbers with the dollar ($) sign

Code

• Algorithm is a list of various coded instructions
• A URL is the address of a document or "Page" on the World Wide Web

Operating Systems

• PASCAL is NOT an operating system

Storage

• ROM is used to store firmware
• Documents can be created with MS Word

Spreadsheet Software

• MS Excel is an example of spreadsheet software
• Ctrl + [ is used to decrease font size by 1 point
• .txt is the extension of a text file
• Column chart is good for a single series of data
• Templates regulate the layout and formatting for slides in MS PowerPoint

Presentations

• PowerPoint is used to prepare a presentation/slide show
• Use Format, Replace Fonts to replace a font on all slides with another font
• Use Custom slider show to create a new slide show with the current slides but presented in a different order

File Formats

• .zip is not a file format for a picture

Page Orientation

• Layout menu tab is used to change the page orientation in MS Word
• Formulas in Excel start with =
• Rows in Microsoft Excel spreadsheets are labeled as 1, 2, 3, ...
• Cells are labeled as A, B, C ...
• Ctrl + Shift + 7 is the shortcut key used to apply outline borders

Excel Short Cuts

• Shift + F11 is the shortcut key to add a new worksheet

Document Formatting

• Columns are used to create a document like a newspaper

Front Size Units

• Point is the standard unit of Front size
• Mail merge sends the same letter to different recipients
• Print layout view allows you to view the Header and Footer

Margin Types

• Middle is not a type of page margin in MS Word
• Home Key moves the cursor to the beginning of the Line

Ribbons

• The Insert ribbon includes the command for inserting charts
• The Home ribbon contains options related to font formatting in MS Word
• The Page Layout ribbon contains options for adjusting the margin and orientation in MS Word
• Excel is a Spreadsheet program developed by Microsoft
• AND is a logical function that returns TRUE if all arguments evaluate TRUE; FALSE otherwise
• DATE() function is used to create a date with year, month, and day
• Cache memory is faster than RAM

Computer Components

• A Processor unit, a memory unit, and an I/O system form Microcomputer
• Channels of communication are Zoom, Google Meet, and Microsoft Team
• Verbal & non-verbal Communication skills are used in customer service and etiquette

Presentation Tools

• Slide Master View is used to customize how your presentation will look as a printed handout
• Build slide avoids showing all of the elements of a slide at once
• Use Transitions > Timing Group > Duration Box to set the transition speed
• Ctrl + T shortcut displays the computer taskbar during a slide show
• Esc is the keyboard shortcut key for stopping media playback
• F11 key is used to create a chart in MS Excel
• Ctrl + Shift + ; inserts the current date
• F2 is used to edit the highlighted cell
• Ctrl + K with CTRL inserts hyperlinks
• Ctrl+9 in Excel hides the selected rows
• Ctrl + Shift + _underline removes all borders
• Ms PowerPoint give presentations
• Cleaning process remove is a disk
• The short cuts we see on the desktop is called Icon
• MS Access example database
• MS word example of word processor
• Strikethrough crosses the word with line
• Computer Application Program is MS word
• Magic tool not used in ms word

Commands

• Brush used word width in MS word
• Magic tool is not used in MS word
• Print Layout view in header or footer available
• Cropping removes unwanted part of image
• Ctrl+E to apply center alignment
• Indentation space start of paragraphs
• WordArt ms word styling
• end Note placed at the end of document
• Ctrl+3 line height 1.5 used
• Header both A and B used page numbers
• Freeze Panes always visibile when scrolling down worksheet
• Pointing touching computer object Animations layout doesn't exist
• Both A and B used as mark
• Mark is used at background
• Text line

Rectangular Pages

• Text Wrapping in rectnagular
• Orientation used print in page
• Outline remove border
• COUNT how many number entries there
• Filtering displays only data that needs to be displayed
• Excel calculates spread sheet and graphs 108 line chart comparing employess
• AVG is not function in excel
• IF condition check in excel
• logical operator for greater and smaller
• Line chart trends change graph
• Sorting arranging arrains of collumn
• Arange to arrange window
• F7 is spell check
• Zoom is not communnicat

Hardware

• Verbal
• Documents holder is chair height is just
• Note Pad application computer
• D transitions for animations
• MS power point not image
• Pot x extinsion for image
• Micrp processor use cards
• Both a and B to delete
• 1987 introduction
• Potx file extensions
• wvm not image folder
• --general 2 scrolls
• Size note file attribute
• Bussiness letter type documents
• excel 4 symbol
• title slide intro
• Autofill is feature to complete
• Pie card is help compara
• Cahrt wizard to create
• Pie chart graphics is differnt departments
• pie chart single series
• Cell excel entry
• Excel 3 defaul file
• B:E5 excelrange
• Work book excel
• database electrocnailly
• Patch free bug
• Exceel and google slide presentation
• Uploading process of transfering
• software program url
• ARPA interent was orginal
• Download trasfer
• layout margin word

Computer security

• To desighn main slides
• protocal internent
• Home page web main page
• Windows not search
• Authentcatuon verficantion loging
• Hyper mark text link
• Browsing website
• name intener ip address
• Restrating Computer boating is restart
• Icon shotcut
• Scanner is image my comopuer
• HDD note
• Handle accounts spreed sheet
• Sutonny my what unicode font
• Bing search
• bolglogs
• systen cpu hard disk
• _ is system unit
• -recycle recycle bin
• • screen Refreshscreen
• change it the text around more
• print
• secion beak
• PDF not merge -supers script supersript
• ---like thickness stying
• Bookmrk macrom tag

Key Points

• font effetc letter below the nomral
• excel ctlr shorcut
• Custon transiation effects
• Style thickneing the line
• For detailed infrmation you use foot notes
• Fooder pased at the top
• iblograthy mircor
• file style pater used close shap
• bottom page noteds appear
• excel cell
• column chart compartign charts
• uncompress to compress
• Comtroller panol chage
• switch user
• Diplay to bring icons
• How many presentation
• time formt shift at
• 11 is key
• currndate
• excel 3 row
• Arithmetu - sign excel function
• and ture
• Aplication microsoft
• -Magic tool world
• joyster is officd
• reast 2 only moder

Document Protection

_Read only word protects different name excel prevents protection negative is not space template not lail merge send email by key F7 check spelling supter is up

• text inserts boarder
• macro micro word A7 to protect _LSI chip modern

Misc

• c network card is it board
• central connection
• is netwrok
• network attatch repeaters pines j to RJ45 no 802 netwrork animation
• space not used sign stiketough

Short Questions

• google, meet, skypr are conferencing apps

• drive, megudatastorage

• edge, firefox are browse gmail and mail providers

• --ctrl =k is shortcut

• guip grapaicl

• break help formatting verbal and comunictaion speaking writing

ethiqute and postitivy

• --snap to scren

loading ream and system calte

• Duplex -1

• insert ctrol + break page use

short 4 scale

• --16,peripheral printers commom

• --5 impt desivce

• -place cusro press

• ----insert

• ---- insert pic

go home idn transistiosn interset and useful

dates task bar change linuc,mac, windows software picture jping

plubbin what to check cable monitor

short to use and shortnes slides creatr labesl insert pic

• insert trl
• remove trellum function
• --lurl reosrouc
• -- ppr powerpoint gooles docs