AIS Lynda Excel Tutorial Quizzes
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