Practice - Introduction to Excel

Which of the following are available text orientation options in orientation command? - Rotate text up - Horizontal text - Angle clockwise - Vertical text - Angle counterclockwise

Rotate text up Angle clockwise Vertical text Angle counterclockwise

Use the (Headings Print / Scale to Fit) feature to format your worksheet to fit on a designated number of pages.

Scale to Fit

You've copied text from a PDF to use in a worksheet. How can you open the Paste Special dialog box to paste the text without formatting into your worksheet? - Press Ctrl + + - Press Ctrl + Alt + V - Select File > Open - Select Home > Clipboard > Paste drop-down arrow > Paste special

Select Ctrl + Alt + V Select home > Clipboard > Paste drop-down arrow > Paste Special

The (COUNT / COUNTA) returns the number of cells in a range that contain values while (COUNT / COUNTA) counts the number of cells that aren't empty in a range of text.

COUNT COUNTA

When moving a cell to a new location that has data, clicking (OK / cancel) on the warning dialog box leaves the cell in its previous location.

Cancel

Which mathematical operator is used to perform multiplication? - ^ - \ - / - *

*

Use the (Header/Footer / Headings Print) feature to add column letters and row numbers to a printout.

Headings Print

The (IF / ISLOGICAL) function displays a value based on a comparison.

IF

Data can be imported into workbooks from which types of plain text files? - .doc - .txt - .csv - .docx

.txt .csv

Which of the following table names contain an error? - _Values - 1stQuarter - PartsCosts - Dog Breed - Sales%

1stQuarter Dog Breed Sales%

Which of the following statements about cells are correct? - A cell is an intersection of a row and a column. - An active cell is called the cell reference. - D4 is an example of a cell name. - The name of a selected cell is displayed in the formula bar.

A cell is an intersection of a row and a column. D4 is an example of a cell name.

In Excel, which of the following are sort options for tables? - A to Z - By color - By relevancy - Z to A - By date

A to Z By color Z to A

The function (SUM / AVERAGE) adds the values in a range and then divides the total by the number of values

AVERAGE

Pressing which keyboard shortcut will open the Excel Search box? - Alt + S - Ctrl + C - Alt + Q - Ctrl + V

Alt + Q

When creating a new table, Excel automatically: - Calculates totals - Sorts in ascending order - Applies formatting - Sorts in descending order

Applies formatting

Using which of the following fonts will make labels easier to read? - Arial - Times New Roman - Calibri - Palatino Linotype - Tahoma

Arial Calibri Tahoma

You printed a worksheet with a chart, but part of the chart is cutoff on the page. Which steps can you try to correct the problem? - Change the worksheet margins - Drag the chart below - Resize the chart - Zoom out on the worksheet

Change the worksheet margins Drag the chart below Resize the chart

The (clear all / clear content) feature removes content in selected cell, rows, or columns, along with any formatting and comments.

Clear all

The (clear content / clear comments and notes) feature removes the comments or notes associated with the select cell, row, or column.

Clear comments and notes

The (clear comments and notes / clear formats) feature removes the formatting associated with the selected cells, rows, or columns.

Clear formats

The (clear hyperlinks / clear all) feature removes any formatted hyperlinks that are associated with the selected cell, row, or column.

Clear hyperlinks

What should you do in Excel to avoid typing errors when creating a cell reference? - Type the name of the cell - Click the cell - Highlight the column - Press Ctrl + V to paste the name of the cell

Click the cell

Which steps can you take to remove all the data you've just typed from a cell? - Press Ctrl + Shift - Click Cut on the Clipboard group - Click the cell, then press Delete - Click Undo on the Quick Access Toolbar - Press Ctrl + Z

Click the cell, then press Delete Click Undo on the Quick Access Toolbar Press Ctrl + Z

What is referenced when formulas are inserted into a table? - Column headings - Table names - Cell references - Row headings

Column headings Table names

Clicking (cut / copy) allows you to duplicate data in a cell.

Copy

Which step should you take to best fit a column for lengthy text? - Press Tab at the end of the text - Drag the column boundary to the end of the text - Double-click the column boundary - Merge the column with the adjoining column

Double-click the column boundary

Which of the following features will allow you to search in a table for data that meets multiple criteria? - Total row - Filter - Sort - Analyze

Filter

Themes include which of the following? - Fonts - Effects - Colors - Graphics

Fonts Effects Colors

You used a specific font and text highlight color on a cell and would like to apply that formatting to several other cells in your worksheet. What command should you click yo do this? - Conditional Formatting command - Format Painter command - Paste command - Themes command

Format Painter command

Where does the text appear when typing in an active cell? - Formula bar - Name box - Status bar - Search box

Formula bar

Use the (Header/Footer / Margins) feature to add information to be printed at the top or bottom of each printed page.

Header/Footer

Which of the following statements about worksheet graphics are correct? - Images can be inserted within specific cells. - Images can be resized and rotated. - Formatting can be applied to images. - Images are freely moving objects.

Images can be resized and rotated Formatting can be applied to images Images are freely moving objects

Which Excel chart element labels the chart components based on categories in the first column of data? - Chart area - Chart title - Slice - Legend

Legend

The function (MIN / MAX) returns the minimum value in a range of cells.

MIN

Use the (Margins / Scale to Fit) feature to change the space around the worksheet when printed.

Margins

Which of the following are available border options in border command? - No border - Diagonal border - Thick bottom border - Outside borders - All borders

No border Thick bottom border Outside borders All borders

When moving a cell to a location that has data, clicking (OK / cancel) on the warning dialog box replaces the cells contents.

OK

What are two ways to access the Text Import Wizard? - Select data > get external data > from text, and then select the desired text document from the Import Text File dialog box - Select Insert > Text box - open a text file using File > Open - Drag and drop a text file into the workbook

Select data > get external data > from text, and then select the desired text document from the Import Text File dialog box Open a text file using File > Open

Which steps can you take to view all the formulas in your worksheet? - Select show formulas on the formulas tab - Press Ctrl + ; - Select lookup & reference on the formulas tab - Press Ctrl + '

Select show formulas on the formulas tab Press Ctrl + '

You have the option to insert which of the following in your worksheet? - Sheets - Cells - Workbooks - Rows - Columns

Sheets Cells Rows Columns

Cell contents refer to - a cell's label - a cell's row - a cell's column - data contained in a cell

a cell's label data contained in a cell

A range refers to - a series of selected cells - the intersection of a row and column - an individual selected cell - a series of selected worksheets

a series of selected cells

Clicking (cut / copy) allows you to move data in a cell.

cut