MicroComp

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

If you have a table of customers and you want to display the records of only those people who live in a certain city, you should click the ____ on the Home tab

Filter button in the Sort & Filter group

When you move a chart to a new worksheet, the new worksheet is named ___ by default

Chart1

Because Excel follows the standard mathematical order of operations, it will calculate the formula =4+2*3 to which of the following? A. 18 B. 2 C. 10 D. 9

10

In Excel, which of the following formulas will return a result of 33? A. =5*3+6 B. =6+5*3 C. =(5+6)*3 D. =5+6*3

=(5+6)*3

Which of the following is the correct formula for adding the contents of cell C2 to the contents of cell C3? A. +2C+3C B. C2+C3= C. =C2+C3 D. C2+C3

=C2+C3

Which of the following formulas should you use to find the total of a range of values located in rows 5 through 15 of column F of an Excel worksheet? A. =SUM(F5:F15) B. @SUM(F5:F15) C. =ADD(F5:F15) D. =TOTAL(F5:F15)

=SUM(F5:F15)

When you enter data in a form

Access saves the data automatically

Which of the following buttons is not available when the spelling checker flags a potential spelling error

Add All

To be able to view the contents of PDF files, the user can download ____, which is a free program

Adobe Reader

Which of the following is not an example of applications software

Apple OS X

To alphabetize records by last name from A to Z , click the ___ button

Ascending

Which of the following is not a correct example of a cell range? A. B4:8J B. C5:G5 C. A1:A12 D. F18:L75

B4:8J

To change a column chart into a bar chart, select the chart, click the Chart Tools Design tab, click the ____ and then click Bar

Change Chart Type button in the Type group

To change the style of a chart, click an option from the gallery in the ___ and then click a different chart style

Chart styles group on the Chart Tools Design tab

How can you move a slide in Slide Sorter view

Click the slide and then drag it to where it should appear

To combine revisions from multiple author into a single document, use Word's _____ feature

Compare

How can you automatically adjust the width of a column to fit the size of the longest entry?

Double-click the right border of the column heading

One-Drive files are accessed using

File Explorer

_____ displays symbols to let you know the sync status of the following between your local computer and OneDrive

File Explorer

Use the ____ button to create a subordinate list within a bulleted list

Increase List Level

Which of the following features describes Excel's Auto Fill feature?

It enables you to copy an entry across a row or down a column or create a series of entries across a row or down a column

If you want to center the title in cell C3 across columns C, D, and E, drag to select the range C3:E3 and then click the

Merge & Center button

To combine table cells, select the cells and then click the _____ button on the Table Tools Layout tab

Merge cells

In which of the following views can you add notes that only the speaker can see

Normal view

The ____ pulls data from fields that you choose

Query Wizard

When you create a query, Access

Saves it as an object in the database

To set up a presentation that will run on its own, click the ___in the ___ group on the Slide Show tab

Set Up Slide Show button; Set Up

To display all the formulas in a worksheet at once, click the _____ button in the Formula Auditing group on the Formulas tab

Show Formulas

What happens to the default tab settings if you set a left tab at the 3-inch mark on the ruler

The default tab to the left of the new tab are cleared

If you copy a formula containing a relative reference and an absolute reference to a new location, what will happen?

The relative reference will automatically adjust, but the absolute reference will remain the same

If the spelling checker flags a word and you click the Ignore All button, what will happen

The spelling checker will not flag any more of the instances of that word

What is the function or purpose of Word's Format Painter

To copy the format settings from one area of selected text to another

A file that contains compressed data from multiple files is called a ___ file

ZIP

What does the Address bar in File Explorer dislay

a bread-crumb trail or path to the current folder location

What type of software application is Microsoft Excel

a spreadsheet program

Suppose that you have a customer table containing a field called State. If you click the first record in the State column and then click the Align Left button in the Text Formatting group on the Home tab, what record(s) will the formatting be applied to?

all the records in the State column

In Outlook, an activity that has a starting time and an ending time is called a(n)

appointment

In Excel, dates are stored ___ so they can be used in calculations

as sequential serial numbers

Pressing which key or combination of keys removes the character to the left of the cursor

backspace

To use the Auto Fill feature, make a cell active and then hover the mouse pointer over the lower right corner until the mouse pointer becomes a

black crosshair

When you insert a chart, the legend appears at the ___ of the chart

bottom

What do the letter CPU stand for

central processing unit

Rather than type a cell reference into a formula, you can _______ to add it to the formula.

click the cell on the worksheet

Which two placeholders appear on a title slide by default

click to add title and click to add subtitle

OneDrive is a _______ storage system

cloud

When creating a new record that is almost identical to an existing record, it is best to

copy the entire existing record and then make the necessary changes

A good way to call attention to one slice of a pie chart is to

explode the slice away from the rest of the chart

_____ is the process of decompressing files and saving them to a storage medium

extracting

A collection of related ___ makes up a record

fields

To save a newly created Word document, begin by clicking the ____ tab

file

To save a word document as a PDF file, click the ____ tab, click the save as option, click the save as type arrow, and then click the PDF option in the drop-down list

file

The purpose of creating a query is to

find records that meet a certain condition

Which of the following is not an input device

flash drive

You can change all of the following at the Font dialog box except

font theme

The way text appears on a page is called its

format

OneDrive files can be accessed from the website at which of the following URLs?

https://onedrive.live.com

What should you do if you accidentally delete a row or column

immediately click the undo button

Which buttons can be used to create multiple levels in a list?

increase indent and decrease indent

If a large number in a cell displays as a series of pound signs (###), you must ___for the contents to display properly

increase the column width

Input, processing, output, and storage are the four steps in the

information processing cycle

Because an Access report is linked to the objects used to create it

it automatically updates whenever changes are made to the data in those objects

Which of the following statements is true about header and footer formatting that is done on the Slide tab in the header and footer dialog box

it is automatically applied to every slide

To widen a column so it displays all the data, hover the mouse pointer over the right border until the pointer changes to a ____ and then double-click

left-and-right pointing arrow with a vertical line in the middle

You can use the slide master to

make formatting changes to all slides at the same time

When you increase the font size of the text in cell, you may need to

manually adjust column width or row height

The ____ is the thin sheet of fiberglass containing electrical pathways that connect the key components involved in the information processing cycle

motherboard

Moving through a hierarchy of folder is called

navigating

When you start Microsoft PowerPoint 2016, a blank presentation containing a single slide opens in ____ view

normal

How many data series can a pie chart contain

one

A database can best be described as a(n)

organized collection of related data

To prevent having duplicate entries in a field, assign a(n) ____ to the field

primary key

Which of the following is not a touchscreen gesture?

pull

To access a list of preformatted table styles, such as calendars and lists, click the table button in the tables group on the insert tab then choose

quick tables

Which of the following loses data when the computer is turned off?

random access memory

To enter an appointment that occurs on a regular basis, use the ___________ button

recurrence

Which presentation view displays the timings assigned to each slide

slide sorter

Once you have selected a transitional effect for a slide, a transition icon resembling a(n) _____ appears below each slide number in the slide thumbnails pail

sliding star

What is the best way to arrange database information in alphabetical order?

sort it

Which of the following would not be appropriate to include in a slide master footer placeholder

speaker notes

_____ are predesigned sets of fonts and paragraphs properties

style sets

A query extracts data from one or more

tables

An Access report is based on related

tables or queries

Give your contents a more polished and professional look by using predesigned documents called ______ which include text formatting and graphical elements

template

What does Excel's spelling checker feature review?

text

Layouts can include all the following elements except

text boxes

Which of the following performs the mathematical calculations and coordinates the functions of the computer system

the CPU

To end a presentation, right-click the current slide and then click End Show or press

the Esc key

Which of the following is one of the advantages of saving a Word document as a PDF file

the file will not be compromised as it might be if opened in different versions of Word

What happens when you check the Hide background graphics check box for an individual slide?

the graphic from the slide master are hidden on that slide

The colors used for text, slide backgrounds and graphical elements are preset by the ____ and any variant you apply

theme

Why might you choose to add axis titles to an Excel chart

to describe what the labels and numbers along each axis represent

Why would you use a query?

to pull data from one or more tables

In PowerPoint, the visual effects that occur when you move from one slide to the next in Slide Show view are called

transitions

The difference between a bar chart and a column chart is that a column chart has ___ bars and a bar chart has ___ bars

vertical; horizontal

Click the ____ button on the insert tab to search for a picture on the web

Online Pictures

To copy a format settings from one cell to another use the ____ tool

Format Painter

Windows automatically connects to the OneDrive server when you use your _____ to sign in to a Windows 10 computer connected to the Internet

Microsoft account

To save a Word document to OneDrive, you must first have a(n)

OneDrive account

File Explorer displays links to all available storage media, such as your

OneDrive folder

How can you edit the text on a slide

Select the text you need to change and then type the replacement text

Which view is used to run a slide show for an audience

Slide Show View

Use ____ to insert an organizational chart, pyramid, or similar diagram into a document

SmartArt

Changing the theme of a worksheet changes all the following characteristics except

page setup

Most Excel functions require that one or more arguments be surrounded by which of the following?

parentheses ( )

Font size is measured in

points

Adding records to a database is sometimes referred to as ___ the database

populating

When a USB flash drive is being used it must be connected to a USB _________ on your computer

port

Which of the following actions will cause the next slide in a presentation to display

pressing the right arrow key

Which of the following functions will cause the current date to display in the active cell? A. =(DATE) B. =TODAY() C. =DATE() D. =(TODAY)

=TODAY()

Which of the following is not a valid relational operator? A. > = B. < = C. > < D. >

> <

Which of these font effects is widely used for book and movie titles

italic

Which type of text alignment will give your document the look of a published book

justified

Which of the following terms are used to identify the two types of page orientations for Word documents

landscape and portrait

What is the default text alignment in Word

left

In a chart, the ___ tells you which piece of data each colored line or slice represents

legend

The software that manages the CPU, provides the user interface and supports operations such as saving files is called the

operating system

Which of the following characters can be used in a file name

period (.)

Each part of a _______ chart represents a percentage of the total quantity or amount

pie

To create a new folder, use the New folder button or _____ a blank area of the file list pane to open a popup list, click New, and then click Folder

right-click

To insert a column, _____ and then click Insert

right-click the column heading

Which of the following styles is not available for a numbered list

wingdings

How are the columns labeled in an Excel worksheet?

with capital letters (A, B, C, ...)

When you open Excel you can create a blank

workbook containing one worksheet

You can display the Outlook Calendar in each of the following views except a ____ view

yearly

Which of the following is not one of the advantages of using OneDrive

you download OneDrive files to access the content

Which of the following is an absolute cell reference? A. $C8 B. $B$6 C. C$4 D. A5

$B$6

When you type 6/12 into a cell, Excel automatically applies the _______ format

Date

Suppose your text runs slightly longer than one page. Which of the following is not one of the methods available in Word to get it to fit on one page

Reduce the spaces between characters

In the Find and Replace dialog box, click the ____ button to change all occurrences of an item

Replace All

When entering data in a table or form, use the ____ key to move to the next field

Tab

____ storage requires an internet connection and allows you to access data from any device

cloud

Microsoft Office 365 is an example of

cloud-based subscription software

Which type of chart compares differences between values?

column

In an Excel chart, you can place a data label at the outside or inside end of the ___ or centered on it

data point

Pressing which key or combination of keys removes the character to the right of the cursor

delete


Kaugnay na mga set ng pag-aaral

Cognitive Psychology Exam 4 (tutorial quizzes)

View Set

I know why the caged bird sings vocab

View Set