Which Microsoft office application is a spreadsheet program?

excel

Which tab do you click to display backstage view?

file

Which of the following mouse commands will display a shortcut menu?

right click

If you have downloaded a file from the internet and it opens in protected view, you should never open the file.

false

Which part of the office interface is located across the top of the application window and organizes common features and commands into tabs?

ribbon

Which of the following includes information about a file such as the location of the file, the size of file, when the file was created and when it was last modified, the title, and the author?

files properties

When you save files to your OneDrive, they are available to access from other computers that have OneDrive capability. If you are working on an excel or word file, others can be working on the same file at the same time you are work on the file.

true

You can change user information from which page in backstage view?

account

Which keyboard shortcut allows you to paste an item from the clipboard?

control+v

Clicking close in backstage view will close the file and exit the app.

false

Which part of the file explorer window shows the location of the current folder?

navigation pane

When you open a file, windows will always ask you to choose an application to open the file with.

false

Which of the following keyboard commands will create a new folder in the file explorer window?

control+shift+N

Which key do you press to select multiple flies that are not adjacent to each other in the file list?

control

Use the copy command to remove a file from one location and copy it to another.

false

Which of the following symbols cannot be used in a file name?

asterick(*)

Which of the following displays frequently opened folders?

home list

Which of the following displays information about a file, including the location, size, and last modified date?

properties dialog

Which feature allows you to combine and compress multiple files into a single file?

zip

You have just downloaded a document from SIMnet. Where will you find the file?

download folder

Which feature in word automatically places text on the next line when the right margin of the document has been reached?

word wrap

Which of the following actions is used to select a paragraph of text?

tripe click the paragraph

How are grammatical errors marked in a document?

blue double underline

In the editor pane, which command will prevent the word from being marked as a misspelling in all the office applications, not just word?

add to dictionary

Which command would you use to copy text to the clipboard and remove it from the document?

cut

Which paste option pastes the text with the original formatting of the copied text?

keep source formatting

Which of the following opens when you use the find command?

navigation pane

Which command would you use to replace all instances of a word with another word?

replace all

Which would you use to magnify the text onscreen, making the text appear larger?

zoom in button

In addition to the number of words in a document, what else does the word count dialog display?

the number of pages

Which type of font has an embellishment at the end of each stroke to lead the eye from one character to the next?

seriff

Which command would you use to change the text from uppercase to having each word capitalized?

change case

Which command would you use to call attention to text by coloring the background behind the text?

text highlight color

Which command is used to copy the styles from one word to another?

format painter

Styles ensure parts of your document, such as headings, all use the same formatting.

true

Which kind of list would you use for instructions that do not need to be performed in a certain order?

bulleted list

Which command do you use to evenly space words, aligning the text on the right and left sides of the printed page?

justify

Which command displays hidden formatting marks in a document, including paragraph and spacing marks?

show/hide

You can adjust the amount of space that appears before and after paragraphs from the view tab on the ribbon.

false

Which tab stop displays the text to the left of the tab stop?

right tab

Which of the following is a group of formatting elements you apply to a document?

theme

A ________changes the font and paragraph formatting for an entire document based on styles.

style set

A ______is a graphic or text that appears as part of the page background and is usually faded in appearance.

watermark

The text that appears at the top of every page, just below the top margin is known as what?

header

A piece of content that is reusable in any document, such as a cover page or a watermark, is known as a _____.

building block

Which of the following would you use to add your company’s name over and over again in a document without typing it every time?

property control

What are the blank spaces at the top, bottom, left, and right of a page known as?

margins

Which of the following will add text that when clicked will take you to another place in the document?

hyperlink

What would you use to force text on a new page that will have its own settings separate from the rest of the document?

section break

What would you type in the pages box on the print page to print only the fourth and seventh page in a document?

4,7

How many worksheets does a new excel workbook have?

one

The cell d3 refers to the cell at ______.

the intersection of column D and row 3

Which of these dates uses the long date format?

Saturday, January 1, 2022

Data markers are graphic representation of the values of data points in a chart.

true

Formulas begin with which character?

=

Which of these cell references is an absolute reference?

$b$8

Autosum is located_____.

on the home tab, in the editing group

The zoom slider is located _______.

at the lower right corner of the status bar

The keyboard shortcut to begin the spelling checker is ____.

f7

Which of these tasks can you perform in backstage view?

enable editing when a workbook is in protected view, preview how a workbook will look when printed, create a new workbook from a template

When you cut and paste a cell containing a formula with relative references, excel_______.

does not update the cell references to the new location and treats the formulas as if it contained absolute reference

Which paste option pastes formulas and number formatting but none of the cell formatting?

formulas & number formatting

To split a cell into two cells ________.

you cannot split a cell into two cell; you can only unmerge merged cells

To apply the double accounting underline format_____.

in the font dialog, on the font tab, expand the underline list and select double accounting

Clicking the borders button on the ribbon applies which border style?

the most recently used border style

The keyboard shortcut to open the quick analysis tool is______.

control+Q

To highlight cells with values in the top 10% of the select range, use _______conditional formatting.

top/bottom rules

You can remove conditional formatting using the _____.

clear rules from selected cells command

Selecting a cell and pressing delete clears ______.

cell content only

Where is the set print area command located?

on the page layout tab, in the page setup group

Which of these methods can you use to enter a formula using the AVERAGE function?

formula Autocomplete, autosum, function arguments dialog

Which of these functions returns the current date and time?

NOW

To count the number of cells that contain text or numerical values, but not blanks, use which function?

COUNTA

What is the definition of concatenate?

to link items together

A formula to display the value of cell A5 on the inventory worksheet looks like this:

=inventory!a5

Which of these is not an acceptable name for a named range?

current inventory

Identify the value_if_true argument in this formula:=IF(A2>100, “High”, “low”)

high

Identify the Pv argument in this formula=PMT(B1/12,B2,-B3)

-B3

In a PMT function, what is the Pv argument?

the present value of the loan

A ______is the cell containing a formula that references the value or formula in the selected cell.

dependent

What is the final step in creating a presentation?

practice your presentation

Using the same font style on the title for each slide is an example of which design principle?

recurrence

Which view would you use to view the presentation as your audience will see it?

slide show view

Which are predefined areas in slide layouts where you enter text?

text placeholders

Which type of font has an embellishment at the end of each stroke?

seriff

Which command would you use to copy and paste formatting from one object to another?

format painter command

Which command aligns text along the upper edge of a text placeholder?

top

If a list includes more items than will easily fit vertically on a slide, you should use the command to display the items side by side.

columns

Which command would you use to locate specific instances of text in your presentation?

find

What is the keyboard shortcut for reversing the last action you performed?

control+Z

When creating slides from a word outline, text with which style applied to it will become the main text on each slide?

heading 2

Which command would you use to copy text to the clipboard and remove it from the presentation?

cut

Which would you use to display items in a list in a particular order?

numbered list

Text that includes predefined graphic styles, such as shadows, reflections, and glows, is known as _____.

wordart

Which of the following is a special type of placeholder that gives you a quick way to add a variety of material to your presentations?

content

What is the intersection of a row and column in a table called?

cell

Which of the following are visual diagrams containing graphic elements with text boxes in which you enter information?

smartart

Which of the following are added to a document as an SVG image?

icons

Which of the following graphic objects can be rotated along three different axes?

3d models

Which command hides the sound icons and play an audio file across the entire presentation?

play in background button

_______are the basic building blocks of a database.

tables

Each row in a table contains all the data for a single ____.

record

Each column in a table represents a specific data value called a ______.

field

All data entered into a form are stored in the underlying______.

table

You must manually save the record each time you enter data in a table or form.

false

When you are entering data in a new record in a form, the UNDO command will _____.

undo the entire record at once

You can undo a record deletion.

false

To rename a database object, double click the name in the navigation pane and type the new name.

false

When sorting a datasheet on more than one field, apply the ______first.

innermost sort

Creating a backup of the database removes unnecessary file space and hidden, temporary objects from your database.

false