Excel Written Exam (#2)
Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result? 1) # 2) - 3) @ 4) *
1) #
All formulas begin with a(n) _________. 1) = sign 2) % sign 3) # sign 4) + sign
1) *=* sign
__________ is a group of related data points represented by data markers. 1) A data series 2) The x-axis 3) The y-axis 4) A value axis
1) A data series
Which of the following displays trends over time? 1) A line chart 2) A pie chart 3) What-if analysis 4) An axis
1) A line chart
What is a summary sheet? 1) A worksheet where totals from other worksheets are displayed 2) A sheet with two panes: one with the data, the other with the summary 3) A worksheet with sheet names, sheet information, and sheet locations of all other worksheets 4) A worksheet with data on the left side and the summary on the right
1) A worksheet where totals from other worksheets are displayed
A(n) _________ refers to a cell by its fixed position in the worksheet. 1) Absolute cell reference 2) Data marker 3) Relative cell reference 4) 3-D cell reference
1) Absolute cell reference
Which of the following is *NOT* a way to create a formula? 1) By using a Function button on the status bar 2) By typing 3) By using a Function button located on the ribbon 4) By using the point-and-click technique
1) By using a Function button on the status bar
Hold down the ______ key to select nonadjacent cells. 1) Ctrl 2) Alt 3) F2 4) Spacebar
1) Ctrl
Use the ________ key to select A5:A8 and D5:D8. 1) Ctrl 2) Shift 3) Alt 4) $
1) Ctrl
What is the keyboard shortcut for flash fill? 1) Ctrl + E 2) Ctrl + F 3) Alt + E 4) Ctrl + F2
1) Ctrl + E
Which of the following is the first order of operations? 1) Expressions within parenthesis 2) Exponentiation 3) Division 4) Multiplication
1) Expressions with parenthesis
The quickest way to repeat an action in Excel is the ________ function key. 1) F4 2) F6 3) F11 4)F2
1) F4
What are the two contextual tabs that display under Chart Tools when a chart is selected? 1) Format and Design 2) Insert and Format 3) Home and Design 4) Insert and Design
1) Format and Design
How can you identify the Chart Elements button when you select a chart? 1) It is a green plus sign 2) It is a percent sign 3) It looks like a funnel 4) It looks like a paintbrush
1) It is a green plus sign
Which of the following does not display to the right side of a selected chart? 1) Move Chart button 2) Chart Filters button 3) Chart Styles button 4) Chart Elements button
1) Move Chart button
Where is the Format Painter button located? 1) On the mini-toolbar and the Home tab 2) On the Home tab and the Page Layout tab 3) On the mini-toolbar and the Design tab 4) On the mini-toolbar and the Page Layout tab
1) On the mini-toolbar and the Home tab
In the excel window, where does [Group] display when worksheets are grouped? 1) On the title bar 2) On the ribbon 3) On the sheet tab 4) On the status bar
1) On the title bar
Using a touchscreen, which of the following actions is the same as right-clicking the mouse? 1) Press and hold for a few seconds 2) Touch the screen with two fingers 3) Slide right 4) Slide right and then press
1) Press and hold for a few seconds
To rotate text a worksheet, in the Format Cells dialog box, you can click and drag the _________. 1) Red diamond 2) Black, bold triangle 3) Red circle 4) Blue diamond
1) Red diamond
In Goal Seek, the _________ box contains the formula that calculates the information you seek. 1) Set cell 2) To value 3) Goal Seek dialog 4) By changing cell
1) Set cell
Tiny charts embedded in a cell that displays a visual trend summary alongside your data are called _______. 1) Sparklines 2) Data markers 3) Data labels 4) Data series
1) Sparklines
The ________ displays the current cell mode, the page number, and the zoom buttons. 1) Status bar 2) Formula bar 3) Ribbon 4) Quick Access Toolbar
1) Status bar
When using a touchscreen, which of the following actions is the same as click an item? 1) Tap the item 2)Press and hold for a few seconds 3) Slide right 4) Touch the item with two fingers
1) Tap the item
Which of the following is *FALSE* about worksheet tabs? 1) The active worksheet tab displays in red font 2) You can rename a tab by double-clicking on it 3) A worksheet tab can be copied 4) You can change the color of worksheet tabs
1) The active worksheet tab displays in red font
When you type data in a cell and press Enter, what cell becomes the active cell? 1) The cell below 2) The cell above 3) The cell to the right 4) The insertion point does not move
1) The cell below
The MEDIAN function finds ________. 1) The middle value in a range of cells 2) All numbers that correspond to an argument in the function 3) The average value in a range of cells 4) The one number that corresponds to an argument in the function
1) The middle value in a range of cells
The COUNTIF function has two arguments ________. 1) The range of cells to check and the sum of the range 2) A value as the criteria and an average of a range of cells 3) The range of cells to check and the criteria 4) The range of cells to sum and the criteria
1) The range of cells to check and the criteria
In a line chart, which of the following resides along the bottom of the chart? 1) The x-axis 2) The plot area 3) The legend 4) The y-axis
1) The x-axis
Which of the following resides along the left side of a column chart? 1) The y-axis 2) The x-axis 3) The legend 4) The plot area
1) The y-axis
You must select ______ on a worksheet to create a pie chart. 1) Two ranges 2) Four or more ranges 3) At least three ranges 4) One range
1) Two ranges
When preparing a document for printing, a ________ indicates that only the columns to the left will be printed on the first page. 1) Vertical dotted line between columns 2) Vertical red, bold line between columns 3) Vertical bolded, black line between columns 4) Horizontal bolded line between rows
1) Vertical dotted line between columns
AutoFill will fill a series when you establish a pattern _________. 1) With two or more cells 2) Through the use of a formula 3) With a minimum of three cells 4) Through the use of a function
1) With two or more cells
Which symbol represents that a cell is an absolute cell reference in a function or formula? 1) % 2) $ 3) & 4) *
2) $
If a sheet tab has ______ you know that it is not selected 1) A dotted background 2) A background color 3) A red border 4) A bolded border
2) A background color
A defined set of formatting characteristics such as font, font size, and font color are known as a ________. 1) Label 2) Cell style 3) Series 4) Theme
2) Cell style
The _________ is the temporary storage location for cell contents copied from a worksheet. 1) Excel table 2) Clipboard 3) Paste area 4) Office Pane
2) Clipboard
When formatting a worksheet to be printed, __________ show where page breaks are located. 1) Red lines 2) Dotted lines 3) A solid bold line 4) Blue lines
2) Dotted lines
How do banded rows display? 1) With a solid border around each row 2) Even rows are formatted differently from odd rows 3) Even rows have a different background and font color than do odd rows 4) Even rows are bolded; odd rows are not
2) Even rows are formatted differently from odd rows
Which of the following is the second order of operation? 1) Expressions within parenthesis 2) Exponentiation 3) Multiplication 4) Division
2) Exponentiation
The default number format for cells is the ______ number format. 1) Comma style 2) General 3) Currency 4) Accounting Number
2) General
Which of the following is *NOT* one of the three spatial dimensions of 3-D? 1) Width 2)Height 3)Length 4)Depth
2) Height
Which of the following is *NOT* one of the default calculations displayed by AutoCalculate? 1) Average 2) Maximum 3) Sum 4) Count
2) Maximum
_________ is a procedure that determines which digit to the right of a number will be the last to be displayed. 1) An absolute cell reference 2) Rounding 3) A constant value 4) Cell addressing
2) Rounding
How do you know if some rows of a table have been hidden from view when a filter is invoked? 1) A number pertaining the number of hidden rows displays next to the funnel icon 2) Row numbers display in blue 3) Row numbers display is red 4) Row numbers are bolded
2) Row numbers display in blue
To size a chart proportionately, hold down the ________ key and ________. 1) Shift; drag a left or right sizing handle 2) Shift; drag a corner sizing handle 3) Shift; drag a top or bottom sizing handle 4) Ctrl; drag a corner sizing handle
2) Shift; drag a corner sizing handle
Which of the following is *NOT* part of the Accounting Number Format? 1) Small amount of space at the right edge of the cell 2) Three decimal places 3) A thousand comma separator 4) A fixed dollar sign aligned at the left edge of the cell
2) Three decimal places
In Goal Seek, you enter the specific value that you want to achieve in the ________ box. 1) Set cell 2) To value 3) By changing cell 4) Goal Seek dialog
2) To value
Sheet tab names are ______ when they are grouped. 1) Bolded 2) Underlined 3) Italicized 4) In red
2) Underlined
To what extent can a pie chart be rotated? 1) Up to 45 degrees 2) Up to 360 degrees 3) Up to 90 degrees 4) Up to 180 degrees
2) Up to 360 degrees
What is a pane bounded by? 1) The ribbon 2) Vertical or horizontal bars 3) The status bar 4) A solid red line
2) Vertical or horizontal bars
The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as _________. 1) General fund analysis 2) What-if analysis 3) Relative cell reference 4) Goal Seek
2) What-if analysis
The value axis is also known as the _________. 1) Category axis 2) Y-axis 3) X-axis 4) Legend
2) Y-axis
When a cell is part of an active formula, it is surrounded with ___________. 1) A white border with small boxes on each corner 2) A colored background with small circles on each corner 3) A colored border with small boxes on each side 4) A bold, black border with small circles on each side
3) A colored border with small boxes on each side
What is an Excel table? 1) A series of rows and columns that contain related data located on a minimum of two worksheets 2) A series of rows and columns that has been assigned a name and can be used in a formula or function 3) A series of rows and columns that contains related data that can be managed independently from other data in a worksheet 4) A series of rows or columns on a separate worksheet that can be managed independently from other data in a worksheet
3) A series of rows and columns that contains related data that can be managed independently from other data in a worksheet
A Chart and all of its elements is known as the _________. 1) Chart sheet 2) Plot area 3) Chart area 4) Axis
3) Chart area
The <, >, and <> can be described as ________. 1) Criteria 2) Arguments 3) Comparison operators 4) Logical tests
3) Comparison operators
Which of the following is *NOT* a way to insert the SUM function into a cell? 1) Insert the AutoSum function from the Formulas tab 2) Alt + = 3) Ctrl + = 4) Insert the AutoSum function from the Home tab
3) Ctrl + =
A _____ in a pie chart identifies the pie slices. 1) Data point 2) Data series 3) Data label 4) Data marker
3) Data label
_________ is the keyboard shortcut for the Spelling command. 1) F1 2) F12 3) F7 4) F2
3) F7
To display the document properties, click the _______ tab. 1) Design 2) Home 3) File 4) Page Layout
3) File
_________ is an Excel tool that finds the input needed to arrive at a desired result. 1) A what-if analysis 2) A bevel 3) Goal Seek 4) Formula Autocomplete
3) Goal Seek
Where is the fill handle located? 1) On the Quick Access Toolbar 2) On the Home tab 3) In the lower right corner of a selected cell 4) In the top right of an active cell
3) In the lower right corner of a selected cell
When you print a chart sheet, how is it automatically formatted? 1) It has a default footer and page number 2) It is left-aligned on the page 3) It is centered on the page 4) It is right-aligned on the page
3) It is centered on the page
Which of the following is *TRUE* about a pie chart? 1) A pie chart should be your first choice when there are two data series to plot. 2) A pie chart has a minimum of three data series. 3) It shows the relationship of each part to a whole. 4) It displays data that is arranged in one or more columns or rows or data.
3) It shows the relationship of each part to a whole
Where do sheet tabs display in a workbook? 1) Under the ribbon 2) On the right side of the workbook window 3) Lower area of the workbook window 4) On the status bar
3) Lower area of the workbook window
In Excel 2016, row headings are identified by ________. 1) Roman numerals 2) Uppercase letters 3) Numbers 4) Lowercase letters
3) Numbers
In a large worksheet, which two Excel commands help to make the worksheets attractive and easier to read? 1) Print Titles and Summary sheet 2) Detail sheet and Summary Sheet 3) Print Titles and Scale to Fit 4) Print Titles and Conditional format
3) Print Titles and Scale-to-Fit
What are the default names of worksheets? 1) Worksheet1, Worksheet2, etc. 2) 1, 2, 3, etc. 3) Sheet1, Sheet2, etc. 4) Excel 1, Excel 2, etc.
3) Sheet1, Sheet2, etc.
Where does Excel's NOW function retrieve the date from? 1) The Internet 2) The Office 2016 suite 3) The computer's clock 4) The Excel program
3) The computer's clock
If you edit data in a worksheet that is associated with a pie chart _________. 1) An error message will display 2) A new, second pie chart must be created 3) The pie slices will be automatically updated 40 The pie slices must be manually updated
3) The pie slices will be automatically updated
Comma style format displays a number with _________. 1) Three decimal places 2) No decimal places 3) Two decimal places 4) A dollar sign and two decimal places
3) Two decimal places
The Percent Style button formats selected cells as a percentage with __________. 1) Three decimal places 2) Two decimal places 3) Zero decimal places 4) One decimal place
3) Zero decimal places
A chart value that originates in a worksheet cell is referred to as _________. 1) A data marker 2) The x-axis 3) A data series 4) A data point
4) A data point
The Count Function counts the number of cells in a range that ________. 1) Contain a number or text 2) Match a given value 3) Contain text 4) Contain a number
4) Contain a number
The keyboard shortcut to display Print Preview is ________. 1) Alt + F2 2) F3 3) F2 4) Ctrl + F2
4) Ctrl + F2
Which of the following Excel features recognizes a pattern in the data of a worksheet? 1) COUNTIF function 2) IF function 3) Find and Replace 4) Flash fill
4) Flash fill
Which of the following is the default number format in Excel 2016? 1) General format, Cambria, 12 pt. 2) Decimal format, Calibri, 11 pt. 3) General format, Times New Roman, 12 pt. 4) General format, Calibri, 11 pt.
4) General format, Calibri, 11 pt.
Which of the following is *FALSE* about a workbook? 1) It contains one or more worksheets with a series of cells 2) It contains one or more worksheets 3) It contains pages called worksheets 4) It can contain only one worksheet
4) It can only contain one worksheet
Which of the following is *FALSE* about the NOW function? 1) It updates each time the workbook is opened 2) It is a volatile function 3) It uses the computer's calendar and clock to display the date and time 4) It remains constant even when the workbook is opened
4) It remains constant even when the workbook is opened
A text value in Excel is also referred to as a ________. 1) Formula 2) Cell address 3) Constant 4) Label
4) Label
When you type text in a cell it is __________. 1) Centered 2) Right-aligned 3) Fully justified 4) Left-aligned
4) Left-aligned
On your keyboard, which two symbols function identically in date formats? 1) The comma and the forward slash key 2) The dollar sign and the ampersand 3) The forward slash key and the period 4) The hyphen key and the forward slash key
4) The hyphen key and the forward slash key
What does a data bar in a cell represent? 1) The values in a range of cells 2) The values of the two cells to the left of the cell with the data bar 3) The sum of the values above the data bar cell 4) The value of a cell relative to other cells
4) The value of a cell relative to other cells