COREPOWER YOGA TT FINAL - QUESTIONS AND ANSWERS | 2026 UPDATE | WITH COMPLETE SOLUTION.

NVCC ITE 140 EXAM 1 | QUESTIONS AND ANSWERS | 2026 UPDATE |
WITH COMPLETE SOLUTIONS.



A chart value that originates in a worksheet cell is referred to as ________. - (answer)a data point



A defined set of formatting characteristics such as font, font size, and font color are known as a
________. - (answer)cell style



A text value in Excel is also referred to as a ________. - (answer)label



All formulas begin with an ________. - (answer)=



Comma Style format displays a number with ________. - (answer)two decimal places



Hold down the ________ key to select nonadjacent cells. - (answer)Ctrl



In Excel 2016, row headings are identified by ________. - (answer)numbers



The Percent Style button formats selected cells as a percentage with

________. - (answer)zero decimal places



The ________ displays the current cell mode, the page number, and the

zoom buttons. - (answer)status bar



The default number format for cells is the ________ number format. - (answer)General



The keyboard shortcut to display Print Preview is ________. - (answer)Ctrl + F2



The value axis is also known as the ________. - (answer)y-axis

,NVCC ITE 140 EXAM 1 | QUESTIONS AND ANSWERS | 2026 UPDATE |
WITH COMPLETE SOLUTIONS.



Tiny charts embedded in a cell that display a visual trend summary alongside your data are called
________. - (answer)Sparklines



To display the document properties, click the ________ tab. - (answer)File



Using a touchscreen, which of the following actions is the same as right clicking the mouse? -
(answer)Press and hold for a few seconds



What are the two contextual tabs that display under Chart Tools when a chart is selected? -
(answer)Format and Design



When a cell is part of an active formula, it is surrounded with ________. - (answer)a colored border with
small boxes on each side



When preparing a document for printing, a ________ indicates that only the columns to the left will be
printed on the first page. - (answer)vertical dotted line between columns



When using a touchscreen, which of the following actions is the same as clicking an item? - (answer)Tap
the item



When you type data in a cell and press Enter, what cell becomes the active cell? - (answer)The cell
below



When you type text in a cell it is ________. - (answer)left-aligned



Where is the fill handle located? - (answer)In the lower right corner of a selected cell



Which of the following does not display to the right side of a selected chart? - (answer)Move Chart
button

, NVCC ITE 140 EXAM 1 | QUESTIONS AND ANSWERS | 2026 UPDATE |
WITH COMPLETE SOLUTIONS.




Which of the following is FALSE about a workbook? - (answer)It can contain only one worksheet.



Which of the following is NOT a way to create a formula? - (answer)By using a Function button on the
status bar



Which of the following is NOT one of the default calculations displayed by Auto Calculate? -
(answer)Maximum



Which of the following is NOT part of the Accounting Number Format? - (answer)Three decimal places



Which of the following is the default number format in Excel 2016? - (answer)General format, Calibri, 11
pt



________ is a procedure that determines which digit to the right of a number will be the last to be
displayed. - (answer)Rounding



________ is the keyboard shortcut for the Spelling command. - (answer)F7



The symbols <,>,<> can be described as _________. - (answer)Comparison operators



How do banded rows display? - (answer)Even rows are formatted differently from odd rows



How do you know if some rows of a table have been hidden from view when a filter is invoked? -
(answer)Row numbers display in blue



If a sheet tab has ________ you know that it is not selected. - (answer)a background color