Excel Essential Training Exam 34 Questions with Verified Answers
In Excel, a file is a ____________. - CORRECT ANSWER workbook
You click once a cell
... [Show More] that has the word "cat" in it and begin typing the word "dog", and then hit Return on your keyboard. The cell - CORRECT ANSWER now says "dog"
The most effective way to add up five different cells in a row is to _____ (after typing the equal sign into the formula bar). - CORRECT ANSWER use the function SUM, type an open parenthesis, and the highlight the five cells
What is true of formatting cells to a particular category, such as Accounting or Currency? - CORRECT ANSWER This adjusts the display of your data, but not the data itself
When moving or copying data from one cell to another, in order to maintain the formulas of the original cell you must _____. - CORRECT ANSWER simply complete the action. Excel maintains the formulas for you
Which of the following is not type of Sparkline (mini chart)? - CORRECT ANSWER Scatter
_____ means "exact match" when creating a VLOOKUP. - CORRECT ANSWER FALSE
If you highlight a column and then click the Sort alphabetically button (A-Z), - CORRECT ANSWER only the data in the column is sorted
All of the following are required to begin creating a PivotTable, except: _____. - CORRECT ANSWER Begin with an equal sign and open parenthesis
A macro is a way to automate a sequence of steps in your work. - CORRECT ANSWER true
Excel is _____. - CORRECT ANSWER all of these answers
You highlight a column of data in a worksheet. In the status bar below, you'll see all of the following by default, except: _____. - CORRECT ANSWER Minimum and Maximum values
You can create a new workbook by pressing Ctrl+n on your keyboard, or for a greater variety of options, - CORRECT ANSWER navigating to File > New
Date entries are numbers and, by default, - CORRECT ANSWER lined up on the right side of the cell
Save is a safer way to save your work than Save As. - CORRECT ANSWER False
When you copy a formula into an adjacent cell, Excel will adjust the corresponding columns/rows to fit that cell. - CORRECT ANSWER true
How can you access font styles and effects other than what is presented by default on the Home ribbon tab? - CORRECT ANSWER click the dialog box launcher in the bottom right-hand corner of the Font section
How can you insert a new row into your data without disturbing an adjacent set of data on the same sheet? - CORRECT ANSWER highlight only the data where you'd like to insert a row. Right-click>Insert...>Shift cells down
All of the following are ways to print your spreadsheets with greater efficiency, except: - CORRECT ANSWER Remove all headers and footers
To create a chart, you begin by _____. - CORRECT ANSWER selecting data
Which of the following is not type of Sparkline (mini chart)? - CORRECT ANSWER Scatter
To see multiple worksheets from different files at once, - CORRECT ANSWER Click on the view tab > Arrange All
A fast way to make a copy of a sheet in the same workbook is to drag the sheet tab with the _____ key held down. - CORRECT ANSWER CRTL
When creating an IF function, a _____ separates the "logical test" from the "value if true/false". - CORRECT ANSWER comma
_____ means "exact match" when creating a VLOOKUP. - CORRECT ANSWER FALSE
If you lock a cell and then protect the worksheet, _____. - CORRECT ANSWER the cell cannot be edited by others.
Workbooks containing _____ cannot be shared. - CORRECT ANSWER tables
If you highlight a column and then click the Sort alphabetically button (A-Z), - CORRECT ANSWER only the data in the column is sorted.
There are unique filtering options for text and number entries. - CORRECT ANSWER true
Data validation allows you to _____. - CORRECT ANSWER restrict or limit data entry to your specifications (i.e. only positive numbers, maximum of 10 characters, etc.).
Goal Seek is a tool that - CORRECT ANSWER allows you to see how changing one data item in a formula affects the others
ll of the following are required to begin creating a PivotTable, except: _____. - CORRECT ANSWER Begin with an equal sign and open parenthesis.
Slicers provide you with _____ for filtering PivotTable data and visualizing what you have filtered. - CORRECT ANSWER buttons
A macro is a way to automate a sequence of steps in your work. - CORRECT ANSWER true [Show Less]