computer skills placement test

In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are

.wav files and .mid files

What is a motion path?

A method of moving items on a slide

The "Control Panel" is:

A system tool that allows a user to set certain settings

What tab to choose how you want your images to slide in the slide? and to click start duration and delay.

Animations. Example: appear, fade, fly in. Click animation pane to select which image comes in when.

to insert duplicate slides on powerpoint

Click New Slide on Home and click drop down then click Duplicate Selected Slides on bottom

Create a new email message

Click New on the Home tab

In Word

Click Review to check spelling & grammar or to see how many pages, words, characters, paragraphs, and lines, click Word Count.your document has. as well as thesaurus..on review tab

to set margins

Click page layout and click margins

to check spelling on word

Click review tab and click spelling and grammar (not available on my version)

To change web browser home/start page

Click start and go to default app settings-Web browser

How to you open a program such as when there are no icons on the desktop?

Click the START button and select the program from the menu

to select a specific search engine

Click three dots on top right and scroll down to search engine and change from there

to display/hide images on a webpage

Click three dots, scroll down, Click advanced, go to site settings, click on images and go from there

When integrating Word and Excel, Word is usually the

Client

what is the tab for themes on powerpoint?

Design

To print handouts

File-Print-Full Page Slides options and go from there

To print slides

File-Print-Print all Slides

on Outlook, what tab do you click to reply or reply all?

Home

what is the tab for new slides ?

Home

Conditional formatting is on the

Home tab. It evaluates the highest and lowest numbers. The highest numbers may be highlighted in green and lowest number highlighted in red, etc.

Which Of The Following Creates A Drop Down List Of Values To Choose From?

Lookup wizard

what parameter is used to specify data transfer speed?

MHZ

attach a file

Message tab or right hand side

Spell checking

Once on email, click the Review tab to check spelling and grammar

A block of text is selected and now you wish to center align them. Which of the following command will let you do it?

Paragraph command from Format menu

The Minimize button is used to:

Reduce a window to a button on the taskbar

Tabs open up

Ribbons

To mark as read

Right click or click email icon on the right side

To filter

Select column headings Ive created, and click DATA tab. For this you click drop down arrow This gives me the option of eliminating certain records. i.e pg 13 movies

To Freeze Panes

Select the row underneath the row you would like to freeze, then go to the VIEW tab, and click freeze panes, that way if you scroll down the page, you can still see the column titles.

An operating system is:

System software

"Desktop" is a computer term that refers to:

The initial screen showing icons for folders, files, and applications

home tab

To change number formatting ex. currency, general, accounting, etc

Some formulas in excel include

Total: =Sum(D3:D22) OR you can go to home tab and click the autosum option. Average: =average(D3:D22) there's also an auto average option when you click autosum option Highest: =max(D3:D22) Lowest: =min(D3:D22) you can use autosum for all of these formulas, or click drop down arrow for more options ( autosum found on home tab)

When you are instructed to "point and click," it means you:

Use the mouse to move the pointer around the screen and then click the mouse button once or twice to select the object.

Which Windows program do you use to manage folders and files?

Windows Explorer

what does LAN refer to?

a computer network

A range is

a group of cells

Which of the following should you use if you want all of the slides in the presentation to have the same "look"?

a presentation design template

how many kilobytes are equilvalent to one megabyte?

about 1,000

where would you find notepad and calculator?

accessories

All computers must have:

an operating system

selected word to fly in from the left?

animations, fly in, effect options

files that are included with an email message?

attachments

Double click to

be IN the cell

where in excel would you find the fill handle?

bottom right corner of the selected cells or cell

how can unauthorized computer system access be reduced?

by using a firewall

The autofill is used to

click and drag to copy what's in the cell, copy a pattern depending on what you select, to copy a formula, left, right or up and down. It's also good for dates and times, you can just type in the first month or time, click and drag, and it will fill it in on its own.

To bookmark a web page

click on three dots on top right

What is the name of the Windows location that stores cut or copied information?

clipboard

to activate a hyperlink

copy and paste a url and click enter

Excel: format painter on home tab is used to

copy the format of a cell. To do this you click good example, click format painter, then you click and release to copy the format not the content. You can also select a range to do this.

Creating a subdirectory required you to

create a new folder for specific terms

use in combination with the mouse in order to select both folders?

ctrl

which button can be dragged to control the first-line indent of a paragraph?

curser button

What Are The Different Views To Display A Table

datasheet view, design view, pivote table and pivot chart view ALL THE ABOVE

which key creates a new paragraph?

enter

The Maximize button is used to:

expand a window to fill the entire screen

In software applications such as Microsoft Word, a document in known as what on the PC?

file

thin, white area above the column letters that starts with the "fx" button?

formula bar

The Formula bar

gives you more formula suggestions if you type in it. To the left of formula tab you can also use to lookup more formulas. There is also a formula tab that gives you more options. You can also click drop down of a formula type and click insert function and type in what you wanna do.

Any computer parts that you can actually touch are considered to be:

hardware

Styles

home tab

to flag a mail message

hover your cursor over an email until you see a flag icon or click flag icon on the right side of the email

type of chart would be best to use if you want to visually represent the contributions?

insert, pie

To sort and filter

just click one cell, (on mine I have to select everything I wanna sort) click HOME tab or DATA tab, and click sort A to Z

which button merges and centers cells?

merge and center

You can select an entire row to

merge and center a title

A ___________ is a pointing device used to move a pointer on the screen and to make

mouse

which button allows you to change the line spacing?

paragraph box, 0.5, 1, 2

add special graphical object: process, cycle, or hierarchy?

press insert, then smartart

how to start slideshow?

press projector button or press F5. make sure start from beginning is checked.

right align the contents of the selected column?

press the right alignment button

The _________________ is an output device that produces output on paper.

printer

After you delete a file from your hard disk, it is automatcally placed in the

recycle bin

substitute the occurrence of the word?

replace

you can select your content and double click between any two columns to

resize everything so the data fits like it should

What program command saves a copy of a file under a different name

save as

To move up the spreadsheet

shift enter

to move left of spreadsheet

shift tab

click ONCE to automatically sort files smallest to largest?

size

add a logo at the bottom of each slide and change all the bullets, which powerpoint feature will allow this?

slide master

icon that represents a compressed file?

slides.zip

The term ____________ refers to the set of instructions that directs the hardware in a computer to accomplish a task.

software

To name a range you

start in the upper left and say the name of the cell in the lower right. i.e.: L7:L12

Select on of the followintg to determine the proper procedure for shutting down your computer.

start menu, click "shut down"

What type of device is a flash drive?

storage

In a file hierarchy, a folder inside another folder is called

subfolder

which button will immediately calculate the total cost?

sum function also known as AutoSum (home button)

to move right of spreadsheet

tab

The _____________ shows what file and applications are open.

taskbar

What is the significance of a faded (dimmed) command in a drop-down menu?

the command is not currently accesible

what is spam?

unsolicited direct advertising sent to a large number of recipients

Ruler is on the

view tab

An unwanted program running on a computer is called a

virus

you are allowed to make a copy of a copyright protected computer program:

when making a backup copy

You can INSERT on word

wikipedia and online videos

Worksheets added together create a

workbook

A WORD file can be attached to an e-mail message?

yes

in word

you can click format when you click an image to add shapes and lines