Excel 2016 Practice Questions and Answers
Classified in Computers
Written on in 
English with a size of 3.22 KB
Excel Practice Questions and Answers
The ________ displays the current cell mode, the page number, and the zoom buttons.
Answer: Status bar
A text value in Excel is also referred to as a ________.
Answer: Label
When you type text in a cell, it is ________.
Answer: Left-aligned
Which of the following is NOT a way to create a formula?
Answer: By using a Function button on the status bar
________ is a procedure that determines which digit to the right of a number will be the last to be displayed.
Answer: Rounding
Which of the following is NOT part of the Accounting Number Format?
Answer: Three decimal places
Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ________.
Answer: Sparklines
What are the two contextual tabs that display under Chart Tools when a chart is selected?
Answer: Format and Design
Which of the following does not display to the right side of a selected chart?
Answer: Move Chart button
The value axis is also known as the ________.
Answer: Y-axis
A chart value that originates in a worksheet cell is referred to as ________.
Answer: A data point
The keyboard shortcut to display Print Preview is ________.
Answer: Ctrl + F2
Comma Style format displays a number with ________.
Answer: Two decimal places
Which of the following is NOT one of the default calculations displayed by AutoCalculate?
Answer: Maximum
The Percent Style button formats selected cells as a percentage with ________.
Answer: Zero decimal places
Normal view maximizes the number of cells visible on your screen.
Answer: True
The Formula Bar in Excel 2016 displays the value or formula in the active cell.
Answer: True
The status bar displays the ribbon as well as the Quick Access Toolbar directly above it.
Answer: False
After column Z in an Excel worksheet, the next column is AA.
Answer: True
An outlined cell in a worksheet is the active cell.
Answer: True
Auto Fill works only with alphabetic values.
Answer: False
Auto Fill generates and extends a series of values into adjacent cells in a worksheet.
Answer: True
The default font for Excel 2016 is Times New Roman 11 pt.
Answer: False
The Quick Analysis tool displays in the lower right corner of a selected range in a worksheet.
Answer: True
To indicate a range, include a dash between the two cell references.
Answer: False