AIS Lynda Excel Tutorial Quizzes

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Suppose you highlight a column of data in an Excel worksheet. In the status bar below, you'll see all of the following

-Caps and Numlock -Average and Sum -Average and Count

What is Excel?

-an application where data can be illustrated with a chart -a program used for maintaining large lists of data -spreadsheet package

Typical uses for Excel

-analyzing sales data -tracking customer information -creating a budget spreadsheet

What are required to begin creating a PivotTable?

-headings should be in. single row at the top of the source data -source data must not have empty rows or columns -source data must be organized as a list or table

All of the following are ways to print your spreadsheets with greater efficiency, except:

-remove all headers and footers

Review this formula: =VLOOKUP(B2,D:F,3,?) If you're trying to use VLOOKUP to find an exact match, what value should replace the question mark?

0

What is the maximum number of worksheets that can be undeleted using the Undo command?

0

If you type 7/6/20 into a cell and press Enter, what data will be displayed by default?

7/6/2020

Suppose cell A2 contains the formula =B2+B3. You select A2, then drag the AutoFill fill-handle in the lower-right corner down several cells. What formula now appears in cell A3?

=B3+B4

What is the best formula for adding together five adjacent values in a column?

=SUM()

If you want to copy just the VISIBLE data in a selection, you can use Home > Find and Select > Go To Special > Visible Cells Only. What's a much simpler way to do this using a keyboard shortcut?

Alt + ;

You've selected a section of data and now want to generate a chart. What keyboard shortcut should you use to create the chart?

Alt + F1

Suppose you have a long list of text values in column A. You want to calculate how many times the word "overstock" appears in column A. What function should you use?

COUNTIF(A:A,"overstock")

How can you see multiple worksheets from different files simultaneously?

Click on View > Arrange All.

How can you access font styles and effects other than what is presented by default on the Home ribbon tab?

Click the dialog box launcher in the bottom right-hand corner of the Font section.

In order to use Slicers to filter some data, what must you first do to that data?

Convert the data into a table.

A fast way to make a copy of a sheet in the same workbook is to drag the sheet tab while holding down the _____ key.

Ctrl

Which of the following is NOT a way to add a comment to a cell?

Ctrl + C

How can you create a copy of an existing chart?

Ctrl + D

You can Redo the latest action using the Quick Access Toolbar. You can also Redo using the keyboard shortcut _____.

Ctrl + Y

You can Undo the latest action using the Quick Access Toolbar. You can also Undo using the keyboard shortcut _____.

Ctrl + Z

You can copy a worksheet by right clicking it, selecting 'Move or Copy', and checking the 'Make a Copy' checkbox. What's a faster way to copy a worksheet?

Ctrl + drag the worksheet tab.

What's the keyboard shortcut to call up the Format Cells dialog box?

Ctrl/Cmd + 1

What's the keyboard shortcut to launch the Help system?

F1 key

T or F: If you delete a worksheet, you can bring it back using the Undo command.If you delete a worksheet, you can bring it back using the Undo command.

False

T or F: Save is a safer way to save your work than Save As.

False

To save a file in a particular style (like CSV, PDF, or older Excel) where should you navigate?

File > Save As > Save As Type

Suppose you create a PivotTable and then make changes to the source data for that PivotTable. You return to the PivotTable, and notice that the changes are not showing up. What do you need to do?

Go to Analyze > Refresh to update the PivotTable.

How can you insert a new row into your data without disturbing an adjacent set of data on the same sheet?

Highlight only the data where you'd like to insert a row. Right-click > Insert > Shift cells down.

If you want to set up Data Bars, Color Scales, or Icon Sets, where should you go?

Home > Conditional Formatting

Suppose column A contains a wide range of number values. You want the cells with values >20 to be highlighted with a color. Where can you find a tool to achieve this?

Home > Conditional Formatting

What's the best method for adding a hexagonal graphic to your spreadsheet?

Insert > Shapes

If you highlight a column and then click the button to Sort Alphabetically (A-Z), what happens?

Only the data in the column is sorted.

To control the display of comments, what tab should you go to?

Review

You can add items to the Quick Access Toolbar (top left corner) using its drop-down arrow. What's another way to add items to this toolbar?

Right-click any tool icon, then click 'Add to Quick Access Toolbar'.

What action should you take if you want to assign a password to your workbook?

Save As > Tools > General Options

Which of the following is not a type of Sparkline (mini chart)?

Scatter

What is the primary advantage of Slicers when viewing a PivotTable?

Slicers allow you to see which fields in the PivotTable are being shown and which are hidden.

What happens if you double-click the right side of a column's header?

The column width adjusts to fit the largest entry in that column.

What is true about formatting cells to a particular category, such as Accounting or Currency?

This adjusts the display of your data, but not the data itself.

T or F: A macro is a way to automate a sequence of steps in your work.

True

T or F: There are unique filtering options for text and number entries.

True

T or F: When you copy a formula into an adjacent cell, Excel will adjust the corresponding columns/rows to fit that cell.

True

T or F: Worksheets are individual sets of data within a workbook.

True

When you right-click on a cell, what happens?

a shortcut menu appears

The AutoSum tool first looks for values _____ the selected cell, then looks for values _____ of the selected cell.

above....to the left

Suppose a cell contains the formula =(E3*$H$2) * E3. The variable $H$2 is a(n) _____ reference.

absolute

What does the Goal Seek tool do?

allows you to see how changing one data item in a formula affects the others

Suppose cell B2 in a spreadsheet contains the formula: =if(A1>100,'bazinga','zippo") If cell A1 contains the value 425, what value appears in cell B2?

bazinga

Slicers provide you with _____ for filtering PivotTable data and visualizing what you have filtered.

buttons

Your notice that a worksheet displays columns A, B, C, E, F, and G. What happened to column D?

column D is hidden

When creating an IF function, a _____ separates the logical test from the value if true/false.

comma

Suppose you single-click on a cell that contains the word "cat", then type the word "dog", and then press the Enter key. What does the cell now display?

dog

If you're using the VLOOKUP function for an approximate match, not an exact match, how must data in the left column of the lookup table be arranged?

in numerically ascending order

A linking formula references cells _____.

in other worksheets of the current workbook or in worksheets in another workbook .

Date entries are numbers and by default they _____.

line up on the right side of the cell

You can create a new workbook by pressing Ctrl + N on your keyboard. An alternative method is to _____.

navigate to File > New

What is the maximum number of steps that can be recorded in a macro?

no limit

How can you add a manual line break to the data within a cell?

press Alt + Enter

Locking or unlocking cells in a worksheet does not have any meaningful effect until you _____ the overall worksheet.

protect

What does data validation allow you to do?

restrict or limit data entry to your specifications (i.e. only positive numbers, maximum of 10 characters, etc.)

To create a chart, you begin by _____.

selecting data

When moving or copying data from one cell to another, in order to maintain the formulas of the original cell you must _____.

simply complete the action. Excel maintains the formulas for you.

The zoom slider bar lets you enlarge or shrink the data shown on screen. Where is it located?

status bar at bottom of screen

Workbooks containing _____ cannot be shared.

tables

What does the solid blue line indicate in Page Break Preview mode?

the boundary between data that that will and won't print

To create a macro that can be used in any workbook that you open on your current computer, you should store it in _____.

the personal macro workbook .

What the main purpose of the Freeze Panes command?

to keep information from scrolling off the screen

The most effective way to add up five different cells in a row is to _____.

use the SUM function

In Excel, a standalone file is called a _____.

workbook


संबंधित स्टडी सेट्स

ELC 401 Final (Completion Portion)

View Set

Organizational Behavior: Chapter 12 leadership

View Set

CIST 1130 Midterm Practice CH.2,4,7 & 8

View Set

Chapter 9 Teaching and Counseling

View Set