Excel

9 September 2022
4.7 (114 reviews)
90 test answers

Unlock all answers in this set

Unlock answers (86)
question
You can apply ____ formatting that appears only when the value in a cell meets conditions that you specify. a. specified b. narrow c. customized d. conditional
answer
d. conditional
question
____ allows you to select cells for use in a formula by using the mouse. a. point and click b. click mode c. Formula mode d. Point mode
answer
d. point mode
question
To verify that a formula contains the intended cell references, use Excel's a. functions b. Range Rinder c. Reference Finder d. Reference Checker
answer
b. Range Finder
question
To override the order of operations, use ___ a. brackets b. asterisks c. quotes d. parentheses
answer
d. parentheses
question
A___ is made up of two values and a relational operator. a. formula b. condition c. function d. comman
answer
b. condition
question
You can assign a ____ to a cell and Excel will calculate the results. a. formula b. reference c. value d. micro
answer
a. formula
question
____ colors tend to reach towards your worksheet's reader. a. cooler b. darker c. warmer d. brighter
answer
c. warmer
question
A____ is predefined set of colors, fonts, cell styles, and fill effects that can be applied to an entire workbook a. theme b. function c. condition d. definition
answer
a. theme
question
When Excel starts and the blank workbook displays on the screen, all of the columns have a default width of ____ characters in 11-point Calibri font a. 8.43 b. 12 c. 15 d. 64
answer
a. 8.43
question
the ___ is the order in which arithmetic operators are calculated a. order of values b. order of operations c. order of signs d. order of calculations
answer
b. order of operations
question
_____ colors tend to pull away from your worksheet's reader a. cooler b. darker c. warmer d. brighter
answer
a. cooler
question
To check the spelling of text in a single cell, ____ the cell to make the formula bar active and then click the Spelling button on the Review tab. a. single-click b. double-click c. right-click d. double-righ-click
answer
b. double-click
question
Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box? a. inbetween b. more c. greater than d. outside
answer
a. inbetween
question
A(n) ____ is a prewritten formula that is built into Excel. a. argument b. array c. worksheet d. function
answer
d. function
question
____ allows you to create or modify a worksheet while viewing how it will look in printed format a. Normal View b. Page Layout View c. Print Preview d. Review
answer
b. Page Layout View
question
The ___ button lists formatting options following an insert of cells, rows, or columns a. Insert Options b. Format Options c. Formatting d. add cell
answer
a. Insert Option
question
A dot on the screen that contains color is called a ____ a. font b. pixel c. character d. point
answer
b. pixel
question
A(n) ____ takes a value or values, performs an operation, and returns a result to the cell a. operation b. cell c. function d. argument
answer
c. function
question
The default view for a worksheet is +____ a. Normal View b. Standard View c. Page View d. Basic View
answer
a. Normal View
question
A blank cell in Excel has a numerical value of ____. a. zero b. one c. five d. negative ones
answer
a. zero
question
A saved workbook is referred to as a ___ a. book b. workbook c. project d. file
answer
d. 0.file
question
The range of cells receiving a copy is called _____ area a. source b. destionation c. copy d. reference
answer
b. destination
question
In ___ mode, as you type a character, excel inserts the character and moves all characters to the right of the typed character one position to the right. a. insert b. overtype c. right-align d. push right
answer
a. insert
question
the ___ is a blinking vertical line that indicates where the next type character will appear a. lnsertion point b. key tip c. active cell d. ribbon
answer
a. Insertion point
question
____ Allow users to enter, calculate, manipulate, and analyze data a. charts b. lists c. worksheets d. databases
answer
c. workseets
question
You view the portion of the worksheet displayed on the screen though an a. Active window b. worksheet window c. cell d. active cell menu
answer
b. worksheet window
question
The default view in Excel is ____ view a. Work b. auto c. normal d. Roman
answer
c. normal
question
A cell is referred to by its unique address, called a(n) ____, which is the coordinates of the intersection of a column and a row a. Cell reference b. Name box c. Unit d. Active cell
answer
a. Cell refernce
question
The mouse pointer turns to a ____ whenever you move it to outside the worksheet a. Hand b. Block arrow c. Double-headed arrow d. Crosshair
answer
b. Block arrow
question
___ cells involves creating a single cell by combinig two or more selected cells a. formatting b. merging c. embedding d. splitting
answer
b. merging
question
Which of the following is not a valid entry into a cell that requires numbers? a. + b. E c. # d. $
answer
c. #
question
A(n) ____chart is drawn on the same worksheet as its data. a. 3D pie b. embossed c. embedded d. local
answer
c. embedded
question
The number of workseets that you can add to a workbooks is a. 100 b. 256 c.1,067,456 d. limited by the amount of memory on the computer
answer
d. limited by the amount of memory on the computer
question
Each worksheet in a workbook has ____ rows a. 100 b. 32,767 c. 65,536 d.1,045,567
answer
d.1,045,567
question
You press the ___ key on the keyboard to display a Key Tip badge. a. ESC b. CTRL c. ALT d. Home
answer
c. ALT
question
The ___ feature of Excel works behind the scenes, correcting common mistakes a. AutoCorrect b. Spelling c. Help d. Ribbon
answer
a. AutoCorrect
question
To enter a number as text, start the entry with a(n) a. asterisk b. hyphen c. semicolon d. apostrophe
answer
d. apostrophe
question
To emphasize certain entries and make the workseet easier to read and understand you ___ the worksheet a. format b. edit c. print d. proofread
answer
a. format
question
Holding down the ____ key while you drag a chart snaps the edge of the chart area to the workseet gridlines a. ALT b. Home c. Insert d. CTRL
answer
a. ALT
question
The ___ command in th Auto Calculate area displays the number of non black cells in the selected range a. Count b. Blank c. Zero d. fill
answer
a. Count
question
When you click the Format Painter button and move the mouse pointer onto the worksheet, the mouse pointer changes to a block plus sign with a _______. A: cross hair B: hand C: paintbrush D: double-headed arrow
answer
C: paintbrush
question
An alternative to clicking the Paste button is to _______. A: click the Drop button B: click the Move butto0n C: press the Enter key D: press the down arrow
answer
C: press the Enter key
question
A pie chart with one or more slices offset from the main portion is called a(n) _____ pie chart. A: exploded B: detached C: separated D: highlighted
answer
A: exploded
question
The ______ on the status bar can be used to change the size of entries to make them more readable. A: Fit in cell button B: Zoom slider C: View tab D: Fit in screen button
answer
B: Zoom slider
question
The worksheet entries that determine the size of the slices in a pie chart are called the________. A: data series B: pie data C: data collection D: chart data
answer
A: data series
question
To copy a word, such as Monday, which Excel might interpret as the start of a series, hold down the _______key while you drag the fill handle to a destination area. A: Spacebar B: F4 C: CTRL D: Shift
answer
C: CTRL
question
A cell reference with only one dollar sign before either the column or the row is called a(n)_______. A: mixed cell reference B: relative cell reference C: absolute cell reference D: incomplete cell reference
answer
A: mixed cell reference
question
Text in a cell can be rotated counterclockwise by entering a number between 1 degree and ___ In the Alignment sheet in the Format Cells dialog box. A: 10 degree B: 45 degree C: 90 degree D: 180 degree
answer
C: 90 degree
question
A____ function is one in which the action taken for the true or false case includes yet another IF function. A: Hidden IF B: Complex IF C: Nested IF D: Double IF
answer
C: Nested IF
question
To specify an absolute reference in a formula, enter a(n) _____before a column letter or a row number. A: percent sign B: apostrophe C: dollar sign D: title
answer
C: dollar sign
question
To display the original worksheet after answering a what-if question, click the ___button for each value you changed. A: Copy B: Save C: Restore D: Undo
answer
A: Copy
question
Use the ___ function to enter the system date into a cell in the worksheet. A: IF B: Now C: GMT D: Date
answer
B: Now
question
When creating panes in a worksheet, the bar going up and down the middle of the window is called the ___. A: horizontal split bar B: vertical split C: scroll bar D: vertical ruler
answer
A: horizontal split bar
question
Which of the following is not considered a format symbol? A: $(dollar sign) B: , (comma) C: +(plus sign) D: %(percent sign)
answer
C: +(plus sign)
question
You can emphasize a slice of a pie chart by___ it from the rest of the slices so it stands out. A: offsetting B: impacting C: embedding D: charting
answer
A: offsetting
question
The____ command removes selected cells from the worksheet and shifts the remaining rows up or shifts the remaining columns to the left. A: Columns B: Delete C: Rows D: Cells
answer
B: Delete
question
Excel allows you to control the rotation angle, elevation, perspective, height, and angle of the axes of a chart by using the ____. A: Chart Painter dialog box B: Pie Chart Control box C: Control tab D: Format Chart Area dialog box
answer
D: Format Chart Area dialog box
question
Using the mouse to move or copy cells is called ____. A: mouse copy B: move and drop C: drag and drop D: mousing
answer
C: drag and drop
question
Using the ___ button on the Ribbon, you can format a cell quickly by copying a cell's format to another cell or range of cells. A: Formatter B: Format Painter C: Copy D: Layout
answer
B: Format Painter
question
When you cut cells using the Cut button, Excel copies the cells to the Office Clipboard, but does not remove the cells until you paste the cells in the destination area by clicking the ___button. A: Move B: Complete C: Execute D: Paste
answer
D: Paste
question
When a formatted number does not fit within a ceU, it displays a. ##### b. #DlV/O c. #DIV@ d. None of these
answer
a. #####
question
Data can be arranged in ascending or descending order by using a. Sort command from Table menu b. Sort command from Data menu c.Sort command from Tools menu d.None of these
answer
b. Sort command from Data menu
question
3. Red triangle at the top right corner of a cell indicates a.. There is an error in the cell b. There is a comment associated with the cell c.The font color of the text in cell is red d.The cell can't accept formula
answer
b. There is a comment associated with the cell
question
How many sheets are there in Excel Workbook by default? a.2 b. 3 c.4 d. 5
answer
b. 3
question
To move to the previous worksheet press a. Ctrl+PgUp b.Ctrl+PgDn c.Shift+Tab d.Ctrl+Tab
answer
a. Ctrl+PgUp
question
The accounting style shows negative numbers in a.Bold b.Brackets c. Paranthesis d. Quotes
answer
c. Paranthesis
question
The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called a. freezing b.locking c.selecting d.fixing
answer
a. freezing
question
When you create two or four separate windows containing part of the spreadsheet that can be viewed, you have created a. sections b. panes c.views d.subsheets
answer
b. panes
question
To keep specific rows and columns from scrolling off the screen you first must position the cell pointer a.to the right oftbe column you want to remain on the screen b.below the row you want to remain on the screen c. on the row you want to remain on the screen d. both below and right of the row and column you want to remain on the screen
answer
d. both below and right of the row and column you want to remain on the screen
question
. If you wanted to sort an employee me so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort? a. zip codes (ascending), then last name (ascending), then first name (ascending) b.last name (ascending), then first name(ascending), then last name (ascending) c.zip codes (descending), then last name(ascending), then first name(ascending) d.last name (descending), then first name (descending), then last name (descending)
answer
a. zip codes (ascending), then last name (ascending), then first name (ascending)
question
. If you require more than two conditions or if you want to analyze a list using Excel 2003's database functions, you must define which filter? a.Auto Filter b.Update Filter c. Advantage Filter d. Advanced Criteria Filter
answer
d. Advanced Criteria Filter
question
A quick way to return to a specific area of a worksheet is to type in the __ a. Name box b. Formula bar c.Zoom box d.None of these
answer
a. Name box
question
Which keyboard shortcut opens the Go To dialog box? a. Ctrl + B b. Ctrl + Shift + B c. F2 d. F5
answer
d. F5
question
If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort? a)zip codes (ascending), then last name (ascending), then first name (ascending) b. last name (ascending), then first name(ascending), then last name (ascending) c.zip codes (descending), then last name(ascending), then first name(ascending) d.last name (descending), then first name (descending), then last name (descending)
answer
a)zip codes (ascending), then last name (ascending), then first name (ascending)
question
What chart object is a horizontal/vertical line extending across the plot area aiding reading values a. catogory axis b. data marker c. data point d. grid line
answer
d. grid line
question
Two common wildcard characters that Excel recognizes are a. and/ b. c. *and ? d. +and-
answer
c. *and ?
question
The format Cell Number can has an option to show negative numbers in a. green b. blue c. red d. quotes
answer
c. red
question
To access the Go To dialog box in Excel you can press? a. Ctrl+G b. Ctrl+H c. Ctrl+O d. Ctrl+A
answer
a. Ctrl+G
question
To centre workseet titles across a range of celll, you must ____ a. Used merge and center button to center the text across multiple cells b. wident the columns c. checks whether text is the same in one cell as in the next d. all of these choices
answer
a. Used merge and center button to center the text across multiple cells
question
What error code does excel dispaly if a range name is miss-typed or deleted a. #REF! b. #Name? C. #Value D. #N/A
answer
b. #Name?
question
What is a circula reference? a. Geometric modeling tool b. a cell that points to a drawing object c. a formual that either directly or indirectly depends on itself d. always erroneous
answer
c. A formula that either directly or indirectly depends on itself
question
To protect a worksheet, you can choose Protection and the Protect Sheet form the .... menu a. view b. insert c. format d. tools
answer
D. Tools
question
A cell's unique address is calla a. cell address b. name box c. cell heading d. active cell
answer
a. cell address
question
What is the keyboard shortcut for creating a chart from the selected cells a. F1 b. F5 c. F7 d. F11
answer
d. F11
question
A function inside another function is called a ____ function a. Nested b. Round c. Complex d. Compound
answer
a. Nested
question
A value used in a formula that does not change is called a. constant b. function c. cell range d. cell address
answer
a. constant
question
To select several cells or ranges that are not touching each other, you would ____ wile selecting a. Hold down the control button b. hold down the shift key c. hold down the control key d. hold downt eh control and shift key
answer
a. Hold down the control button
question
to move the previous worksheet press a. Alt+PgUp b. Ctrl + PgUp c.Ctrl + PgDn d. Alt + PgDown
answer
b. Ctrl + PgUp
question
YOu want to track the progress of the opening and closing price of a stock. Which type of chart should you use? a. Pie Chart b. Bubble c. Stacked Colum d. High Low Close Open
answer
d. High Low Close Open
question
How many arguments does an AND function allow you to enter a. 16 b. 30 c. 255 d. 64
answer
b. 30