Module 1/2
When you are in the Excel application, what shortcut key can you use to open an existing workbook?
A. Ctrl+Alt+O
B. Ctrl+O
C. Shift+O
D. Ctrl+Shift+O
B. Ctrl+O
Which of the following commands does not belong to the Windows group on the View tab:
a. Hide
b. Split
c. Zoom
d. Arrange All
c. Zoom
Which of the following symbols specifies an absolute reference?
a. %
b. &
c. $
d. @
c. $
Which of the following functions would correct the capitalization errors in MAIN STREET?
a. PROPER
b. UPPER
c. LOWER
d. TITLE
a. PROPER
How does Excel determine what data to use when creating a chart?
a. It uses all data on the current worksheet.
b. It uses all data in the current workbook.
c. It uses the selected cell and all adjacent cells.
d. It uses only the selected cells.
d. It uses only the selected cells.
What is the keyboard shortcut to go to elements of a workbook?
a. Ctrl+E
b. Ctrl+F
c. Ctrl+G
d. F5
c. Ctrl+G OR d. F5
In the bottom left corner of the Microsoft Excel interface which of the following screen views are not available?
a. Print preview
b. Page break preview
c. Page layout
d. Normal
a. Print preview
Like a standard formula, a function begins with an equal sign (=). True or False?
True
Which of the following can you use as a delimiter within a TEXTJOIN function?
a. A space
b. A comma (,)
c. A dash (-)
d. All the above
d. All the above
Which of the following terms refers to a row or column of data in a worksheet that is plotted in a chart?
a. A data series
b. Axis
c. Data label
d. Data table
a. A data series
You can use the Replace feature to find specific formatting and replace with different formatting. True or false?
a. True
b. False
a. True
Which of the following operators is used to start a formula in Excel?
a. *
b. /
c. =
d. $
c. =
A cell that contains zero (0) is evaluated as a blank cell. True or False?
False
You can use a hyperlink to connect which of the following?
a. A cell
b. A range of cells
c. A named range of cells
d. A website
a. A cell (correct answer)
b. A range of cells (correct answer)
c. A named range of cells (correct answer)
d. A website (correct answer)
Which chart element displays a grid of the chart’s underlying data?
a. Legend
b. Data table
c. Data labels
d. Trendline
b. Data table
To insert a row into a worksheet, you can select the row header and use which of the following keyboard shortcuts:
a. Ctrl+Plus sign (+)
b. Ctrl+Hyphen (-)
c. Ctrl+Asterisk (*)
d. Ctrl+Slash (/)
a. Ctrl+Plus sign (+)
Which of following operators is used to multiply in Excel?
a. *
b. /
c. ^
d. X
a. *
You are constructing an IF statement that evaluates whether cell C9 is greater than 150. Which logical operator would you use?
a. =
b. <
c. >
d. <
c. >
When creating a link to a document within a workbook, which area of the Insert Hyperlink dialog box should you use?
a. Create a new file
b. Email address
c. Place in this document
d. Existing file or webpage
d. Existing file or webpage
Which of the following options can you use to emphasize data points on a sparkline?
a. Data labels
b. Markers
c. Callouts
d. Gridlines
b. Markers
Ctrl+C is the keyboard shortcut to ______________________ data?
A. Copy
B. Paste
C. Insert
D. Format
A. Copy
Which of the following symbols can you use to override the order of operations?
a. " "
b. @
c. ( )
d. *
c. ( )
What is a delimiter?
a. A way to combine data
b. A way to organize data
c. Something used to limit the use of data
d. A process to collect data
b. A way to organize data
Conditional formatting uses a condition to determine a cell's _________________________________.
a. Value
b. Appearance
c. Size
d. Location
b. Appearance
Which of the following cannot be added using Quick Analysis?
a. Charts
b. Cell styles
c. Sparklines
d. Conditional formatting
e. Average
b. Cell styles