WorksheetsCIS Microsoft Excel (Review)
Total questions: 62
Worksheet time: 31mins
This shortcut key undoes the previous action
Control Z
Control A
Control X
Control B
This shortcut key selects all items
Control Z
Control A
Control X
Control B
This shortcut key cuts the selected item
Control Z
Control A
Control X
Control B
This shortcut key changes the text style to bold.
Control Z
Control A
Control X
Control B
This shortcut key pastes an item on the clipboard
Control V
Control C
Control U
Control I
This shortcut key copies the selected item
Control V
Control C
Control U
Control I
This shortcut key adds an underline to selected text
Control V
Control C
Control U
Control I
This shortcut key changes the text style to italicized.
Control V
Control C
Control U
Control I
This shortcut key saves the file.
Control S
Control P
Control O
Control L
This shortcut key prints the file.
Control S
Control P
Control O
Control L
This shortcut key opens the area when a previously saved file can be opened.
Control S
Control P
Control O
Control L
This shortcut key redoes a previously undone action.
Control S
Control P
Control O
Control Y
This shortcut key opens a new blank workbook.
Control N
Control 9
Control 0
This shortcut key hides selected rows.
Control N
Control 9
Control 0
This shortcut key hides selected columns.
Control N
Control 9
Control 0
You can save a workbook, open a workbook, print a workbook, or get help for solving problems using the _________.
Backstage View/File Tab
Home Tab
Insert Tab
Page Layout Tab
You can copy and paste selected text; change the font face, size, color, and style; change alignment of items in cells; and insert and delete cells using the ______.
Backstage View/File Tab
Home Tab
Insert Tab
Page Layout Tab
You can specify a table, develop a Pivot Table, create charts and graphs, insert Spark lines, and add hyperlinks by using the ______.
Backstage View/File Tab
Home Tab
Insert Tab
Page Layout Tab
You can select the page margins size, switch the page orientation between portrait and landscape layouts, specify titles to be printed in a worksheet, and specify the print area by using the _____.
Backstage View/File Tab
Home Tab
Insert Tab
Page Layout Tab
You can add the AutoSum function, IF functions, Date functions, and trace precedents and dependents by using the ____________.
Formulas Tab
Data Tab
Review Tab
View Tab
You can get external data, apply a sort and/or filter to data, remove duplicates from a data set, and format text to columns by using the _______
Formulas Tab
Data Tab
Review Tab
View Tab
You can check spelling and grammar, add comments, track changes, protect workbooks, and share workbooks by using the _______
Formulas Tab
Data Tab
Review Tab
View Tab
You can show the worksheet in Normal view, Page Break view, and Page Layout view, and you show/hide the Formula Bar by using the ______
Formulas Tab
Data Tab
Review Tab
View Tab
Microsoft® _____ is a computer program used to enter, analyze and present data using spreadsheets and charts.
Excel®
Word®
Access®
PowerPoint®
Which of the following options in Backstage View contains the command to change
the file type of a saved file?
Export
Info
New
Publish
Which of the following groups on the Home tab contains the commands to insert
delete and format cell width and height?
Number
Styles
Cells
Editing
Which tab on the Ribbon contains the function library?
Home
Insert
Page Layout
Formulas
________ points to a specific cell and does not change when copied and includes dollar signs in the reference name
Absolute Cell Reference
Relative Cell References
________ is the address of a cell range based on the relative position of the cell
Absolute Cell Reference
Relative Cell References
Which of the following is a relative cell reference?
A1
B$1
$C1
$D$2
Which of the following is displayed in the image?
Flash Fill
Auto Fill
AutoComplete
Joe wants to copy the formatting of cells A1 through C1 in his workbook to use in another location. Which of the following commands should he use?
Cut Painter
Copy Painter
Paste Painter
Format Painter
Which of the following appears around cells which have been copied?
Stationary blue and white dotted lines
Moving red and white dotted lines
Moving green and white dotted lines
Stationary red and white dotted lines
All formulas must begin with which of the following symbols?
=
&
+
.
Justin wants to create a formula which adds the values in cells A1 and B1 together
and then multiplies the sum by 10. Which of the following formulas should he
enter? (REMEMBER PEMDAS)
+A1+B1*10
.A1+B1*10
=(A1+B1)*10
&(A1+B1)*10
José notices cell A5 of his worksheet contains the railroad tracks (#####) formula error. What should he do?
Delete the formula and just enter the value he wants in the cell
Resize the cell to fit the contents
Clear the formatting on the cell
Filter the cell
Which of the following adds the values in cells A1 through A10?
=SUM(A1:A10)
=SUM(A1,A10)
=SUM(A1!A10)
=SUM($A1$A10)
Alex wants to find the highest value in a range of cells. Which of the following functions should he use?
=MIN( )
=AVERAGE( )
=MAX( )
=MEDIAN( )
Which icon in the Function Library should be clicked to add the NOW function?
AutoSum
Date & Time
Lookup & Reference
More Functions
Which of the following is a type of equation which returns a value such as TRUE or FALSE?
Argument
Expression
Nest
Control
Carlos needs to combine words in a First Name and a Last Name column. Which
of the following functions should he use?
IF
MIN
MAX
CONCATENATE
Which of the following can be used to locate data in a particular column?
VLOOKUP
HLOOKUP
CLOOKUP
RLOOKUP
Which of the following can be used to locate data in a particular row?
VLOOKUP
HLOOKUP
CLOOKUP
RLOOKUP
Which of the following areas in the PivotTable Field list task pane should you place numerical values to be summarized?
FILTERS
VALUES
ROWS
COLUMNS
Brian wants to apply a different chart style to his PivotChart. Which of the following PivotChart Tools tabs should be used?
Analyze
Format
Styles
Design
Which group on the Table Tools Design tab holds the command for adding a Total Row to a table?
Tools
External Table Data
Table Style Options
Table Styles
Which of the following structured references should be used to refer to the data in a table range?
[#ALL]
[#DATA]
[#HEADERS]
[#TOTALS]
Which group on the Table Tools Design tab holds the command for renaming a table?
Properties
Tools
External Table Data
Table Styles
In order to create a chart, which of the following must be selected?
Data tools
Worksheet tab
Data source
Table styles
Brandon wants to add a legend to his chart. Which of the following should he click to add this item?
Quick Style
Add Chart Element
Shape Styles
WordArt Styles
Which group on the Chart Tools Design tab holds the command for switching row
and column data?
Data
Chart Layouts
Chart Styles
Location
Which of the following should be applied if you want to display only rows which meet a certain specified criteria?
Filter
Sort
Data bar
Icon Set
Which group on the Home tab contains the commands to apply a filter or a sort?
Clipboard
Font
Alignment
Editing
Other than the Home tab, which tab on the Ribbon contains the commands for applying a filter or a sort?
File
Data
Review
View
Select the following statements that are TRUE about sorting.
Date and time data can be sorted chronologically
Data can be sorted by cell color
Data is arranged in a certain order such as alphabetically or numerically
Data is hidden if it does not meet the sorting criteria
Which of the following applies formatting to cells depending upon the contents of the cells?
Conditional formatting
Conditional sorting
Filters
Style sets
Which of the following is a series of commands and instructions grouped together as a single command to accomplish a task automatically?
Macro
Sort
Filter
Icon Set
Which tab on the Ribbon contains the command to record a macro?
File
View
Insert
Which of the following cell references is read as “cell A1 and D6?”
A1,D6
A1!D6
A1:D6
A1-D6
Which of the following error messages would appear if the cell reference is not valid?
#####
#REF!
#NAME?
#CELL?
The IF Function is an example of which type of function?
Financial
Text
Date & Time
Logical
Which of the following is NOT a comparison operator?
>
<
/
=
