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