CIS Final Exam Flashcards

Which Microsoft office application is a spreadsheet program?

Which tab do you click to display backstage view?

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

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

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

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?

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.

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

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

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

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

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

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

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

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

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

Which of the following displays frequently opened folders?

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

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

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

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

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

How are grammatical errors marked in a document?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

How many worksheets does a new excel workbook have?

The cell d3 refers to the cell at ______.

Which of these dates uses the long date format?

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

Formulas begin with which character?

Which of these cell references is an absolute reference?

Autosum is located_____.

The zoom slider is located _______.

The keyboard shortcut to begin the spelling checker is ____.

Which of these tasks can you perform in backstage view?

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

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

To split a cell into two cells ________.

To apply the double accounting underline format_____.

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

The keyboard shortcut to open the quick analysis tool is______.

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

You can remove conditional formatting using the _____.

Selecting a cell and pressing delete clears ______.

Where is the set print area command located?

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

Which of these functions returns the current date and time?

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

What is the definition of concatenate?

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

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

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

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

In a PMT function, what is the Pv argument?

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

What is the final step in creating a presentation?

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

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

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

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

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

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

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.

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

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

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

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

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

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

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?

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

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

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

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

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

_______are the basic building blocks of a database.

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

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

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

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

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

You can undo a record deletion.

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

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

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