9.11: Chapter Review - Review Questions
-
- Last updated
- Save as PDF
Review Questions
1 .
Excel is a spreadsheet software that can design sales report tables and calculate math equations using ______.
-
data, lines, and rectangles
-
calculators, graph paper, text
-
numbers, GUI, WordArt
-
cells, formulas, and functions
2 .
What is the primary difference between worksheets and workbooks?
-
Worksheets are tabs in a workbook.
-
Workbooks are tabs in a worksheet.
-
Worksheets are cells in a workbook.
-
Workbooks are cells in a worksheet.
3 .
Which command can be used to paste information that was recently copied?
-
Ctrl+C
-
Ctrl+A
-
Ctrl+V
-
Ctrl+=
4 .
What is the cell format that lets you type long numbers using just the first three digits?
-
Scientific
-
Date
-
Accounting
-
General
5 .
What are examples of the benefits of using both numerical and text data in your worksheet but keeping them in separate columns?
-
Numerical data can be combined with text data for writing descriptions of objects and their measurements.
-
Text data can be used for autofilling a calculation of multiple scenarios.
-
Numerical data can be used in accounting, dates, or number formats, while text is used for descriptions or headers.
-
Text and numerical data are easily typed and interpreted by Excel, as it can read words, thus they can be used for computable lists.
6 .
What is a benefit of preformatting cells in Excel?
-
You can automatically fill the data without typing it by inserting an image from the phone.
-
You can type the data and Excel will apply the format, so it looks how you want it to.
-
You can send a Bluetooth connection to the data, and it will be autofilled.
-
You can use the cell references to do mathematical operations.
7 .
What are the two methods to add numbers in Excel?
-
using the SUM function and the “+” sign in formulas
-
using constants and cell references
-
using variables and constants
-
using functions such as PRODUCT and constants
8 .
The ______ function does not have the same functionality compared with the “/” because it does not return a full answer if it has decimals.
-
DIVISION
-
PRODUCT
-
QUOTIENT
-
PROPORTION
9 .
Where in the ribbon can you change the font?
-
You can change the font in the Alignment command group on the Home tab.
-
You can change the font in the Text command group on the Insert tab.
-
You can change the font in the Symbols command group on the Insert tab.
-
You can change the font in the Font command group on the Home tab.
10 .
Identify the steps for automatically highlighting any cells from a column that are greater than a certain number.
-
Select the cell you want to analyze, click on Conditional Formatting, go to Highlight cell rules, click Greater than, and set the parameters.
-
Select the column in question, then click on Conditional Formatting, go to Highlight cell rules, click Greater than, and set the parameters.
-
Select the column in question, then click on Conditional Formatting, go to Highlight cell rules, click Between, and set the parameters.
-
Select the cell you want to analyze, click on Conditional Formatting, go to Highlight cell rules, and click Top 10%.
11 .
Where do you find the Spell check command in Sheets?
-
Format menu
-
Extensions menu
-
Tools menu
-
File menu
12 .
______ is the process to select two noncontiguous cell ranges.
-
Ctrl+Select
-
Shift+Select
-
mouse left-click select
-
mouse right-click select
13 .
What commands or tools are found on the toolbar?
-
all the options that are contained on the Tools menu
-
tools that the user selects to be placed on the toolbar
-
the more widely used tools/commands
-
all of the commands and tools from the File and Data menus
14 .
What menu would you use to add cells in a worksheet in Sheets?
-
Tools
-
Insert
-
Edit
-
Data
15 .
Double-clicking on the cell edge between the column header row will:
-
change the format of the cell to financial
-
automatically resize the column width to the data in the column
-
remove the data in that column
-
highlight the column for graphing
16 .
Where will you find the Themes settings in Sheets?
-
Format menu
-
Insert menu
-
action bar
-
Page Layout menu
17 .
What is the function name for subtracting in Sheets?
-
There is none.
-
MINUS
-
SUBTRACT
-
DIFFERENCE
18 .
______ is the name of the function for multiplication of two values in Sheets.
-
PRODUCT
-
TIMES
-
MULTIPLY
-
RESULT
19 .
What is the difference between the QUOTIENT and DIVIDE functions?
-
DIVIDE gives you decimals in the result, and QUOTIENT gives you whole numbers.
-
There is no difference; they will always produce the same answer.
-
QUOTIENT will give a result with the first two decimal places, whereas DIVIDE gives a result that includes all decimal places.
-
You can use QUOTIENT in Sheets, and you can use DIVIDE in Excel.
20 .
What would be a general header style most favored by the corporate world?
-
leaving it plain text, as it can be easily read by Sheets
-
aligning the text to the right, applying a bright color background, and plain type
-
applying bold text, with no background or alignment
-
applying a background color shading, bold font, and center aligned
21 .
How do you look for public templates in Sheets?
-
You need to go to the Welcome screen, and search for templates there.
-
You need to go to Google.com, and type “X template site:docs.google.com”.
-
You can’t because Sheets doesn’t have access to public templates.
-
You can look for Microsoft Word templates because they work in Sheets, too.
22 .
What is the main difference between freezing panes in Excel and in Sheets?
-
In Sheets, you can choose the row or column at any part of the worksheet.
-
In Excel, you can choose the row or column at any part of the worksheet.
-
In Sheets, you can only start the pane freeze at the first row or column.
-
Both are the same in all aspects.