Microsoft Excel 2019 Final Exam Study Guide
PEMDAS is the acronym for
Parenthesis, exponents, multiplication, division, addition, subtraction
A formula is used in an Excel workbook to
Perform mathematical operations such as add, subtract, multiply, or divide data
Instead of removing all the commands you added to the Quick Access Toolbar, you can use the _________________ tool to set it back to only the default commands.
reset
The _________________ key moves one cell position to the right of the currently selected cell.
tab or right arrow
When you've copied data, which of the following is a correct method to paste it somewhere else? a. Select where you want to paste the data, and then select enter on your keyboard b. Right-click or access the context menu for where you want to paste the data, and select Paste c. Select where to paste, and then select Ctrl+V d. Right-click or access the context menu for where you want to paste the data, and then select Paste here
A, B, C
The types of alignment for contents of a cell include: a. Horizontal b. Vertical c. Italic d. Rotation
A, B, D
Which format can a workbook be saved in? a. .xlsx b. .xlxs c. .xls d. .xlsm
A, C, D
Like a standard formula, a function begins with an equal sign (=). True or False? a. True b. False
A.
Review the following formula: =$C$2*A7. This formula uses which of the following reference types? a. Absolute b. Relative c. Mixed d. Worksheet
A.
When you select all the columns in your worksheet and double-click on a column divider, that is known as _________________.
AutoFit
How can you access Backstage view? a. Windows key b. Select File c. Select Home d. Ctrl+B
B
To display text in a cell turned on its side or on an angle, you change the _________________. a. Position b. Orientation c. Wrapping d. Margins
B
Which command do you use to change the color of a cell background? a. Background color b. Fill color c. Border color d. Font color
B
Which is the correct shortcut to access the Replace feature? a. Ctrl+G b. Ctrl+H c. Ctrl+R d. Ctrl+I
B
When a cell or a range has a defined name, what is that known as? a. Range b. Named range c. Named cell d. Defined cell
B and C
Which of the following processes can you use to rename a worksheet? a. Right-click in any blank cell and select Rename Sheet b. Right-click on the sheet tab and select Rename c. Select Format in the Cells group and select Edit Sheet Name d. Select Format in the Cells group and select Rename Sheet
B and D
Which following operator is used to divide in Excel? a. * b. / c. ^ d. @
B.
Which function is used to add specified values? a. AVERAGE b. SUM c. COUNT d. MAX
B.
Which keyboard shortcut can you use to toggle relative, absolute, and mixed references? a. F1 b. F4 c. F6 d. F8
B.
Which of the following is a valid named range? a. A7 b. Sales_Data c. Sales Data d. Sales\Data
B.
The keyboard shortcut to access the Paste Special dialog box is: a. Ctrl+Alt+A b. Ctrl+V c. Ctrl+Alt+V d. Ctrl+Shift+P
C
To delete a column in a worksheet, you can select the column header and use which of the following keyboard shortcuts: a. Ctrl+Plus Sign (+) b. Ctrl+Slash (/) c. Ctrl+Hyphen (-) d. Ctrl+Asterisk (*)
C
To paste copied data from horizontal to vertical, which option would you use from Paste Special? a. Values b. Formulas c. Transpose d. Formatting only
C
Which of the following symbols specifies an absolute reference? a. % b. & c. $ d. @
C.
The ________ function counts all the nonblank entries in a range.
COUNTA
To display a cell's value with a money symbol and two decimal places, you would apply a _________________ number format.
Currency or Accounting
If you have an Excel workbook as a 97-2003 version, what will the file extension be? a. .xlsx b. .xlxs c. .xlt d. .xls
D
To make text and numbers inside a cell large, you need to use the _________________ formatting option.
Font Size and Increase Font Size
The _________________ tool allows you to copy formatting from one selection and paste it onto another space.
Format Painter
A _______ is a predefined formula used for specific purposes and calculations.
Function
The _________ command helps you search and select a function to be used in a worksheet.
Insert Function
The box directly under the ribbon, on the left side of the screen is known as the _________________ box?
Name
The Find command is located on the Find & _________________ button on the Home tab.
Select
To display formulas in the worksheet, you can select the _________ command in the ribbon.
Show Formulas
You can use the Replace feature to find specific formatting and replace with different formatting. True or False?
True
Select the _________________ next to the formula bar to complete a data entry into a cell and remain in the same cell.
check mark
When you cut data from a cell, Excel adds it to the _________________.
clipboard
Ctrl+C is the keyboard shortcut to _________________ data?
copy
When you access File > Open, you can switch between workbooks and _________________.
folders
The option that allows you to copy data that is vertical and paste it horizontally is known as _________________.
transpose
You can find Freeze panes on the _________________ tab.
view
By default, when you select Enter to complete a cell entry, where will the active cell be? a. In the row below b. In the row above c. In the next cell to the left d. In the next cell to the right
A
If cell A1 contained the number 1 and you used AutoFill to fill the cells automatically down to A20, what number would be in cell A20? a. 20 b. 10 c. 2 d. 1
A
In the bottom left corner of the Microsoft Excel interface which of the following screen views are not available? a. Print preview b. Page break preview c. Page layout d. Normal
A
To insert a row into a worksheet, you can select the row header and use which of the following keyboard shortcuts> a. Ctrl+Plus Sign (+) b. Ctrl+Hyphen (-) c. Ctrl+Asterisk (*) d. Ctrl+Slash (/)
A
Which is the correct shortcut to copy a worksheet to another sheet in the same workbook? a. Select the sheet to copy, then use Ctrl, drag and drop b. Select the sheet to copy, then use drag and drop c. Select the sheet to copy, then use Shift, drag and drop d. Select the sheet to copy, then use Alt, drag and drop
A
Which of the following statements are true? a. The Quick Access Toolbar can be moved to beneath the ribbon b. The Quick Access Toolbar cannot be reset to default settings c. The Quick Access Toolbar cannot be moved beneath the ribbon d. The Quick Access Toolbar cannot be hidden from view
A
Which of these methods can you use to set the width of a column in a worksheet? a. Double-click between a column divider to make it AutoFit b. Select the divider between 2 rows and drag up or down c. Right-click or access the context menu for a column header and select Row Height d. Select Format in the Cells group and select Row Height
A
To create a new workbook: a. Go to File > New b. Select Ctrl+N on your keyboard c. Select Ctrl+O on your keyboard d. Go to File > Open
A and B
Where would you use Headings cell styles? a. Cells at the top of a column of data b. Cells that label rows of data c. Cells that contain totals d. Cells that contain comments
A and B
When you have a column name that is much longer than the data in the column's values, what options make it possible to display the entire name without making the column wider? a. Apply Wrap Text to the column name b. Indent the column name c. Change the worksheet margins d. Rotate the column name text
A and D
Which of these methods can you use to insert a new row in a worksheet? a. Right-click or access the context menu for a row number, select Insert b. Right-click or access the context menu for a column header, select Insert c. Right-click or access the context menu for a cell, select Insert Entire Row d. Home, Cells group, Insert > Insert Sheet Rows
A and D
Which of these methods can you use to set the width of a row in a worksheet? a. Select Format in the Cells group and select AutoFit Row Height b. Right-click on a row header and select Column Height c. Double-click between a column divider to make it AutoFit d. Right-click on a row header and select Row Height
A and D
Cell styles can help you to _________________. a. Keep consistency in formatting b. Make your worksheets easier to read c. Apply formatting more quickly d. Perform calculations
A, B, C
The Quick Access Toolbar has which commands by default? a. AutoSave b. Save As c. Undo d. Redo
A, C, D
Which of the following options can you use to format the contents of a cell? a. Font Size b. Sort c. Italic d. Underline
A, C, D
Which of following operators is used to multiply in Excel? a. * b. / c. ^ d. X
A.
You want to add a range of cells and then divide by the number of cell entries. Which function can help you with this task? a. AVERAGE b. COUNT c. IF d. MAX
A.
The COUNT function counts the following value types: a. Numeric constants b. Numeric cell ranges c. Text values d. Empty cells e. Numeric cell references
A. , B. , and E.
If you used AutoFill to fill Jan from cell A1 across to L1, which of the following AutoFill options will be available to select? a. Copy cells b. Fill formatting only c. Fill without formatting d. Fill months
All of the above
You can customize the Quick Access Toolbar via which method? a. Right-click or access the context menu of a button on the ribbon and add it. b. Right-click or access the context menu on the ribbon and select Customize Quick Access Toolbar c. On the File tab, select Options, and then select the Quick Access Toolbar d. Right-click or access the context menu on top of a button on the Quick Access Toolbar and remove it
All of the above
How can you most efficiently copy all Font, Cell, Alignment, and Number formatting from one cell to multiple other cells? a. Select the one cell with the formatting that you want to copy, select the Copy command, select the other cells, and then select the Paste command b. Select the one cell with the formatting that you want to copy, double-click the Format Painter command, select the other cells, then select the Format Painter command to turn it off c. Select the one cell with the formatting that you want to copy, use the Format Cells command, and then select the other cells d. Select the one cell with the formatting that you want to copy, select and hold Ctrl while you select the other cells, and then select the Format Painter command
B
If you double-click a ribbon tab twice, what happens to the ribbon? a. It disappears b. It will show tabs only c. It will auto hide d. It will move to the bottom of the screen
B
Two of the main format options for a cell's appearance are: a. Fill Color and Table b. Border and Fill Color c. Page Layout and Border d. Print Layout and Fill Color
B
What is the keyboard shortcut to search for data in a workbook? a. Ctrl+E b. Ctrl+F c. Ctrl+G d. F5
B
When you are in the Excel application, what shortcut key can you use to open an existing workbook? a. Ctrl+Alt+O b. Ctrl+O c. Shift+O d. Ctrl+Shift+O
B
Which statement is true? Select all that apply. a. There is no difference between using Convert or using Save As to upgrade a workbook to the latest version of Excel. b. Converting a file replaces the old version file with a new version file, leaving one copy. c. When a file is converted, you'll be able to use the full functionality of Excel. d. A file saved in an older version of Excel cannot be opened in Excel 2019.
B and C
Which statement is true? Select all that apply. a. When you've right-clicked or accessed the context menu on a cell where you want to paste data, Paste Special is not available on the context menu b. When you've right-clicked or accessed the context menu on a cell where you want to paste data, you can select Paste Special on the context menu. c. When you've copied data, you can access Paste Special using Ctrl+Alt+V d. The Paste Special button can be found on the Paste drop-down arrow on the Home tab.
B, C, D
The formula =6*2/3 produces the same result as =6*(2/3) a. True b. False
B.
To position text equally between the top and bottom of a cell, which alignment setting would you use? a. Merge cells b. Orientation c. Vertical alignment d. Shrink to fit
C
What is the keyboard shortcut to cut data from a cell? a. Ctrl+C b. Ctrl+D c. Ctrl+X d. Ctrl+Z
C
Where on the ribbon will you find cell styles? a. Home tab, Font group b. Page Layout tab, Themes group c. Home tab, Styles group d. Insert tab, Illustrations group
C
Where will you find the formula bar? a. File > Open b. File > Options c. Directly below the ribbon d. On the Quick Access Toolbar
C
Which area of the Excel application has the following three commands: Save, Undo, and Redo? a. Status Toolbar b. Mini Toolbar c. Quick Access Toolbar d. Formula Bar
C
Which of the following commands does not belong to the Windows group on the View tab? a. Hide b. Split c. Zoom d. Arrange All
C
What is the keyboard shortcut to go to elements of a workbook? a. Ctrl+E b. Ctrl+F c. Ctrl+G d. F5
C and D
When you are in the Excel application, what method can you use to save an existing workbook with a different name? a. F11 b. File > Save c. F12 d. File > Save As
C and D
What is the answer to the following calculation: (4+6)*2-10/2 a. 5 b. 3 c. 15 d. -30
C.
Which of the following operators is used to start a formula in Excel? a. * b. / c. = d. $
C.
Which of the following symbols can you use to override the order of operations? a. " " b. @ c. ( ) d. *
C.
Which of the following are not evaluated in the MAX or MIN functions? a. Cells with number values b. Ranges with number values c. Empty cells d. Text values in the specified range
C. and D.
If you used AutoFill to fill Quarter 1 into cell A1 down to A5, what would the contents of A5 contain? a. Quarter 5 b. Quarter 3 c. Quarter 4 d. Quarter 1
D
In the Munson's List of Events on the EventList worksheet, which number format does the data in the Year column need? a. Short Date b. Accounting c. Long Date d. General
D
When you enter data into a cell, where else on-screen will what you have entered display? a. The cell below b. The cell above c. The ribbon d. The formula bar
D
Which formatting feature for alignment will put contents of a cell on multiple lines within the same cell? a. Long Date b. Indent c. Increase Font Size d. Wrap Text
D
Review the following formula: =Sales!C10+A7. This formula uses which of the following reference types? a. Absolute b. Reference c. Named d. Worksheet
D.
The COUNT functions are in which of the Function Library categories? a. Financial b. Date & Time c. Math & Trig d. Statistical
D.
Which of the following is the best example of a mixed cell reference? a. A2 b. $A$2 c. A2:B5 d. A$2
D.
You need to determine the largest value in a range of numbers. Which function should you use? a. MIN b. SUM c. COUNT d. MAX
D.
If cell A1 contained January and you used AutoFill to fill the cells automatically across to L1, the contents of L1 would be _________________.
December
To center a title on a worksheet across multiple columns, use the _________________ feature.
Merge & Center and/or Center Across Selection
You can align cell contents centered over multiple columns with _________________.
Merge & Center, and Center Across Selection
The alignment setting that makes a paragraph of text flow on multiple lines in one cell is _________________.
Wrap Text
Describe the benefits of using a named range. ______
You can use a named range as a reference in a formula instead of using the cell reference. You can also use a named range as a way to navigate large worksheets.
Describe two methods you can use to create a named range. ______
You can use the Name Box or the Define Name command in the Formulas tab of the ribbon.
If you do not want a cell reference to change when you copy or move it, you need to make a(n) _______ cell reference in a formula.
absolute
The +, -, *, and / are all examples of
arithmetic operators
To display more than one workbook on the screen at the same time, you would use the _________________ command.
arrange all
The COUNTBLANK function counts the number of ____________ cells in a range.
blank
If you have the ribbon on the Auto-hide setting, there will be an _________________ next to the Ribbon Display Options.
ellipsis
